Recent content by butter30

hey does anyone know to create a parameter query for a field format of yes/no i tried [enter yes/no] then typed yes it doesnt work say expression is incorrect or too complex HELP please thank you

i was referring to table although both would be useful

in access 2007 does anyone know to build an expression for length validation, from the expression builder that states that minimum length of 3 characters is required.

i was looking oer my normalisation notes and i feel kinda stupid now is this just meant torepresent a relationship link and not a table? booking link) -customer ID (PK) -email address

btw is one to one relationship the 1 and 00 sybmol that show in relationship?

the tables i show are 3rd normalisation form, Arent the relatonship between 3nf tables always 1 to 1? thanks guy for helping im a newb when it comes to access ^^

all 1 to 1 relationship

can someone tell a macro code that does the following on event procedure for this specfic field i would like form field (a) data to go to 2 different tables when the user clicks add record further note the form is made on table (A) andthere is a column in table called (a1) "form field a...

hi i was wondering if its possible to do this and if so how tables and their fields (alpha) -1 pk -2 -3 (beta) -4 pk -5 -6 (gamma) -1 -4 pk the form is created in beta containing following fields -1 (charlie) -how do i make the data go to this table instead of subform? -4 (beta) -5...

can you give example with reference to system plz im a beginner at access

sorry i dont understand what you mean i changed the (booking link) to number and long intergal but still doesnt work

here are the tables involved and their fields (client) -email address (PK) -clients details i.e. post code and address (booking) -customer ID (PK) autonumber -product -quantity -price (booking link) -customer ID (PK) -email address relationships (booking link)'s customer ID has...