Search results

I have been using the syntax: DoCmd.OpenReport "Label_Single", acViewPreview, , strWhere This has worked for the last month. Suddenly I am getting an error 3615 Type Mismatch in expression. I have not changed anything in this code for over a month. Here is the full code: Private Sub...

I am having trouble getting data to appear on my Report. The report is based of a Query, qryLabel. When I run qryLabel the correct data is displayed but when I try to use this data on the Report, I get an #Error or #Type. Here are the methods I have tried so far to get the data on my Report...

I am attempting to use some external data to populate fields in my DB. I would like to reformat the ProductID in my DB to match a ProductName coming into my DB. We have many products that have 2 pieces. If the product does have two pieces, the external database has two ProductNames that look...

Hey all, I am attempting to perform a calculation while using a DLookUp. I have three tables that will be included. Here is what I would like to do. I would like to take FingerPrint.TableDiamtr and divide this by FingerPrint.AvragDiamtr. These would be values that come from the FingerPrint...

Hello all, I have a form that has comboboxes with an "Other" option. I want to make a textbox that appears when "Other" is selected and then the user can input information. I have five combo boxes that I would like to do this on. I have put this code in the Form_Current and cbo_Change event...

I have a form for data entry that have multiple comboboxes. I am trying to get one combobox to base its "list" on an entry from a previous combobox. The first combobox is based on a QuantityType table and has four options. The next combobox is based on a ProductDesign table and will have...

Hey all, I am trying to get a report to print straight out without opening the report in a preview. Here is what I have so far. I know I need to use doCmd.PrintOut but I can not figure out the correct syntax to get it to work. I highlighted the code in question in red. Private Sub...

I am attempting to create a printed label with a concatenated field. I want the field to abbreviate several shapes and colors but i will just start with the shape. =IIf([Shape]="round","RD","TH") This is what my basic statement says. I am attempting to nest other options inside of this...

Hello there, I am working on updating a database and ran into a problem with a concatenated field. I have a form "Product" that is being recreated to match what my employer would like to see. On this form I have added a header field that will give a product description. It works great with the...