Search results for query: *

Is there an VB API call that will return the drive and path of a database if I provide the DSN name? For example, I have a Microsoft Access 2000 database located on a network drive: f:\apps\dbs\vstats.mdb. On a client machine I have a DSN for this database named "STATS". I would...

I am customizing a Contact form in Outlook 2000 and getting a curious response when I attempt to place a textbox control on the form and link it to any one of the pre-defined email fields (Email 1, Email 2 or Email 3). After I link the textbox control to an email field it is no longer visible...

I am customizing a Contact form in Outlook 2000 and getting a curious response when I attempt to place a textbox control on the form and link it to any one of the pre-defined email fields (Email 1, Email 2 or Email 3). After I link the textbox control to an email field it is no longer visible...

Many thanks, that was just the help I needed. I found that my declaration of a Public string array caused an error if used in the "This Outlook Session" section." But I was able to get around this by placing my original code in a separate module and calling it from the...

I have a VB Script routine that runs (as code behind forms) when I open the contact form in Outlook 2000. The purpose of the code is to load a list of telephone numbers into an array which is used to validate phone numbers in the address book. It works fine now but I would like to have the...

Within Outlook 2000, select TOOLS>OPTIONS and then select the "Mail Services" tab. At the top of the Mail Services dialog box, you will see "Startup Settings." The default setting is "Always use this profile." Change that to "Prompt for a profile to be...

I posted this under MS Office Suite but didn't get any responses. If anyone can give me some advice on this it would be appreciated. I'm attempting to design a contact form in Outlook 2000. My objective is to have the activities list appear at the bottom of the General page/tab rather than on...

I'm attempting to design a contact form in Outlook 2000. My objective is to have the activities list appear at the bottom of the General page/tab rather than on a separate "Activites" tab. I would like to replace the large text box at the bottom of the General page with the...

Thanks Pete. That's just what I needed... --------------------------------- Art Madden amadden@tampabay.rr.com

I am actually trying to parse a data file and delimit it with commas and semicolons (commas for field separators and semicolons for end-of-record markers). The data file is currently delimited with paragraph markers between each field and two consecutive paragraph markers at the end of records...

This question pertains to Microsoft Word 2000. I am writing a VBA routine and need to loop until the end of document is reached. I have looked for examples online but don't see any good examples. I want to use the construct similar to: Do ..... Loop until 'END OF DOCUMENT' Any help with...

I'm in the process of upgrading a VBA application from Access 95 to 2000. Part of this process is switching from the use of DAO to ADO/ADOX. I'm having a problem converting the DAO code which checks the Connect property of every table (tabledef) in the database and determines which tables...

I cross posted this question in the VB6 Programming forum and received a response from KevinClark that did exactly what I needed. ...thought I would post his response here in case anyone else was interested. -am ---- By Kevin Clark.... In VB apps I use the SQLDataSources and SQLAllocEnv APIs...

Many thanks Kevin. It worked first time! -Art M.

I'm trying to write a VB6 or Access 2000 VBA program that will list the ODBC data sources installed on a users workstaiton. Further, I want to list only data sources of a specific type, such as Microsoft SQL Server, etc. I know how to view the information using the ODBC Administrators tools...

I would like to write a VBA routine in Access 2000 that will present a list of available ODBC data sources to a user. (These would be ODBC datasources that have been previously installed and configured on the users workstation.) In addition, I want to only show data sources of a particular...