New Access user requires help

[PHolmes]

I have created a database and I am now tying to extract one record at a time.

The record in question will be the last record entered every time. I have created a macro to go to the last record but when I try to extract only this record it fails and I end up with all records in my report.

Can anyone please help?

Paul.

 

[Jack Cowley]

I don't know how you determine which is the last record that you wrote but you can look at Top Value in Help to see how you can set it in a query to show one record.

 

[prycejones]

Try this...
(and before anybody makes any comments - we all have different ways of doing things - thank you microsoft!)

Function load()
Dim db1 As database
Set db1 = currentdb
Dim sqlstring As String
' the where clause here will speed up your record getting if it is a big table
sqlstring = "select * from [yourtablename] where [yourfieldname] = 'a_value';"
Dim rs As Recordset
Set rs = db1.OpenRecordset(sqlstring, dbOpenSnapshot)

If Not rs.EOF Then
rs.MoveLast
'your code goes here
End If

End Function

I havn't tried it but it should work.
Hope it helps
E & OE
(I never knew what E OE means but I saw it on the bottom of some document once and some one said it meant "Errors and Ommisions Accepted", however, you may notice that the Letters dont match the words so I am still puzzled)
What I mean to say is
SFAEJICIFIU
(Sorry For Any Errors Just In Case I F*****d It Up)

Pryce

 

[Pat Hartman]

Relational tables are not like sequential files. Records are not necessarily stored in physical sequence. When you open a recordset to read a table, the rows may not be presented in the order that you expect. You must use a query with an order by clause on a unique field or fields to have a predictable and reproducable order to the records.

If by "last" you mean the most recently entered record, you need to include a field with a date/time data type that is populated via the Now() function as each row is inserted. Then you can get the Max() value for this timestamp and that will be the most recently entered record.

prycejones,
"Errors and Ommisions Accepted" is more likely "Errors and Ommisions Excepted".

 

[dennis g]

If you have a macro that points to the last record, can't you "tell" the report to print the current record? If you have a key field, use code in a macro that executes the report with code like:[Id]=[Forms]![your_form]![ID]. Maybe not what you're looking for, but I use this alot.