I have an unbound forms that have some fieds. When the user has the cursor in
a particular field, and he press F2 (or any other function key), another form
is displayed so the user can enter some values  and when pressing ok, the
initial field is filled with the appropriate value ...

I have a list box in a form. It's a list of courses. I want the user to
select a course from the list, click on a command button, and open the roster
form for the corresponding course. So far so good-- I can do that.
But if the roster has not yet been started for the course, I ...

I am trying to create an auto id that is similar to this:
B = Random Letter
20051103 = Year, Month, Day
1T4SZ = Random Letters and Numbers

I have 5 tabs one for each credit card. on each tab is a subform that is
suppose to show the redcords for that  credit card.  the subform is a
contiuous form.
I did get the first form to work, but unable to get the rest to show the

Using Microsoft Access 2002 (10.2627.2625)
Windows XP Pro SP1
I am writing a VB6 app to insert records into my Access database, based on
one of my forms. Upon clicking on the "Send" button in my app I have the

I am getting a non-specified runtime error on Access 2003 runtime only (can't
duplicate on my development station) under this circumstance:
In my Form_Current, I call a sub that enables/disables certain controls
based on contents of other controls. Some of the controls that I

If I have a database of various scripts.  Is there a way that I can launch
the Script contained in the "Script" textbox using the On_click event of a
run button?
Thank you,

Greetings All,
I am having a problem with my Connection string and I am fresh out of ideas.
I have a front end and back end database.  My tables are linked in the front
end but when I execute my connection I get the following error:

 I have a database on our network drive and there are about 30 users who
have access to it.  I have it broken into front-end and back-end databases
but I am noticing some significant performance issues.  The back-end is
linked to one ODBC Sybase table that is getting close to ...

Using Microsoft Access 2002 (10.2627.2625)
Windows XP Pro SP1
I have a form called frmCustomerDetail. On this form I have included the
Primary Key for the base table, CUSTOMERID, in a hidden TextBox:

I have the function
Public Function GetXMLfromCommandText( _
     ConnectionString As String, _
     CommandText As String) As Stream

I use the SYSCMD progress meter. It works just fine, except it lingers after
the sub has finished. Do I need to deallocate it or turn it off in some way?
How?

OK, I am a Access Rookie trying to teach myself Access using VBA.  
Undoubtedly, this has led me to DAO and ADO.  A light has not quite gone off
yet and I can seem to figure this out on my own. Any help would be greatly
appreciated...

From Excel, I can hide a single column even if it crosses merged cells,
without hiding all of the cells included in the merged set of cells.  If I
hide the column with a macro, all of the columns in the merged set of cells
are hidden.  How can I get the single column to be hidden ...

while executing my code I want to make waiting less boring by indication
progress with a progress bar.
My code does different things: getting values, putting into labels,
visualising labels. It is many code to run through so it takes a while. What