Search results

I just checked if the DoCmd.OutputTo works with a form and it does. This is what I meant when I said "Print", sorry for the confusion. So, lets find a way to make this work. Is there a way to store each instance of this form in some sort of cache or spool and then output the entire spool/cache...

so can this be done with the microsoft XPS then?

I never tried using the PDF plugin to print the form... I didn't realize that it couldn't be done with that. I have been using it to save a report that prints after my envelopes have printed. Thanks for the input. Like I said though, as far as I can tell there is no way to make this print as...

Ok so here is the skinny... I have a form that I need to print multiple times, but to one file such as a PDF or XPS (ideally the file-type is up to the user). I need to be able to print it as a form, I can't use the same information in a report because of a function that only works in the...

The only differences I could find were: Private Const LWA_COLORKEY As Long = &H1 and in the SetFormOpacy sub: SetLayeredWindowAttributes frm.hwnd, TColor, (sngOpacity * 255), LWA_ALPHA or LWA_COLORKEY When I added the two of these to my code, the form was no longer visible, and the TColor...

Sorry to dig up an old thread, but I had something to add, georgedwilkinson code wasn't working for me, here is a code that is almost the same, but works. For the Module: Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" _ (ByVal hwnd As Long, _ ByVal nIndex As...

One thing that I can see already that has already caused me problems is if there is an AND statement without something following it... So what I am thinking is this: If Checkbox1 = true then if sqlStatement = "" then sqlStatement = Condition1 else if sqlstatement <> ""...

I think I got it. This seems like it should work, I will go through and write the code and let you know how it goes. Thanks a lot for the help gents, it is much appreciated, and hats of to atomic shrimp for the answer, well done. They should do a "Karma" system on this board. If you answer my...

atomic shrimp, What you just wrote is bascially what I am looking for, but how do I introduce WHERE into the first statement? maybe at the end of building the strcondition, if strcondition = "" then strcondition = "" else strcondition = "Where " & strcondition ?? something like that ...

One of the problems right now with my database is that the information I get is from a website that predetermines how the tables are built. I pay for a service that provides names and information for me, and the format of their table is what dictates the format of my tables. Eventually I could...

Galaxiom, could you expand on your IF THEN statement? A simple example would help me wrap my head around what you mean. Thanks for all of the help so far everyone. I appreciate the effort that everyone puts into this forum.

I didn't know you could drop the true from a statement, that helps a bit. Thanks. Even if I drop the true though, what you're suggesting is basically what I am doing now: For each true statement, add a piece of the SQL statement. The problem is, that there are 100 possible combinations of that...

I need a simplified way of writing and IF THEN loop I have 10 checkboxes that are search criteria for my database. So 100 different possible combinations of search criteria. For each checkbox that is true, it will paste a piece of a SQL statement based on user chosen range, that is sent to...

so for anyone who runs into this and needs to use it, rename txtOrigin to the name of your initial textbox (the one the text is comming from), and txtMemoTarget to the name of the textbox that you want the letters in.

You my friend, ARE THE SHIT. You are a cool version of the mister wizard of access programming. You solved my enigma! It works beautifully, and from this I think I can create the rest of the fuctionality I need. Thank you so much. And no need to use excel, I think I was about to open up another...

Yes I do. Thanks for all of the help, i appreciate it

I have fontstudio to create the fonts of my handwriting. The problem is, if I have a word like "ladder" you can see the two D's are exactly the same... (they are suppose to be, its a font). That is why I am making more than one font, so that there is variation between characters that are the...

By the way, for those of you that are wondering why go through all of the trouble of making something look handwritten... this is marketing material that I am sending out. I have a tenfold response rate for my marketing if the material is handwritten VS. typed. The scanned letter looks EXACTLY...

The field will have many random fonts. Here is why, so that you understand what it is that I'm trying to accomplish... I have a business that sends out handwritten letters to people. Each letter is the same format, with only the name and their address changing. Writing 100 letters a week is...

First, thanks to both of you for your answers. I am sorry to sound rude, it just gets frustrating searching literally 20+ hours for an answer to one tiny piece of code. I am sure everyone here can relate. It is hard to see that your post has been viewed 15 or more times and to not even have one...