Search results

Re: Passing combobox value to a report - more info Good question - Attached two images: 1) Error message happening 2) The query that is behind the report, where I am attempting to pass the value in the drop-down to for a selection process.

How would I identify the value (field) in the drop-down of an unbound combo and get it passed to the query behind the report. Attached are a couple of screen shots that show how it is going. Screen shots 1) form in design mode 2) the vba code behind the button to create the report Thanks for...

Re: my email cc is not working? - resolved I have attachments working too. Thx Russ

Re: my email cc is now working -Oct2011 not attachment strAtt any one using it with success, if so what is your format?

Bob - you are a genius! When it comes to Access. Russ

I need to get the active tab name from the form? TxtQueryVarible = Me.TabCtl14 MsgBox TxtQueryVarible, vbOKOnly, "Confirmation... " This tells the tab i am at is index 0 Thx Russ

One item to note. Within the Tools Startup - the check box for the status must be checked on this meter does not show on the bottom of the screen.

Got it! The first one has the extra literal. The next two do not. And then there is not a pop-up box. It make just a little meter thingie on the bottom of the screen. Thanks for all the help. Russ

This is a vba module that generates emails. I added only 3 lines. # SysCmd acSysCmdInitMeter, "Currently Emailing ", totNumRecs SysCmd acSysCmdUpdateMeter, "Currently Emailing ", intNumRecs SysCmd acSysCmdRemoveMeter # I am getting a Debug message on the SysCmd...

Thanks for the Outlook code - I might still got thaty way. When the email id is outside of the company address book, this pop-up error message is occurring. "The server rejected one or more addressses. The server response was: 550 5.7.1 Unable to relay for emailid@gmail.com "

No this is not for Outlook. There is a different batch of code out on web. I did test that code a couple months ago and did get it working. But there is a Microsoft Security pop-up security message. There are patches to make it so the pop-up security does not happen, from places like...

I do emails with this module outside of MS Outlook Exchange. From event VBA, I pass parameters building the subject line, to email and body to this famous common module. Option Compare Database Public Function Xmail(strTo As String, strFrom As String, strSub As String, strBody As String...

I am using a common function xmail and the cc part is not working does anyone know what i can do to fix it? I get the to part of the email to work but the cc will not work. It is listed as the cc on the to mail, but the email for the cc is not generated. Thx Russ below is code: Option...

resolved Doing that change did it - On the Format tab of the property sheet for the form, turn off the Record Selectors. Thanks Russ

Please see the attachment. I do not know how - why - there is this line on the side of the form with and arrow. But I would like to remove it. I could not find out to. Russ

RESOLVED now loading the correct value instead of this ... TxtSubject = Q1230NDT3RDNOTICE!IDCoName_2010TDB use this TxtSubject = rs!IDCoName_2010TDB Russ

I know my loop is working because the counter is working and I am getting three emails. The problem is the value from the table is staying with row 1. I do not know why the row 2 value is not being loaded into the varible and emailed to me. The value getting loaded into TxtSubject is staying...

The home users are just going over the Internet. I will have to research what it would take to use a "A Terminal Services session or Citrix". Thx for your help Russ

Yes, they all have their own front-end. And they are not developers or query writers, they just go through the a form.

Re: Scheduled run of Compact-Repair off hours - moreinfo 6 remote users company's network 3 home users - their at home internet connection to a vpn tunnel