Search results for query: *

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...

It's a Number. I found out it's because I use LEFT JOIN. It accepts INNER JOIN and then I set up a GROUP BY. I think I have something that works now. However I need to check some of the values to confirm.

Thanks for the answer. The C1, C2 etc. would mean Cell 1 and so on. It was to illustrate that the countries were split into cells. I could have provided you a table name, that's right. I tried this solution and it seems to work, but it's fairly slow, compared to what I have come up with after...

I don't know whatever I did before, but no it doesn't crash, it just pops up and says that my JOIN expression is not supported: SELECT gr.year, gr.installed_mw, s.year AS prevyear FROM MI_installed_capacity_growth_rates AS gr LEFT JOIN MI_installed_capacity_growth_rates AS s ON s.year =...

table is not the problem....I just wrote table instead of the real tablename :) It crashes as soon as I write the -1 in the JOIN, so that it's not a 1 to 1 comparison. Crashing meaning I get a popup saying Access stopped working and I have to start Access all over.

Hello! I've have created this query in MSSQL: SELECT gr.year, gr.col1, s.col1 AS prevyearcol1 FROM table AS gr LEFT JOIN table AS s ON s.year = gr.year-1 ORDER BY gr.year Access 2007 crashes when running this. Is it possible to get this result by typing it in another way? I simply want each...