Activity Stream

Is that good or bad :confused:?

Maybe check out Allen Browne's Return to the same record next time form is opened ? Vlad's code is a lot like Allen's........:rolleyes:

Sorry but I disagree, having code in the unload event of the form that saves that unique ID in a local settings tables would also work (and the local...

Your database is a Web database. Web databases were introduced with Access 2010 with the intent of allowing Access databases to be published on-line,...

Only way to know the answer to that with what you've done is to test it?

Thanks for all the suggestions. I've implemented the most agreed-upon method with a few changes. Instead of using static variables, I created a...

Michael, I am returning your zip file. In addition to the database you sent to me, included is the copy I used to create and populate the Table...

again, that can only be done with an update time stamp. this works to do that, based on having a date field that stores the UpdateDate, which...

I took that the OP wants to navigate to other records after opening the form, not necessarily in one direction (next) but also previous; my method...

No, that was my first thought, then I thought, why not just filter to that record and anything after that? That would use the method the O/P is...

But you still have to remove the filter manually, don't you? And you propose adding a button as well. With what I suggested the form would...

Well I tested my method before offering it, and that worked just as well, without any other commands? Or am I missing something here? :(

Yes, when you open the form using the Where clause of the Docmd.OpenForm method it opens the form filtered to that record. But that was not what the...

Well the link would not download, but copying it and using that, I managed to download, but my version is too old to open it.

O/P was already doing that?, but just filtering to that record, or at least that is my understanding?

Sometimes you just can't fix what you're handed. Sometimes it's not worth the time and effort to fix a design mistake if it's not causing problems....

@Welshgasman, Somehow I did manage to download it and it does work. When openend, you'll get a save window and it will create your own DB. I...

In the Unload event of the f_Aircraft form write the current Serial in a local tblSettings table. In the Load event of the same form add something...

Personally I wouldn't compound the problem. It already caught you once. I'd spend some time searching and replacing with proper field names.

You probably need some kind of history system to record your activities, and a way for you to "tell" the form to "remember" a particular activity. ...

When you open a form like that, all you have done is filter to that record. If you remove the filter, you will get all records, but again start at...

The only way you can pinpoint the record you worked on last is to date/time stamp it because by that definition, it could be anywhere between record...

sorry, i can't do that. Consider in first that the "id" field is not unique (i'll add a one later) and it a unique code for the person, so i can join...

there is a working example provided on post #8 of the cross post ...

think this is a web database which was deprecated years ago. Most of the objects have the 'web' icon You can edit those objects that don't...

aside from the other comments your sql shows a count so it is an aggregate query, but you are not grouping on anything.

... and make sure the problem isn't in the query you're calling with that sql.

You also need to remove the comma after TotalItems and add a space at the end of line 2. In my opinion its better to put the spaces at the start of a...

You cannot have = and Like ? :( Stop changing the SQL until you get it working, else you are going to be all over the place. :( Small steps, small...