Ok, so I figured out most of this with some helpful code from the web. The following code works when I create draft emails. I select the draft or draft that I want to have a "From Field" populated for and run the macro. problem is at this point, I am getting the outlook is trying to send an...
I have a third party vendor product that sends PDF files to clients. This product creates outlook emails to a drafts folder or just creates outlook emails and sends them. The product does not however have the ability to set the from field before sending the emails. I need a way to either have...
I would like to program a keypress event so that when a function key is pressed the click event is kicked off. Basically,
1. User presses F9
2. Program interperts Keypress and calls a click event of a command button found on the form.
I am having trouble interperting the keypress as a...
If you're subtotalling in a footer, you might be able to do a detail count. Then you can set all your subtotal fields to
=Iif ([txtDetailCount] > 1, [txtSubTotal], "")
Hope that helps!
It sounds like you are printing more than 1 set of reports at a time and want to do one right after the other. If that's the case, there is a recent thread in this forum that tells how to run several sets of reports from 1 report by creating a sub-report.
If that's not the case, what I did...
Hello, thanks for the tips, but I guess I didn't express myself well enough. The size of the fields are okay, there is plenty of space after the text is finished, I would just like to have the text spaced further apart between the lines.
What I want to do is to change between single spaced...
Is there a way to change the line spacing inside of a label or text box of a report? Some fields have several sentences that wrap around, need to get some white space in there...
Thanks!
To CosmoKramer-
It worked, you are a genious! Now for the super-challenge if you're up for it. I know this is a total longshot and has a 99% probability of being impossible, but here we go:
I've got a variety of names in this field, like the examples below:
Mr. Fred Rogers
Mrs. Smarty...
Still no joy,
Both in the created field within the query and within the control source or format property fields of a report textbox Access is still adding on the brackets. Access really doesn't like it!
Any other ideas? Thanks for your help
Hello,
Thanks for the tip, but even though I can see how it would work I can't get it to work. I have tried this in 2 places:
In the query I made a new field
Proper: StrConv([txtField], vbProper)
As soon as I got out of the field it showed this:
Proper: StrConv([txtField], [vbProper])
I...
Hi all:
I have PDF files that contain as many as a few hundred pages. I am looking for a way to write VB or VBA code that will break out each page of the source PDF into many PDF files each containing one page and each with a unique file name. Can this be done?
Thanks,
JCG4LOM
I want data that comes from my query in 'upper' format to display in 'proper' format in the report:
I.E. MR. GENE BOOGIEMAN
will be Mr. Gene Boogieman
I can do this in Excel and Word...
Please help. Thanks!
You may also want to consider using a textbox on your form versus a combobox. It seems like you know already what rep number you want to run the query for. In that case a user could populate the text box with the number (1 for example). Once the user clicks the run button you can capture the...
Thanks Tony, but I am not sure that is what I need. I have code to open the report in design view. I then want to set the values of textboxes to be the values of variables I have calculated through code. The example code I gave sets label values, not textbox values. I know the following...
I am looking to populate a report textbox using a value contained ina variable of code. The only way I have found to do anything close to this is using a label. Since, I need to use the value within the report to calculate other report values, I would prefer to use a textbox.
Here is the code...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.