I hv this tbl structure that i key in thru form
No  Recdate      Amt
1    02-04-08     500.00
2    02-04-08     500.00

In my Form there is a commandkey to merge to the All records and below is
the VBA, my question is how can we make it like a combo box to chose the
year, because the user is not a programmer, and is not able to open it in
design view and change the VBA.

VBA Userforms that work in Excel or Word 2003 cause problems in Access 2003
when the file format is 2002/2003 but not 2000. VBA code line "Load
UserFormName" cause Run Time error 75. Sometimes also Run time error 57:
Device I/O error.

I have created an input form for new records from our main production form.
The main form does not refresh after the new record is added.
I have to exit and reopen to see the new record.
Where can I pout a Refresh command to show the new record immediately?

I jus don't know where to start on this one.
I'm relatively new to this, i'll explain as clearly as i can.
What i'm trying to achieve is on my form i want to calculate a current
payout figure based on the current date. I can do this in an Excel

This is my VBA to merge to all " chruch officers " for the year 2008.
Our database could be exists of many years. How can we use the benefit of
merge all but for selected year:
Thi is my VBA:

I have a form which has an embedded picture as a background.  I would like to
print this form but without the picture.  The only way I can do this is by a
- removing the picture before printing; or b – creating a report for the same
data.  Is there a straightforward way a form ...

I have created a input form based on a query, in Access 2007, that displays
all fields in the Design View but displays only a blank screen with a header
and footer in Form View. Not even the labels are displayed, just the light
blue background. I have tried everything I know how ...

I am working with an adp with a SQL Server backend.
I have a bound form that contains the id in the form header. The
detail section contains several fields. This form saves a new record
just fine. The problem is that when I try open the form for an

Hi
I hope someone can tell me how to do this.  I have an append query that runs
when I open a form.  While working with the full version of Access (ver 2002)
I have turned off the warnings for action queries - but when I create the mde

I have a form that is not giving me the arrow and asterisk to add new
records. It has the arrow to go to the first record and the last record. All
the tables have the arrow and asterisk at the bottom. I have set allow
deletions, additions, and edits on the form. What could be up? ...

Is there a way to hide certain characters in a text box similar to
password?
For instance, I have a field with the social security number, but I
don't want the whole number visible.  Is there a way to hide all but

I want users to be able to click a command button on a form and that takes
them to another form (I got that part written) where they can add a record to
the second form. That record is then stored in the underlying table of the
first form. Thanks so much!!!

I would like to generate a PO number using the following
month/day/#### so it appears as, using todays date for example:
0508-0001
Is this possible for a Form?

I have a combo box which allows the user to select an employee. The employee
and his record are then displayed using a main form and a subform.
The problem is that I also allow the user to scroll through the employee
record using the record selectors. So the record might be on Jane ...