Solved

how to use temptable as row source for combo box in adp

Posted on 2004-03-30
3
299 Views
Last Modified: 2012-08-14
In an adp project, I create a temp table called #Employee.
I can access the records in this table through code or a stored procedure, but when I try to use it as a rowsource for a combo box, I get the error that the record source doesn't exist for this form or report. I get this error even if I use the Stored Procedure that does return records.

So, is there any to get the records of a temp table into a combobox?
0
Comment
Question by:Mach1pro
3 Comments
 
LVL 11

Expert Comment

by:phileoca
ID: 10715246
Sure. many ways.  Easy solution would be make a Select Query:

TempTableListQuery

With the fields you want from the temp table.   Then on your combo box, set the row source type to table/query and the row source to the query, and select the number of columns, and which column u want the query to be bound to.

KT.
0
 
LVL 6

Author Comment

by:Mach1pro
ID: 10715319
There are no queries in an Access Data Project
0
 
LVL 32

Accepted Solution

by:
jadedata earned 500 total points
ID: 10715953
There are no persistant queries,... but there should be plenty of SQL usage...

Why not use a persistant table, but clear it before use?  Refill it as needed??

Creating and destroying objects is always a messy business in an application.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question