Activity Stream

This form will do what you ask, but how you would integrate it with your DB is perhaps problematic. If you upload a copy of your DB it would be...

What do you mean by 'updates the table' - new record is created? If you want to provide db for analysis, follow instructions at bottom of my post.

Some deep hidden table?

Let me start again with a different scenario. I have a form that is used to collect the items requested. Every time the Collected button is pressed a...

Let me start again with a different scenario. I have a form that is used to collect the items requested. Every time the Collected button is pressed a...

You're welcome. Its always seemed illogical to me that no lock file is created when opened exclusively. How does Access know the file is already...

This is illustrating something different, but note how the recordset is opened using SQL with criteria: http://www.baldyweb.com/ImmediateWindow.htm

You want to let the server do the filtering rather than Access, when you can. I don't use ADO much, but I'd open the recordset on an SQL statement...

All these years and I never knew that. I just copied that line from somewhere without investigating it. Thanks.

In een query SELECT uurloon, , , *+IIf(,25,0) AS bedrag FROM JouwTabel; Overigens kan je beter geen spaties en speciale tekens (zoals >)...

ROFL :rolleyes:

And for our mainly English speaking members: I am a beginner with the Access Database and try to invent everything myself as much as possible but...

Oh God, do they never stop talking about the war and the Germans. You seem all to be John Cleese. https://www.youtube.com/watch?v=yfl6Lu3xQW0

No we did it over here just before DD. There was a program on this week about a Polish double agent that sent false information to the Germans about...

Seems a lot of trouble and time. In the times I still developed Access solutions I never used the internal tables but relied on a database that...

Tested your code. Works. Removing the switch does allow the laccdb.

A lock file isn't created when an ACCDB is opened exclusively. Change the default open settings for that database by removing the /excl switch in...

Or something like SELECT TOP 1 addr.* FROM Addresses addr WHERE addr.PersonID = PersonIdValue ORDER BY DateFrom DESC

Hi, Done Thank you

Try: SELECT Addresses.* FROM Addresses WHERE DateFrom = (SELECT Max(DateFrom) FROM Addresses AS Dupe WHERE Dupe.PersonID = Addresses.PersonID); ...

Here are the pertinent parts: Dim sh Const AktivniSlozka = "C:\Users\danespe\Desktop\LichTest\" Set sh = CreateObject("wscript.shell") sh.Run...

Thanks for your valuable advice. Will update if it works.

Thanks for your advice. Will try it.

What is the code to open db? I tested programmatically opening db with FollowHyperlink and laccdb is created.

Glad I could help, and thanks for the star!

Thanks davegri! You are totally right about it being a matter of opinion! I'm still surprised by the amount of talented people here and that there...