Search results for query: *

I have an smallapplication that gets distributed to clients. I have some code to automatically send through Outlook, which works fabulously (I found it on another thread here!). However, what if my client does not use Outlook as their primary email? Here is the code that I currently use. How...

Hey all. I have recently installed a Access 2003 database onto a machine which has 2007 installed. You can see all the data, but on my menus that I have set up, you can click until the cows come home, but nothing works. It simply will not follow the program instructions! Everything is just...

I am running a program whereby I do a lot of copy > paste functions from Access. When the office clipboard gets full, the user gets an error. I saw some discussion on this thread. http://www.tek-tips.com/viewthread.cfm?qid=1227582 But I am wondering if anyone is able to contribute any...

I have an Access program whereby I am importing some information into access from Word documents. The code also looks for certain criteria in the Word documents, and breaks it up into smaller word documents based upon those criteria. A typical word file that I am trying to break down into...

I have been working with Access VBA to manipulate Word to do a document, then read some of the information from Word back into my Access Database. I cannot figure out how to return the current section number. For example, VBA will open a Word document, look for a word that they user has...

I am working with a program to automate Word to create documents from Access. When the user is in access and says "Create Letter" (by way of a command button), I need a popup screen to say "Please wait..creating document name???". Then in the background it should go to word (quietly in the...

I am accessing Word through VBA from access. I get the following message: Error 462: The remote server machine does not exist or is unavailable. It stops on the line setdocorig = documents.open Dim wd As Word.Application Dim docOrig As Word.Document Set wd = CreateObject("word.application")...

Hello all! I am working with VBA from access to manipulate Word documents. So far, so good. However, I am running into some errors when VBA tries to open a word document that is already open. That makes total sense, of course. I want to trap this error, and report back to the user "This file...

I am trying to manipulate Word from my Access application. I need to add some customdocumentproperties, but when I try to declare the following Dim itmDocProp As DocumentProperty I get the following error I am sure that this is simply a problem with the reference, but I have no idea which...

I am currently working on a document mgmt program. The basic functionality is Access has a database of the document names and the directories, and then opens word to do the actual editing (through hyperlinks). Everytime a user clicks on a hyperlink, I want to go into the word document and...

interesting.... When setting on the debug to break, all controls on my page come up with an error message (in debug mode) I would love to say that it is easy. But all I am doing is putting on a "break" in the code so that I can step through it. The form is still open. No issues that I can...

I have developed several applications in Access. However, now i would like to globally distribute and sell them (I own all the code). I am wondering where the best place is to start? Many machines that I may be distributing to may not have Access installed on them? What licencing is required...

When using a data control, I find that I have to specify the database name. The directory for my computer will obviously not be the same directory for a computer that the program will ultimately be installed on. I know that I can set this through the code using app.path, but this does not help...

I have just moved from VBA to creating VB6 programs. I am using Access 2000 for a backend database, which is jet 4.0. My copy of VB6 does not see it as a valid database. I can connect using ADO, but I have had some "learning challenges" trying to use ADO. So, I have jumped back to using DAO...

As well as doing programming myself, I also run a small business on the side (not a computer business). But I really don't know much about operating systems or networks or the like. I am running XP home edition-SP2, as, until 2 weeks ago, I only had 1 computer at the front desk. Now that it...

I have a form that has 3 possible search criteria. ItemID Category Description The user can enter one or all three to search on. It needs to find the closest match. The SQL statement I am runnning looks like this. If Me.txtSearchCategory = "" Then Me.txtSearchCategory = "*" end If If...

Newbie here! I have been programming in VBA for quite some time, and have recently made the jump to VB. I am trying to pass a form name to a subroutine in a module. The subroutine analyzes records to meet various criteria. Because it is done so often, I make it a generic subroutine. Easy to...

I am a fairly good VBA programmer, and am now making the jump to Visual Basic. Wanting to be as advanced as I can be, I want to learn ADO funcationality. I have read quite a bit about the flexibility and how to set connection strings. I have read in these forums that you should use the ADODC...

I have several applications written in Access, with a lot of VB coding behind the scenes. I would like to begin to distribute my programs for $$$. From what I have researched, distribution through Access is somewhat of a pain. So, now it looks like I have to make the jump and translate them...

I have several applications written in Access, with a lot of VB coding behind the scenes. I would like to begin to distribute my programs for $$$. From what I have researched, distribution through Access is somewhat of a pain. So, now it looks like I have to make the jump and translate them...