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

gratzi thnx for the input that works well now.

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

cheers.... thankyou all is good now

the data type is text on table Hello WHich property on my table is it ? the data type is text ...is that what you mean

finally got the hang of auto fill thnx to everyone who responded to this I finally got the hang of it last week. had a major block on understanding this method

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

further enhancment Thnx wayne that worked really well. Next question are there any parameters I can add to this to get the location column to sort ascending. below is the current code [Location 1] Or [Location 2 ] kind regards :D

thnx no worries...thankyou....for responding

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

perfect solution I had the same problem .. and same error messge I had Deleted a previous command which means I had code in twice mucho gratzi

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

thnx for responding after copious sweath and tears shift /enter on 1st line and shift /enter last line does a reasonable block select...

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

oops....thnx

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

cheers........... louchey

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