I know this is simple but I'm new to Recordsets and can't find the code.
I would like to create a temporary table when my form loads, it should
contain 3 numeric fields and 3 Yes/No fields. I need to write temporary
values to these fields when this form is open and then destroy ...

I have a combo box whose Row Source Type is table/query and Row Source
is "SELECT DISTINCT [Package Name] from Packages ORDER BY [Package
Name];".  I can see the values when I run that SQL statement as a
query, but nothing shows up when I run it as a function of the form

In Albert Kallal's WordMerge, will it work only with fields from tables, or
can it pull from Query fields as well?  And if so, does it have to be set up
any differently... how do you tell it you want Query fields rather than Table
fields?

I'm using a table to transfer data between forms,
This table periodically has new records put into it, & I was wondering how
to pull the most recent record
I'm not sure what the statement would be to pull the fields from that one

jkcsaj djladfh dvkldw w

1 - How many "simultaneous users" can Access support?
2 - Is the problem the backend computer resources or the Access code?
3 - Is there any tips for minimizing the potential issues?
4 - Other comments and tips welcome.

My database crashed and is asking that I repair it.  I cannot repair it
because it thinks I and another person are in when we are not.  The ibd file
show us in it.  I have copied the db so all is ok.  Now I want to delete the
old one but cannot because of this issue.  How do I ...

I'm working on creating a database that pulls data from three fields
and concatenates the results into a fourth.
http://s22.quicksharing.com/v/5121074/ScreenShot002.png.html
I'm almost there, I suspect, but the first field from which I pull has

I have a problem which, I hope someone can help me.
I have a table that have the following fields:
ID
Date

I have two training tables. Is there a way to post information from one
textbox to the same field on both tables.
ei employee number on form would like it to go to both tables as this links
both of these tables to the employees table.

I am trying to do this:
SELECT * FROM MySybaseLinkedTable WHERE dtDateTimeField >
(SELECT MAX(dtDateTimeField) FROM MyAccessTable)
When I run this query without the subselect and manually put the date

I hope that someone can help me with the following problem.
I would like to have an access report with a date parameter that
allows me to retrieve data from an access table. I've tried to add the
following date parameter in a query "Between [type beginning date] And

How can I delete one record whichs shows #error on fields.  I get stuck in an
invalid argument when I try to enter the field to delete it.  I click on OK
for invalid argument and it keeps coming back several times.

I created a spreadsheet with checkboxes (controls) on it for reporting
purposes.  I now need to import the data contained on the spreadsheets
into Access.  The data is not laid out in neat columns or rows, it was
formated to be a stand alone report originally.  My problem is not in

Whatever I do, I cannot pull a calculated field from a query into a form or
report without getting a #Name? error.
I did the simplest of tests: created Table1 with fields Field1 and Field2,
with format Number, Long Integer.