I have a function courtesy of the newsgroup that clears the list box. I
would like to now set the listbox back to its initial state where you can
see the first item in the list. The same goes for a combo box I am not sure
after clearing how to get it back to show the first item.

Problem creating a recordset object from another recordset object.
1. create first object. rstTemp with 10 fields - no problem
2. create second object rstTemp2 with one field - no problem
3. Attempt to create a third object with the following suedo code

 I use Access 2000, after one program made to .MDE (excutal), bisides F11
key can pop database window, what are the other keys can do the same?
 I am trying to block those keys on the start up setup to unselect "Access
Special Keys" under Advanced option, will this be sufficient ...

I have two nightly scheduled jobs at a client site - one at 2:00am and the
other at 5:00am
Both jobs launch Access 2003, log into the default system workgroup, open a
[different] Access .mdb that collects data, then shuts down.

Is there some way to reposition the built-in Msgbox in Access2000 to a
position that's more appropriate for my needs?   It always appears
automatically in the center of my screen, yet my program runs in one corner
of the screen (big screen, high resolution) and I'd rather have it ...

I want to display via a drop down menu the "My Computer" component of a
computer system. I want to incorporate a backup function into an aplication
but want to be able to select from the drop down where to backup to. eg
C:Lo9cal drive, D: Cd Drive or E: Zip Drive.

I am having an issue with my ADP when i use the Package Wizard.  I
would like the program to have the funcionality to be able to change
data sources if need be "i.e. In access File>Connection..."  I have
tried to add a toolbar to the project with the Connection... button,

Got a table like this.
Name   ID    Location
Bob    1     Home
Frank  2     City

I'm doing a booklet for a class reunion.   Got all the data and everybody's life
history in a little MS Access app and now it's time to get the booklet ready to
go to the printer's.
I have a report that creates same, but rather than send it to a printer of PDF

I have a small application with 2 forms where the user logs into the system,
then the form recordsource randomly pulls up an account ID. The application
is basically an electronic tic sheet and reporting tool.  Once the user is
done they select a check box then system appends the ...

I use access 2002.  Is there an addition of Access2002 that allows you to
use your database on a computer that does not have access.  If so, is it
still available and what is the name of it, is it hard to learn?  I know
books on more advanced topics are usually hard to find.

Running AC97 under Win2k I have a large database, the front end is
about 32MB and contains literally hundreds of queries, form, modules
etc
Every so often while working on it, say, editing a form, or creating a

What would the proper way be to enter a sale, then be able to enter 1 or
more sales persons, their "costs" to the sale, and their commission on the
sale?
Then after its been entered, have all the information show up as a part of

First let me start out with what I want to happen with this and then
maybe y'all can give me some better insight.  I have a database in
Microsoft Access which we need to upsize to SQL.  We currently have a
problem with it now.  On one of our forms (frmScan, which is an unbound

A 'newbie' question - importing into Access from Excel. Googled the
group postings but I can't find the amswer
I have a 50 line three column file in Excel that contains Names and
Tel numbers. Each column is named to agree with the Access database.