Re: Creating a temporary table/query for subform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Maybe I'm missing something, but why can't you base your subform on a query
where the percentage is calculated? I don't see why you need the temp
table.

BTW, when I need a temp table in a multiuser environment, I will
programmatically create a local database (root of the C drive), export an
empty table to it, then relink the temp table back into the program. Then
the user has a local table.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImportToTempDatabase.mdb" which uses a temp database and temp
table to import a text file without bloating the database.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


"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

  • Re: Merging data from Access Query
    ... Data from the database will be placed in the document, ... Y/N ?" ... If the query references the Form, ... The process starts in an access database. ...
    (microsoft.public.word.mailmerge.fields)
  • This ones a challenge: 1.9 not equaling 1.9..... Whats going on???
    ... I've got a real challenge this time with an access database that I'm ... I'm writing this database for work, ... column #1 in the query is titled ...
    (microsoft.public.access.queries)
  • Re: Update Access Table with Excel Table
    ... give you the correct data types, otherwise import the spreadsheet into a ... link that table into your "real" database. ... then turn the query into an Update query, ... the matching fields in the temp table, and referring to the temp table ...
    (comp.databases.ms-access)
  • Re: Creating forms in Excel to Import access data ! Please reply
    ... File>Table Definition, select your database, and set your query - you can ... also type in SQL directly. ... >> access a query in the Access database. ...
    (microsoft.public.excel)
  • ADO to ADO.NET 2.0
    ... and an Access database. ... In this application, we routinely query multiple ... to the database are implemented by the record set's Update command. ...
    (microsoft.public.dotnet.framework.adonet)