Recent content by m33r4
-
M
New people added in table 1 not showing up in other tables despite relationship
If you refer to the link I have posted in the original question, I have used name across all 3 tables. Thanks. -
M
New people added in table 1 not showing up in other tables despite relationship
Table 3 is the training only table - I shall remove the forename and surname fields. -
M
New people added in table 1 not showing up in other tables despite relationship
Thanks for the input. I am sorry to be troublesome, but only in my 3rd day of using Access. I have read the blog link but am none the wiser how to apply this to my tables :o Although I understand to split the 1 training table into 2 tables, I don't quite grasp how I need to list the different... -
M
New people added in table 1 not showing up in other tables despite relationship
Attachment: showing relationship -
M
New people added in table 1 not showing up in other tables despite relationship
I have 3 tables. Table 1: contains staff names and contact numbers Table 2: contains training above staff have been on or need to go on Table 3: contains pc and printer asset numbers of above staff I used a form and entered some new members of staff in table 1. They got their auto numbers... -
M
Zero not showing up in telephone numbers
I tried a few but still missed out the zeros. Have you any suggestions for input mask to cover the UK dialling codes please? Whilst on input masks, would you also have any ideas for UK postcodes please as that is proving tricky with it varying from DE56-2JP to N2-8EW? Many thanks. -
M
autonumber from table 1 not coming across in number field in table 2
There is a 3rd table but my concern is with tables 1 and 2 at the moment. Many thanks. -
M
autonumber from table 1 not coming across in number field in table 2
I have created 2 tables: StaffID StaffTrainingID Table 1 (StaffID) - contains all personal details in the form of forename + surname + position + email + contact numbers ect. Each field/person has an autonumber. Table 2 (StaffTrainingID) - contains all mandatory training/lectures (18... -
M
Zero not showing up in telephone numbers
Thanks for the tip. I suppose that setting the data type to TEXT won't affect any queries or reports on local dialling codes? -
M
Is it possible to create a "Save" button in Access 2007?
:confused: Don't have Access 2010 sadly which comes with a button wizard. Using 2007 and was wondering if there was a simple way of creating a "Save" button at the end of a form please? I know that clicking the X sign in the corner saves and closes the form but users might be wary of doing this... -
M
Zero not showing up in telephone numbers
:confused:Any tips on how I can get the zero in my telephone dialling code to show up in my tables please? I have set the number display to the Long Integer. Thanks.