Recent content by Toledo123

I have a purchase order program and an inventory program that I have written for a steel company. I have to find a way to hide the backstage options from the users getting into the database. There are some men that would get mad and go in there and play around just to try to mess things up if...

Is there a place that I can look to find out what that code might be? Or is there information I can give you where you can help me write the code?

That is what I have but I still need to delete the record when the coil gets down to 0 so I can reuse the coil number don't I. Can Access go back and find gaps in the numbering and automatically fill them in?

I realize that you can do that however, I want to reuse the coil number. Example: We receive a coil today and number it 256. By December we have used all that coil so I want to delete the record from the data base. In February we receive another set of coils and I want to number one of them...

I have a two part question! 1. I have a database that tracks "coils" for a steel company. One the coil is all used up and the weight is "0" I want to be able to delete that coil from the data base so I don't end up with a 200 page report showing coils with a weight of "0". I know how to block...

I have a report that talks about weight of an object. I need to remove all the records from the report where the weigh is 0. Can someone tell me how to do this

Thank you for that, it worked just great. Is there a way to send that filed to print preview and not directly to the printer?

Thank you for that Don't I have to put some kind of button on my form?

I have a PO Form. After the user enters the information on the form I want to have a button that when clicked can send the information to the report where it can either be previewed or printed. Can someone tell me exactly how to do that? My report is called POReport My form is called...

I have a form and table for new coil that has the Gage (size) and Width (size) of the coil. I then another form and table that has the Gage (size) and Width (size) of used coil. The New coil is the main form and the used coil is the subform. I would like for the Gage and the Width field to...

Thank you for that reply. I found that in my research. Is there something that would explain that in more detail?

I am working with a business and they are going to want me to write them a purchase order program within Access 2010. Can anyone point me in the direction where I can start teaching myself how to do this. I am not a pro at Access by any means but I can do alot of stuff within the program. Any...