Recent content by June7

I tried displaying a columnar report on a form and it did not work. Loses columns and displays only one record at a time - I can navigate through records. I tried both down-across and across-down. AFAIK, columns display only in PrintPreview and report embedded on form is displayed in Report...

Duane, did you mean "should not be too"? Mad, why are there dozens of tables like this? Are their field names the same?

If you are building query in Access, only way I know to use SQL to unpivot fields is with UNION or UNION ALL (limit of 50 SELECT lines). And as for dynamically building query, that would need VBA looping through fields.

More about international dates http://allenbrowne.com/ser-36.html

Please post code between CODE tags to retain indentation and readability. Mostly whatever you do in Excel could be replicated in Access. Why would you need Recalc? Don't think I've ever seen this used. Image of subform is not, it is image of query design view. Cannot reference listbox control...

How do you expect us to test without data for bound forms? No tables were included. Also, compile error due to undeclared variable oDB.

Arnel, am guessing inclusion of word "and" with each expression was typo.

Why would record not show if field is Null?

What indicates a record is not a Revision? =Count(IIf(fieldname = "Original", 1, Null)) Or =Sum(IIf(fieldname = "Original", 1, 0))

I don't see "Recent Posts" either, there is a "New Posts". No delay for me.

Just to nitpick, you are already learning SQL. SQL is a language and Access uses it to build queries. When you use query designer to create a query, it generates SQL. Switch to SQL view to see the statement. SQLServer is a database application. And yes, there is a bit of a learning curve but I...

Two offices in same org, same network? What does "100% similar" mean? If same table structure why not 1 BE and apply filters appropriate for user? Can even have multiple instances of a form open with different sets of data for side-by-side viewing. Controlling user options for data interaction...

Which doesn't explain why posted TEST db, even with code adjustment, still fails. However, as long as you have a working file, all is good.

That command was already in code for UsersReport. I added to other report. No change, still fails. Also, as I said, I tried C&R and that did not help. Something wrong with posted file.

File does not close properly at all when windows are hidden, not even when reports are not run. Why is file size so large for so little data and few objects (download was 18MB)? Zip file is still over 15MB. C&R didn't help. I've never seen any real benefit to hiding app window. Implementing...