Creating A Search Command Button

[GarageFlower]

Hi People

Im at work creating a form from a table which has been populated.

Havent filled about with access for years.

I found like the command button in the tool box to create a search button

I need the vbscript to be able to get it too work though.

Can any of you lot help

For example i want to a box to appear where you can type in someones name and then press enter and it will display the matches on the form

Many Thanks

 

[Oldsoftboss]

I search like this....

 

[de049]

Please Help!!!!

Hi,

I have checked out the Search DB offered here but I am now having problems when trying to rename the forms and tables to better suit my scenario.

I have changed the table names in the SQL statement in the form's unbound listbox, which displays the records held in the table.

The error I get now when opening the form is : "The recordsource 'tblCompanies' specified on this form or report does not exist"

I have deleted the report, but still get this when openming the Form.

Can some suggest how to change form/table names and avoiding these hicups in the process.

Many many thanks!!

 

[de049]

I think i got it. Will let y'all know how it goes. Cheers anyways

 

[Rusty]

The error I get now when opening the form is : "The recordsource 'tblCompanies' specified on this form or report does not exist"

Make sure that the Record Source property of your form is set to look at your new table name.

Can some suggest how to change form/table names and avoiding these hicups in the process.

In terms of changing table names in existing databases just be sure to look at every query, form, report and macro that this could have an impact on and change them accordingly. Alternatively avoid renaming tables - it's a pain in the arse if you're running a complex database.

Hope that helps,

Rusty