Linking to an access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'l trying to make address and contact info visible to people using our acess
database. I thought I would link to the .dbopublicaccountsview and make a
drpdown list so you could look up the account in access then link it to our
records in access. I can see "fullname" in table view but when I try to
include it in the dropdown it is not visible, I assume it's because it is a
memo field. How do I efficiently make it so people using my access database
can easily see address info for the business account?
 
I'l trying to make address and contact info visible to people using our acess
database. I thought I would link to the .dbopublicaccountsview and make a
drpdown list so you could look up the account in access then link it to our
records in access. I can see "fullname" in table view but when I try to
include it in the dropdown it is not visible, I assume it's because it is a
memo field. How do I efficiently make it so people using my access database
can easily see address info for the business account?
Click to expand...

In the database, PublicAccountView.FullName is of type nvarchar, same
as the other columns with strings.

I suspect that there's a problem in your code that populates the drop-
down list. Perhaps it can't handle unicode?
 
Back
Top