Need a Data Last Updated Box

[DaveMac]

This should be simple but as usual since I have never done it it is not:

Need a control on a switchboard like form that says Date Last Updated. This will tell the users the last time the master data was pulled down from the master data server. I created a query that does a top 1 and get the date/time we last downloaded.

Any suggestions?

 

[PHV]

Have you tried to use the DLookUp function ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DaveMac]

I did but no success. Might be another syntax issue

Table tbl-fg-items

Field datemodified

Help with syntax?

 

[PHV]

I created a query that does a top 1 and get the date/time we last downloaded
Use that query instead of the table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DaveMac]

How would I reference the query in the control?

sorry don't use very many of these

 

[DaveMac]

I just tried this and it just leaves the field blank


Private Sub Last_Update_Date_BeforeUpdate(Cancel As Integer)
Me.BeforeUpdate = DLookup("[UpdateDate]", "tbl_FGs_with_Family", "[PRDNO]='10084192'")
End Sub

 

[PHV]

Do you know what a ControlSource property is ?

 

[DaveMac]

Yes I tried to put my dlokup in there and it errored out as ?Name

 

[dhookom]

What exactly did you try put into the control source? Did you use:
[TT]
=DLookup("[UpdateDate]", "tbl_FGs_with_Family", "[PRDNO]='10084192'")
[/TT]
You mentioned earlier:

Table tbl-fg-items
Field datemodified

You also mentioned a query but haven't given a query looking name?

Duane
Hook'D on Access
MS Access MVP

 

[DaveMac]

so I am good with using the query. How would I syntax the control source on the form to take the top 1 (there is only 1 record anyways) of the query. I tried this a while ago and got

=[qry_update_date]![FirstOfUpdateDate]

#Name

 

[PHV]

=DlookUp("FirstOfUpdateDate","qry_update_date"=

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

=DlookUp("FirstOfUpdateDate","qry_update_date")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DaveMac]

Thanks again PHV I have had to pick this DB back up and update a few things and I am very rusty. I moved over to the Barcode and SAP team so not as hands on anymore.

Thanks again!

I am all good now