query answer macro

I'm using Office 365 and am importing data from an external database, creating a query as I do. I then have a macro that does some formatting and copies the table, without headers, to my main table. The code works perfectly if I open the editor and run it line by line. When I create a button to...

When I have a query running in the background in excel, and I am editing the code I have by entering the following text: In the image above, I am adding text as "cannot go to 1" while a query is running in the background. However, as I am writing the text, there appears to have no spaces in...

Hello all, I'm struggling with an Access (2010) issue and if someone could help me I'd really appreciate it as it is driving me nuts! I have a 10000+ record dataset that has multiple records per person. The dataset looks like this: <tbody> Employee_ID Employee_Name Dept_Start_Date...

Hi everyone, and thanks in advance for your help. I have a splitting headache dealing with queries in excel.:confused: I have an apparently simple problem. I would like to trigger an Access query from Excel and subsequently to export the results to my spreadsheet. What is more, I would like to...

Hello, I never excel scripted before.. so I am looking for some help with a macro, I created a workbook with a company inventory of all IT items.. each sheet has a listing of a certain type of device (workstations/switchs/keyboards/monitors/printers ect). I have a query that is activated by a...

Dear friends i want to create an set of 30 questions which are fixed and which will be to the left side of column (These questions will not change from user and user).The right side will be the part where the user will answer for the questions which are on the left side.After all this has been...