Search results for query: *

Right... I've been testing this for a few days and know for certain that the recordID is correct; it's an autonumber generated by Access when the record is created. How does one go about checking for corruption? A Compact and Repair doesn't prevent the problem.

Sure. It's just a standard "Find" button. Here is the code behind the button. Private Sub Command72_Click() On Error GoTo Err_Command72_Click ' search button Screen.PreviousControl.SetFocus DoCmd.RunCommand acCmdFind Exit_Command72_Click: Exit Sub Err_Command72_Click...

I have a single form that users have been using for months and months. All of a sudden, when someone does a search for a particular record ID, it fails and produces a Not A Valid Bookmark message that won't go away. The user then has to red 'x' out of the application. Using MS Office 10, Access...

Thanks, I'll post my question there. btw, the button I use is the standard "find record" button that I placed on the form using the button wizard, nothing special with that button.

I have a single form that users have been using for months and months. All of a sudden, when someone does a search for a particular record ID, it fails and produces a Not A Valid Bookmark message that won't go away. The user then has to red 'x' out of the application. Using MS Office 10...

Thanks for the suggestions and advice.

Been there, done that. It's a daily issue with me. I have users on the system from 6:30am - 5:00pm and after that, I would like to perform updates, modifications, etc. but can't get exclusive rights to it with that ldb file in place. Is there a way I can remove it if I know everyone is...

Right, not the usual lock issue. I tracked down the last user to the db by looking at the time stamp w/user name on the table and paid a visit to her. Her db client settings did not indicate a record lock in any way. She had closed the db but for some reason her computer name was still...

I have a multi user (15-20 at a time) db on which users enter time (and other data) into a form which updates a table. The db has been working with multiple users for about 18 months with no apparent problem. Until today. Now, when someone tries to enter their time into the db and move on to...

Here's what I did to fix my situation. I removed the frame (with 2 radio buttons) and replaced it with a single check box with a default value of False. I'm able to change its value back to False when I need to. It's not what I wanted to do, but it works just fine for my needs. Thanks for...

OK. I've tried me.radiobutton.value = true isn't working, I get the same error. What is the best way to change the value back to the default?

Haven't been able to find the answer to my problem yet. If it's out there, please point me in the right direction. I have a report parameter form where a user selects a value from a combo box and then a begin date and end date. On clicking a 'submit' button a barcode report is generated and...

Of course. Thank you!

I must be looking in the wrong places because I haven't been able to find an answer to my question. I have a user input form that populates an "equipment" table. On this form, I have a combo box bound to a separate table. The user can pick a value from the combo box or enter their own value...

Hey MazeWorX - haven't tried that. Thanks for the tip.

I've searched the site for problems regarding "strange characters" but haven't found this particular problem. I have a parameter input form which retrieves a set of records that meet those criteria, e.g., area name, beginning labor date, ending labor date, problem code, and building. The...

Nevermind. I figured it out. Thanks for the clue about the TransDate having a time value to it.

So now the question is, How to get the user to enter the time parameter from a date picker.

Thanks PVH, it does have a time value. I guess I've never had the need to include a time value, but this time I do.

OK. I've been using "between "dateA" and "dateB" for a while now and have a situation where the records with dateB don't appear in the query results. Here is the sql code I'm using; SELECT T_DMZ_EQUIPMENT.ITEM, T_DMZ_EQUIPMENT.TRANS_DATE FROM T_DMZ_EQUIPMENT WHERE...