Search results

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

Hi Is there a way I can make a form open to maximum size to fill the work area without click the forms Max button 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

check boxes Thanks for the tip 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

cursor change Thanks that work great 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

Record deletion Hi Scott I have been typing in some test data manually into the table and have not setup any relationships as yet. So the table is not linked to anything, however I deleted a record. Just thought there may be a way of tyding up the record number. Dave

If you delete a record, the auto number is deleted but the following number remains unchanged e.g. 1 2 4 5 6 (Record 3 deleted). How can you rebuild a table so the auto number remain sequential. Using Access 2003 Dave

Multiple access users Thanks guys, your input is much appreciated. Thanks dave

Hi If I want several users to access a database from their network pc's, should I place the access database .mdb file on the server and set the Sharing properties, then install the access application on each of their stations. They need to each be able to use the database when they need to and...