Hi experts!
I have a subform, Sfrm_Current_Qtr_Data, with a checkbox control "Archive"
that when the Box is checked several things happen one of which is I want to
put the cursor back onto the main form, Frm_Tap_Accounts.

Dear Access People,
I am not sure if the Forms Coding is the right group in Access to ask this,
but here goes.  I have some forms where the background is a certain color.  I
would like to use a picture or something for the background instead of a

Does anyone know how to display only a single record on a report?  I
have the report linked to a table and Id rather not linked it to a
query.  Essentially, I want to display a list of records (which
represent projects in my case) and have the user choose the project

In Access 2003, we are importing Excel spreadsheets and are having a problem
with Access deciding that columns should be numbers rather than strings.
The spreadsheet is imported with the command
DoCmd.TransferSpreadsheet acImport, 0, "xImport", "d:\example.xls", True

Hey all,
i am developing a switch board and want some secuirty on this switch
board to certain options that are availble to users. For example some
options such as view customers,view stock are open to all users. But i

Where did the timer control go?
Has it been deprecated by MS Access 2003?
If so, tell me how I can mak a label blink on and off once per second?
thanks,

I know what is wrong with my code but I don't know how to fix it.  It's
better to explain what is wrong with it in an example than to try to explain
it.
If a user wants to see all the phone calls for Division1 with a priority of

Is my logic off?
I have a lot of data in a recordset and I want to go through and pull
certain rows is that possible? If so how? I really have no clue.
Thanks.

Im trying to allow it so users can search records using < and > for the
date fields.
The search form works fine with = values however when i enter < or >
followed by a date

So I put the data validation code in the before update event of the
form.
I have a button on the form to close the window.
I click the close button, the validation routine tells me I forgot

I use:
=DLookUp("COMMODITY","RATES","Rate_Check = [RATES.Rate_Code]")
in a form field the display textual data based on what is entered in a form
field.

I'm trying to get a message box to show when the user makes changes to
the phase combo box of my form. I put break points in the code and it
goes into it but nothing displays. I just want the box to pop up when
the other combo boxes are empty but it doesnt seem to be happening. Any

Hey All,
I have a problem which i need to solve, at the bottom of my forms there
is 'record features' such as view next record, previous record, go to
last record and add record. I was wondering is there a way of removing

I have a hyperlink field in a form.  The links map to documents on a
local drive.  When I attempt to open the doc via a link I get a MS
Access warning message about hyperlinks that I have to click through.
I want to hand off the database to a client.  Is there a way to disable

I have 4 dropdown boxes e.g. A,B,C,D in a form. If I choose certain value in
dropdown box A, then I want dropdown box B and C show nothing, I mean the old
values should be deleted. My question is that should I use the code like A=""
or I should set the value as Null? And how can ...