MS Access VBA Questions and Answers

Recent IT Questions

1 - 3 of 3
<<PREVIOUS 1 NEXT>>

Temporary recordset in MS Access VBA

Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don't need to make...

View Answer   |  Feb 16 2009  6:40 PM GMT
MS Access 2003, MS Access VBA, ADO
asked by Darryn

  295 pts.

Access 2003 Form fields Sync

Hello, I am turning to you as a last resort :/ Here is the case, thought it looked simple to me at first... : I have a field which needs to be updated according to another field in a form according to the date in a table: Table contains [KEY, field1, field2] and the form uses to updated a...

View Answer   |  Feb 12 2009  3:01 PM GMT
MS Access VBA, Access 2003 forms, Access 2003
asked by Arielnavon

  15 pts.

rolling average VBA code MS Access

Hi All Anyone know how to create a VBA function and or SQL statement which will work in Access to find the rolling average as per example below + see excel file for working example in excel. Should work for a unknown amount of records. Not an easy one I think :-). If it can be done without using...

View Answer   |  Jan 21 2009  1:25 PM GMT
VBA, MS Access VBA, Microsoft Access
asked by Astakeil

  15 pts.

1 - 3 of 3
<<PREVIOUS 1 NEXT>>