Search results

Private Sub cmdSearch_Click() Call Search End Sub Private Sub Search() Dim strCriteria, task As String Me.Refresh If IsNull(Me.DateFrom) Or IsNull(Me.DateTo) Then MsgBox "Please Enter Date Range", vbInformation, "Date Range Required" Me.DateFrom.SetFocus Else...

I get an error 2580

Please help how to resolved this issue I made Command button to clear the value on search by date and showing all data again I get an error 2580 I use below VBA Private Sub CDMClear_Click() Dim task As String Me.DateFrom = Null Me.DateTo = "" task = "select * from qrySearch order by...

Dear Gasman, I tried to use the Macro see below, the question is where can i put a password? Sub Macro3() ' ' Macro3 Macro ' ' Columns("A:G").Select ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _ , AllowFormattingColumns:=True...

Dear All, I'm attempting to protect the entire worksheet except for a set column "H" can be editing I use below vba the problem is all entire worksheet is protect please help how to : Sub Lock_data() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Protect...

Dear All I would like to know how to either disable or remove the close button from the title bar in Access if this is even possible. Thanks

Dear arnelgp, This is what i'm looking for, is working @Gasman your VBA also work, Thank you for all of your help and support

Dear Gasman, Could you please help, You can check my file Thank you

My form contains a text box and a combo box. I would like only When a value is selected from the combo box I want it to be displayed msgbox "Date Entry Required" if in the text box (Date) is empty. The combo box contains a list I would greatly appreciate help on this. Thanks in advance

yes of course

I use textbox unbound, I would like only the Datum must be required if user select value on Status if on status is empty on the datum not required Thank you

Dear all, How to programatically set Textbox to be required? If value on Status on the textbox Datum must be required Thank you in advance

Hello arnelgp, I Like this , thanks for your help Well done

How to Select Multiple hyperlink Records to be Printed in a Report in Microsoft Access. Select Several Rows. If I want to print invoice I have to click one by one in the hyperlink number op the invoice How to select multiple hyperlink to print those invoice

Zie result from the filter

I'm having a little trouble with the form filter in Access. I'm using the listview in a few forms and the user needs to be able to filter there. all data is from combo box please help how to resolve

Dear arnelgp, Thank you for your help, is working well done

I use ms access 2019, which ms access version are you using

I just add accdb file

Dear All, I would like When the invoice status is selected approve, an invoice number is given. Now an invoice number is given with all entered words, do you know how this can be solved Thank you in advance