Search results

Thank you. This works perfect (after the spelling correction). Clearly needed some outside perspective, was working on this all morning

I corrected the misspelling. Working on the single quotes for the fields...

Yea, I realized the loop part just after I made the execute code. I think the execute might work better for me, if I can figure out the syntax

Im trying to do multiple fields but I keep getting a Syntax error. Am I missing an operator/single quotes? CurrentDb.Execute "UPDATE Client SET Client.CaseManger = " & Me.Case_Coordinator & " and Client.CCID = " & Me.ID & " and Client.CMPhone = " & Me.Phone_Number & " and Client.ServiceArea = "...

🤦‍♂️ the whole reason I came here...Yes. The CCID is numeric. It was erroring because of the extra single quotes...Thank you Isaac!

Hey all, Im trying to include the following code in a _Onclick event CurrentDb.Execute ("UPDATE Client SET Client.CaseMgrFax = " & Me.Fax_Number & " WHERE Client.CCID = '" & Me.ID & "'") The event is for Form that includes information that should be updated in another table whenever there is...

Created a form that loads hidden for my user account and requeries the recordset every second, I have the recordset requery on the switchboard timer which goes every second to update the current time on the switchboard itself. A small form that only does a few things. That after opening will...

Hello all, I want to create a form thatll be open hidden for my user account and will be visible when a user logs-in or logs-out For capturing user activity and log-ins I have a form already that is open hidden when they log in (see below) and will capture both when they login and log out. I...

The Forms are Pop-Up, I want the users to be able to move the form to any position on the screen they want...hence the need for minimizing the access window at all times.

Sorry about the code tags. Yes, What I have found in my experience with minimizing or hiding the Access Window is that reloading/reopening the form has allowed for it to pop-up while keeping the access window hidden. I am trying to minimize as much contact with the access window as possible...

Hello All, I have a few forms that are opened as achidden when the database opens and I have a few buttons that will change their property to visible and display the form as necessary. However, I also have accesswindowhidden vba coding and I am looking to keep the visible forms visible while...

Found a workaround for the issue - Created a blank form that opens as Hidden when the log off button is clicked. The unload event then checks for this form. Works like a charm. Thanks for the help! I am in the middle of cleaning up a lot of the code in this database and all the help I get...

I have put it in one of my standard modules. Do I need to reference/call it on the Form code somewhere aside from using the boolean name when checking in the unload event? I keep getting the same error

Yes. I did this. Still seeing the same issue.

Thank you for this! What do you mean by "In a standard module?" I have placed it at the top of all the subs for the Form but I am still getting the msgbox firing whether the user clicks the log off button or not. Any ideas? Log off button: Private Sub Command195_Click() ExitButtonClick =...

Thanks for the help folks. Found this solution. This allows for a search form where you enter the term into a unbound text box. The Results form will come up and load the subform with actual resutls. SearchFormResults Onload Event If Me.SearchQ_Customer_subform1.Form.Recordset.RecordCount =...

Thats exactly what I am looking to do. The Form with the subform/results is only so I can make the results in datasheet view and interactive so they can select the record they are looking for. I want to the dCount portion but im not familiar enough with the syntax to know exactly how to word...

Hi everyone, hope everyone is well and staying safe! Back for a little Search function syntax assistance. I have a search form that opens another form with results in a subform that use the original search form's input. Most of the time, it will display all possible results (it includes name...

Thank you all! I've incorporated that boolean code and have actually started working on shifting my project to outside the Access Shell. This has been a fun project .

I do have a main form and it has a close button that is programmed to quit, saveall. This is the main thing they see once they log in. However, it is within the Access App (Im guessing this is what you mean by Access Shell Window?) they dont have access to anything other than the Main Form...