Search results

Here it is...

Now that was more like what I was looking for except i have trouble to get it work in my db. I understand the principle but when I try to apply that to my db it doesn't work. The combobox solution is same as I have except i have cascading combo boxes so that combobox2 is controlled by...

Well I do understand your example but it is too simple for my purpose. I have a table with 100 records and to set a true or false statment on every image would be very time consuming.

Sorry I don't understand how will this update the image box. Shouldn't that be an after update event?

Hi I have very simple database consisting of one table "tblMain" and one form "frmMain". On the form i have a two cascading combo boxes and two text box which get their data from combo boxes. The issue that I have is I am trying to add image to my form which is based on selection in a combo...

It works! Thank you SteveSchapel and AccessJunkie for your patience and understanding.:o

I attached my database to the reply as I am sure it will provide you with the info you need better than I can.:o

Yes the ArtikelNR is my primary key and it identifies the record I want to print. Next problem is that if I want 4 labels of a certain record the program prints 4 labels of the record i want + 4 labels of each record I have in my table :confused:

The qryMogel from SQL view: SELECT tblMogel.ArtikelNR, tblMogel.Namn, tblMogel.Vikt, tblMogel.Symboler, tblCount.Count FROM tblMogel, tblCount WHERE (((tblCount.Count)<=[Forms]![frmMogel]![HowManyLabels])); I select the required record in the form with command buttons "back" and "forward"...

Multiple copies of just a single label, and I almost managed to do that by following your example. The issues that I have now is: 1. I can print for example 3 labels and they come in right order in the report but after those 3 labels it prints all the other labels i have in the table 2. If I...

Ok now I got it almost working except it prints 5 labels of the record i want plus all the rest of the records that are in the table. And if I choose 5 labels of some other record it first prints 5 labels of the first record and then it prints 5 labels of the record i wanted? :confused:

Well i managed somehow to follow instructions but the result is strange. Printing from the form doesn't work at all but if I doubleclick on my report "rptLabels" a input box comes up "Enter Parameter Value" Forms!frmLabels!HowManyLabels and there I can enter the number of labels i want and I get...

Done. How do I "...add the number field from the table to the query output"?

Can this be done without the query since the report is based on a table?

Hi I have made a program for printing labels i access 2003 and now the only thing I have left is how to print multiple records of one label?. . I have a very simple database with one table, one form and one report. I would like to have a control box in the form for how many labels I want to...