Search results

Is it possible to protect (All Access Objects) “Macros” with a PASSWORD so that an user cannot change coding?

As user is filling out form, if they “check” the checkbox field1, they are to enter the cost in field2. Sometimes they leave field2 blank. How can I default to a value of 55.00 if field2 is null? Thanks from me again.

Hi World: Still learning access 2007, but in only two weeks doing well. My question is: setting up a “Work Order” system for a friend. She wants an “Invoice Number” to automatically show up in form as entering data from customer. The number would increment by one (1) for each new customer. She...

When I click “print” on a form to run a reports, if report uses a TABLE as the input source it work fine. If click “print” and the report uses a “QUARRY” as the input source, I get a macro error box with “error code 2950”. Why & how can I eliminate this problem? Thanks for any solution!

I have a table “Quilts”. When a customer comes in I enter “Work Order” information in a form, like date need by, customer name, phone, what type of work & etc. Also, enter an estimated charge for the type of work. There are 9 different charge fields. I have to sum these with a calculator and...

Please help this beginner. I have a table called “Threads” with about 9 columns. I would like to go thru table and perform a math function (using data in two of the columns) and place the results into a 3rd column. Ist column “Maximum Qty”, 2nd column “Current Qty”, 3rd column “Reorder Qty”. So...

I’m new (only 4 days) to Access, but have been able to create an inventory database, input forms, and reports. I want a report to print “Reorder Qty” based on criteria (Maximum Qty) minus (Current Qty).Could someone PLEASE tell me how to accomplish this. Thanks in Advance!!