Search results

I have been using mousehook.dll for years and it has performed perfectly. Until now I have a database that has a very long form and need the user to be able to use the wheel mouse, but only to scroll through the form not the records Any ideas

The solution ended up being as follows. Combo Box 1 controls content in combo box 2 Combo Box 1 and 2 control the content of Combo Box 3 An if statement controlled whether or not there was a combo box needed for the criteria and on big ass table with all of the combo box criteria

The database has a primary table with many sub tables I need to be able to search all of these at once, incorporate greater than and less than for dates and numbers, incorporate Null for all fields and Like for text fields their are approximately 95 fields. Some of the text boxes use combo...

Ok I think this is a tough one. If not please smack me upside the head for being dumb I am using Access 2010 on an Access 2003 Database I am creating a elaborate search form. Let me explain The is is a continuous form and the first field is called TableName. There is combo box control called...

That did it. And now that I see it I see how it works. Many thanks

The . in front of the MoveNext got rid of the error. And it works for the first record and then stops.

I have tried the following code: With Me.RecordsetClone Do Until .EOF Me.chkPrint = True MoveNext Loop End With I get the error Sub or Function not defined. Does anyone have any ideas?

I have a continuous form in my database that depending on the criteria used will display any number of records. Each record has a check box so the user can select a record for printing. Quite often the user wants to select all of the checkboxes. My question. Is there a way to do that in vba...

That article was awesome. Learned a few tricks I will be putting to use in many projects. Thanks

That would have worked but there were a few controls I did not want have affected.

I need to be able to set the Enabled and Locked properties of all fields in a form based on someones security level I know I can do this If Forms!frm_LogonStorage!SecurityLevel > 51 Then Me.FirstName.Enabled = True Me.FirstName.Locked = False Else...

This only works on the form you are on. I needed to go to a record on a different form. Thankyou anyway. I will be able to use this code in other places

That did it. I had tried several iterations of something like this on my own but was getting nowhere. Thank you very much!!

Here is the DB Open the MainMenu Form Then Click the New Button in the Custom Navigation Area This opens pfrm_AddClientDuplicateCheck Use a common first name like John This will show several results On the left side of the list each result has a button because this is a continuous form. When...

Ahha, I got it. Thanks for the trigger nanscombe. There is other code on the after update of these three fields. This form is a filter form to determine if a client exists. As soon as all three text boxes were blank and Information msgbox was triggered to let the user know there was nothing to...

Here is a screen shot of the small dialogue box that appears

I have created a smaller version of the db with the two forms in question and the clients table (tbl_Clients) If you open pfrm_AddClientDuplicateCheck and Type John as the first name you will see that the form is filtered to show that there is a John in the table, Then reset the form and type...

The purpose of the copy is to create a new record using pfrm_AddClientPrimary/ pfrm_AddClientDuplicateCheck shecks to see if the client already exists. If not then the value of those three text boxes are to be transfered to pfrm_AddClientPrimary The fields are bound. The form is bound. The...

I swear my brain has left me for a trip to China or something. There are two forms invoolved in thi pfrm_AddClientPrimary pfrm_AddClientDuplicateCheck On a command button in pfrm_AddClientDuplicateCheck I have the following code. Private Sub cmdAddNewClient_Click() DoCmd.OpenForm...

I have one question. This has to be applied to an underlying form/subform from another open form. I am not sure how to do that. My original code sets the filtre of this form. That was easy to figure out, this is not