Here's my code:
   Do While currentDate <= tempFinish
       strSQL = "UPDATE Forecast SET Forecast.totalValue = ""totalValue""
+" & dailyValue & " WHERE (((Forecast.calDate)=#" & Format(currentDate,

Given a startDate, and a finishDate, how can I:
a) Find out the number of days in each month between those dates. ie
28/09/06 to 02/11/06 would have 3 days in September, 31 in October, and 2 in
November.

Need to find a way to replace a blank field with characters.
Any field that has 'no data' to contain 'UK'
Had a question about this here a while ago but it has been deleted...
Thanks

I have an ms access table with some 400 records. Ms access aborts when I open
this table in datasheet mode. Opening the table woth a form works fine albeit
slow.
The same database and table perform fine on the laptop of a fellow worker.

Hello I have form in him are fed friends with specifications of people and
birthdate I want that in their birthday of the date will color red or will
jump me sign Thank you

I have another probably simple question.
I need to check to see if a connection to a network drive exsists before I
execute some code.  If the drive does not exsist, I need to terminate the
proceedure, with a simple msgbox.

In Access, I use several Excel file which are linked to my Database. In a
macro, I have to make sure that these Excel files are closed before running
it.
How do I check some Excel files are closed and stop the macro if opened ?

I have a form with a treeview control. I'd like, if possible, to use the
arrow keys to navigate through the nodes.
Is this possible ?
Thanks.

On a pop-up form I have a combo box whose choice needs to be compared to the
information in the field of the LAST record in the subform for the CURRENT
record in the main form (make sense?)
Generically, what would my IF...THEN statement look like?

Hi, is there a way to auto save and close an excel spreadsheet if it
has been inactive or has not been keypressed for one hour. Thank you.

hi...i have a problem..if i have build a relationship for different
table,can i view it as a form so that i can see the result for the two
table in one form only...is there any solution for that?can anyone help
me..

is there a method to export Access reports to a RTF file just bei
calling functions by ole automation.
The DoCmd.TransferText does only work for tables and queries (except I
did something wrong) and using the CommandBars doesn't work because

Hi All--
I have a form that pulls from a table.  I want to have several system
variables that the user can change such as a desired path, client filter,
name filter, etc.

I am wondering how I differentiate between two input boxes in the same event.
 I have one input box fire, the user enters the string which populates
correctly into the table the form is using as a source.  Then I want another
input box to fire and populate a different field.  Is ...

In Access 2000, I use the MSysObjects table to find, modify and refresh
connections to ODBC tables.
Where is MSysObjects in Access 2007?