Recent content by JJman

Lo and behold... that's what happened. Sometimes it's the "make sure it's plugged in" kinds of issues that bring developers to their knees. :) I'll deal with that and also put some locking on the form. Thanks for your help!

Actually, as far the first issue, my understanding is that one person's information would only overwrite another's if they were editing the same field, which they are not. I assumed they could all use the form at the same time without a problem so long as they stay out of each other's fields...

We have several instances of this in our database. Simply use an expression as a field in the SQL for the second combo box that references the first one as it's criteria. Then, on the afterupdate event of the first combo box, requery the second. Como1 afterupdate event to requery combo2...

We have a form which tracks information for certain tasks. Each day, different users record the information related to his or her own task in specific fields, and leave all other fields alone (there is no security in place to prevent it, they just don't). We're having an issue where each user...

Just a side note to say I haven't actually had time to try it yet. I temporarily changed it back to a text field. Hopefully TheAceMan (or someone.... anyone!) will come to our rescue. :)

Sounds like another A2k bug that throws sand in the gears... Thanks for the heads-up.

When the code below runs, it highlights the first "Left" keyword and gives me a message saying it can't find the project or library. Any help is appreciated. Private Sub ChildID_AfterUpdate() Dim teststring As String Dim teststring2 As String Dim teststring3 As String...

Like "[a-z][a-z]*" worked great. Thanks to both of you!

I'm working in an Access Project to put criteria on an expression field to only show records where the left two characters are letters, not numbers. I've tried unsuccesfully using wildcards specific to each. Any help is appreciated!

Wonderful! Muchas Thanks! :)

Can anyone tell me how to set up compound unique indexes in A2K (as opposed to compound PK's)? I've heard there is a way but can't find information on it in Help or any books. Thanks!

Ok, I'll give this a shot. I was hoping I wouldn't have to go this route if I could avoid it, only because the table has almost 10 million rows and even optimized queries take quite a while to run, especially since this is only one of two nested queries. I'll let you know how it goes. Thanks...

Thanks Hap! Also very good info!

Thanks! These will be very helpful!

Some months ago one database here began getting an error message when users tried to open it saying "Error accessing file. Network connection may have been lost." The network connection was fine, however. Users were completely unable to use the database, though it can be opened with the...