Search results

I need to print a report of all of the cars in our facility at a certain time and have created the query. The problem is I need it to take the data and if let's say the list is longer than 3" of the page on the report, I need it to throw it into columns so that it all prints in the middle of...

I have a form from a query for Spark Test reports. The query contains the job number, the customer, car number, etc. for a particular job. I have the form done in Word and have tried to merge the data source but when I click on the datasource in Word the Spark Test Query is not listed for some...

Thanks! I'll try it!

Don't ask me, just a form we have to have due to Federal Regulations and the American Association of Railroads guidelines. Doesn't seem to me they are really even needed if the car number, etc. is listed...ya know.

Thanks but it doesn't seem to be working. The user will open this form, enter one small number and then hit print. It is based on a query which the form is pulle up by job number. The form has the customer, job number, car number, other number, date, purchase order number, etc. I need it to...

Is there any way to set a checkbox on a form so that if for example there is a car number in the car number field the default value is true?

So, should I move the operation type and the schedule date into a different table? Otherwise, do I need 5 operation dates?

I have 3 questions that I can't figure out. #1) I have a custom menu created. How do I set it to open a form empty instead of having the 1st record fill in. I know how to do that with the switchboard, just open in add mode but I can't figure it out with the mnau. #2) I would like for a...

THANKS!

We have several services per job. Such as Inspection Strip Lining SiphonPipe Nuts & Bolt's etc I have a table and a query set up so that it pulls all the services performed up per job so that we can enter the invoice totals & print the necessary forms, however..we do not always bill for them...

Actually it is a report utilizing 2 subforms. I don't know if that makes a difference or not.

I have a report with a page header/footer and 2 subreports. I would like for each subreport to print on a separate page and I can't figure out how to accomplish this. Can anyone help?

We did but I never got it working correctly. Bob did though I believe....I haven't checked my email yet. THANKS!

So I don't need that in the table? Only in the combo box?? I have it working right now where the contact list drops down ALL contacts but when I put in [forms]![WORKORDERform]![cboCustomer] in - everything disappears! God I am so frusterated!

Okay, In my CONTACTS table, I have the CustomerID set to number. I have the look up set to ComboBox. Row Source Type=Table/Query Row Source..when I click on the three dots & it opens the query window I have 2 columns...CustomerID & Customer (in asending order) from the CUSTOMERS table. The...

I thought that was how I had it set up! Uugh! http://users2.ev1.net/~dls4967/newchandler.zip

I have searched the forums, downloaded samples and tried and tried to get a cascading combo box to work to no avail! Here is the setup: Workorder Table WorkOrder ID Customer ID ContactID etc etc etc Customer Table CustomerID Customer Name etc etc Contact Table Contact ID Fname LName Phone...

That didn't work...it came up #Name? when I ran the report

GOT IT! It's all working fine and I added a text box (Exp3) that totals Exp1+Exp2. The query and reports are working fine. It if formatted as a subreport and I can't figure out how to have the exp 3 from the subreport copy to the bottom of the main report so I can add in with other totals.

OOPs...I wrote the 3rd exp on the subform wrong. It is =Sum([exp1]+exp2]). Sorry about that.