Recent content by northernbreaks

  1. N

    Date()

    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
  2. N

    Date()

    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
  3. N

    Date()

    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
  4. N

    Date()

    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
  5. N

    form size when opened

    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
  6. N

    Textbox data to several tables

    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...
  7. N

    Textbox data to several tables

    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...
  8. N

    Inputting data Text box to several tables

    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...
  9. N

    Query result to Text box

    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
  10. N

    Query result to Text box

    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
  11. N

    Check Boxes

    check boxes Thanks for the tip Dave
  12. N

    Check Boxes

    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...
  13. N

    Security

    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
  14. N

    Changing cursor

    cursor change Thanks that work great Dave
  15. N

    Changing cursor

    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
Back
Top Bottom