Activity Stream

The video of Thomas Moller's excellent presentation to Access Europe is now available on YouTube: https://www.youtube.com/watch?v=GlmWWmgSQo8 The...

it's almost certainly your use of a double - the auto setting affects what you see, not the underlying value. Leave the format property blank, see...

Hi all, thanks for being patient with me. The pictures below show the settings I used. I may be misunderstanding something from the earlier replies....

Thanks. I used OnCUrrent instead, it worked!

Worked first time. Thank you.

I think can CopyObject TO a database but not pull from. Use Docmd.TransferDatabase instead?

Forgot one line within the With statement: With olTeamContact ... .FileAs = .FirstName & " " & .LastName ... End With With olMemberContact...

Requires a unique record identifier field. If not already in table, add an autonumber field as the RepPK field in the example. Use whatever name you...

At last, after some time of experimenting, I could finally solve the problem. :D I found the following link from forum member June7 that helped me a...

See if you can make post 2 here work for you https://www.access-programmers.co.uk/forums/threads/running-count-over-a-group-in-query.274257/

Yes, that sounds about right for most IT depts I have known. :(

I created a macro (not a procedure) that I can run and open a form filtered to what the active record is in another form. The main form is a...

Well without *some* code to tell Access which record you want, I think you are out of luck.? Even if possible in some way, it will cripple the ease...

I’m well aware you can’t go that route but there is very little support for access macros on line. if you weren’t so dismissive you would find...

You don't provide the name of the field, you provide the value of it in the current record. Don't think you can do this from the ribbon unless you...

let me give you some background... The Table is called "Contacts" that feeds a Form called "Contact Details". I work off of Contact Details and...

That makes a lot of sense... You are correct, the database has a "ID". When I open the dialog popup and view FORM properties under the Data tab,...

Yes, I mean VBA.. not permitted to use it as the commands have been disabled. Thank you for your time

Can't go that route, VBA isn't permitted by employer. Thanks for the attempt

I would also consider a split form or an emulated split form.

If you are forced to use macros, your choices are limited. Google ‘access openform’ one of the parameters is where. Populate it with something like ...

The record in the main form has a unique field (maybe autonumber id)? Then if you open the dialog, filter its records to match the id value. That...

Update. If I set the Order By property of the main form to 'Name' and do the same for the sub form, then it works. Thanks for the replies, guys!

Ding, Ding, Ding! Cranial Light Bulb Illumination Alert! Ah, the offset parameter is the number of the record and not the PK of the record! And...

You might consider a split form which automatically deals with a single table in the manner that you described.

When you say 'macros' do you mean VBA or actual macros? Macros are different in Access. Not sure how you could without some code?

Why not look at the syntax of the command? :( https://learn.microsoft.com/en-us/office/vba/api/access.docmd.gotorecord Can you now see the...