Search results

Any other ideas?

In response to gemma-the-husky, The database I'm creating is mainly for data entry but it will require the users to do some occasional search and edits. My users are not very savy so I need to make sure they consciously make the decision to update an existing record. I would prefer not making...

Again, thanks for the replies. Pat, I switched it to a command button and it works in unlocking the subforms but not the parent form. When the form loads everything is locked down but when I push the button only the subforms allow me to edit. That seems strange since the OnCurrent() event of...

You're right, Pat. The other buttons are working now. It is only the button I am trying to use to unlock the record that is not working. When I click it it won't even stay depressed. I'm using the code: Private Sub tglLockUnlock_Click() Me.AllowEdits = True Me.AllowDeletions = True...

Pat, thanks for your response. I tried the code above and it worked in locking the records but unfortunately also locked all of my other command buttons on the forms, (I guess that's logical) so I would have to make them exceptions. So since the whole form is locked the toggle button is also...

I'm trying to add a toggle button to a form that will lock and unlock the form to prevent inadvertant editing errors. I've looked up all of the code I could find on this issue and still run into errors and problems (my VBA level is beginner). Any help would be great. I have a form with two...

Here is my query field in a make table query: Date of 3 month f/u due: IIf([Date of IC Review] Is Not Null,([INDEX_DATE]+83),"") But I want the response of ([INDEX_DATE]+83) to be formatted as a date and not as text. The existing table field of INDEX_DATE is already in date/time format...

I got lagbolt's final reply to work for me and it went great. Plog, I created the table you suggested and tried to run the query but it gave me this message: "Cannot join on Memo, OLE, or Hyperlink Object ([06_tbl_Second_Third_Attempts_EXPORT.Response=tblResponseTimeFrames.ResponeType)."...

Fairly new to access and I've searched all over to get the syntax on this right. I have a table with a field [Response] and a field [Index Date] along with an Id number. I've tried this IIF statement but keep getting the Invalid Syntax error - "You may have entered an operand without an...