Thanks Skip.
That's what I thought I'd have to do.
I will modify the original template, perform the mail merge, and email the file and repeat until it looks good.
Thanks.
If at first you don't succeed, then sky diving wasn't meant for you!
Hi Skip,
Thanks for the response.
I wasn't sure if an 8.5 x 11 document could be converted (before emailing it).
I can certainly recreate the document in a new format/page layout.
I just don't know what to adjust (ex. page size, font size, etc.)
The current document is only one 8.5 x 11 page...
Hello,
We have several Word mail merge 'template' files (we call them notices and saved as a regular Word document).
The files contain database mail merge fields.
We have a dos batch process that opens the notice template file and activates macros to connect to the datasource and populate the...
Hello,
Does anyone know where the change password default text is located?
Choose password
You can choose whether you pick a password,
or have the system create one for you.
1. Pick a password
2. Pronounceable password will be generated for you
Enter choice...
Hi George,
I'm sure it was a well deserved vacation.
Thanks for the remaining code you provided.
If at first you don't succeed, then sky diving wasn't meant for you!
I was able to get it working by hard coding the sa user id and password.
DB.ConnectionString = "Provider=MSDASQL;Driver={SQL Server};Server=" & cboServers.Text & _
";UID=sa;PWD=123456"
It also worked by prompting for the user name and password
' DB.Properties("Prompt") = adPromptAlways
'...
I should also point out that I can make an ODBC connection using SQL Server Native Client 10.0.
I also tried:
DB.ConnectionString = "Driver={SQL Server Native Client 10.0};Server=" & cboServers.Text
and it errors with
Keep in mind that I'll be connecting to SQL Server 2014 or 2016.
If at...
Hi George,
In the getRecordset code, you have a function called globalConnectionString.
Would you be able to provide the code for that?
I tried
DB.ConnectionString = "Provider=MSDASQL;DSN=" & cboServers.Text and
DB.ConnectionString = "Server=" & cboServers.Text & vbNullChar & _...
Hi George,
Thank you so much for the information.
I think this will be so helpful in transitioning away from sqldmo.
Thanks again for taking the time to provide the code samples as well.
If at first you don't succeed, then sky diving wasn't meant for you!
Hi George,
Thanks for the reply.
What would the best way to handle the return values.
Would I associate your query in a recordset or is there a better option?
I'm sort of working backwards.
The step before this, a combo box is filled with server names.
This is the same list you would see in...
Hello,
I have been given the task of trying to update an old program in VB6 that uses SQLDMO.
The problem is VB6 is trying to connect with SQL Server 2014 (or 2016) and SQLDMO isn't supported.
When it tries to connect, the following error appears:
I haven't worked with VB6 in a long time and...
Hi xwb,
Yes that is the default path as I described.
Something or an update process is changing the paths to the Updates path.
I'm trying to find out why the paths are changing and how to stop it from happening.
The reason this is a problem is that it is affecting the existing Word mail merge...
Hello,
I have come across a situation and I don't know if this is an Office issue or a Windows issue.
On several machines, Office 365/2016 is installed in a Windows 10 environment.
The installed path is the default path: C:\Program Files (x86)\Microsoft Office\root\Office16.
On several...
Hello,
I have just updated the open ssh to openssh-7.6p1 on SCO 6.0.
Using the command ssh -V, it shows OpenSSH_7.3p1.
Does anyone know if this is a display issue or was a lower version actually installed?
Cory
If at first you don't succeed, then sky diving wasn't meant for you!
Hi Eddie,
Thank you for posting the patch for the update.
Unfortunately I am not able to test this update.
The computer in question had a hard drive crash and we replaced it with a Windows 10 machine.
Other computers either have not had it installed yet or the monitor configuration is...
Hi Eddie,
Perhaps the two computers that are fine haven't yet installed the patch.
On my computer, the settings are to download updates but not to install them.
Or it could be a lucky co-incidence.
Victor,
Thanks for the additional info.
Just as one comment stated, in my case, the user logged...
Hello,
I don't have the specifics at the moment although I know it does use an AMD HD series card.
Something in that update definitely affects something.
If at first you don't succeed, then sky diving wasn't meant for you!
Hi Vitor,
I found KB4034664 was installed yesterday and that is when the problems started.
I reverted the screens to the original configuration and uninstalled the update.
So far everything seems to be back to normal.
Outlook opened on the extended screen with all icons and mouse hover is not...
More testing.
Unplugging one monitor, no icon problems when only using one monitor.
The main monitor was on the right side and extra monitor was on the left side.
I changed the settings so that the main monitor is on the left side and the extra monitor is on the right side.
By changing the...
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.