Recent content by BLutgen

I can approach this problem from two different ways, but only one may work. I currently have a query that searches for a certain range of order numbers. The query is then printed in spreadsheet format for office use. I either have to A: somehow put a footer on the bottom of the query when it...

Does anyone have any other ideas or is there just no way to do this?

Hey Joe, That is what I was afraid of. Thanks for information. I think that my company will just have to fax the printed report instead. Thanks again! Brad

Thanks for the help guys but unfortuantly it doesn't work. My form has two tabs with information on it, and I think that is what is causing the problem. When I use either method, an error screen pops up saying all of the fields do not match and asks if I want to paste the fields that do match...

Thanks for the help, but I am not sure that I am understanding it right. If I set this up that way, I then have to enter every person who is going to be using the database as a user under either the "Engineers" Category or the "User" category. Is this correct? What if the...

I am sure this has been answered, but I searched and couldn't finad anything. I want to email a report from Access out to salesmen in the field. I tried to use a command button with the wizard but none of the file formats you can choose from bring up the report decent. The excel just brings...

I have a user who wants to be able to page back through records on a data-entry form, then once he finds a record be able to copy it into a new record, change whatever might be a little different, and then save it as this new record. The original record needs to remain unchanged. He feels that...

I have a database that I need to set up security on. The engineers all need full access to the database, and everyone else who enters it should only have read only priveleges. How should I set this up? Can I make something so that one password opens the database read only and another password...

Thanks a lot, worked great

I have report which is based on a query. The query gets its criteria to run from two text boxes and a combo box on a form. Basically the combo box is a customer, and the text boxes are beginning date and end date. On my report, in the report header, I want the customer name and those dates to...

Thanks, it works great. It is fun to learn new stuff and actually see it work!

Thanks for the help, but I wish it were that simple. Maybe it could be that simple and I am just not realizing it. The report just lists all of the models in one column, labeled "Model" Basically, the user selects a customer, then enters a date range that they want to see for that...

Thanks a lot. That is exactly what I needed to know. Brad

I have a report that lists every order for a certain period of time that the user chooses. The report also lets the user select only a certain customer. When the report is run it then sorts the product(engines) by the model number. (All model numbers are grouped together) Is there some way to...

I have a end user who likes to use the main table to locate data. I am using a switchboard with command buttons for navigation. Is there a way to open the table from a command button? I didn't see it in the wizard, and am not yet real proficient at VB to know the command for it. Thanks in...