Search results for query: *

Hi, sorry I don't know what forum to put this question in so it might not belong here but here goes...I have 2 excel workbooks (one with all my data and the other which I would like to link the data to). My excel workbook with all my data (export.xls) has data dating from 1996 to 2004 and is...

Hi everybody, In ms excel you can have it so that when a file is opened a message pops up that says something along the lines of "This file should be viewed in Read-only mode unless you need to edit it." And it is then followed by buttons to choose from such as "Read-only" and "Edit"...

I was just quickly wondering why when I use an OutputTo function in my macro it moves very slowly, but then if I change it to a TransferSpreadsheet it works in the blink of an eye. What happens during the OutPutTo function that makes it go so slow? Thanks, Phil

Hi everybody. I currently have a code that will work but only on the active window. I would like it to work on a select worksheet so that you don't have to be looking at the worksheet for the macro to run correctly. My code looks like this: ChDir "G:\All\Phil" Workbooks.Open...

Hi everybody, sorry but I am a little wet behind the ears when it comes to VBA so I know this question is really easy but my code currently looks like this: Workbooks("test.xls").Worksheets("all companies").Cells.ClearContents Workbooks("all companies.xls").Worksheets("all...

I am running a macro which uses the "OutputTo" function in order to send my query results to an Excel workbook. (I not using "Transferspreadsheet" because I want Excel to start up immediately after I export the data.) I am currently getting a message that says the file I am exporting...

Hi, all I am trying to do is copy data from one file ("allcompanies.xls") and paste it to another file ("test.xls"). Allcompanies.xls are results from a query in Access and so the size of it can vary every time it is opened. The problem I am having is that I can't run this macro if they are...

Hi everybody, I am running a macro that opens a query and then just exports the data to an already existing excel spreadsheet. My problem is that when I run the macro I get an error saying "The External Table isn't in the expected format." I don't understand this because the file just a regular...

Hi, I have a simple question but since I am relatively new to Access I don't know the answer. I have one table ("first2") and one query ("04") which both have the exact same format. It looks something like this: RR Year Comm W1 W2 XX 1999 1 123 144 Table "first2" has my...

Hi everybody, I have a question about writing an append query. I currently have a table with data from 96,97,98,99,00,01,02,03,and 04. My company is sent a new excel sheet every week with the new data (in this case 2004) as well as the rest of the year. An example would be this is week 23 so...

Hi everybody, I am very new to VB and this might be a really easy question but here goes- I have taken over this project for somebody who left and had already written a lot of the code for it. Currently the macro has our data being imported into one worksheet. I was wondering if there was an...

Hi everybody. I have a small problem. I currently am using combo boxes on my form so the user can just pick one or a range of vlaues. (Such as you could pick 1996 or 1996-2004 but not 1996,1998, and 1999). I was thinking that it might be more practical to use check boxes so the user could...

I have a problem with the macro that I am running. At the start I import a table and then I run a query on it at the end I want to delete the table but when I try "DeleteObject" it always comes up as an error and says that Access could not lock the table because some other user is using it...

I am stuck right at the end of this database and I just need a little bit of help. After I have entered all my information into my form I run a macro which generates query results. What I would then like to do is export these results to an excel workbook that I already have made, just make it...

I am stuck right at the end of this database and I just need a little bit of help. After I have entered all my information into my form I run a macro which generates query results. What I would then like to do is export these results to an excel workbook that I already have made, just make it...

Hi everybody I just have a quick question. I am making a database and I want to be able to have two or three combo boxes where I could select criteria and then be able to run a macro and these criteria would be used in the query that the macro runs. This means that there would not be any pop...