Risk80
Last Activity: Jan 20 '08, 07:35 PM
Joined: Dec 19 '07
Location:
-
Worked, thanks for your help. -
Synchronise TextBoxes on a Form
Hi
I'm posting (again) because I have a problem in a specific form. Basically I need the value of one text box to be the same as the value of another text box but only when a command button is pressed.
So for example, if the value of textbox1 is "12", i need the value in textbox2 to also be 12, but only when the button is pressed. It is quite a simple problem but I can't find the code to do it, please help. -
Thanks lee, I used a modified version of your code and eventually got it to work. Thanks :-)Leave a comment:
-
Thanks for reply
No, I am not only referencing people by name, each person has a visitor ID, which is linked to the visits table. It is unrealistic for people to remmeber their ID so it is easier if they provide their name and the appropriate record is selected. Each visit may only have one visitor, but a single visitor can have many visits.
It is not a problem for if the person is a new visitor, but the problem i face is assigning...Leave a comment:
-
Help with forms
Im trying to create a database for a visitor logging system. Basically, if the visitor has never visited before, he or she must be entered into the database and "signed in". All of the visitor details are stored in a "visitors" table. Here's where the problem lies. If the person is an existing visitor, i.e. someone who has visited in the past, his or her details are already stored, so that person just needs to be assigned a visit... -
Works absolutely flawlessly! Thankyou very much for your time. This has helped me a lot. :)...Leave a comment:
-
The fields in the table are:
Visit ID ( Auto number)
Visitor ID ( Number)
Date of visit ( Date/time)
Time of sign in (Date/time)
Time of sign out ( Date/time)
Staff name ( Text)
Reason for visit ( Memo)
Signed out ( Yes/No)
I am only dealing with the sign out part of the system at the...Leave a comment:
-
Still can't get it to work. I just realised that the form doesn't have a record source, and i was unable to get the code above to work. This is turning into a headache.
Edit, posted this before i saw the reply directly above, however I can't get it to work because I dont know what to replace the word "account" with. I haven't had much experience with this sort of stuff however I feel that the Dlookup method is the method I'm looking...Leave a comment:
-
The record source of the form is the visits table. Basically, the signed_out is not shown on the form, thus it only exists in the table. This is because it doesn't need to be changed manually and can be handled automatically if I can get this to work. Basically, I type something into the form, and whether or not the signed_out (yes/no object) is set to yes or no depends on whether a certain message box is shown.
The only part I can't...Leave a comment:
-
Thanks for your quick reply.
It needs to link to a table not a form, so i changed the code to:
which is basically what i need to do, however this doesn't work. The form is referring to a table, not another form. Please advise.Code:If [Tables]![tbl_visits]![signed_out].Value = True Then (do stuff) End If
Leave a comment:
-
If statements for Yes/No fields
Hi.
I'm relatively new to using Access, and I have a specific thing I can't get to work:
I have a table called tbl_visits and within that table a field for "signed_out ", which is a yes/no (boolean) field. Basically, from within a form, when a button is pressed, the database needs to return whether the "signed_out " field is yes or no and take appropriate action. Current code:
...Code:If DLookup("signed_out",
No activity results to display
Leave a comment: