search and update

UniversalJOC · Mar 1st, 2002, 04:05 AM

how would I create a button that basically allows a search to be made.
activates the find action. asks for a user name (initials for example) and then number to be found in a column. then takes you to the requested row, and also updates the corresponding columns (eg Columns E - the word 'Active',F- current date,I - initials,J-the word 'customer')

Corni · Mar 24th, 2002, 09:33 AM

Open the Forms toolbar (View|Toolbars) and place the button control on the worksheet. Then assign a macro to the button that is going to perform all tasks you need. You have to be familiar with VBA.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 04:05 AM	#1
UniversalJOC New Member Join Date: Feb 2002 Posts: 40	how would I create a button that basically allows a search to be made. activates the find action. asks for a user name (initials for example) and then number to be found in a column. then takes you to the requested row, and also updates the corresponding columns (eg Columns E - the word 'Active',F- current date,I - initials,J-the word 'customer')

Mar 24th, 2002, 09:33 AM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	Open the Forms toolbar (View\|Toolbars) and place the button control on the worksheet. Then assign a macro to the button that is going to perform all tasks you need. You have to be familiar with VBA.