Search results for query: *

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

I'm using the make-table query below but I only want it to give me one record for each Student_ID (alias for dbo_corr.from_descr), where it has the maximum dbo_corr.entry_date value. I know I need a HAVING clause with a sub-select statement, but don't know the syntax to do this. Help! SELECT...

Oops! Forgot to post the SQL... SELECT A.Primary_Unusable_id AS PrimaryID, B1.Unusable_description AS Primary_Desc, A.Secondary_Unusable_id AS SecondaryID, B2.Unusable_description AS Secondary_Desc, A.Unusable_date, A.Child_Key, A.Child_name, A.Additional_Comments, db_country.SPM_name FROM...

I changed a text field in a table to a memo field to allow as much space as needed to store text, however, now a query that was selecting that field only displays two characters (that I can't reproduce here). I use the query to do a mail merge, and now the mail merge displays things like ?', ?X...

Both ways worked great, Tony. Thanks again. May I ask where you got the value of 700 for bold formatting? I'd love to have a list of things like that.

Hi Acdel, I was using conditional formatting before, but it wasn't working. It would apply the formatting even when the value was only 2. Very strange, I know. This is why I decided to code it instead. Anyway, I'll give Tony's ideas a shot. Thanks to you both!