Recent content by BrianWen

Thanks for the answers and sorry for the very late reply (Holiday). It is the exact same database that is distributed out to about 100 users. The font used in a least some of the labels with the problem, is MS Sans Serif (size 8) so it's a font everybody should have, but come to think of it...

We are using a database in Access 2013, but the original file was created in perhaps Access 2000. It was later upgraded to ACCDB and actually the version the users use is ACCDE. Anyway, the original file got a bit corrupt (I couldn't delete things like queries and such and other strange...

Hi! I'm creating a Word 2010 add-in coded in C#. I stumped a bit here. I want to create a new label document and show it on the screen. I have this so far: Word.Application wordApp = new Word.Application(); wordApp.MailingLabel.CreateNewDocument("L7163", "Name and address here")...

Nevermind, I understand what you mean... It worked just fine. Thanks for the help!!

Sounds like something I could use, but I'm not entirely getting what you're telling to do. Could you elaborate just a bit. I know my way around SQL, so I do know LEFT JOIN for instance.

I was thinking the solution perhaps could in adding date another time as a row heading, but I can't figure out how that could be done to get all four quarters.

Hi all! I have a table with some amounts, a date and a region. I'm building a crosstab query to display a the date (consolidated into quarters) as row headings (so four rows Q1, Q2, Q3 and Q4) and region as column heading and of course the amount as value. That works perfectly, only I want to...

As far as I know it's not neccesary to construct a long SQL manually by looping over the multivalue recordset. I believe can be 'In(controlname)'.

Problem is I'm not using the multivalue field as criteria in the query, but instead a control bound to the field. It doesn't complain of this as criteria either, but it doesn't return any records: Forms![Dataform]![Filter_subform].Form![multivaluefield].Value

Hi all! First of all, I know of the implications of using multivalue fields. The data I store in the field is on the fly data (what the user has selected for filtering). So, let me first explain the setup: 1. Table (filter) that contains a few fields that for each user contains what the user...

Seems like it's not possible, unless if I save it in a table. I'll consider that... Thanks all!!

LOL, stupid me. How could I forget that. I knew it of course, but as such I never use...Usually I just program my code not to fail :) Thanks for the answer!

I have a script that among other things finds every comments in a sheet and processes them with this code: Set rngComment = Sheets("HelpSheet").Range("E5:E300").SpecialCells(xlCellTypeComments) If rngComment Is Nothing Then GoTo bla End If For Each rngTemp In rngComment...

lameid: Sounds interesting, but I'm not sure how to save? - The save buttons are grayed out and CTRL + S doesn't do anything. Is there a trick?

Hi everybody! I don't know about accdb, but mdb remembered what sorting the user had selected in a certain view before closing Access. So that when opening the same form, the records (in continious form) would be sorted the way the user had last. I'm talking about the two A-Z and Z-A buttons...