Search results for query: *

Hello, For some reason when I try to print from Microsoft Word or anywhere else, I get a message that says "No printers are installed. To install a printer go to settings on the start menu and click Add Printer..." I've done this a million times before, but now there is no "Add...

Thanks Roy. It worked! Have a great day and a nice weekend.

Hello, I have a text string in a report where I want to include a currency field from a table. The table has 100 records. So far, my expression looks like this: ="The company contributes " & [ContributionAmount] & " per year for up to 10 years." The...

I have an accounts payable database with fields for "Date Paid" and "Amount Paid." I would like to create a query from this database that will create a new calculated field called "Year Paid" that will separate the totals by year paid and will sum the totals into...

I have an accounts payable database (tblAllFields) with fields of Vendor, Amount and Date Paid for 1200 items dating from 1996 to the present time. I want to create a report that will calculate the total amount paid per vendor per year and that will also show total items paid per vendor per...

Yes, the page header would normally appear on every page including the first page, but for some reason, it does not appear in this case. I found out that after I open the report from the form, if I go into design mode and then back to print preview, the text does in fact appear on the first...

Thanks for your advice - the code you gave me worked. I actually want to have the text "Mordacia" appearing on all pages of the report, so I put Text46 in the Page header instead of report header. For some reason, though, the text appears on all pages except for the first page. Do...

I have created a search form for users to select criteria for reports. There are 8 different criteria that can be selected - the user can select any combination of criteria and then select a command button which filters the data. I would like to just create one report and use code to change...

I have a form that runs queries based on the controls in the form that contain value. I can only select one control at a time and currently run separate queries based on each control: for example, with controls of NAME, DATE, AMOUNT, CATEGORY I can run a query on only one field at a time...

I am creating forms with tabs and keep running into the same problem. The Tabs are visible in design view, but when I select Form view, they are way up at the top of the screen, and I have to use the right and bottom scroll bars to move the screen up to view the tabs. I have tried coding for a...

I have created a report whose record source is a parameter query. The report opens from a command button on a form. When the report opens and the query runs, the "Enter Parameter Value" box appears and the user is asked to enter a start date and an end date for the range. I want the...

Hi, this seems like it should be easy to do, but every time I try to run a query off of several tables, it does not work. I want to pull all the data from all the fields of the three tables, but when I try to select * from each table to enter all the fields and then run the query, I get...

Hello, I am trying to combine the data from 3 tables with identical fields - the 3 tables contain payment/invoicing tracking information for products for 3 different years. Only the table for 2002 will continue to be updated. After I combine all of the tables (some products will appear each...