Thanks a lot n8kindt
Nz() is a good one that I didn't know about.
I got my problem solved partially though as two tables are related and any entry in the Org table that doesn't have a contact associated with it from Contact table is not shown in the result set.
How I can have all the records from both table?
I am using MS Access 2000 and tblOrg is master table in the relationship.
Thanks for the help.
Ra...
razjafry
Last Activity: Feb 22 '09, 06:22 PM
Joined: Sep 28 '07
Location:
-
Mailing List Query
Hi Experts,
I have two tables - tblContact and tblOrg
Contact table has only one option of mailing address e.g address,city,po stal code
whereas Org table has two options - one simple address - address,city, postal code
and other one is mailing address which is populated automatically if a check box is checked "Is mailing address same" - mailing address, mailing city, mailing Postal code
I want to generate... -
This query runs but gives very few records.
I expect around 3000 record on the base the selection I am looking for but it gives only around 100 records so need to look into this query quite in detail to figure out the right combination.
Thanks for your help.
RazLeave a comment:
-
Thanks a lot,
Its working on the base of ID now.
RazLeave a comment:
-
combo box search is giving runtime error 2501
Hi,
I am trying to create a combo box to search record on the base of ID but it gives runtime error message 2501 "the openform action was cancelled" all the times.
I posted this question before but remained unresolved for ID search criteria
http://bytes.com/forum/thread757878.html
I changed the data source from table to query but still with same result.
Right now select criteria on the... -
Yes I tried to run it as is and it gives the error message that I need to specify at least one table or query.Leave a comment:
-
Hi NeoPa,
Thanks for the help but somehow I am unable to get anything out of this so far as it ask at least one table or query to be part of this code.
I am sorry if it sounds like some extra work for you.
RazLeave a comment:
-
Hi NeoPa,
Thanks for having me in your list. I'll be looking forward to your help whenever you get a chance.
Thanks,
RazLeave a comment:
-
Hi NeoPa,
Thanks for your effort for looking into it.
I think it won't be that large dataset and if some kind of solution is there then it should be good enough. So would you please spare some time and give me the solution/template.
Regards,
RazLeave a comment:
-
Hi NeoPa,
sorry if I wasn't clear enough in my question.
To me looks like you are getting it right though and can be a good starting point to custamize further if it need to be.
Thanks for your help.
razLeave a comment:
-
Hi NeoPa,
As per your instruction I am posting MetaData of both tables. Thanks a lot for your help.
Note: tblOrg has One-To-Many relationship on tblContact
Table: [tblOrg]
"intOrgID",numb er,PK"
"coop_yn",ysnCh eckbox
"Active/Inactive",ysnCh eckbox
"strOrgName",te xt
"strAddr1"t ext
"strAddr2", text
"strCity",t ext...Leave a comment:
-
Need help for mailing list query
Hi Experts,
I have two tables- contact and organization. Both tables have the mailing addresses. Some contacts in contact table don't belong to any org so I give the link to those as individual which is an entry as organization in Org.. table.
There are certain organization which don't have any contact person listed. These two tables are linked as Org..as master and contact as slave.
I want to create a mailing list.Criteria... -
Hi,
I think you should select both fields as a group, then right click to copy and then right click the third tab and past them there. I hope this would solve this minor problem.
razLeave a comment:
-
Thanks a lot.
It worked right away the way I wanted.
You are actually BridgingLinq(K) instead of missinglinq -:)
Take care,
SyedLeave a comment:
-
How to populate Mailing Address if its same as Street Address?
Hi Gurus,
I have street address fields as Addr1, Addr2, City, PCode, Prov, Country.
Then I have a check box asking if the mailing address is same as the street address.
How I can populate all the corresponding mailing address fields automatically if someone checks the check box as Yes.
I use mailing address fields as MailAddr1, MailAddr2, MailCity, MailPCode, MailProv, MailCountry.
I really appreciate all the help.... -
Thanks again Ronald,
So nice of you taking time to explain that to me.
Take care,
SyedLeave a comment:
-
Hi Ronald,
I hope I am not asking too much but would you please elaborate that code a little bit for me so I can understan how it did work. Its just part of my learning process.
Thanks again.
SyedLeave a comment:
-
Hi Ronald,
You are a great help. Thanks a lot. It did work for me and now I have all the postal codes with a space in between.
Thanks again for your help.
SyedLeave a comment:
-
Adding a space in between the data values
Hi,
I want to add a space between postal code in my database but don't know how to accomplish it.
We have postal code format N1H8L5 or N1H 8L5 (note: a space between the middle of six characters. We have both kind of formats entered in our database.
I want to change them all to the the one format with the sapce in between.
How I can change those without space in between to the desired format.
Thanks for your... -
Thanks a lot for your replyLeave a comment:
No activity results to display
Leave a comment: