Activity Stream

Do yourself a favor and DO NOT use spaces in object names. Object names include Field names, Table names, Query names, Form names and Report names....

The autonumber field is jumping numbers, so not consistent. So I created another field and use dmax function. I have used this function in the...

Not sure what this means. The autonumber field is not providing a unique number for each record? Please explain.....

Yes, Paul's solution is better. I tend to use "brute force" and use VBA to get things done. Glad you got it working.

Without seeing you db it is almost impossible to give you an answer for the question number 1. As for the second one just set the Default property of...

I looked at the link you suggested and most of my system is now working. Have a few other issues to address yet. Thanks for your help.

Thanks. I think you are picking up what I'm laying down here. I'm absorbing your advice, but just a quick response to one point: we don't do...

I've dabbled in a lot of PM and corrective data, both with fixed and variable frequency requirements and will say that for this, 11 date fields in a...

Thanks - but no, returning call error - I imagine the database owner is not allowing that. (caveat that's the first time I've created and run a...

Thanks for the suggestion and offer of providing code... but the form is unbound - only for entering criteria for the query. I am not displaying...

By the way, if it's slow you might consider a pass through query to the back end if that's an option.

Happy to help!

Thanks for the suggestion and offer of providing code... but the form is unbound - only for entering criteria for the query. I am not displaying...

Brilliant! - that worked I was calling via ODBC which made it very slow so needed to create a tmp table with all recs first and then extract from...

Brilliant! - that worked I was calling via ODBC which made it very slow so needed to create a tmp table with all recs first and then extract from...

Welcome to the forum. I would use the Me.Filter and Me.FilterOn properties to filter the form. Another method is to use VBA to create the WHERE...

Try something like: >=Nz(!!, #1/1/2000#) And <=Nz(!!, #12/31/2039#) Basically using dates that are before/after anything in your data.

I didn't think the code buiulder was causing the problem. Just the fact that I had quite a bit of code that I added. I am getting errors about 32...

I think you hit the nail on the head. The errors were showing 32 to 64 bit. I will check out the link and see if I have any more issues. Thanks...

@Joseppy, Welcome to the forum. I have to say I am confused as to why you think the Code Builder (aka Expression Builder) has anything to do with...

See this link by Jeff Conrad Kick Users Off -Detect Idle Time for ideas and/or This one from Microsoft

Not sure why you would need more than one hidden form whose timer event looks for the trigger? Some put a file in a folder and have the trigger form...

When you say "subreport" do you mean "subform"? Is name of subform/subreport container control? Post code from the button click event. Post...

Hi I would suggest that you do not use Dropbox for your Access databases.

Try without the .Text property. You can only use that if the control has focus. Plus you seem to be missing commas. The structure of an IIf() is:...