Recent content by IceGirlAnne

Well, it shouldn't really be a problem if there are import errors, but if the user were to accidentally load the wrong file, I just wanted them to be aware of it from the beginning instead of waiting to see the final report, where the data is all messed up. Thanks anyway!!!!!!! :) :)

Hi, Well, when I run the application I made, if the user chooses a file that's not based like on the import specification I made, an error box doesn't show up, it just continues and creates a report based on no or wrong data. I just wanted my program to check to see if import errors occurred...

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

thanks Great! Thanks so much for all of your help!! I really appreciate it!!

In other words....I thought I was reusing it, but when I go to check, only the first column of that file is showing the file, and the rest of the column fields are blank for that different file that I am importing.

Yes, that's exactly what I mean. How do I reuse an import specification? Or, what steps should I take to do that? I'm sorry...I'm very new at this!! And, is what I did to create an import spec in the first place correct? Thanks for your help!

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

Don't worry about it! I got it to work. My number fields in the table were set as long intergers and they should have just been integers. Thanks anyway!!

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

thanks! Hi! I tried it again and I think I got it to work!! Thanks for all of your help!!! :D

I tried.. Hi, I just tried and it didn't seem to work. It's as if the last page thinks that there is data there to be shown but there is no more data to show, so it's just a big blank space there with the page header and footer.

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