Search results

let me try tomorrow, will let u know.

Yes it is correct

If TempVars!sRepRecSrc01 <> vbNullString Then [Reports]![rptFullDue]![Pro-FormaDue].Report.RecordSource = TempVars!sRepRecSrc01 The Above also Doesn't Seem to Work

iam entering in the open event of the Main Report

sorry Typo Error i have 3 subReports in a Report, want to change the recordsource for all the 3 subreports if to be displayed in this report. iam using the following: If TempVars!sRepRecSrc01 <> vbNullString Then Me.Pro_FormaDue.Report.RecordSource = TempVars!sRepRecSrc01 Error is You Entered...

i have 3 subforms in a form, want to change the recordsource for all the 3 forms if to be displayed in this form. iam using the following: If TempVars!sRepRecSrc01 <> vbNullString Then Me.Pro_FormaDue.Report.RecordSource = TempVars!sRepRecSrc01 Error is You Entered and Expression That Has an...

sorry i didn't know whether to post here or there, let me remove it there.

i do understand, may be i don't know how to do it. What iam trying to do is Use a Single Query and a Report for Different forms. Iam able to open a Query with DoCmd.OpenQuery but DoCmd.OpenReport gives and unknown error.

tried "Like " * " & [Forms]![frmReports]![cmbCropYear] & " * "" its not working

iam looking to use a single access query for different forms

I want to store the below Form Criteria in a Global String Like " * " & [Forms]![frmReports]![cmbCropYear] & " * " When i store it returns nothing, request someone to help.

Iam getting error with the following Line: If DCount("[Duty]", "tblstaff", "[SellerID]= sSellerID And ([Duty] = 8 Or [Duty] = 12)") >= 1 Then Also tried - If DCount("[Duty]", "tblstaff", "[SellerID]=" & sSellerID And "([Duty] = 8 Or [Duty] = 12)") >= 1 Then sSellerID is an Integer Can Someone...

Thanks Onur_Can and arnelgp, it worked fine. Stay safe and healthy everyone

i get the following error at Set rs = db.OpenRecordset("tblStaff") You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column. (Error 3622)

can someone help with the code

sEmail = DLookup("[E-Mail]", "tblstaff", "[SellerID] = [cmbSeller] AND [Duty] = 2")

Iam trying to get the Email Address of 2 Staffs is "tblStaff" with 2 Conditions. one condition is the sellerid and second condition is duty=2. following is the code iam using. If DCount("[Duty]", "tblstaff", "[SellerID] = [cmbSeller] AND [Duty] = 2") >= 1 Then For i = 1 To DCount("[Duty]"...

its Sql Server, iam querying a linked table

Can u please then tell me what i shld do

Iam Using the SQL LIKE "*" & Forms!YourFormName.YourComboBoxName & "*" in the Criteria of a Access Query. i have 4 controls to be searched like this. I need to search a field with Numbers. While Searching for "1" it returns 18,16,12,13 instead of just returning "1" if i use...