Search results

I made an application where the user is to select a file and once selected, it loads into a table. Is there anyway or any code that I could write so that it checks to see if import errors occurred & showed up in the table section, so then I could display a dialog box that explains to the users...

I sort of asked this question already today, but I didn't solve my problem after all... Here's my problem--- I want users to choose a fixed-length text file in order for it to be imported into a table that has been created. I thought that I needed to create an import specification, so I...

Hello, I'm new with Access and VBA and I'm trying to learn how to do things such as import files into tables, make reports through VBA, do queries through VBA, etc... Does anyone recommend any good books that will help me with this? Thanks!! :)

Hello All-- I created a table to import a delimited text file and did the whole line of VB code (DoCmd.TransferText acImportDelim etc...) correctly I believe, however, after I load the file into the table, I look at the table and it only contains the first field of each row. For example, in my...

Hi! I made a report from a query that I did, but the last page of the report shows a page header & footer even though there is no data to be shown. Is there a way to get rid of that last blank page that has the page header & footer from the report. Thanks so much for your help!!

Hi! I am a super-novice user of Access and I was wondering if you could possibly help me with my problem (I'm using Access 97)--- I have imported data from 2 files into 2 Access tables. Each one has the same fields--Product Number, Source Location number, destination location number, ship date...