Recent content by Casper2012

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...