Search results

Hello- I have beeen around access for many years and I am surely no stranger to its ways. Hoever, latetly I have been give more and more tasks at work that I fee as though I would benifit greatly from taking a class to re-fresh up a bit. I am not above paying for the good stuff. Just wanted...

i tried to save it in 2003, but there were some features of the db that wouldnt allow me to do that....

Hello- I have a form with a subform that is running a query. Well the form is doing some weird stuff with the query. I have included the db so someone can look at it and see what I am doing wrong. Thanks- (dont worry the name in my db are all fictional) *** I am using the Contact_List...

Ahhhh.... I see whatya mean. Boy I feel stupid, right there in front of me the whole time.. LOL Thanks Rural!

I understand they can be query's, I already had a source query for this form. This script is running on the page, just wondering how to filter so that my phone numbers are showing is a list order... thanks in advanced!

I have a combo/lookup box in my form that allows me to search by phone number and populates fields for me. My question is, how can I show my phone number to list in accending order?:confused: ****************************** Private Sub cboNames_AfterUpdate() If Len(Me![cboNames].Column(1)) >...

Actually it was just some code that was in one of the sample databases that came with Access 2010. Is that a basic code to "open" a record in a form?

I think the sample will work.:) Another issue I am having is. The sample db5 that you sent, after I perform the search and the items return in the form, I need to place a link to open the form to another Form. I am trying to use this code, (i got this from another db) wanted to know if it...

One more question for you John. I am going through my tables and organizing them better using normalization rules. However, i have a field that listed all the suppliers we use. This field has a dropdown list to choose from. Well in the old table if the name of the supplier wasnt there we could...

I really think you have John! I am working on the project over the next few days and will let you see the final results! **Again , I really do appreciate all your help with this "mind-boggleing" experience!!

This is great JOHN! I think we may actually have something here. I will need to do a LOT of work with merging the databse you showed my with what I am actually trying to do. I will basically use the db you sent as a template to bring data into my database. Man this is great. I will post the...

John- I am checking out your db5 project and was wondering what is the command to enter a "CLear Form" button. If I wanted to put a button on the welcome page that would clear the data out and start again....

Sorry John, didnt mean to confuse you. What I was asking was, is there a way to use the button I created on my form to perform the parameter query, and populate my form with the results. See, some of my customers may have 2 -3 phone numbers and I need to be able to choose from a list the...

Buit can the same results come from the search button I created on my form? Can it search the query and return the result like you metioned before?

looks like i only need to search for phone numbers, not a contact criteria...

I tried that and I dont think it will work for what I am trying to do. I was trying to run the command from the Button I had on the form. But when I run the command (which runs the query) it show me the query in a table. I need the results to show in a form so I can choose the result from the...

Also, in my query I have the Field: Contacts.* Table: Contacts could I use the Like [Enter phone Number] & "*" command here or would I have to spread out each of the fields independently to get it to apply for the phone number? I hope that...

I tried the code and I am getting a Syntax error: DoCmd.Close acForm. "Contact Details" Any ideas?

Sounds easy enough JOhn! Just wondering though... What would be the better way to perform my query? A. Like [Enter phone Number] & "*" <or> B. Like "*" & [Forms][Search]![Phone Number] & "*" I really appreciate your help John! I have been reading alot of your posts. You are...

:)Hello- I was wondering if there was a way to run a parameter query and have the results open up in a form? Thanks for any help anyone could pass along!