Wondering if it is possible to have a number of tabs that, when starting a
new record from within the tab - have a field contained in a common table
populated with the appropriate text corresponding to the tab.  
As an example, say you have 3 tabs; Application, Renewal and ...

I am new to any programming and I have not been able to figure out how to
work with it yet so I am hoping that somebody can step me through this
process.
I would like a button on my switchboard to run code. I have a query that I

Hi, here is code i'm using on the On Load event of my subform:
Private Sub Form_Load()
   If CurrentProject.AllForms("frmClientBuildings").IsLoaded Or Parent.Name
= "frmWorkOrders" Then

How do you write code to skip past a few fields if someone selects a certain
response to a field (combo box). For example, if [Mechanism] <> 1 then I want
the form to skip to the field, [Intent]. I am guessing the code will include
the SetFocus statement? Yet I am not sure how to ...

I am attempting to hide and make visible a Tab/Page based upon a value from a
combo box on the main form.
This is what I’m working with:
Main form:  Single page

I added a command button to my main form that would allow the user to add a
new record. However, when I click on it I get an error message saying, 'You
can't go to specified record.' Here is my code:
Private Sub AddRec_Click()

I serach Access Monster for a similar issue but i came up with nothing.  I
appreciate if someone share a code to transfer the current record from an
access database form to an excel sheet.  In other words, when I open the form
and do a search for x record, I would like to transfer X ...

I running in to the following problem, which I seem not to be able to solve,
any help is appriciated.
A single form, with navigation and selection buttons turned off. A simple
record sourse with 2 text fields f_1 and f_2. I have only on data field

Using Access 2002 I need to be able to identify the 2nd and word in a text
string so that they can be shown seperately on the form.
Does anyone have some examples to achieve this please.
TIA

Any one know the correct syntax for "Windows Userprofile" ??? Im using
terminal server and each user needs there own directory for this word
template.
Here is what I have that works without thier own directory.

Hai,to every one
here is my question
I have designed the coding to collect the feedback report from the user,
which includes Name of the user, staffno and comments.But when I click on

I have a form with a subform on it.  I select the parent field in the form
and fill the subform with records. When I move to the next value in the
parent field in the form, the respective subform values apear blank. What I
want is that the subform appear populated with the ...

I'm trying to delete a record from a form that has a Listbox populated by
the same tbl as the form. In the OnClick of a delete button I have the
following code:
Public Function DelRecord()

In my database, I would like to make the things easier for the user to
edit row items. My target is to enable user to focus on required
invoice items quickly. The table is called "Tbl_Invoice" which is
related to other tables where all relationships are enforced for

I am self-employed and am trying to track compensation for projects.  I have
been using Excel but decided to change to Access for the capability of
pulling queries and running reports.
My dilemma is two-fold.  First, in creating my table my pay ie for one