Search results for query: *

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...

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...