I want to create a form as a calender month view
the same as in outlook
i have found this website having the same idea and it can explain my
idea

I'm working on an Access 2007 db, and we are unable to modify db
objects, as it says other users are logged in. There is no one logged
in, although the lock file shows 3-4 users. Any suggestions on
correcting this?

I have two tables. The PK from the parent table (Table 1) is a FK to
the child table (Table 2) with a one-to-many relationship.
On my form, I use a query to return some data to unbound fields from
the parent table for display purposes only. The other fields on the

I have report which I need to print 3 times, but would like to have
the following headings
Customer Copy - Print 1
Accounts Copy - Print 2

I am a true beginner in Access and coding.
I am creating a database with facility information and I want to use
the address of a specific facility to display a map on my form or at
least open a new window with the address already plugged into Google

The following code works well except I can't think of an elegant way
of checking for the existance of the named field prior to creating
it.  Suggestions?
Public Sub pNewField()

Have a textbox in a report footer that sums data using Sum. That text box
value is used in a few calculations in the footer.
Trouble is, if the report has no data then the box simply shows #error and
all following calculations fail. Nz doesn't work.

i have a table that has the two fileds:
Return Date, Extension Time for Return Date
i need a query to choose the max date between these two fields
eg: if return date       = 01 May 2008

I just converted a 2000 db to 2003 running on Vista. Went looking for the
ini file created when using WritePrivateProfileString and can't find it. Did
a complete file search and can't find it but the info is getting written
somewhere and I am able to read it.

Just have a small problem with boolean fields in a list box showing as 0
and -1, not Yes/No or True/False.
Is there any fix to this?

I have a table with four date fields, some of which may not be filled
in based on our data entry needs. I have a criteria set as <date()-180
which is supposed to pull dates older than 180 days ago. The problem
is that when I use that criteria for all four fields I am not getting

I have two date fields.
PaymentDate  - is set to default to today :  =Date()
MeetingDate - is going to find the next meeting date after the PaymentDate
So using April as an example:

I have a project which requires the batch import of customer contact
information, print mailing labels for those customers who have their
date of first letter field in the database set to null, and update the
date of first letter field with the date the mailing labels are

Sometimes it works and sometimes it crashes.
If I want "Today is " & Date$ & "." to appear
in a query field, why might it work sometimes
and not others?

Control name on form is "Kit #"
The afterupdate event that fires for this control calls the control
Kit__ as per following.
What is happening here?