Search results

Hi, Not sure what you want to do. My guess is that you want to change the form's Recordsource. That's the easiest solution. Here's what i think. Create or copy "qryaddNewTransaction". With the new query, add the WHERE condition. In the checkbox on click event,change the RecordSource to the...

Hi, Is this code in the current database? Is this code in a form's module or a standard module?

Hi, Change your code to this. Private Function FilterIt() As Variant Dim varFam As Variant Select Case Me.cboGroup Case "(All)" varFam = "[Group Name] LIKE '*'" Case Else varFam = "[Group Name] = '" & Me.cboGroup & "'" End Select FilterIt = "WHERE " & varFam End Function

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.