Search results

Hi, I have 2 date fields in a Table, both correctly set to Date/Time values and formatted as UK dd/mm/yyyy. These work fine in Forms & Queries. However, in one query I have concatenated the two [Datefields] in a calculated field to display as a single column. (The two date fields ae mutually...

I have a tblClub with only three Columns ID,Name & Number. (Col 0,1 & 2?) I only need to store the Number (Col2) in a separate tblMembers. I've created a Combo on the tblMembers Input Form. I would like the Combo to display Name & Number (Col 1&2), but only save Col2 (Bound) to the tblMembers...

Hi, I'm currently constructing a DB which should have <1000 records when completed. I'm aware of the Normalisation issues, but uncertain as to how far to take it ? As an example, I have 14 clubs under the one league. Should I create a separate Club_Table, or can I simply use a 2 Column Combo...

Hi, Unsure as to how to proceed with updating addresses. DB now contains some 750 records. Members addresses are stored in six separate Fields in Table, (House name, Street,District,Town,Postcode etc.)& input is by way of an Input Form. I'm not sure how to proceed if a member changes address, as...

Hi, I've found lots of info, here & elsewhere, on age calculation from a DOB field - however, very little detailed and precise instructions as to how to make it all work ! I've found the following code on here: Age...

Hi, I simply need to convert a text box to UpperCase, and then store in underlying table (it's a "City" address field,entered in an input form, to use in mailmerge for addressing mail in the UK). I've found two methods, one using AfterUpdate & "UCase", the other using OnKeyPress & "KeyAscii"...