Search results for query: *

Hi Everyone - Need just a little bit of help. I have a report that calculates totals(column totals and totals across the page). This report groups the line items by date. However, contain in some of the fields are negative values which shows up on my report as a double entry. for...

The following expression when run comes up with a message that says, "Data type Mismatch in Criteria expression". Why is this? >DateSerial(DatePart("y","Date")-5,DatePart("m","Date"),DatePart("d","Date"))

Please Help me on this one, I have a Query that I want to interrogate records that has a "Date" thats more than five years old. How do I code the criteria for selecting these records. I tried using the 'DateAdd' function, such as, ">DateAdd("m",60,Date())&quot...

I need some Help with this one, I have an Append Query that updates a History (access) table. But, when I run the append query I want to add a date that the record was appended to the History table. I want to perform this action in an (event procedure). How do I do this? I need some code...

Hi Everyone, My question is how do I use VBA coding to Link ODBC files when starting up a a MS Access Apllication?

Thanks Maguis. I take it that the Msgbox will follow right after the " end If " statement. True.

Hello Everyone, I have a form that I set up as a dialog form that has one unbound textbox use to receive a value. Once the value has been entered into the unbound textbox I than use a macro with the following commands that will allow me to open the form for the matching record...