Search results

I have a query that has 4 Tech fields and 4 Hour fields and a few other fields that are not pertinent to my question. When the Tech opens the query it will ask for the Tech's initials at each Tech field. The Tech entering his/her initials will appear in only one of the fields at a time and...

If my total = ................... If my total = $0.00 to $500.00 I need to multiply it by 4% anything over $500.00 I need to multiply it by 5%. Is there an easy way to accomplish this? Mike

I have a form set to be blank when opening it using: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec CUSTOMER.SetFocus End Sub This works great. I also have it set were the last tab stop is a command button that does two things A) it prints the form and B) it brings up a new record...

I am trying to create a combo box in a form that gets its data from one table and saves it in another. I have my main table called serial list. When you use the Work Order form all data entered goes into the serial list table. The fields ranges from the customer to the part number to the...

I want to create an association with 3 different cells. In cell "A" I type in a part number then cell "B" automatically gives the part description and cell "C" automatically gives the shop that part number goes to. I am sure that this is possible, but I just don't know what to look for. If...

If you are talking about Tools, Security, User and Group Permission. Object type database <current database>. It was not checked with anything. I have changed that and it still does not let me do anything else.

PANIC!! Could not read definitions All Right this topic has been covered in two posts unsecuring a secured database and Error Message: Could not read Definitions , however neither of these post have helped me cure my problem. I open my db and log in. When I try to open any thing other than...

Can any one tell me if it is possible to make vertical fields in a Table??? If it is not possible how can I get a table of address to appear on a form vertically? Right now I have a form that has a list box for customer address and it appears like this: company, contact, address, city, state...

I have a report that I want the total of the royality field to show up at the end of the report and I have searched and searched, but I cannot come up with the answer that I am looking for. Can some one please point me in the correct direction. Thanks, Michael

To help keep this simple I have a query that has 3 fields. 1 = R/T/W/S/E 2 = TOTAL 3 = 5% DISCOUNT My 5% DISCOUNT field looks like this 5% DISCOUNT [TOTAL]*0.05 which means that everything gets the 5% Discount. How can I write an exprssion that will let me say that when the R/T/W/S/E field = R...

I spent the last hour reading post after post trying to find the info I was looking for with no luck, so I thought that I would post and see what I get. I have one database and multiple forms. I enter data on a form when we receive a unit in and it goes into the database. This form does not...