Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by applemacman

  1. applemacman

    Record Numbers

    thanks a lot for the help! solved the problem perfectly!
  2. applemacman

    Record Numbers

    Hi thanks for that, i copied it all in and when i open the form it produces a run time error '3001' "invalid argument" and then have to debug in VB. It hilights this line of the code in yellow, If Me.RecordsetClone > 1 Then Private Sub Form_Current() 'count number of records' If...
  3. applemacman

    Record Numbers

    thanks for the reply, where is this recordsetclone on the form? what would i have to type in? I thought that i would have to put something in VB to check the number and then if greater than 1 make the buttons.visible?? sorry i know you have answered my question however i just dont understand...
  4. applemacman

    Record Numbers

    Hi People! Heres the problem, i have created a search page with different criteria, this then runs a query which will return a number of results depending on the users selections. When there is more than one record returned, the user uses buttons to view the different records. I would like to...
  5. applemacman

    Refresh Sub-Form

    sorry where is the data entry property, i looked in properties but cannot find it??? Thanks for the reply
  6. applemacman

    Refresh Sub-Form

    Hi, I have a form (With text boxes) and a sub form (also with text boxes, used to input new records onto the form). The problem that i am having is that when the form is opened, i would like the text boxes in the sub form to clear. At the moment they show the data for the first record in the...
  7. applemacman

    Copy Text Box Value

    yes i have just put it in the code builder and it works now! Thanks for the quick replies!
  8. applemacman

    Copy Text Box Value

    Thanks for the quick reply! I just tried that and it says that Microsoft Access can't find the macro 'Me.' I have to then click OK and nothing has been copied. Any suggestions?
  9. applemacman

    Copy Text Box Value

    Hi, im a new user to access and have been trying to create a database. To simplfy the problem i have a form with a text box and a sub form with another text box in it. I would like to know how to copy the data from Text box 1 to Text box 2 on the sub form. This process should happen when the...
See more

Part and Inventory Search

Back
Top