Re: [MS_AccessPros] Re: Contact Database

 

I answered my own question for the filtering. It was the record source, it is ordered by first name, last name. 

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

From: "Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, December 19, 2014 11:36 PM
Subject: Re: [MS_AccessPros] Re: Contact Database

 

Hi Art,

If you change the RowSource for many of the comboboxes, the SQL statement must be stored in the control TAG property -- this is used when the SQL is changed to add criteria.  I have not tested it on SQL Server. 

The RowSource for the find Address listbox is changed each time the contact changes.  When I deployed it, apparently I left 759 in there for CID, which was an oversight on my part but shouldn't cause an issue.  Perhaps edit the RowSource to remove that criteria.

I would be interested in connecting to you sometime and getting it to work with SQL Server.  Email me.

thanks, Art

Warm Regards,

Crystal

 *

   (: have an awesome day :)

 *

On Friday, December 19, 2014 4:46 PM, "Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Sorry I should have added a subject. 

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

From: Art Lorenzini <dbalorenzini@yahoo.com>
To: "Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, December 19, 2014 5:41 PM
Subject:

Sorry to bother you but I have been working with parts of your Contact database and I have ran into an issue. I have ported the backend to SQL Server but I ran into an issue with  fnd_AdrID listbox. When I run the record source: 

SELECT qCart.CID AS CIDq, qCart.TypIDadr, Adr.CID, Adr.AdrID, IIf(Nz([Adr].[TypIDadr],9)<>0,"","*") & IIf(IsNull([Adr].[CID]),"","*") & [AdrTy].[TypAdr] AS [Address Type], [Ctry] & (" "+[St]) & (",  "+[City]) & (", "+[zip]) & (", "+[Addr1]) & (", "+[Addr2]) & (" -- "+[Area]) & (" ("+[adrNote]+")") AS Address
FROM (SELECT C.CID, AdrTy.TypIDadr, AdrTy.TypAdr FROM c_AdrType AS AdrTy, c_Contact as C)  AS qCart LEFT JOIN c_Address AS Adr ON (qCart.TypIDadr = Adr.TypIDadr) AND (qCart.CID = Adr.CID)
 WHERE qCart.CID = 759 ORDER BY IIf(Nz([Adr].[TypIDadr],9)<>0,"","*") & IIf(IsNull([Adr].[CID]),"","*") & [AdrTy].[TypAdr], IIf(Nz([Adr].[TypIDadr],9)<>0,"","*") & IIf(IsNull([Adr].[CID]),"","*") & [AdrTy].[TypAdr], Adr.Ctry, Adr.St, Adr.City, Adr.Addr1;

I get the following message:

[Microsoft][SQL Server Native Client 11.0][SQL Server]

The multi-part identifier "AdrTy.TypIDadr" could not be bound. (#4104) The multi-part identifier "AdrTy.TypAdr" could not be bound. (#4104) The multi-part identifier "AdrTy.TypIDadr" could not be bound.

t must be SQL Server coughing on it because it runs fine your sample. Any ideas?

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

__._,_.___

---

Posted by: Art Lorenzini <dbalorenzini@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___