Search results

Actually I want to update the data in same table upon user choice. So I have table ShirtStyle which contains records and one Field called StyleType. I would like to apply same style to other Pieces. For this i created another table to save Each StyleType and then to get the same style to update...

Hi, Please have a look on the attached image. I have a table which contains Already Saved Styles. I would like to update the new table with already saved Styles where by considering form1 parameters. Style Type field always blank in new table so Style will be added to new table field using...

UPDATE tbl_Saved_ShirtStyle INNER JOIN tbl_ShirtStyle ON tbl_Saved_ShirtStyle.OrderNo_ItemNo = tbl_ShirtStyle.OrderNo_ItemNo SET tbl_ShirtStyle.StyleType = [tbl_Saved_ShirtStyle]![StyleType], tbl_ShirtStyle.Collar = [tbl_Saved_ShirtStyle]![Collar], tbl_ShirtStyle.[Mandarin Collar] =...

Yes this is working great! So I did mistake not added Inner Join?

Hi, I am trying to add the query to update Table 2 using Table 1 data but it is not working UPDATE [Table 2] SET [Table 2].Name_ = [Table1].[Name_], [Table 2].Result = [Table1].[Result] WHERE ((([Table 2].[roll no])=[Forms]![Form1]![cboRoll])); I would like to update the Table 2 fields where...

It says Sub or Function not defined.

I want to be specific as I don't got solution from the link. So Can you please have a look on code.

Hi, I am trying to save the reports on disk using Query records. the program works well for all records but giving error when I type parameter in query design. The below code working well for all records in query but not working when I set parameter in a query design for a field which linked...

Hi all, My access program printing the reports in pdf on local drive well. But when computer on network then some time it saves the pdf on desktop but most of the time the error occurs which is 2501. Private Sub cmdPrint_Click() Me.Form.Refresh ' my code DoCmd.SetWarnings False Dim strUserName...

not good in , didn't find.

how can I? Please share.

The Main form doesn't having the fields linked with master / parent.

Hi, I have main form with subform. I would like to show relevant record after choosing value from combo-box. The matching field type is text.

Thanks for your time. Have a good night.

The subform name is: "frm_Reports_lRecallSheetStatus"

type mismatch error.

No. it don't have.

Yes, I changed the type from number to Text.

="[EmpID] ='" & Str(Nz([Screen].[ActiveControl],0) & "'") I am not much familiar with code to search record in subform.

I want to show the relevant records in subform by choosing the EmpID from drop down. It was working well on numeric data type but not on text.