Searching Forms

[Charmed7]

I really have to question my abilities using Access. I have looked at past posts and see solutions, but I can never make them work. I tried using the SearchExample02.zip database, but there's a query that has a field [tblCompanies].[TradeID]

Where is TradeID? I can't recreate that field.

I tried using the newer one posted Searchdb.zip. No luck there either! I'm not familiar with any vba etc etc.

I guess if someone isn't holding my hand Does any one have any suggestions for a good walk through book. I have a few but they're too advanced for me. I have even taken a few classes. But I still can't "do it" right. If someone had the time and energy to help me with this search field issue, that would be great. Otherwise, I don't think I'll ever finish my project. Thanks.

 

[WayneRyan]

Charmed,

Post a sample DB with a specific question. The DB, and your knowledge,
will both grow as your specific questions get answered.

Wayne

 

[Charmed7]

I have a search form I got from here, and when I click the update button it brings me to Visual Basic and highlights Dim dbNm As Database

FYI, the two dbo* tables are usually linked. I'm having problems with that too. I posted under Queries called "Make Table" regarding that.

Thanks again.

 

[Mod]

I have a search form I got from here, and when I click the update button it brings me to Visual Basic and highlights Dim dbNm As Database

FYI, the two dbo* tables are usually linked. I'm having problems with that too. I posted under Queries called "Make Table" regarding that.

Thanks again.

You're going to need to add a reference to MS DAO. in the vb window, select Tools->References then scroll down to the M section... Look for "Microsoft DAO 3.6 Object Library". check that box, click OK and save the file then re-run the module.

Edit: this only fixes the error that was halting it. I haven't looked at any of your relations or anything.

For a long time I've thought that there should be a better way to include references, you know like #include. copying code gets much more complicated when you have to go to the menu everytime.M$ bleh

 

[Charmed7]

Thank you Thank you Thank you Thank you Thank you Thank you.

And I would never have known that. So maybe my faith in myself is reassured.