I am opening a report via VB code, using DoCmd.OpenReport.  It works great,
but it always opens the report behind several other forms that may be open at
the time.  I would like it to be opened in front of (on top of) everything
else that's open.  Are there any options like this ...

Does anyone know the syntax to access the current user logged in via VB code?
I can't seem to find a reference to it.  I know it should be really simple.
Thanks in advance!

I set up a Switchboard, using Access's Switchboard Manager.
It works fine.  
I was looking at the code & there is a field called "SwitchboardID" where I
guess Access assigns a number for each Switchboard in the program.  My

I want to be able to return a Capital X when the 4 key on the number pad is pressed.
What do I need to use? I've gotten confused with KeyDown, KeyUp, KeyPress, Key Code and KeyAscii.
Thank you.

Is there a way to show the Caption text and a picture on a command button?  
When I had the Caption text alone, the text showed fine.  Then when I added
a picture via the Picture property, all that shows is the picture.  The text
doesn't display anywhere.

I have a form that returns all fields associated with a user-input invoice
number.  
After update, a query is run to locate the data from one table associated
with the invoice number entered.  Then, a particular field from that query

Hi. sql skills not great.  Sometimes I'd like to let
Access generate the sql for me (for example, in the query
builder) and then use it in vb.  But of course it isn't
the same.  Can vb sql handle inner joins?  Can it handle

I'm trying to create a custom menu to assign to certain users.  According to
the help file I should go to the View/Toolbars/Customize menu item and then
click New.  The problem is when I have my database open, the Toolbars menu
item is not showing up at all on the View menu.  ...

I am trying to filter or limit the contents of one combo/list box based on
the selection from another combo/list box.  Both are on the same form and use
different rowsource types and row sources.
I have been trying to use the following procedure, but continue to get the

I'm working on a time log and have a form with three text boxes, and I want
to subtract my finish time from my start time and put this in a third box.  
The following code give me a 13 Type mismatch error.
Private Sub cmdStart_Click()

Hi there, I have spent some time now searching and have not found the answer. :(  Sorry if this is basic.  
I have a form that I have a control for a list box, which is pulling the report names from the mysysobjects table. SQL as follows:
SELECT msysObjects.Name
FROM msysObjects

on a survey entry form i want u to be able to enter in a entry with a
picture of a house to show. i can only find a way to get it so that when u
click on it the picture opens in a different window(default picture
viewer), i want it to be open, viewable on the form.

the service on this board is great for any ms access problems. i am a
20yr/o work student in college and i got a job where i have to make an
access database, its an 8-month workterm, i was having a lot of problems
until i came here. thanks guys.

Does anybody know how I could set reminders for calls/meetings etc. in Access
97? I think I could export stuff to Outlook to accomplish this but it seems
like too many steps. Wondering if maybe I could do the same thing within
Access using Visual Basic.

Oh  mighty gurus of Access:
I've got a problem.  For some reason, I have a database in which the code
underlying forms and modules will not break at breakpoints or for watchpoints
in the debugger.  Any clues what might have caused this, and how to recover???