Search results

thanks for the replies. I know it "shouldn't" but it does lol... put the double quotes when a field contains a comma. anyways Gemma/Ranman is on the right track. I did some more searching and ended up with this code snippet.... ' Note the ExPath and Exfile are variables instead of hard...

Hi I am trying to build a PIPE delimited file with no double quotes. I created the specification file and selected <none> for the text qualifier but it will still put it around the fields that have a comma. I can't have it around any field and I do not see a setting to make sure it is not in...

holy ...I posted this just over 6 years agoo...lol, I guess you searched unanswered threads... I am pretty sure I figured it, but thanks anyways.

see the bolded entry above..

did you check off to use "specific Printer" in the report design? You didn't say what is happening

Thanks vbaInet, you gave me the nudge I needed! I had to get out of that "box" I was in (think outside), ultimately it was using the "Public" to declare the variable that solved it. then I found I forgot to replace one of the form references. So thanks for the help.

hang on, I'm just reviewing the code, I see a reference to the form I forgot to replace

Yes, I just don't often need to declare a Public Variable. Anyways, I got it working with a Module, but still get an error if I close the form

OK I see what I missed, I need to declare as "Public" Public Frm_std20 As Boolean Public Frm_std40 As Boolean Public Frm_HC40 As Boolean Public Frm_HC45 As Boolean Public Frm_ttDays As Boolean

that is where I am stuck, I know what you mean, but I'm not able to get the value to the report, I get "Variable not defined". I know how to code (not a pro) but get lost in the scope sometimes, tend to stick with what I know. Module: Option Compare Database Option Explicit Dim Frm_std20 As...

The code below works like a charm, but getting it to work with the form closed that is a problem. You see I want the form to be popup make the choice then print report and had off the choices to the report. I currently have Popup turned off (so it drops behind the report), but it causes my...

I set up a report that is opened from a form that has Unbound check boxes. The checks are used in my code to hide or show the relative controls on the report. Also I coded the Detail section "On Format" event to calculate the spacing for when a Control is not selected to be shown...

ok gotcha.. Dim std20 As Boolean, std40 As Boolean,HC40 As Boolean, HC45 As Boolean

wait, what do you mean? I thought you also said it doesn't work? why would you use it?

thanks guys, I am really surprised. I have seen people do it on one line and that is the only reason I ever did it. luckily I don't do it all the time, so I will have to review my code.

I always thought it was good practice to group similar variable together on a line (within reason). eg Dim std20, std40, HC40, HC45 As Boolean I just discovered that the above does not work. I have check boxes and for example if I uncheck the std40 & HC45 the variable results are as...

here is my Access version

I even copied a working control then copy pasted the rowsource and controlsource, and the colors changed when I did so!!!

Here is an example of how messed up it is. I completely re-did my lookups for this one combo. I made the image a bit blurry to obscure data, but look at the columns, first and 3rd are the way I want it and the middle one is messed up? Now it is even worse, or partly better depending on how...

thanks, I have tried all that as those solutions have been described in the things I found through internet search, and I also have SP2? I can post screen shots on the weekend