Activity Stream

Okay, I get most of all that. I guess I'm just used to having "things" having a location to exist, whether used or not. So, isn't there a proactive...

Thank you. I created another query that references the original query and it seems to work!

Your report should be based on a query that does the filtering (I presume you've used a table). If you cannot, you would have to filter the report.

I don't think you can do what you're trying to do since at run time, an expression needs to be evaluated in order to feed another one, and the query...

duplicate post

Yes, I had completely forgotten the syntax of the "Call" and used the wrong syntax to call the function. Public Function xfrMoveDon(dummy As...

Sorry I wasn't clear. It happens when I run the query from design view.

if the function is in the master form (no subforms) then form not needed: Forms!frmDonFamEntry.MoveDon (0) if its in a sub form of the...

Didn't you try this a few months back? This one was the one I was thinking of?...

AFAIK it's because exp_Gross Sales isn't known until the query runs. I'd try either just entering a value or just hit OK rather than Cancel (that's...

wouldn't it make more sense to just return a null for the propertyI do not see how you test anything about a property (such as null) if it doesn't...

Logic is simple - properties don’t exist until they are created. Just like a table or query or module or report or macro or any other object. Just...

I got to thinking. (Oh, there he goes again--I can just see the haters coming) If description is an option when creating table field properties,...

The idea is to fix things in the description, so if it doesn't exist, just if around the field.

There is an issue with the normalization. These dates are very important and are used on a form and often filtered on the so I have a table that...

Okay thanks! So, it looks like I can write a generalized function for properties (by replacing "Description" with another passed argument), and...

The video of my Optimising Queries & the JET Show Plan presentation on 7 Sept is now available on YouTube:...

If the field property doesn't exist you want to create it so you can set its value, yes? Then you need an error trap that traps that error and...

Use a function to test for the property. If false you can then create the property in the else argument. If chkPrp(tdf.Name, fld.Name) = True...

A scanner is just another input source. Look at the similar threads at the bottom of this one. The links look promising.?

I approved your post. Have you searched generally for any info on finger print reader with MS Access? Have you contacted the manufacturer for...

That's because they are the field names, hence the un-normalised structure. If the OP changes it to the example I posted, he can a) Add a dozen...

Would it not be easier to set them in Options, even dummy entries, then they would exist when they needed to be changed?

No. My simple thoughts were that most documentation can be done online, even if it is needed to be scanned in. I myself am right now entering...

When I started there was no internet, what we had were business groups who typically met for breakfast and talk about what they did and/or what they...