Recent content by mcbass1

I love this forum! Thanks Shadow, I used your suggestion and created a function that I call from the query - It worked perfectly. And thank you too Bob. You've helped me out of more jams than I want to remember. Mike

This error seems to be showing itself on a handful of pc's that use the database. The problem seems to be pc specific, not user specific, but I have been unable to find a fix. I had one of the users that is getting the error go into the vb script editor of the database in question and type in...

Thanks guus, I'll give it a shot.

Thanks Guus, I actually have that in place right now. I added two fields to the table, one check box called "locked" and one text box for the operator id. If the box is checked when a user tries to pull up a record, a msgbox tells them who it's locked by and pulls up the record read only. If...

I have a form linked to a table in a FE/BE database with multiple users. The problem I'm having is that multiple users will be accessing the same record at the same time, and the write conflict error shows up. I have changed the form to update the controls from commands entered in an...

Thank you Banana and Pat for your help, but I think recordsets and connections are beyond my scope at this point. I only have a year and a half of self teaching under my belt. I've created a work around that seems to have solved at least my record locking problem. I found a post by Shadez...

Is the construction of a recordset what I need to do to enable record level locking? Here is my onload event, but it's giving me an error: no value given for one or more required parameters. Private Sub Form_Load() svo = Forms![*Dispatch Panel]![SVO#] svcdate = Forms![*Dispatch...

Great, SQL - I know less about that than I do about VB. I'm trying to add a WHERE clause for two fields but keep getting an error. Private Sub Form_Load() 'specify the OLE DB provider and open the connection. With cnn .Provider = "Microsoft.Jet.OLEDB.4.0" .Open...

OK, I added the following code to bind the forms to an ADODB.Recordset Object and feel like I'm close: Option Compare Database Private cnn As New ADODB.Connection Private rst As New ADODB.Recordset Private Sub Form_Load() 'specify the OLE DB provider and open the connection. With cnn...

I don't have any coding, defining connections. Could that be the problem?

I verified it's 2002-2003 format. I created a db from scratch and just imported everything to it - same result though.

Yep, "Edited record" is selected on Default record locking, and the "Open databses using record-level locking" is checked. I cleared out the query, inserted three new records and tested, and two of the records seem to be on the same page - can't modify both at the same time. Help, Mike

Thanks for your reply Pat and please exuse my ignorance in this area - I'm learning. I'm running Access 2003 and Jet version 4.00.9511.0 If the database is set up to open using record level locking, why would it be locking at the page level? Thanks, Mike

Thanks Pat. I have no clue about this - is there an easy way to get and use jet 4.0? Looks like I have a lot of reading to do. Mike

I have another problem with the dispatch panel form: I'd like multiple users to access this continuous form, and sometimes a few people can go into it at the same time. But, during testing, some users were not allowed to go in. There's no error, it just won't load.