In table I created a combo box.
In the Form I would like the user to be able to choose from the drop down
menu the values already there but also to be able to add a new value as and
when but also to be able to have that value available with the existing

anyone please help!
what must i do if i want to generate monthly report where the date is input
by user.for example if user want to view the april report, so he enter the
april word then all the activities on april has been view

I have just ugraded from Access 97 where I was pretty compfortable to 2003.
One thing I have noticed that seems to behave very differently, and gave me
quite a scare is that in access 97 I could begin work on a DB that was not
secured, work on it, If I needed to reopen it I could ...

I have been supplied with data with the address in one field separated
by commas:
POBox, Suburb, State, Postcode
I need to have each of the values in separate fields.

I'm missing something. Fairly new to Access and trying to build a selection
application. I'm presenting a list of customers in a continuous form
"ChooseCust". This list includes some information that would allow a user to
place a check in a checkbox if they want that customer on ...

I have posted a similar query to this and I have attempted to follow the
suggestions but I have had no luck.
Here's the situation: I have ONE table and a form based on it. Two of the
fields in this are called Region and Area. Region has a combo box containing

I have a global variable "xxxx" and want to reference its value in the
criteria of a query.  I was thinking of;
   Like '*' & [forms]![CloseItem].[xxxx].[value]
I also have a different variable "yyyy" and want to set its value to the

I have a form that calls a Popup form.  When I close the Popup and return to
the underlying form.  I would like to requery for that Underlying form.
How would I Requery (simply Me.Requery)?
And

Can i set a table field to gets its value from a public module variable in
access?

My first in a series of questions I guess... I was wondering what a
logical way to go about establishing a database would be. My database
that I have built right now tracks approximately 300 personnel and has
approximately 100 fields... Its tough using the documenter and

Pls send the formulae for expiry notification for a set of date entries

I have been lurking around numerous places and finally have decided to
come out of hiding. My name is Robert and I have been using access on
and off now for about 8 months. I am active duty military and while I am
not a programmer by trade, I have recently taken on a data ...

I want to know if I have created/developed an access application in Access
2000 and 2003 what kind of runtime program that suitable for the pc that
running on win 98 to view my application.
Actually i want distribute the application to school and most of the school

 I am entering a value, in a form, that will mainly be currency, however on
occasions it could be a percent or a fixed number.
Being stored as currency, percentage or fixed is not important as long as
the display of the number is in the correct format. I was hoping to do this

Hi everyone, hope you are well :)
I have the following code for my command button, but when I click the "OK"
button, an error comes up with the following
Run time error 2447