Search results

The number is not too important at present. I have set it at 345 at present, during the design phase. I can reset it later. I tried to put it into the control source with no effect ( yes I remembered the =) I'm thinking about dropping the year to be honest. I'm starting to think its a nice to...

It's in the format property of the Consignment Number field on the form

Like this "PUK-NWI-OHS-"&[Consignment Number]& Format( [ConsgnDate],"-YY")

Thanks Bob, all I get is #Name?

I have a database and I am struggling to format the appearance of an AutoNumber to comply with the company standard as an example it should appear like this PUK-NWI-OHS-325-19 The AutoNumber in this is the 325. However, I cannot format this to pin the year on the end I'm using...

Thank you for trying YouTube let me down.. its normally very good

Thanks Dave, Unfortunately it is an older version of access (V3.0) and my system hates it and wont open it.

data not date d'oh... sorry

Hi guys and ladies, I have a report with a large date field that has an address in it. Is there a function that I can use that will increase the font size to fit all of the available space in the field?:banghead:

A little background. I work on an oil rig in the north sea. Our power supply is pretty hit and miss and sometimes if the power surges and or goes off completely (usually in the middle of the night) it can corrupt forms, macros and code. I am obsessive about backing up my databases. My...

Thank you. its people like you that make people like me look almost competent :)

Is it possible to change the background colour on a form as a conditional format? Two fields. [Normal Position] and [Current Position] the options are 'Open' and 'Closed' id like to change the background colour of the form if these fields do not match. Can it be done? Cheers guys and...

The relationships so far

This is the appearance of the form that works perfectly and when I get when I try to add a record.

Two screen shots of the properties frmRegister is master [MaterID] and the child is sfrmPriority [PriorID] both of these are auto generated numbers. They do have an established relationship between the source tables. The problem arises when I try to add a record. I have one record that works...

I have a form [frmRegister] with a subform [sfrmPriority] They are Master and Child. frmRegister is master [MaterID] and the child is sfrmPriority [PriorID] both of these are auto generated numbers. They do have an established relationship between the source tables. The problem arises when...

it is the Primary Key. I will show my ignorance now and ask.. What is a foreign key?

Hi, I have a form called frmRegister on which is a sub form sfrmPriority They are linked Master = MaterID (an AutoNumber) and PriorID (again an AutoNumber) All works well until I try to add a record to the system and then the sub form sfrmPriorty is blank even when I start to add details to the...

Hi guys and Ladies, Is there any way of producing a report from a form? By that I mean, can I convert the contents, structure and data on a given form into a report to save having to redesign the form?:banghead:

I have a form on which I have a combo box with three selections[Status]. Sampled, Presumed and Strongly Presumed. Adjacent is a field called 'Certificate' Currently the Certificate filed is set as Visible - No. How do I set the field to become visible if and only if the combo box...