Activity Stream

according to AB it is a reserved word http://www.allenbrowne.com/AppIssueBadWord.html#T Did you try stepping through the code to identify what...

agreed. and i should have. and where i can... (100% self taught here, so...'where i can cautiously'), i try to ...unfortunately, i jumped the...

So please explain how you resolved it. This site like others is here to help people, which is why you came here? So try and give back? It might help...

works for me... thnx !

'type' Is a reserved word, but surprisingly... 'tag' is not. (Which works out well for me since 'tag' in the term used as an industry standard in the...

Thank You ! Wow! Nice!

What method did you use to make field name change? Several system tables have field named Type. I found five. Hope you didn't change them.

I would have thought MsgNo and MsgText would be enough?

Wow, I would have thought both would be reserved names? :( For code use ctrl + f and search on whole project. Perhaps use the documenter to find no...

thnx! this is trivial but... is there a standard convention for this type of table? i'm thinking: - one table for all text on all forms -...

I think with info like that, you would be better off with a table?

If you want to be able to change the message in future without having to modify code, use table. Otherwise, hard-coded message is fine.

Hi I will send this over tomorrow. Thanks for your responses

Use dropdown Thread Tools above first post to mark as Solved. Done.

What is structure of raw source data? Provide sample of that as well. Possibly you just need a CROSSTAB query in Access.

Hi June Apologies. I don't really know how to do this. i have attached a spreadsheet of what i would like to do. Courses across the columns and...

Well, certainly does populate rows. Which method?

Hi June7 Thanks for the link. This only seems to show to start at a specific cell to populate columns and not rows, unless I misunderstood the code(...

Start with review of http://accessmvp.com/KDSnell/EXCEL_MainPage.htm

Provide mockup sample of what you want as output. Can use Excel. A simple self-join will relate the records, however, each pair will be duplicated...

Do the first calc in a textbox then in another textbox reference the first. You can set it as not visible. =IIf(txtSumof6Compounds = 0, "ND",...

Hi moke123 Thank you very much for the 3 examples!!!!! are great!!! with all of the them I have excellent ideas how to solve something like...

Hi June_7 Thank you! I have followed the advice and worked great!!

Was that addressed to my post? Your example is pretty poor, as it seems the next record is linked to the prior record, and vice versa? If the...

Agreed. I did exactly that but don't have a criteria calculation to combine the records. Concatenating the name is the easy part. Doing this manually...

Thanks to June 7th, we see where we were off. Classic case of overthinking the problem. This is the working code to get the sum. =IIf(<>"ND"...

I am thinking you just need simple concatenation if you link all the tables correctly Brand & " " & Size & " " & Type & " " & Resolution & " " &...