Search results for query: *

Please disregard my question. I just realized that my problem was the result of some code I had placed in a format event while experimenting with the RDC. There’s three hours of my life that I’d like to have back!

How do you get the Report Viewer to show changes that you programmatically make to Text Objects via VB at run-time? When I run the following code, the changes I make to the recordset are shown in the Report Viewer as expected, but the changes to the Text Object are not shown. In case it...

I’m having trouble using the Form Layout window to position forms in my projects. Most of the time when I view the Form Layout window (via View|Form Layout Window) it comes up with no forms on it. Other times it works just fine. In either case I know that I have set the StartUpPosition...

This is my first foray into creating ActiveX Controls. I’m having trouble understanding the cycle of reading/writing properties (i.e. persistence) that occurs when the host application moves from design mode to run mode and back. The book I’m reading states “that the first time we draw our...

In a nutshell you're saying: -- With late binding the ID's are irrelevant. Therefore, binary and project compatibility are for all intents and purposes equivalent and irrelevant. -- With early binding the ID's are used to make calls to the object's methods. Since recompiling the component...

I'm a bit confused about the Project compatibility option available to ActiveX components. One book I have says that under Project compatibility the Windows registry is updated each time the ActiveX server/component is compiled, thus requiring you to recompile all the clients too. However...

Is it possible to specify the primary-foreign key relationships between tables in VisData? Also how do you enforce referential integrity and specify cascading delete operations? I know how to do these tasks using Access and the DAO, but I can’t figure out how to do them in VisData (assuming it...

I gather that you have various controls bound to the data control. If so, you are correct in saying that you need to specify a database name and record source to bind these controls. The trick is to set these two properties, bind your controls (i.e. textboxes), AND THEN clear the DatabaseName...

Here’s how I approached the very same problem when using the intrinsic data control to connect to an Access database: 1) leave the DatabaseName property of the data control empty in design mode – this ensures that the recordset cannot be built using a bad path during initialization. 2) place...

When I “For Each” through a collection I usually use a Variant type control variable. However, in the case of the Forms collection or Controls collection, what type of control variable should I use? I have successfully used type Form and Control respectively in these “For Each” loops but am...

Thanks for the responses. I know that this was a really basic question. I appreciate your help. Jon

Simple point of clarification: What exactly is a global variable? Is it a variable that is declared as public in the Declarations section of ANY module or is it limited only to a variable declared as public in the standard/code module? The book I’m currently reading is being rather ambiguous...

Could somebody please recommend a good book on ActiveX? Specifically, I want something to teach me how to design and create ActiveX EXE's and DLL's using VB. My experience with ActiveX is limited. So, a book catering to beginning or intermediate VB programmers would be best. Thanks for your...

Thanks for the recommendation. I'll give it a try.

I've been connecting to Access databases via the data control but would like to start learning how to use ADO. Can anybody recommend a good book on ADO for beginners that is both understandable and thorough? TIA

Is it safe to assume then that the recordsets of joined tables (i.e. dynasets and snapshots) can only be used for reporting while the recordsets of individual tables (i.e. dynasets and tables) can be edited, added to and deleted from? Jon

The following is a highly abbreviated version of the code that is causing the problems. Specifically, debug takes me to .ActiveDocument.Tables.Add… when I incur an error 5850. Private Sub mnuInvoicesPrint_Click() Dim wdApp As Word.Application Dim wdDoc As Word.Document Set wdApp = New...

Steve, This is just what I was looking for. I appreciate your help, Jon

I’m trying to use Word from within Visual Basic to print a document. Everything works perfectly the first time I print but all subsequent attempts to print fail. The sequence of events is as follows: First print: everything is fine. Second print: Run-time Error 462 – The remote server machine...

Does anybody know if it's possible to emulate word wrap with an array of textboxes? Specifically, I just want the current word being typed in a textbox to wrap to the next textbox in the array if the maxlength is exceeded while typing that word. While I could use a single multiline textbox, I...