Thanks! The way dRahme suggested worked.
I had already tried what PHV suggested but without success in Access 2000. What I ended up doing before reading these posts was to run a single query that created the table, then ran a UNION query similar to what PHV suggested to insert the rest...
I'm attempting to use a UNION query to make a table, but keep getting error msg that "An action query cannot be used as a row source.
The code works in Rapid Sql against Oracle tables, but when trying to use it in an Access query's sql it won't work. Tried mimicking other make-table statements...
I have 100 or so like tables I was able to import into an Access mdb from Excel files. Now, I need to copy all of these individual tables into one - fields are the same in each table. I guess I should have imported them from files into one table, but that is beside the point.
Can a...
Hi,
I have an Access mdb with linked Oracle tables wherein a form on the mdb allows users to update the tables. The mdb is sitting on a network drive and is often used by more than one user at a time. Is there any way to turn off the Access message that the database (mdb) is read-only...
never mind. I found the problem.
I left a Selection.AutoFilter after the loop that was getting applied on the summary page and taking the filter off.
Thanks for your help!
yeah, the filter should have been >= 1 AND <= 99. Thanks.
When I filter on the second sheet only, manually, the filter works properly. Conversely, if the second sheet happens to be the active sheet, instead of the first, the filter works against the second sheet and then not on the first...
Here's the code, based around what you gave me. The copy & paste works fine, however, for some reason, the filter criteria do as required on first sheet, but next sheet it sets the range and copies and pastes, but the filter criteria aren't being applied.
I'm just testing it against a model...
Zathras,
Although this looping code works, for some reason (is it an Excel issue or the code?) the range criteria works on the first sheet, but not on subsequent sheets.
Thanks Zathras!
a working model except for two things: 1) using the macro to do a copy paste, the code set a specific range that might not be the appropriate rows for following sheets, based on the filter criteria - <>0 for example. How do you make it general enough to be applied to all...
I need to create some code to loop through multiple sheets of an Excel workbook, same format for each sheet, and extract the relevent data - acct nbr, amount, etc - where the amounts are <> 0 and either dump into a table or another sheet. From there, will dump into flat file.
Any tips on...
I created an import macro utilizing the TransferText action, however, it requires the specific file name to be typed into the Action Arguments. Can an InPut Box be used to prompt the user to select the file they want and then incorporate that into the macro or would it be better to just run a...
I created an import macro utilizing the TransferText action, however, it requires the specific file name to be typed into the Action Arguments. Can an InPut Box be used to prompt the user to select the file they want and then incorporate that into the macro?
On the other end, exporting a file...
I created a form to be used for entering data. The form has a header section and two tabs - page 1 and page 2 - with data from each going into different tables (primary key is the same) in the detail section.
How could I make the second tab invisible and then be made visible only after the...
I was trying to set a validation with an input mask of four digits to a specific field so that someone inputting the parameters could not enter the incorrect number of digits. While using 0000 did not allow someone to enter a letter, it still allowed me to type in only one digit, or more than...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.