Recent content by Terrier

It's sorted now, I had two masks set up one on the form and one on the table!! Thanks for your help. Mark

No that made no difference.

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...

Ken thank you, that works a treat.

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 really need it to be a report as I need to print it out so that it can be posted

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.

RivetHed Many thanks for your help, I am truly grateful, I have spent most of the week trying to get that to work. Mark

Rivethed, Yes it is a medium date.

Tried that and got an error msg saying DATA TYPE MISMATCH IN CRITERIA TYPE

OK. I am trying to build this into a query (using expression builder) to display Items whose expiry date is 60 days or less, but some items do not have an expiry date. How do I get around this. BTW the expression I have come up with is &quot;If «Expr» [Expiry_date]&quot;<=(Date()-60) But it...

I am just reading this as I want to set up a query/report to alert me when an item is 60 days off it's expiry date. So the query will include Month(Date-Day(Date)) - 60?