Search results

thanks! this is a great article. i'm fairly new at this database stuff and trying to learn most of it on my own. you've been a great help!! have a great day!

yes! what would i need to add to the script to accomplish this?

perfect! that works beautifully. do you know how to add the Null if there are empty fields?

yes, i would like to have my address show on "one line" for a report i'm trying to create! if you have any suggestions, they would be welcomed. thanks for replying.

hi, i was able to figure out how to make it work. Now i would need to create a script that will have all of my address information such as address, city, province, postal code and phone numbers as one. any ideas? really appreciate your taking the time to help me out. i promise one day when...

hi, here is the SQL that i currently have: SELECT [TBLContactDetails.strcontactdetailsFirstName] & " " & [TBLContactDetails.strcontactdetailsLastName] AS NAME, tblContactdetails.strcontactdetailsDesignation, tblGroupDetails.strGroupdetailsdescription...

hi, I'm trying to write a query from a table that has a combo box. I want to have the information in the combo box added to the AS NAME so that i have first name, last name and then their designation all in one. I'm able to have the first and last name group, but I can't seem to add the...

Hi, thank you for your response. What I'm trying to accomplish is that I have a 'data entry' type form. In my form I've created a drop down list for the 'association' that the contact person belongs to. I also created a table for my associations that contains all the contact info. this is what...

Ok, so if i'm setting this up on the form itself, I would change the properties of the combobox to select a query? would this fill in the address sections automatically or would I have to have the query stating where the information should be updated. I would need to have my fields match...

yes I would pul the information from a different table. would this involve building an event procedure?

sorry for the lack of information. I have a form that is set up for the users to select from a drop down list the name of the association. I would like to have it that if the association is selected, then the address would automatically be filled in with the proper coordinates as per the...

hi all, I have a form that is set up for the users to select from a drop down list the name of the association. I would like to have it that if the association is selected, then the address would automatically be filled in with the proper coordinates as per the chosen association. I hope...

:D Thank you so much. I'm still skeptical as I can't believe my solution was so simple. but it's working! I'm wondering if you'd be able to help me with an other function I'm trying to do. here's the scenario: i have a contacts form which will update my junction table, thank you! now I'd...

thanks. i did create the subform using the junction table, but i need for the "group" to show up as a name and not an ID number. how can i do this.

thank you! i'll give this a try. My subform is based on the junction table, but the problem is that I want the name to appear instead of a number. how can i do this

I've created a form and subform using a a query on a conjuction table as this is a many to many relationship. the problem I'm having is that my subform will not allow me to update the field to add new information to the specific contact. if i add to the subform it updates the wrong table. I'm...