Search results for query: *

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...

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...

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...

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...

I just picked up a used Palm IIIxe but it did not come with any software disks. Anyone know where I can get the Palm Desktop Software? Brad

This is just a simple query question and I can't get it for the life of me. The name of the query that I am working in is "Panel No Code" There are a bunch of fields in the query but the only ones that matter are: [no code] [no code2] [no code3] [no code4] [no code5] [no code6] [no...

I have a form with a command button on it. When you click the command button it automatically prints a report that is based off the current information on the form. Where can I go to get this button to print two copies of the report by default? Is it something I do with the command button or...

I am using a combo-box on a form along with a command button to set the criteria for and then to run a query. I set up a combo box to search by distributor. I linked it to the distributor table and to the [distributor] field within that table. Heres my problem.....my company has numerous...

Is there a way to put in pull down menus for search criteria? Some of my fields are rather long so it would be much easier to select a criteria rather than having to type the entire thing in exactly right. Any thoughts would be great. Brad

I am running a database using switchboards. I have the command buttons set up ok to open up the next form. However, is there a way to close the previous form when I move on to the next, all from that same button? My On Click opens the next, but can I add something in or change something that...

I have a main switchboard that autoexecs. One of my command buttons on the switchboard is not working and I cannot get it working for the life of me. I just want it to open up another form. The form I am opening is "Old Quote" and the name of the Button is [OldQuote] The code that I...

I have a database set up with switchboards and I need to have the user enter quote information on a form and then print that information on a report using a command buttom from the form. The information on the form does data-entry into a main table to store the information. I need only the...

I have a form where many of the fields are distributor information. I also have a table that is [Distributor Name] [Address] [Phone] [Fax] and [Contact]. These same fields are on my form. On the form I have a pull down combo box for the distributor name and would like the rest of the...

I have three tables. The fields in the tables are almost exactly the same, except for the field [model] since this is what differentiates the product into the different tables. I want to run a query that will search all three tables for a common name, like a distributor name. This way I can...

I am creating an end of the month report. I have a query that gives me all of the information I need in the report. It is as follows: Basic fields such as [qty],[model],[customer],etc. It also includes both [Cancel date] and [date on EOR report]. I then have four hidden fields. They are...

I am setting up an end of the month report for my company. I am running a query to give me the information for the report. All of the data is coming off of one table. My field names for the query is just general information such as quanity, price, est. ship date, etc. I have the customer as...