Search results

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.

Yep, the listbox is set up correctly. I haven't found a way to open this particular report at *all* in VBA, but it works perfectly fine when clicking on it in the Reports list on the left hand side, or setting up a button on a form for it.

I have a list box that displays reports that are supposed to open up when clicked. Some of the reports are opening up, some are not, and I can't seem to figure out why. The relevant part of my VBA is like so: MsgBox (Me![ReportList]) DoCmd.OpenReport Me![ReportList], acPreview...

That worked perfectly. Thank you! (This will be good to understand for the future)

I have one form that shows an overview of records, and another form that is used for adding or updating new records. Adding a record works fine, but then when a user goes back into the form, all the text in the main text box is highlighted. I don't much care where the focus is, but the text...

Thanks Simon, Unfortunately, that doesn't fix the problem (and truthfully the way it was set up before was not all that different from that). Remember, the page isn't having any trouble getting to that link itself. If all the data were at that link, it would work fine. It's the fact that...