Search results

yes i want all records where start and end are within the user input

i tried this code on Star date and working good but when i do the same on END date then dose not show any record . >=(CDate([Forms]![Patient_Information]![Date_from])+CDate([Forms]![Patient_Information]![Time_From]))

once the user enter the date and time then the query will show only record that are between start date + time and end date + time.

please see the attached screen

which field , i have 2 field in the query 1- start date 2- End date should i put the code in 2 field or what what should i do .

i tried this code in query ( Start date ) but dose not show any report Between [Forms]![Patient_Information]![date_from]+[Forms]![Patient_Information]![Time_From] And [Forms]![Patient_Information]![date_to]+[Forms]![Patient_Information]![Time_to]

table data contain Start date = Now End date = now +Duration the form contain a report filter Date_from= Date Time_from = Time Date_To = Date Time_To = Time so wanna filter the report query by data entered by user in above field.

hi guys need help i have qurey and wanna to show record between 2 date (start date and end date) but the data entered in the field contain date and time. so is there i way to show the record by entering the start date in one field and time in another filed and End date in new filed and Time...

done guys thank you i done with this code: On Error GoTo new_Err Me.[cycle subform].SetFocus 'sets the focus to sfrm_Each_Book_subform DoCmd.RunCommand acCmdRecordsGoToNew new_Err: Me.[cycle subform].Form.Cycle1 = Me.No_of_Cycle.Value Me.[cycle subform].Form.date_ = Date

i tried this code but did not work Me.[cycle subform].SetFocus DoCmd.GoToControl ([Cycle1]) DoCmd.GoToRecord , , acNew Me.[cycle subform].Form.Cycle1 = Me.No_of_Cycle.Value Me.[cycle subform].Form.date_ = Date End Sub

done i changed the field to cycle1 but i want the date upon click it go to new reccod in subform and paste the value. how to do that

Hi guys; need help please i have a form and subform, so i created a button to add the value from from to specific filed in subform in new record , i tried the below code but got this error code "the setting you entered isnt valid for this property" Private Sub Command1608_Click()...

because i have 2 report each will show data based on check mark (YES/NO) option

because i need to filter report based on selected drug.

solved thanks guys

HI guys , need help please, i am designing a query for report and i am having field name drug name in query, where the user can enter drug name in the form so what i want is that; to dlookup for the drug selected by user in Drug list (Table) to match the selected drug with 1- Drug name (text)...

Hi guys; need help please , i designed a form with text field once the user update this text filed with Number (ID) then all field on the form will be filled with data form query based on the ID entered but if the ID not present i need to cancel update and show message box " no record found"...

thank you so much solve successfully

i changed the field to drug_name

the error in this line exp_date = Date + BUD cant attached its big size.