Search results for query: *

I have a question. I have a table in my access database that holds the inventory for my company. I want to print labels from the fields in the table onto a jewelry label. I already have a jewelry label printer but I have no idea how to set it up. Anyone have any ideas? thanks Bhavesh Vitha...

Heres the rest of the code: Option Compare Database Private Sub Combo4_AfterUpdate() Me.RecordsetClone.FindFirst "[random_numb] = " & Me![Combo4] & "" Me.Bookmark = Me.RecordsetClone.Bookmark End Sub Private Sub Command6_Click() DoCmd.OpenQuery...

Heres the sql code for the query. The file is sort of working but not the way i want. INSERT INTO sales ( random_numb, item, item_numb, grams, price, [date] ) SELECT inventory.random_numb, inventory.item, inventory.item_numb, inventory.grams, [Forms]![sales]![price] AS Expr1...

The second error I get is when i press the button. It is Run time error 7874 Microsoft access cannot find the object 'qryAppendinventoryQuery.'

I started what you told me and I think I got a good start. I put all the codes and everything in and this is the first error I recieved. Microsoft Access cannot find the macro "me." Also I do want to delete the items from inventory what query do i have to make this possible? thanks

Thanks for the help but what you said sounds French to me but I'm going to see what I can do. Right now I only know the basics of Access but Im learning so I should figure it out just a matter of time. Once again thanks and I will let you know if I encounter any problems.

I'm trying to create an access program for my work (jewelry store). I created on inventory table that has a random number as the primary key. The other fields are item, item number, supplier code, price, and grams. I want to create another form where i can enter the random number to take that...

Michael I plan on updating the inventory the next morning. So all the sales from the previous day will be scanned and taken out of inventory. I will probably have to create a button so that once all the items are scanned into the sales table I can click the button and delete all the items from...

I have a couple of questions. I want to build an inventory program for my jewelry store. These are the requirements can anyone tell me if this program is possible. 1) There is going to be an inventory table with these fields: Item, Item number, weight, supplier code, price, cost code, and a...