I have a combobox , and when i click on the box i wan't to:
1) save a record
2) goto a new record
3) goto a CONTROL

When the On Click event executes the following code from a form with
Me![SignSel1] <> Cancel MS Access shuts down.  If I put a break point in the
code and step through it executes fine.
OS: Win2K for NT

  I am trying to execute the following code in MS Access 2000 (in a
separate module sheet).  When I attempt to run this code, nothing happens
(nor does this routine appear in the list of available macros to run).  If I
compile the modules (via "Debug", "Compile ..."), they seem ...

Can you provide code to make a list of the fields within a table?

This is a followup to my prior post about Access saving forms slowly. For
reasons unknown to me, Access hogs up to 98% of the processor for about 20
seconds when saving coplex forms - but only some of the time. It seems to
work that way for an hour or two, and then suddenly work ...

I have been tasked to begin developing dbs in XP and 2003. I have one user
who refuses to learn ADO and wants to develop only for 97 DAO. Besides the
obvious issues, will I have to always include a DAO reference to make sure
the XP 2003 dbs will work if I have to convert a db for ...

I found the KB article on the problems with using SendObject (Q260819) more
than once in a procedure in Access 2000. I used their replacement procedure,
& though I'm nowhere near clever enough to understand how the procedure
works, I did get it to operate successfully.  Then I ...

I have a piece of code to detect if the 'Live' or 'Development' version of a
database is opened.
When the dev. version is copied to the live folder, it detects this and
links to itself to the correct backend.

My PC has Office 2000/Outlook 2003 installed. I do a great deal of VBA
programming using Access and Excel. A good deal of these things aren't
distributed - I have the only copy and it runs on my PC.
I was looking at Microsoft Office Tools and I found the "Digital Certificate

I am getting the error, object variable/with block variable not set... I have
the oApp set.  I don't understand why I'm getting this error.  I have tried
setting oApp to the active document, and another variable.
   Dim strFlowChart As String

I have an unbound form and would like to load control values when a tab is
opened and save those values when user moves to another tab.
Here is my code so far:
Private Sub TabCtl0_Change()

I am having trouble inserting an OLE Object into a bound
object frame. I have a HelpSubTopics combo box dropdown
where column 3 is a bitmap image.
I want to place this image in the bound object frame of

Access 2002, SP3
Saving forms during development: for a while, Access will save the form
immediately (under a second), then during the next hour or two, it will take
over 20 seconds to save, then suddenly will be back to saving fast again for

I have an outline i want to collapse whenever cell AI is selected. Cell one
also needs to change between a '-' and '+' text depending on whether the
outline is collapsed or expanded.

I have a field that containes data such as H, M, or S.  Is there a way that I
can change the data to Numbers such as  H =1 ;  M=2;   S=3.   I have a
crosstab query that counts that field.   When I have a student that has an H
and  M it creates 2 lines of data.  If I change them ...