Search results

On my form which is used for IT equipment inventory , I would like to have a scrollable memo type field: that would store details of record changes something like date...and username of changee. is this possible ...? Or alternatively does the database store this info somewhere ? regards...

Hello sometimes when Find Record Button on my form generates an error..that says among other things to "Add a GoToControl action before the FindRecord Action." I know zilch VBA...could some tell me the syntax for adding this line and where I should add it. exisiting code for the button is...

If the Level field on my form is empty ( which sometimes can be intentional ) I get an error "cannot be zero length string" How can I set this field to accept nothing or to be populated this is the after update code : Private Sub Combo26_AfterUpdate() Me!Unit = Combo26.Column(0) Me!Location...

I have created a prompt that request a location name is there a way to enter more than one location ie what would the syntax be to ente: bendigo & Head Office in the prompt box hope this makes sense thankyou

I have a table called units with 3 columns unit,location , level I want the fields UNIT and LOCATION to auto update on my form. on my combo box..which is on the Unit field the "After update "property is coded as: IUNIT = Units.column(1) LEVEL = Units.column(2) my syntax I guess is up...

Hello this is driving me nuts If I want to copy data from one line in a column/cell how on earth do a select multiple rows in a column/cell to paste the data into ? instead of doing in row by row. access 2000 looking forward to any replies regards :p

In my form I have a field called Dept that selects from a list box. when the appropriate Dept is selected I would like to populate another field called Level with the slected Department's appropriate floor number. Can you advise which functions I should use / or how to do this . thankyou...

Hello all my add-Ins are missing ie Tools Add-Inns.....there are no addins can anyone tell me which folder they are in so that I can add them thankyou :D

Hello dumb question but my list boxes have about 5,000 blank lines in them how do I clear them out . access 2000 regards P plate access user:p