I would like to sort the underlying table so that when viewed it is in sorted
order. My code (below) is currently sorting a table and creating a new sorted
table. I really do not want to have 2 tables however. I tried using SELECT
... FROM Case1 ORDER BY random asc, but it does ...

I have a form attached to a query that runs a sql on each record
here is the code:
Private Sub Command2_Click()
Dim i As Integer

Can anyone tell me where I can get documentation on the sample database
Northwind.
I'm actually looking to see if it was designed to adjust the inventory when
an item is purchased. I was looking it over to use it but it doesn't seem to

I'm trying to loop through a recordset before any deletions are confirmed,
so that the records marked for deletion can be transfered to another table.
Unfortunately, cloning the recordset of the form doesn't help - once you've
chosen a record and hit delete, the record is removed ...

I utilize ODBC drivers to connect to an Oracle back end.
I need to check for the existance of a table in Oracle and if it exists, drop
the table and commit.
Anyone have any clues as to how to do this or where to look?

I'm looking for an idea here to see if I'm approaching this correct.  I have
a form that references a table.  Pretty much all the fields on the form are
found to the fields on the table so the user can adjust the values if needed.
I'm having issues with one unbound field on this ...

I wish to open a file within a macro of Access.  I want to be able to select
the file that is output to as the file to open.  I figured I could find a way
to set the MyValue as the output file, but I'm not as familiar with Access
code as I am with Excel, so Help would be ...

I've posted this before but did not get a response.  I've seen many posts on
how to get MAX and MIN range of an array of numbers but how do i get the MID
range. I have three values say 18,17,15. I can get MAX MIN but when I try to
get 17 it comes out 18.

I have a table that was imported from an iSeries that has
approximately 300 fields. I would like to create the descriptions for
each field by looking them up from another file that contains the
field name and description. I belive that I need to use

I am wondering if it is safe to copy a backend database from the frontend.
Currently I am just doing it with "application.compactrepair", so that the
backend file is copyed to a location and at the same time compacted and
repaired.

I have main form and subform.
From the main form I can open a new "problem card" and then return to main
form
The subform display all open "problems card".

Is there a buildin combobox with color pallet
so I can choose a color and it value save in a another field

i am trying to calculate the weight of an order, it goes something like this:
Weight = DSum("[ProductID]*[ProductOrderUnitQuantity]", "ProductOrder",
"[OrderID]=" & [ID])
but i dont want the sum to contain productID instead i want it to say

I have a form that users enter a person's name and title and I would like to
know if there is a way to have the field use a drop down list of past entries
(similiar to entering search terms in Google) and allow the user to click on
previous entry and use it instead of having to ...

I have a database that is split, one holds my tables while the other consists
of all my forms, modules etc. I create a new table once a month to hold that
month's data. I have to do this due to huge volume of data. Problem is that
my code isn't working and am not sure why? Can ...