Search results

I do not use a cross tab query for my reports. I use a plain query, with some VB code. First, i use a year month field of long integer, with the year as the first four digits, and the month as the fifth and sixth digit. 201001 is January, 2010, etc. and for now, call the field YYYYMM Then...

OK, interesting, there are completely new references for X64 that are not available for x86. and when i went back to open the database on XP, there were missing references. . . . Vista x64 did not have missing references, just unchecked references. . . situations which make you go hmmmm...

When i move my databases from my work laptop to my home tower, some weird things happen. This expression in a query does not work on the home tower: Left([Labor category],3) Error message is function is not available anyone know where to activate built in formulas?:confused: sportsguy

I figured it out. . . in the navigation bar, CUSTOM has to be selected. . . sportsguy

Office 2007 is 32 bit ONLY. All 32 bit apps installed on a 64bit MS OS are loaded into Programs (x86) to keep them separate from the native 64 bit apps. I have been running Vista x64 for almost 2 years, and office 2007 a bit less than a year. Office 2007 is designed to maximize features in...

I have created customized GROUPS. How do I get the queries i have created to show up in the custom GROUP? its not intuitive, and I can't seem to find the answers online anywhere. . . sorry, I haven't spent the $49.99 for a 1,000 page book which starts at the beginning of access database...

Button.Event On Click DoCmd.OpenReport "myReport", acViewNormal to print in PDF open report in design view, click on PAge Setup, Page setup select middle tab page at the bottom, click use specific printer select your PDF printer. . . sportsguy

Thanks for the code, its very helpful to get me started. I will figure out how to get the Print group down from the Office button myself. . . its well worth publishing in one of the code sections above, as its great for hacks like me to figure out. . . sportsguy

That is print preview. . . which is why I asked, "What am I missing?" and one other quick question: When I create a query, graphically, the query itself can't run on the first attempt, because at the end of the SELECT statement before FROM is , * which is a comma and an asterick. That...

:confused: check the attachment, what am i missing?

That is the one step that has an extra step of going to the HOME button first, for an extra click, Bob Larson please note, when the print button should be on the ribbon. . . or is that NOT an option?? geez, i wish i knew more about 2007 sportguy

Its working fine. . . read my avatar comment! But what your toolbar is missing is a print box button, as I ran a report, and printing requires a right click on the actual report to select the print option. . Other than that, its almost perfect! (almost because of the lack of print button!)...

Yes, if you post a snapshot of the excel spreadsheet, this would give people an idea on how to lead you in the best direction. sportsguy

COOL! I got it to work very easily. . . if I stop long enough to actually read the directions! Of course, now the test database isn't working properly on my home computer, with Vista x64 and Office 2007 versus my work laptop XP and Access 2007. . . but its a huge step in getting the ribbons...

Banana! you have answered a question I have not had time to explorer, due to work and the learning curve! So according to the link you provided, i paste the XML code right in the memo tab of the USysRibbons table? is that correct? I don't hate Access 2007 as I did when i cut over cold...

jamer, how do you do it now? or don't you do it at all? What is the goal or output of the database to be used for? Understand that for the board, is a big requirement for helping you, as some may interpret the word control to be inventory to be accounting based. Others, like myself, might...

Thank you, Thank you Thank you! you just saved hours of time Me.Caption = Forms!Home.cboYYYYMM & " " & Left(ReportTitle(Forms!Home.cboYYYYMM), 3) & " " & Forms!Home.cboOperation & " " & DLookup("[Operation]", "REGION", "[RegionID] = Forms!Home.cboOperation") & " Op Coverage Trend" sportsguy

Ah, its the On Open event, that's what I was missing. . thanks sportsguy

Those still keeping the genius title, I have a basic report which runs based upon a couple of drop down boxes from a form. The report runs fine, but what I want to do is to update the report Caption prior to printing so that the print to PDF will have the correct file save as name, and I...

and as a side note to all you who have determined that the IT department just doesn't smell right, the controller from my company went to a larger GE subsidiary, who I talk to regularly, and he is just shocked at how old and dysfunctional a GE subsidiary can be, as compared to the company he...