I need to import a text file with dates that are formatted as "dd-mmm-yy". If I use the Wizard, I have to go through the Advanced options to tell Access how the dates are formatted. Is there any way to bypass the Wizard and import to Access with the date specifications and a "|" as a...
I receive a daily modification file with 41 coded fields. In order to run reports with the code descriptions I have to create a "tangled" mess of joins. How can I combine all the codes into a single lookup table?
I need a query or VBA code that will add a block of numbered records that add the number of records a user designates and increments the records by one from the last record in use. For example, if there are 100 records and the user wants a block of ten, I need to add records with the numbers...
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.