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...
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...
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 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...
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...
In the query criteria field type in:
[Forms]![FormName]![Comboboxname]
This will set the criteria of the query based on whatever is chosen in the combo box.
Brad
Like I stated earlier in a previous post...I just picked up a used Palm IIIxe which I like a whole lot. One problem is that it didn't come with much documentation or instructions. So with that in mind, can someone tell me how to adjust the contrast? My buddy has a Handspring and they have a...
Thanks, I ended up finding that too. I couldn't find it when I looked through Palm's web site but when I typed it in Google it gave me the correct link on to the site. Hooray for search engines! Thanks again!
Brad
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.