Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BrianWen

    Different sizes control elements. Why?

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

    Different sizes control elements. Why?

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

    Word add-in C#: Add label document

    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")...
  4. BrianWen

    Crosstab query include 'null rows'

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

    Crosstab query include 'null rows'

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

    Crosstab query include 'null rows'

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

    Crosstab query include 'null rows'

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

    Multivalue field in subform as criteria in query

    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)'.
  9. BrianWen

    Multivalue field in subform as criteria in query

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

    Multivalue field in subform as criteria in query

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

    ACCDE doesn't remember sorting

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

    Excel 2007: SpecialCells(xlCellTypeComments)

    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!
  13. BrianWen

    Excel 2007: SpecialCells(xlCellTypeComments)

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

    ACCDE doesn't remember sorting

    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?
  15. BrianWen

    ACCDE doesn't remember sorting

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

    Join table on not equal

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

    Presenting data the right way

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

    Join table on not equal

    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 =...
  19. BrianWen

    Join table on not equal

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

    Join table on not equal

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

Part and Inventory Search

Back
Top