Search results

The field "Answer" appears in your field list, so you can add it to the reports. Your can also go into the query and change the name of the field if you wish. 1. Have a look at the query that is the source for the form. 2. Have a look at the form in design view and you will see how the Hours...

Have a look at your sample now;

The is not need for any code, just use tables and queries. Have a look at my attached sample; Open frmData and Add Customer Name and treatment. You will notice that BNS 20 does not appear in the combo. Now open frmDataList (shows all treatments) and you will see that there is one for Helen...

cokeblue8, Have a look at my attached sample. This will copy over the name of the state each time that you click the command button.

Lori, I have attached a copy of my "Invoice with saved prices" sample. Before you try to understand how it works, may I suggest that you look at ComboTo FillInControls191106_Update.zip which I posted in this thread, as it may help you understrand how they both work. I can't answer that as I...

aman909, Have a look at my sample, this is the easy way to do it. The 2 tables are just linked by a key. I also have a sample that will create a new invoice and a subform of orderitems, let me know if you want a copy.

jeremycod, Have a look at my attached sample, I think it will do what you want.

Have a look at my attached sample, it will open both word and pdf files. Have a look at the code behind the "Open PDF" button. You will see that you have to tell access where the Acrobat.exe is. Before you use it, open both of the tables and change names & paths to suit your situation. Hope...

Your do NOT print forms they are for displaying data. You print reports. What you are doing is the right way. Don’t try to reinvent the wheel. My form1 won't work now that I have deleted the tblJPG. There is an exercise for you.............get the combo on the form working again. When you...

Have a look at the query that is the source for cboWidth, I moved the DataID to the second column. The I told the control txtDataID (which is on the form but hidden) to use column (1) (which is really the second column) as the source for its data =cboWidth.column(1) When you "count" columns is...

Fixed, sorry about that

The new attachment will do what you want. You just have to have the folder and the database file in the same directory. If you want to have a look at the code, open the report in design view and select Detail / Properties and look at On Format. I have also removed the table that held the .JPG...

I was just about to ask you that question. Here is your db back and working. A couple of things that you will have to do; 1> Change the name of your folder that holds the jpgs to RejectSteelBarcodes same name just no spaces. 2>Put the folder in your c:\ drive 3> Open up the table tblJPG...

What you have not done is formatted the "MyNumbers" in the query that is the source for the list box. I just changed you sample and it worked for me.

You said you had 10 but you had 11 Have a look at the document that I posted; you have different names for the JPG's and the list in the access table. Example: You have a jpg named 0.875.jpg but in the access table it is not listed, there is a 1.875. Which is correct?

Have a look at my attached sample:

Post an example of what you want. do you want 123-45 or 123,45 or what?

Your problem is fairly easy to fix, but you need to give consistent information. In the attached document you will see that the table in access does not = the list of jpg’s. You also have 11 not 10. Post back with the correct information and I or someone may help you.

mithani Have a look at the sample I post Here

Have a look at the sample I posted here You will find it 3rd from the bottom of the thread, it's called autofill.zip