Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 12th, 2006, 01:21 PM
Registered User
 
Join Date: Jul 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access combo box does not work with SQL Server

Hi,

I am migrating an Access Application to an SQL Server. One of the issues I have run into is that my combo boxes do not work correctly.

The combo box is unbound and uses a query to populate it's contents. The query (called ddQry) is of the form:

SELECT ID, NAME from tblCode where codetype='flavor'

The relavent properties on the combo are:
RowSourceType: Table/Query
Row Source: ddQry
ColumnCount: 2
Column Widths: 0";2"

The results of the query are of the form:

1, Orange
2, Mint
3, Lemon

What happens is when tblCode is an Access table, the combo box works as expected. However, when I migrate the table to SQL server, all items show up when you drop down the list, but after you select one the combo is empty. Also, if you change the column widths to display the first column the values do show after selection, but as expected just the number is displayed.

Any thoughts?

Thanks,

Jerry


Reply With Quote
  #2 (permalink)  
Old July 12th, 2006, 02:31 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Is this a linked table or a data connection/recordset? Is this a local query you are looking up, or a SQL view?

Still ruminating...

mmcdonal
Reply With Quote
  #3 (permalink)  
Old July 14th, 2006, 03:00 PM
Registered User
 
Join Date: Jul 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The table referenced in the query is linked to the SQL database.

Also, I make this happen in trivial form that just has a combo box and a query to a linked table.

Any insight is greatly appreciated.

jerry

Reply With Quote
  #4 (permalink)  
Old July 14th, 2006, 03:30 PM
Registered User
 
Join Date: Jul 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Also, the query runs against the linked table, not against a view.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Data from a combo box darkhalf Access VBA 1 February 22nd, 2008 04:28 PM
combo box doesnt work in IE7 but Firefox mamuco Classic ASP Components 1 June 4th, 2007 10:10 AM
Combo box dropped down don't work proper Sneha Patel Book: Wrox's Visual C# 2005 Express Edition Starter Kit 1 May 28th, 2007 07:08 AM
Combo box can not work with dynamic Range dahlia492 Excel VBA 1 November 20th, 2006 12:43 PM
Access Combo box with sql server jbritz Access 4 June 18th, 2003 11:33 AM



All times are GMT -4. The time now is 05:53 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.