Search results

A simple way is to add " ALL" to your combobox source. Then code accordingly as: If Me.ComboBoxName.Value = " ALL" then Docmd.openquery "YourQueryALL" else Docmd.openquery "YourQuerySELECT" End If Make sure you have a space before the word "ALL". This way, " ALL"...

Office 2000 Developer Edition would allow you to distribute your application royalty-free by creating a "run-time" version of your program, "Professional" does not. edtab

Hi John, The problem lies in the fact that you are using the same query as the source for your main form and the 3 sub-forms. I have a "suggested" solution for you. Look at the form "Master2" and the "qryINCIDENTS" which I have created for you. You'll see that by doing it this way, you do not...

OK, got your mdb. Which form and subforms are you having problems with? edtab

Send it to edtab@hotmail.com edtab

If you db is not too big, you may e-mail it to me. I'll see if I can figure out your problem. No promises. edtab

Just because you're moving your mdb to a dedicated server does not mean you have to move up to SQL. What I suggest you do is "split" your database into a "front end" and a "back end" if you have not already done so. The back end should reside in the new server and the front ends should be...

You usually get this type of message if you try and assign a value to a "calculated field". You may want to review the "after update" event of your combo box and see what fields are being updated. edtab

On the same form, create a combo box which will allow you to isolate a group/category of employees. Next, create an option box and using "Case ...End Case", with 8 possible sort orders. You would then create 8 queries based on the combined values of your dropdown combobox and optionbox. Run...

Try this: Private Sub Command0_Click() If InputBox ("Please enter your password.","Password Checkpoint") = "make_up_a_password_to_fill_in_this_space" Then Dim stDocName As String Dim stLinkCriteria As String stDocName = "Mailing List" DoCmd.OpenForm stDocName, , , stLinkCriteria...

I think you can use a combination of dropdown combobox and option box which will limit you to 8 queries only. I've seen this done before. If you are interested for more details, let me know, I might be able to help. edtab

! If I understand your question correctly, you have a main form and multiple subforms showing together on the same screen and that you would like to transfer values from your subform into the main form. The main form would have a name that Access recognizes... eg. "forms!frmWorkOrder". Your...

Try this: Me.Text50 = "Hello" & DLookup("Name", "passcode", "IDNumber = " & Me.password). edtab

Is it possible to send a particular Access report to a specific printer via code or some other way? edtab

Whatever the user filters will show in your list... at the same time, the same items will also show in your report if you choose to run it. edtab

a) Create a report using the same data source as your list box. b) Create a command button on the same form where your listbox is. c) Run the report using a "Docmd.openreport" in the "Onclick" property of the command button. edtab

In the AfterUpdate event of your CheckBox, try placing the following code: If Me.CheckboxName.Value = -1 then Me.ListBoxName.Requery End If Substitute the name of your CheckBoxName and ListBoxName accordingly after the "Me." This should work. edtab

Hello Bob, Thanks for sharing your knowledge with the forum. Just goes to show the more you learn, the more you realize you don't know enough. This is another way of protecting your code without converting to an mde. edtab

Hi Bob, Would you want to share how you hid your modules? This is quite interesting ! edtab

Unfortunately not. I know you can't change the code of an mde. I'm talking about a simple mdb. Can Access be installed in such a way that modules can be hidden? If you can, I am not aware of it. edtab