I would like to use the sytem record or rec count or recno, something like
that in the forms.  
1.  Is there such a thing in Access?
2.  Is there a GOTO (to send to a specific record in the table and refresh

My boss wants to run a report using the calendar control, as it takes him
too long to type the numbers in to a paramter prompt for the query.
I have designed a form which has two fields
Startdate

Hey - I have not learned the vba method of using access - do it all the easy
way thru the wizards and tables.  So I don't know how to ask my question.  
But, here it is.  I keep the stats for a NASCAR fantasy league and I wrote a
little program to help me with it.  I created a ...

Hi;
Second time I'm asking this question, and hope someone can suggest a cure.
I'm running a form with a cbo box for data entry. I have 5 other BASICALLY
IDENTICAL cbo's on the form, all of which work fine.

I have created a form but once I enter the info I can't get the line to
continue down to add more records, it will just stay on the one record. I set
my property default view to continuous forms but it will only stay on the one
form and once I close out the form it doesn't save ...

I have created a form with a subform based on a query.  Everything
looks great on my screen but when I go to file- send as attachment and
use the default HTML format for the attachment the only thing that
show up in the HTML is the primary form data, nothing from the

I have a Form 'frmTest DLookup' that is used to input data into a table
'tblTest DLookup'.  The table was build with a lookup to the 'Contacts' table
to provide a drop-down of available contacts when completing the form.
The 'tblContacts' contains 'ContactName' and 'ContactEmail' ...

How can I set a pop-up form to only take one record?
I have a popup form (single form) to take some customer info however when if
they tab past the last field all the data disappears.
Anyway to prevent this?

Is there any way to create a input mask to put the hyphen's between each
group of 4 numbers in a credit card field?
The added difficulty is the while most CC's have 4 groups of 4 numbers, Am
Express has 4, 4, 4 and 3

Is there a way to alternate background colors for each row in Form view?

I feel I have a fairly simple form but I'm having a few issues.  I am
establishing a form which will allow for 2008 PnL and Volume projections.  
For each trader, I have current PnL and another box for a projected % rate
increase/decrease.  I then have a format that multiples the ...

Probably a very siMple, but for me very vexing, question:
I have a form that has a drop down box to select a value and datepicker to
pick a date.  The subform doesn't activate until I click on the white space
where it should be.  Then everything works fine, including the selection ...

Morning Everyone!
I need some advice on how to go about a database I am trying to design.
There are about 6 employees and each one has about 10 tasks they are
responsible for doing weekly and/or monthly. The two ways I thought about

New to coding...
I want to use a selection in a combo box (cboClassification) to
populate a text box (Con_Num_Class) on the same form.  The code I am
using is not working

My application works on Accessa 2000. Alla my data are in SQL server,
so there is an ODBC link between them.
I have a table which includes for instance names of countries.
Is it possible to creater some kind of trigger or something else to