Search results

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.

The checkbox is in the table and in the queries but not on any form. There are no unbound fields in the continuous form at all. Here are some screen shots: The five fields in the continuous form run off a query and show two or three fields from each record. When clicked, the single form...

Banana: I had actually already moved that code to the form_current event, just had an old version that I shared. The other is still on form_unload, because I want the checkbox to uncheck when they exit, even if they don't alter anything on the record. I guess it may be better to use...

Hi Banana. I have two fields I added to the table, one is a check box which is checked when someone is in the record, and the other is a field that holds that person's ID#. The check box is checked on Load - if it's not checked, it checks it and puts that persons id# in the other field and the...

The dispatcher does need to update the record. I don't have a problem with them (receiver or dispatcher) only being able to update a record when they are the only one with it opened, but the problem with record locking hinders that. When I go in the back way and pull up a record then try to...

There will be instances where a dispatcher has a record pulled up, documenting it while talking to one of our contractors, and the customer calls back. I'd like the receiver of that call to be able to update the record - right now it would be locked, although it will tell them it's locked by a...