Search results

The above can't be right. If I ran an if then for each one of the possible matches based on 1 field, wouldn't it only work if the last one listed matched? Otherwise, wouldn't the variable be reset with each step up until the last one that references [Phone]? I'm sure this is basic stuff here...

Question to Beef or anyone familiar with this sample (about posted samplesearch.zip db): Say I wanted an individual input box on the search form to query multiple related fields (say their is a field where order address and also a seperate field where customer address is stored), how would that...

Thanks to Beef & dcx693. The sample provided is proving very useful, thanks! I've been sorting through a search of "search multiple fields" and this is one post that satnds out so far. Is there a consensus solution that most seasoned posters here would recommend to use? I know in Access there...

OK, now I need to figure this out: Against my better judgement (from what I read about normalization), and for making forms easier to set up, I have three phone number fields: BusinessPhone MobilePhone EveningPhone How do I string those fields together into a similar Combo Box search in the...

say I have a drop down list to declare a data type, is it possible to update the input mask for another field based on this data type? Example: Input Type A : 000/000/0000 Input Type B : 0/00/000/0000 Seems simple enough with some VB If Then code, I just have no idea how it would be done, and...

Exactly, I just wanted to clarify... I figured the wizard would have done this automatically. Thank you ejstefl! I will give this a try shortly.

But people will not know the customer number. They will be on the phone with George Smith, they'll know his name, but have no idea what his customer number is, so it seems a search box for customer number would be useless.

Hello, here goes... #1 I have a form with a combo box to be used for navigating to records (created using the wizard), based on a query with these fields: 1 - Last Name (Sorted Ascending) 2 - First name (Sorted Ascending) 3 - Company 4 - CustomerID (PK) The combo box only partially works, it...

Not just rude, probably more delusional.... But whatever you gotta say to feel better about yourself. :rolleyes: I'm sure you're pullin' all kinds of 'dimes' huh playboy?:rolleyes: Stick to explaining to people how to normalize data, and don't be so concerned with calling beautiful women ugly...

Thanks, you always are quick with good answers. I need a name other than "Banana" though :p... The db is used concurrently by only 3-7 users, without much likelyhood to expand beyond 10-15 for medium term... I am looking into SQL, as of now I use a split db design in access, but I am sure in...

Hello, I am fishing for advice on what systems people would recommend... Currently, our system breaks down like this: We use Peach Tree (old version - sucks) for accounting (this is where my question will kick in) We use a rudimentary database I built for contact/prospect management (I...

Ehh, maybe it is a bad idea... I was thinking, say there are 10 options in a list, but 90% of the time, only 2 of those will be used. I was thinking have 3 radial buttons... 1 for "Other, if other was selected, they would have to select one of the uncommon values from a drop list. After...

Can anyone take a shot at this please? It would be appreciated, if even a not possible was given. Thanks!

I promise I have searched, but I hav spent 10 minutes reading through posts that are unrelated... What is the code to have multiple fields updaterd based on what is input into a field? --- Example: A ZIP Code Field, which updates City & State on the form when entered. (I have a table that has...

Hello all... How do you merge / append records from one database into another? The old database was very poorly designed (i.e. no normalization), but much of the data is the same. Instinct from what I have learned says do this: - create a query in each database that joins all fields together...

I just want to say this is one of the most insightful posts I've ever read. Thanks all for excellent reading material! The link to the online '97 book is also excellent, if anyone else has links like that, they would be very appreciated! Thank you!

every 100 points is a jello cube, 1,000 points is a cube o' radioactive jello, and that's some good eats there. Excellent source of Vitamin Z & extra eyeballs!

I did, but still... Someone like Pat Hartman, with 18,000 posts (Eighteen THOUSAND) posts still only has 1 block? Seems a bit of appreciation to the 5,000 post users should be due, regardless of turn over. But I'm sure most of them don't care less, and I don't consider it a huge issue myself...

This is from another forum, where Jello means everything ;) : What is user Reputation? Your "Reputation" is a number that reflects a combination of the number of posts you've made, how long you've been a member, and what other forum members think of your posts. It's represented by a sequence...

Thanks for the insight. I have been working with subforms a lot this past couple days and have found all of the controls that are required to make it seamless into a form. This makes design MUCH easier (I really thought a subform might have to be a datasheet for a while, like I said before...