Search results

What if need to combine date and text parameters together to pass to opening form to display records based on text valeu between two dates. I have following problem: I am trying combine following two fields in ms access vba, Private Sub Command6_Click() DoCmd.OpenForm...

The form is based on a simple select query. It has two button, one for closing the form and one to run the query again. There is no other code on the form. I can't send the whole db, because of nature of the dB. Thank you very much for your time.

What if need to combine date and text parameters together to pass to opening form to display records based on text valeu between two dates. I have following problem: I am trying combine following two fields in ms access vba, Private Sub Command6_Click() DoCmd.OpenForm...

What is the Data Type of txtConsultantDoctorName field in the Table's design view? Text type Row Source - looking up from a group query Bound Column - unbound Column Count - 1 Column Widths - 1 Please be notified all field on the form are unbound. This is a query form which passes parameters to...

the above is right

"dtDate between #" & Format([ApptStartDate], "dd-mmm-yyyy") & "# And #" & Format([ApptEndDate], "dd-mmm-yyyy") & "# the above part works fine but when add the following part it does not work And [txtConsultantDoctorName] = '" & Me.CBODocName & "'" I am actually combing date criteria with...

"txtConsultantDoctorName" I have literally copied the quoted name from the table. Yes this is name of field in the table sorry for inconvenience

yes it is, it is combo box on the form named "frmRecordbetweenTwoDatesbyDoctorNameFormView" and CBODocName is an unbound combo box on the search form and two date field are also on the search form

Re Hi Can somebody help me, I am trying combine following two fields in ms access vba, Private Sub Command6_Click() DoCmd.OpenForm "frmRecordbetweenTwoDatesbyDoctorNameFormView" , , , "dtDate between #" & Format([ApptStartDate], "dd-mmm-yyyy") & "# And #" & Format([ApptEndDate], "dd-mmm-yyyy")...

how do I do that

Hi Can somebody help me, I am trying combine following two fields in ms access vba, Private Sub Command6_Click() DoCmd.OpenForm "frmRecordbetweenTwoDatesbyDoctorNameFormView", , , "dtDate between #" & Format([ApptStartDate], "dd-mmm-yyyy") & "# And #" & Format([ApptEndDate], "dd-mmm-yyyy") &...