Search results

Hi, Then, "Option.Value" should work. "you entered an expression that has no value" The code you gave might not come from it. Is there something else in the code? In the VBA editor, where did the line stop?

Hi, It should be "Option16.OptionValue". This control ("Option16.Value") does not work in VBA. You can set the OptionValue to 1,2,3...etc. HTH

Hi Try this at Microsoft Here

Hi Lucantha, Look at code and comments. First is the "strIDr" where you want to filter the form is the control/Column/Field, is it named correctly? And is "strIDr" a Text or Number? Private Sub Label46_Click() On Error GoTo Err_Label46_Click Dim stDocName As String Dim stLinkCriteria As...

Hi, Try Here

Hi, Try something like this, SELECT txt, ordr FROM (SELECT DISTINCT 'All' AS txt, NULL AS ordr FROM ColorTable) UNION SELECT colorName, colorName FROM ColorTable ORDER BY ordr;

Hi, It's too lenghty to explain, go Here Down load the sample.

Hi, First, Create a Main Form with the RecordSource from Table1. Second, in that same form, create a sub form where the Recordsource is from Table2. Is that easy.

Hi, MS assumed this "Option Compare Database" by default as included the the module. Put it back. There are very little details on how you use the buttons to print the reports. Post the SQL syntax for us to see.

Hi, Maybe you mean the default toolbars in Access? Go to Tools - Customize - check the Toolbars like "Form Design".

Hi, Try without the quotes, like =DLookUp("VendorName","tblSuppliers","VendorNo=" & [VendorNo]) Your column "VendorNo" is a Number datatype and a double.

Hi, The "mailed" table, go to the Table Design mode - go to the ContactID, at the General Tab, at the Indexed Field, change to "Yes (No Dulplicates)". But on the "responses" table, the "contactid" column - it must be set to "Yes (Dulplicates OK)". However, these two columns must be unique in...

Hi, Not the forum, on the left frame of your browser there is a Blue Bar "Menu", click on "+" - "Sample Files" - "+" - "Main" - "+" - "MS Access" - Click "Forms".

Hi, Go Here

Hi antonyx, This is a continuous form with mutli comboboxes and it's on the Detail section. The three comboboxes on top of the detail section is in the Form Header. I hope Peter sample can demostrat the workings of a combobox in a continuous form. If not, look at the Sample at Ken Snell...

hi, Try. if Not IsNull((RS![Unit Type]) then

Hi, Try Here Look for conditionalformating.

Hi antonyx, First, the combobox is not inside the listbox. It’s on top of the listbox. Judging from the query, the listbox on the left is using this query. The listbox on the right using the table called “Driver”. What you are asking is called a listbox search or listbox to listbox. The use...

Hi jempie, Yes you can. If you have a existing table that has a Column with a “AutoNumber” First, do your “Make Table Query” as usual. Name that new table, right click the empty space above the QBE fields. Select the Table with an Autonumber. What you need to do is use that Table, put into...

Hi, Have you check the subform properties tab - Data - Link Child Fields and Link Master Fields?