I am currently trying to advance the date within a query, the query at the
moment displays all letters sent that are more than 7days old. This is done
by using <=Date()-7 in the criteria box of the date the letter was issued.
The date im trying to get displayed is 7 days from when ...

I have 2 reports. I create a form that have two check boxes for those two reports. I want to make a command bottun that allow me to mark on check boxes and then print one of these reports. I need help with code. I do not know how to do. Any suggestion that would help me a lot

Can anyone point me in the right direction. Basically I have a
continuous form which retrieves many values from a table, and each of
the values is a number from 1 to 100. I also have two other fields
from the same table which essentially are for setting the min and max

I am new to Access and I am not even sure how to ask this question, but here goes...I have two tables.  One is a list of patient information and one is a list of class information.  I tried to make a relationship between the two based on classid (linking the patient with a ...

I have a Word template with several FormFields
(Checkboxes, and so on) that needs to be updated from my
access database?
I have managed to write some simple VB-code that opens up

Is there anyway of searching text, putting all of the like words
together, then giving you a count of the number of times that word
appears in Access?
Thanks, David

sorry for opening a new post but I need the answer
urgently.
How do I create a "Bound" combo box? I need the different
records to have a different value but now it is showing

I have a list of families grouped by their last name as
family units.  Sometimes the children will have an
different last name.  How do I tell a query that if the
child has a different last name to use that instead of the

I have an automatic number field and a last name field.  I
want to create a third field combination of the number
field and the first four letters of the last name.  It
would be used as an identification field.  I do it now

I just separated my database into a front end and back end.  What I didn't forsee was some of the code I use has the followin
dim dbs as dao.databas
set dbs = Currentd
Well, this doesn't work for somethings now that the tables are actually in my back end db.  Can someone tell me how ...

Hi. Ive just had a database corruption and I wonder if
anyone has any ideas on how to recover from this, rather
than revert to the last backup. I was in the process of
renaming a Form and I got a corruption message. It said I

I have just completed coding some forms and reports and now I have to put together some documentation that includes 'minumum PC requirements to run MS Access 2000' - having a hard time searching these information - does anyone know where I can find some info
Thank yo

I have a report which contains data from many different
tables.  I'm stuck on a portion where I have to show Prior
year-to-date numbers and YTD numbers.  My table has all of
the months separate, so for example, for this year I would

I want to send e-mails to a number of selected individuals
chosen by a query run in Access.  So far I have been able
to run the query and produced the Word document which is
sent as an attachment.  However, the message area of the

I keep getting a Runtime error 13 "type mismatch error" when I try to select
records with my combo box.   Here is the sql statement:
SELECT DISTINCTROW Contacts.UNIQUE_ID, Contacts.Company
FROM Contacts INNER JOIN Sales ON Contacts.UNIQUE_ID = Sales.Contact