Search results for query: *

thanks a lot for the help! solved the problem perfectly!

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

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

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

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

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

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

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?

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