Search results

Good morning, Here is what I did. I had a perfectly good data entry form setup. The form is capturing information on sailor training, and tblAT contained things like ATdescription, ATDate, ATGainingCmd. I wanted to make sure I normalized ATPlace and ATGainingCmd, since there could be...

Thanks. I think I'll head back to the drawing board based on the input of you three. I need to put the values of two comboboxes (ComboPayGrade) and (ComboDept) in there. Ok. Thks again.

Thanks. That's what I had originally but when I move back to IsNull() I get "Syntax error in query expression '(((TblPayGrade.PayGrade)=[Forms]![SearchForm]![TblPayGrade.PayGrade] Or IsNull([Forms]![SearchForm]![TblPayGrade.PayGrade])) AND ((TblDept.Dept)=[Forms]![SearchForm]![TblDept.Dept] Or...

Hello. I am attempting to design a search that makes use of multiple comboboxes to allow users to select an array of criteria. My present goal is to allow users to search by the following choices, which I'll explain a little more: - paygrade - department PayGrade lives in a table tblPayGrade...

Done. It works. :genuflecting:

Ahhh...I was trolled, perhaps? I had no objection to posting it, since there's only dummy data in the thing.

Database. Errr...that didn't work so well. My database zipped is about 3MB. Am I missing something here?

Roger that! Give me a couple of mins. Thanks.

Re: Re: Newbie Question re: "#Deleted" Sorry - I hate to parade my ignorance, but could you give me a little of your thinking behind the recommendation? Are you saying that you think this is not an RI problem?

doorway pages Jon, I'll certainly put the link on my sites when I get a moment. If you have RREEAAALLY good users, you might want to ask them to put "doorway pages" on their sites. These typically do even more for your rankings than a link. John

Hello, All: I am coming fairly quickly up to speed on Access (I hope), but hit roadblocks from time to time. I researched this question, but was unable to find a definitive answer. I appeal to the Access pros. I am doing some intensive work on a form and deleted a record for the first time...

thks Awesome stuff. I'll try a new structure and see if it sorts out my issues. Thanks.

Greetings! Say you are making a database that tracks where clients have gone on vacation. You have a table named 'tblTrip.' tblTrip looks something like [client id (primary key)] [destination] It's keyed by the client id to a table tblClient which has your basic client info. We track...