Author Topic: Microsoft Access  (Read 341 times)

Offline Eyesee

  • RootsChat Marquessate
  • *******
  • Posts: 5,844
    • View Profile
Microsoft Access
« on: Friday 06 August 21 05:06 BST (UK) »
Not sure how to go about setting up default entries into a field in Table View or in a Form so looking for some help please.

The field will have either Male or Female in it, so want to just press the M or F key and it will insert the rest of the word.

Used to know how to do that in Excel but do not use Access enough to remember how.

Also in a date field when the date is entered in International Medium Format dd-Mmm-yyyy why does it print in the American Medium Format mm/dd/yyyy in the Mail Merge document. Am guessing it has something to do with the formatting of that field in the mail Merge document.

Thanks.
Ian C
Census information Crown Copyright, from www.nationalarchives.gov.uk

CLAPHAM, PARKINSON, Leeds and London
TOMLIENS, Herefordshire and Southwark
CLARKE, Sussex, Cambridge and Shropshire
FAULCONER, MANNINGTON, RICHARDSON, TICEHURST, BROOK, ELPHICK, FURNER All Sussex
UDY, CLEMENCE/CLEMENTS,WHITE, COITE, COBELDICK, Cornwall
BROOKING, Devon, India
RUSH, CARTER, GIBSON, REMINGTON, London and Surrey
CHALKLEY, OLNEY, Hertfordshire
HARRIS, Essex
EDWARDS, York
NOLAN, BERNEY, Kildare

Offline bluesofa

  • RootsChat Extra
  • **
  • Posts: 40
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Microsoft Access
« Reply #1 on: Wednesday 06 October 21 01:22 BST (UK) »
Excel I think has built in logic to auto-complete Tables, which I'm not sure exists in Access

However, in Table Design > View > Design View,
setting a Fields, Display Control to List Box, with Row Source "Male";"Female" appears to work.
A combo box could be used if you wanted to allow for other terms.

with regards changing the format of a mail merge document, via google
  • In the main Word mail merge document, select the date field.
  • Right-click the field and choose Toggle Field Codes from the drop-down menu to display the field code. You can also press Shift + F9 to display the field code.
  • If necessary, delete \*MERGEFORMAT from the field code.
  • Enter the switch after the field name (such as \@ “MMMM d/yy”). Be sure to type a space after \@.
  • Right-click the field and choose Toggle Field Codes from the drop-down menu to hide the field code. You can also press Shift + F9 to hide the field code.
  • Right-click in the field and select Update Field from the drop-down menu. You can also press F9 to update the field.
  • Run the merge by selecting Edit Individual documents from the Mailings tab in the Ribbon and then click OK in the dialog box. In the merged document, the date should appear in the switch format.

So for example; {MERGEFIELD RegistrationDate \@ “dd-MMm-yyyy”}