recordsets

  • Thread starter Thread starter Basil
  • Start date Start date
B

Basil

Hi,

I have a table ([Date of Update]) with 1 row and 1 column
([Date of Update]) in it (i.e. all it holds is 1 date).

I want to reference this in VBA to create functions from
it - eg Reporting month start date, financial year start
date etc.

To reference such created dates in queries would they have
to be functions, or is there a way of referencing stored
variabes?

Could you help me with the code to reference the date in
the table, I assume it will require openrecordset stuff?

I just don't get the different 'type' objects
(opendynamic / opendynaset etc)... could you explain which
(if) I need and why please?

Thank you so much for any help,

Basil
 
Thanks John... spot on. Silly me.
-----Original Message-----
try

=Dlookup ("Date of Update", "Date of Update")


Hi,

I have a table ([Date of Update]) with 1 row and 1 column
([Date of Update]) in it (i.e. all it holds is 1 date).

I want to reference this in VBA to create functions from
it - eg Reporting month start date, financial year start
date etc.

To reference such created dates in queries would they have
to be functions, or is there a way of referencing stored
variabes?

Could you help me with the code to reference the date in
the table, I assume it will require openrecordset stuff?

I just don't get the different 'type' objects
(opendynamic / opendynaset etc)... could you explain which
(if) I need and why please?

Thank you so much for any help,

Basil
Click to expand...


.
Click to expand...
 
Back
Top