Search results

Thanks for the prompt reply... I guess that how I will deal with the anwser (in the dash board) is give the result of the dropdown (5 categories) plus lump all the rest into another category called "Other" That seems reasonable, right? Thanks again,

You guys REALLY keep it going!! Uncle Gizmo, MarkK and Galaxiom - I appreciate all your previous help!! Thanks, Marty Habicht

Hi Guys, May I have some advice -- I have one attribute in the table and the table is normalized. But we have the same attribute in two different forms, one with a table lookup and the other with a free form text input. I'm trying to rationalize this for a dashboard output. Do I keep it as...

Ok now I get it !! :o Here is a few lines of my file: Call it "IT315.txt" ----------------cut here------------------------------------ Table: PA0315 Displayed Fields: 4 of 4 Fixed Columns: 3 List Width 1023 ---------------------------------------------...

I'm not sure which file you want. I've enclosed everything I think!! Marty

Ok you maybe right but how do I solve the problem? I'm using the exact same spec whether I do it manually or under automation!! I've already ripped out half my hair, now I am looking at going bald!! :banghead:

Here is the import statement I'm using: DoCmd.TransferText acImportDelim, "IT315 Import Specification_txt", _ "IT315", "D:\4533 Hires Rehire Status Change\IT315.txt" I can manually transfer the data ie thru File --> Get External Data etc but I can't seem to get the above...

Sorry I still get the error "Property not found" when I try your way Bob. Can you post the whole code? As far as "Docmd.OutputTo " I find that I can produce a PDF of the screen but there are a number of steps, such as saving the file name etc which I'd rather avoid!

No I am right now running an ACCDB ... previously I ran an MDB first in 2003 (~ 2 yrs ago) and then in 2007 (~ 6 - 8 months ago). I also said that it was "sort of " a "Print Screen"... I am not a Computer Programmer in the strictest sense of the word. But I try hard... :-)

Just as I stated "you view the form in print preview mode and if you elect to print that out you will get a print screen." ... but DoCmd.OpenForm Me.Name, acPreview does NOT work for me in 2007 !!

No ! It's just an emulation for the "Print Screen" however it did have the functionality of a print screen - just with the "Print Preview" in between -- you view the form in print preview mode and if you elect to print that out you will get a print screen.

Yes but what is it?

There it is, my simple code. Should work on any any form. All you need is a button named "cmdPrint" It was quite a while ago that I did the original code in A2003, and I don't have a A2003 on hand to compile but this is the original code that worked! Private Sub cmdPrint_Click() On Error GoTo...

The DoCmd.RunCommand (acCmdPrintPreview) allows you to print the screen (eg emulate hitting the Alt+Ctrl+"Print Screen" button) but it does a preview of the print before printing... At least it did for me in 2003 version. However things have changed some how in 2007. I already have the report...

Yes I believe the Docmd.Openreport method works; except that you need a report name to open and I do not have one because it is a "Screen Print". In 2003, you just did DoCmd.RunCommand (acCmdPrintPreview) to get that screen print. However, in 2007 things have somehow changed. I will check...

Thanks for the quick response. I just want to add that I'm trying to execute a sort of "print screen" (which previously worked with 2003 -- but apparently not with 2007! ) I'm trying to match the output of the 2003 version with the 2007 version -- a "Print Screen". I do not have a...

Hi, Two years ago I released a an Access 2003 program to my client. Now they want to upgrade to 2007. I got everything working in 2007 except this little bit of code: DoCmd.RunCommand (acCmdPrintPreview) It gives me the vague answer that "The command or action "PrintPreview" is not available...

Bob thanks for the answer. The classes are meant to help some one simply their own coding. Therefore I would need something that would lock just the classes that I have made while still leaving the rest. My understanding is that the mde would compile the whole works. Is that correct? Could you...

I want to package my classes, but I want to put a lock on them before I do so. I want the computer to return a message similar to one in the Word file attached. Can anybody point me in the right direction? There doesn’t seem to be a lot of help in this regard.

pbaldy, I'm afraid I don't understand what you are saying: >> with the various fields put on different tabs, as appropriate. The tabs each require a subform, don't they? This is how it is laid out: Form (one) | |------------| Tab1 Tab2 | | Subform1...