Activity Stream

curious as to how you made that work. Did you write it so that it would work on "" and Null, or just ""?

Thank you for your response. Will try this also. Regards Gene

Micron: Bingo..thanks a mil. The file comes from another database which I pull down into excel and then into access to run a query. Did not realize...

Presuming each Doc will have no more than 3 records and only 1 of the 3 amount fields of each record has numeric data, an aggregate query should...

Your data isn't the same as what you posted and I used? Doc Commit Obligation Expense 10WRMPP12

You left off all the aliases. You replaced hikerdood_1 etc. with the name of a table, not hikerdood. More like FY102275_1 etc. I can tell you that...

The db opens and you get no messages and no messages when attempting to do anything? There's no banner at the top telling you code has been...

First thought that comes to mind is to make sure the new location is listed in Trusted Locations, or that you at least enable code to run via the...

You have PDFs embedded in Access table? Embedded files use up Access 2GB size limit. Advise to leave files in external folder location. PDFs can...

I'm not answering because I think I'm smarter :) Where is/was "me.fields"? You cannot use Me in query design - only on code behind a form and even...

With VBA code that changes the RowSource after each character. For ideas, review http://allenbrowne.com/ser-32.html and...

Thank you, very much appreciated!

To get the desired join results, do this in query design view: Then:

Pretty sure not; and a best practice is to index fields that you search on; don't set the index property to true on an autonumber field when it's not...

I expect will need to create a VBA function. Provide sample data and describe desired output.

AFAIK, a field is not indexed unless it is designated as primary key or set for indexing in table design.

Is the text in a standardized structure - is the post code always following some text that can be counted on to be present and/or info separated by a...

Maybe it's not ideal, but sometime when importing from other systems you have to deal with junk that doesn't fit your carefully crafted Access...

Your table structure is not normalized. Each number drawn should be in its own record. Then a simple aggregate query (not a crosstab) should provide...

Would you mind giving some advice on setting up a query? I'm losing data as though an Inner Join is being performed, ie I'm only showing fields that...

There is no single field that provides a unique identifier? There are dependent tables? Provide a sample of data. If you want to provide db for...

A MsgBox can display whatever text you want in the prompt. But the response choices must be from a defined set and cannot be customized. Prompt...

Solved my own problem. For the benefit of future searchers here are my notes: I overlooked the fields in my new query that were giving me that...

Do you have the MSI or C2R version of A2013? The MSI fix is now available. If you have C2R, you have to wait another few days for the fix