I am making a database (attached) so that the contents lists for a large archive of photographic negatives can be entered. The form is for data entry & the reports may be PDFd & used for online display.
I have a few problems -
1. How can I make the dates follow one of 2 formats, eg either 8 Sept. 1936 or Sept. 1936
2. How can I make the CallNumber (labelled New Sequence no) field follow this format – so that only 11 characters can be entered eg Box 002/028
3. I made a drop down box for the photographer’s names, but when a new name in entered it is not stored. How can I keep the new name in the drop down box? The box is based on a select query – should it be based on a table & if so how can I convert the query to a table without typing all the names in again? Or is there some other reason the names are not being stored?
4. In the report, the fields called Tags and Notes sometimes do not have data in them. How can I stop the label boxes from showing when the fields are empty? I found a related question on the forum – Invisible textbox when values are null in a formula” but the answer was double dutch to me.
Is there a way I can fix these things without knowing the programming language? I only have a basic knowledge of Access.
Any help appreciated - in simple language please!! thanks
I have a few problems -
1. How can I make the dates follow one of 2 formats, eg either 8 Sept. 1936 or Sept. 1936
2. How can I make the CallNumber (labelled New Sequence no) field follow this format – so that only 11 characters can be entered eg Box 002/028
3. I made a drop down box for the photographer’s names, but when a new name in entered it is not stored. How can I keep the new name in the drop down box? The box is based on a select query – should it be based on a table & if so how can I convert the query to a table without typing all the names in again? Or is there some other reason the names are not being stored?
4. In the report, the fields called Tags and Notes sometimes do not have data in them. How can I stop the label boxes from showing when the fields are empty? I found a related question on the forum – Invisible textbox when values are null in a formula” but the answer was double dutch to me.
Is there a way I can fix these things without knowing the programming language? I only have a basic knowledge of Access.
Any help appreciated - in simple language please!! thanks
