Search results for query: *

I have a database that requires a staff number to be 8 characters long and the first character MUST be a letter and the rest are numbers. I have set up an input mask like this: >A9999999;;_ If I try to enter two letters it will not let me but if I enter a number as the first character it lets...

How do I set up the date elements of a process to work out production for a week and a month when the data is input and stored on a daily basis? The date is stored as DD/MM/YY and is a simple ASCII file containing the details for a number of machines.

How can I specify the minimum field length in a table? I have a field which MUST be 13 characters long, anything more or less is unacceptable. Advice appreciated.

It's me again. I've got a problem when I delete an item off a table. I need to print out a report with the details of the item deleted so it can be sent off elsewhere as a manual record. I've used the 'delete record' from the wizard and thought that I could just tack a macro on to it as well...

How can I put a column on a report to say "yes" under the heading on loan if my table determines the item is on loan by having a membership number entered. I want to build an expression that is something like: If membership number not null then on loan = YES else (nothing). Help please

I have a form that display the attributes of a stock item. I want to use a button to produce an order form for that item using relevant details from the form. Can this be done? How? I think I need to generate a report but am uncertain on how to do it or if this is the right way.

How do I produce a report which only displays the results of a query...the query displays fine as a form but I want to be able to print it as a report with a few other details (from a different table) on it

I have been asked (!) to provide a database which will detail the availibility/non-availibility of our workers. This will include when they are on holiday, working off site, sick, courses etc. Obviously these details will be entered by the users in a date format. The boss wants it to provide a...