Appreciate any advise and info as how to type a song lyrics with its notation
in numbers ?
Thanks you, and best regards,
n krisnanto

I have an account cancellations db (access 2002) for the company. I need to
have certain fields of the dB required (not left blank). However, these
fields should only be required to be filled in when a status field is changed
to "closed" from the drop down box. Status field has ...

Is there a way that you can merge 3 different table into 1 form?

I have a entry form that has a Combo list field named "Name_Lookup".
This field allows user to enter the last name of a person, which in turn, as
the user types the last name of the person, attempts to search a table of
people last names in search of a match, on match found, ...

Hi.  I'm a little freaked out- I just realized that all
of my dates are "backwards": 18/07/1999 rather than
07/18/1999 (July 18th).  Yes, I know.
Can you please show me what input mask I need to use to

Using Access 2000 and all of a sudden on of my apps won't run.  No mater
what form I click on I get the error "Error accessing file.  Network
connection may have been lost."
I have no Idea what file and there is no problem with the network.  I'm also

When I create an Option Group on a form, it seems I can only select a numeric
value in the Option Value which files to the table.  When I create reports I
do not want to see a numeric value, I would rather see something more
descriptive - Yes or No rather than a -1 or 2.

There are two radio buttons on this form. There is code to enable combo box
field when user selects one of the two radio buttons.
My question is this... I open the form and have code to enable the first
combo box [ToEmployee] but the radio button is not selected.  How can I get

I am trying to give an audible warning if a particular field is not empty
when an existing record is entered.  I've tried to use the BEEP command but
nothing happens.  The Critical Stop sound is working in Control Panel/Sounds
which I understand is the default sound for this ...

When I load my form it maximizes itself. I want the form to show at the same
size (small window that I designed). Thanks in advance

On my form you enter one row of infomation - ie
Date - "Employee Name" ( Selected from Combo Box ) Tool Received - Etc. When
you get to the end of the row it creates a new blank row under it. What I
would like is for the name that was selected in the combo box in the first

I have created a Access 2003 database that is used at several work stations
with monitors ranging from 15" to 21".  My forms appear fine on the 19" and
20", but on the smaller monitor some of them are off to the side or below the
switchboard, requiring scrolling to get to them.  ...

I have a form that holds the names of Doctors and their contact information.
This form pulls from a doctor table.
This form is embedded in a doctor visit form, of which I have an 'edit
doctor details' button. This button opens up the form 'doctors' and allows

I have three queries and I want to export them to Excel in one Excel
workbook or in seperate workbooks in a Excel file. I know the code to export
one query to Excel as follow:
DoCmd.OutputTo acQuery, "Qry_1", "MicrosoftExcelBiff8(*.xls)",

I have used the wizard to set up a combobox to finda a record on my form by
the name of the examinee we are testing.  I told it to use the lastname,
firstname, and middlename.  I then told it sort the records in ascending
order.  The box works fine when there is only one Baker, ...