Hi Guys
It does compile and I found the problem. The table that the form was linked to had a field with the same name (Tut, Tut, boob on my part), so I changed the field name, and it works fine.
Cheers
Dave
Hi
I think you may be right, I have tried it on other forms and it works, there must be something on this form that is causing the problem.
Thanks
Dave
still no joy.
I have tried writing this into the form 1sec timer event to update the textboxes.
txtTime_01.Value = Time ' Update time display.
txtDate_01.Value = Date
The Time works but not the Date, it displays nothing.
Dave
Hi
I have setup a textbox and set the expression in the Control Source to =Date()
When I run the form the textbox displays '#Name?'
Anyone any ideas
Dave
textbox
Hi
Thanks for replying.
Its ok I have sorted the problem, most of the form fields belong to one table so adding and modifying data was not a problem, however there is another table of data that the user wanted to see a couple of fields displayed on the same form, displaying these data...
I am trying to link the textboxes on a form so that their values are stored in 2 seperate tables.
Setting the Record Source of the Form to TableA and the various Text boxes etc are set to the Fields in that table works fine, however I want some other text boxes to be linked to another set of...
I am trying to link the textboxes on a form so that their values are stored in 2 seperate tables.
Setting the Record Source of the Form to TableA and the various Text boxes etc are set to the Fields in that table works fine, however I want some other text boxes to be linked to another set of...
query and text box
Hi
I have added a button to a form, but cannot figure out how to move the query result into a text box by just pressing a button.
Dave
Hi
I have a query with 2 fields, when it is run it returns a result based upon the result of the set criteria.
Can you get this value to be displayed in a text box after a button is pressed.
dave
Hi
In my tables I have set a field to Yes/No and the format to be True/False.
When I activate the table it shows the field as a checkbox, however when I create a List Box on a form to that table it displays the fields as True/False, how can I get the list box to also display the field as a...
Hi
When using security login, can we logout and then login to the database without shutting down the database and re-opening.
Such as using a button to logout and then another to login.
Dave
Is there any whay you can change the cursor as it moves over an object, similar to what it does with hyperlink.
I am trying to make the form more dynamic
Thanks
Dave