Recent content by chadrj

Yes, it does, but I am receiving the input as an integer... Would just changing it to a string value fix it...? I will try... Sure does. That was stupid easy! Thanks for your help! Never try to teach a pig to think. It doesn't work and it annoys the pig. -Anonymous

How can I allow for a user to enter "2" in an input box as the value and have the result differ from when the cancel button is clicked? Apparently vbCancel = 2. Thanks, Chad Never try to teach a pig to think. It doesn't work and it annoys the pig. -Anonymous

Is it possible to change the name of the file that appears when using sendobject. For example when sending a query (qryTest) as an Excel document, I would like to name the query something more meaningful ("Test 11-04") without having to change the name of the query in Access. Thanks Never try...

Thanks for the helpful information. I changed the Import Spec in the 97 DB and copied the MSysIMEXSpecs file over to my 2002 DB (after renaming the 2002 spec file). It also needed to copy the MSysIMEXColumns table because it inculdes the column names of for the specifications. Now all is...

I have a database originally created with Access 97 now in Access 2002. While in 97 I created some import specifications to import some text files. Now the format of the files have changed so I need to change the import specs. The problem is that when I try to import a text file through...

Great! Thanks for your help. I will migrate to this new method, and have more confidence that my db will be safe if I'm not here for a day.

There is no error detected, at run time. It just corrupts the database. But... Good news. I think I have fixed the problem. It is possible that this is something that you have advised me to do at some point, or that you assumed I should have already been doing. Before each time I save a...

No hole. They are consecutive. Words can not describe how gratefull I am that you are willing to take a look at this. Enjoy your beer.

1. Machine 1 adds a record 2. Machine 2 adds a record 3. Machine 2 edits the record just added by machine 2. 4. Machine 1 edits the record just added by machine 1. >When machine 1 saves the data for that edited record, the error occures, and you find out that the record was deleted, (or never...

1. I refresh the recordset after adding a record which helps populate the text box with the most recently added record for the individual (caller). I understand the problem that can arise if another user opens a record at about the same time, but these records are first filtered by the caller...

>The reason for these, is you need to be able to find the record just added, and do not know what Autonumber was really used I do capture the auto number that was used. It populates a text box at the time a new record is added. Would I still need to create a GUID to actually find the record?

Machine 2 is really adding a new record. I am trying to simulate entries of calls in a call center environment where multiple reps are entering calls but may overlap to some extent. With the autonumber, I am capturing the newly assigned number that populates a text box and using that to...

Since last post... trial and error with little success. Some more tidbits of information that may help others identify the problem. 1) The program works fine if I run 2 instances on my machine 2) The error in the original post actually occurs when Machine 2 tries to update. It appears to...

Well, my cursor is client side, and I have changed to adLockBatchOptimistic and Update batch. I am using an AutoNumber field as the key, but want to keep it that way if I just need to requery after an addnew. At what point after the addnew do I need to requery? Thanks for your help!

I have an application that uses ADO to access an Access 97 DB. Everything works fine with one user, but in testing with multiple users I get various errors. I am having a hard time finding any information on how to handle multiple users with different recordsets from the same table. The...