Search results for query: *

I found something out on the Microsoft Knowledgebase. Basically, I've been working on some append queries and I was trying to append an autonumber to an autonumber. When I would fix the database by copying the structure and then pasting the data, it would work until I messed up and tryed...

The compact and repair allowed me to enter one record, I left for the day, the ladies tried to enter more and got the same error. The id field is primary. When I enter the form, I enter in add mode and the field is actually not even visible because it normally just goes to the next number and...

I have an autonumber field in a table that was working just fine, for some reason now when I try to enter information into the table, I get an error that I'm creating a duplicate index, what the heck? Not even sure what possibly could be wrong. Help!

I'm trying to use the following code to import a file into a table. However, I'm getting the error "Run-Time Error 2391" Field F1 doesn't exist in destination table. However, when I go file, get external data, import I can successfully impor the file. Not sure why I can't do it in...

The open worked, now I'm trying to figure out what variable the file name is located in. I've stepped thru the code watching the variables to find the one that contains the file name so I can do my import, but haven't been able to locate it.

Unbelievable!!! Thank you, it worked, now I can go on figuring out the rest. Thank you, thank you!

You'll have to bear with me, I'm fairly new in VBA, I did get the reference you noted established, but the Common Dialog Control is what I'm having problems with. I just have been unable to figure out how to get this thing to work. You helped me tremendously by telling me which reference I...

Thanks, that worked great, however, I'm doing an import and want to be able to actually select a file to work with in my code and I can't see the actual files in the folder, just the folders. Do you have any more suggestions? Thanks Lisa

I am having the user select different files to import into an Access 2000 database. In VFP there is a Getfile() command, is there anything like that? I've been doing research on this and everything I've found is tons of code, that I'm having difficulty making sens of. Is there something that...

I have a table with shooters in it and there total scores. There are 3 different classes (Master, Expert and Sharpshooter) and there are 3 different postiions (Standing, Kneeling and Prone). The number of awards...

I have a table with shooters in it and there total scores. There are 3 different classes (Master, Expert and Sharpshooter) and there are 3 different postiions (Standing, Kneeling and Prone). The number of awards handed out depends on the number of competitors. What I’ve done is create a...

I have a table with shooters in it and there total scores. There are 3 different classes (Master, Expert and Sharpshooter) and there are 3 different postiions (Standing, Kneeling and Prone). The number of awards handed out depends on the number of competitors. What I’ve done is create a...

Well, It's now now updating the same record, but still is not updating the correct information. Do I maybe need to use a tabledef? To be honest with you I was surprised that opening and updating the table as a recordset would put any information into the table. If I'm sorting the recordset...

Thanks I will give this a try. Sometimes it seems you just get so frustrated you can't see the little things. Hopefully this will work. Thanks again, I'll be back if I'm still stuck!

Did you guys ever find out where and how to do this?

I want to assign awards and update a table. How the heck do I do this? The code below is updating the table, however, it updates the same record every time. Is there something wrong with my sort? How can I get the code to know which record to update in the table. I've been stuck on this for...

I want to assign awards and update a table. How the heck do I do this? The code below is updating the table, however, it updates the same record every time. Is there something wrong with my sort? How can I get the code to know which record to update in the table. I've been stuck on this for...

PLEASE!!! Anyone out there have any ideas?

I was installing Microsoft Money to check it out. I have 2 partitions. C and D. Well now I can't see my D: drive, well it says my cd rom drive is my D: drive. I have absolutely no clue how to fix this. I don't have a lot of experience in this area. Thanks Lisa

I have a recordset that I'm trying to sort in descending order, then according to a loop I've designed move thru the top 1-3 and assign a position. Ex 10 competitors 2 positions etc. However what is happening is the first time I go thru the loop it updates the correct record, but it stays on...