Search results

Thanks! It works! What about the overtime? If it is less than 0, it needs to say 0 and not -1.687?

I have a report with 2 subreports. One which should print on each page of each record with the same header/footer. I am printing work orders and one has the information for the shop minus any accounting figures and the other is the same but contains dollar amounts. This works fine when...

My database here at the office is FINALLY up and running minus a few little kinks to be worked out. The first one has to do with time cards. Our employees may work 14 hours in one day and it is broken out on the time cards and by job as 8 regular hours and 6 overtime hours however, at the end...

THANKS!

Ya - I know that but when I click it it comes up with a list of categories for the button and actions to perform.....I can't remember which one to choose before I set the onclick event.

I set up a button that merged fields with a report in word containing bookmarks several weeks ago. It works GREAT! I need to do it again and I have the event procedure...I just can't figure out what kind of button I used to set it up. I am using the wizard and I forgot how I did it...I think...

This is EXACTLY what I want to do inmy database but hav no idea how to make it check for it or make the form pop-up? When you enter an item number I'd like it to check for duplicates then if it finds one pop up an screen that gives some details of the similar record and then asks the user if...

I'm not quite understanding how to fix it...please excuse the ignorance.

WORKORDERS and CARINITIALS

Actually...here's a copy from last week I think...I dunno if that query was in there yet or not. Http://users2.ev1.net/~dls4967/newchandler.zip

I suppose it could be. That is the foreign key in the WORKORDERS TABLE and the PRIMARY KEY in the CarInitials table.

The DB is too big for our slow upload speeds but here are some screenshots. Here is the query: Here is the datasheet view that matches the query, it is okay except that it doesn't show the jobs that are trailers. And here is the datasheet view w/the relationship deleted - WAY WRONG. car...

I have a query from two tables. Table A has WorkOrderID CustomerID CarInitialID CarNumber TrailerNumber etc... Table B has CarInitialID CarInitial Since I the WORKORDERS table saves the CarInitialID as a number, I have created a query to use to display the data on top of forms. I have a...

YUP - got that, I was trying to do it without using a query. I do have another simple question though. Our company name is H.C. Chandler & Son, Inc. and I can't get the & sign to come up in a text field or forms, etc. Is there a way to get it to display?

Rob - I am working on EXACTLY the same thing and having a similar problem. Did you get this figured out? Here is the module I created: Function MergeIt() Dim objWord As Word.Document Set objWord = GetObject("f:\DatabaseFiles\GATX INSPECTION FORMS.doc", "Word.Document") '...

Okay *sigh* Thanks! Queries are the backbone of this thing aren't they?

I am so new to Access and learning so much but this one VERY SIMPLE little thing is making me nuts! I have a table WORKORDERS set up in my database. For example it has: WORKORDERS WORKORDERID (primary key) CUSTOMERID PURCHASEORDERNO CARINITIALID CARNUMBER Some of these values (IE...

THANKS!

THANKS SO MUCH! I found it...now I just have to get the Northwind DB but I will DEFINATELY check it out! THANKS SO MUCH!

How would you make the 2nd report display the data in columns?