Recent content by RSW

Thank you both! I'll try that out.

I get "Method or data member not found" errors on several different databases when I open them on my PC. On some databases, I get errors on virtually everything I click (On Enter, On Click, On Dbl Click errors, among others). I've done some research into these errors. Looking at my VBA code...

Thanks! I wonder how that happened? I don't know that I ever would have caught that.

Records can be added into the "Final Assembly" query...which is how I want it. I endeavored to set up the "Structures" query just about identically (the only real difference is that I need two temperatures in its table)...but that one simply won't let me! I've pared down the database as much...

The control source of the combo box is "Location", which corresponds to the column in the table. The row source is a simple select query from a lookup table.

I have a simple form that has a table as its data source; it's mostly text boxes, with one combo box. For some reason, changes made using the combo box are not made in the record. A selection can be made using the drop-down, or an update can be typed into the combo box, but move off the...

I am able to link to an Oracle table through an ODBC connection and update records (directly in the table). I gave detailed instructions on how to do so to another user. She tells me she is able to see the table, but she can't enter data--she gets a "ding" sound when she tries. I am unable to...

That's a good idea--so would it just be something like this? If IsUserMemberOfGroup("admins", CurrentUserID) Then Me.AllowDeletions = True Else Me.AllowDeletions = False End If (the IsUserMemberOfGroup function works fine)

I'll do that as a last resort, but ideally I'd like admins to be able to delete records from the form (the "Delete" button still appears for admins, but neither of us deleted the records in question). I'm definitely interested in hearing your ideas about how it might be happening!

I have a form which had led to records being deleted erroneously. I took off the "Delete" button I had put on the form, and disabled the Delete key (keycode 46 is for both the regular Delete key and the one on the number pad, right?) I didn't think there were any other ways that a user could...

The delete button would still work even if the delete records option was no?

Thanks Bob, this worked perfectly. It seems to also disable the delete key on the number pad (which is good)

Thanks Bob, I'm unclear...do you mean KeyPress or KeyDown?

I have a form that deletes a record if the Delete key is pressed when the form's on that record. I don't want to entirely stop the form from deleting records...because there's a Delete button that can be used for just that. But records are being deleted without warning when a user accidentally...

The name of the report is ReorderRpt. No funny characters or reserved words as far as I can tell.