Re: Creating a temporary table/query for subform

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Duane,

Thanks for the quick reply... here's what I tried:

Dim qdf As DAO.QueryDef
Dim strSetService As String
strSetService = "SELECT * INTO TestQry FROM tblServices;"
Set qdf = CurrentDb.CreateQueryDef("", strSetService)
qdf.Execute
qdf.Close

It did create the table, but it showed up in the database object list
anyway, something I am trying to avoid. How can I prevent it from showing up
there? And how do I detect if a table already exists?

... Jim..

"Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx> wrote in message
news:OjoiNQ8MGHA.1032@xxxxxxxxxxxxxxxxxxxxxxx
If you really need a temporary table that can't normally be seen, try
SELECT tblA.* INTO usystblA
FROM tblA;


--
Duane Hookom
MS Access MVP
--

"LeMay" <lemayNOSPAM@xxxxxxxxxx> wrote in message
news:3oiJf.33743$H71.3699@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm trying to create a subform that the user can sort by clicking on the
column headers.

Before I get to the user side, the code part has become a problem. My
table headers look like the following. ID is the primary key:

ID, Name, Value

I need to make a temporary column that shows percentage; I'll call it
percent. Unfortunately, because it is in a mutliuser environment, I
cannot insert the percentages into the table itself, because each user
would have different percentages. Therefore, I need to create a temporary
copy of the table for each user and add the fourth column called
"Percent."

As another requirement, I cannot let this temporary table or query show
up in the list of objects showing up when you open up the database.

So what strategy should I use?
I thought about using a make-table query using a QueryDef, but I can't
find any help in the MS Access help on how to do this in VBA.

Anyone know how to make this query so it can be used in the subform?

Please reply in the newsgroup.

.. Jim..





.

Relevant Pages

  • QueryDef slow down query
    ... My understanding is that MS Access optimizes saved ... queries when a database is compacted, ... >dim qdf as dao.querydef ... >The problem is once the query is modified by VB code it ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sorting a table with VBA for WORD
    ... You don't need v2 software to make a query. ... If you don't have Access or can't open the v2 database ... dim qdf as dao.querydef ... set qdf = db.CreateQueryDef ...
    (microsoft.public.access.modulesdaovba)
  • Re: Select where statement in a series of queries
    ... Dim db As Database ... Dim qdf As QueryDef ... Query C being the orginal query with a field called. ... >>> dim qdf as querydef ...
    (microsoft.public.access.formscoding)