Search results for query: *

Can anyone point me to some code that they use successfully that will check to see if Word is open, if not, open it. Then, check to see if a specific document is open and if not, open it. Can't seem to do this cleanly. Any help is appreciated.

How can I pass data to a .txt file. For example, I want a file named (fieldname).txt. I want to write data to it: Name: data Address: data Hope that makes sense. Any help is appreciated.

Can I join three tables and update fields from all? Thanks.

I'm dimming some variables in the general declarations area of a form. On the after update of a text box I use the variables successfully to collect data in a SQL update string. Then the user has to click on a button to update the data to the database. But at that point I don't have the...

I have the below code, that loops through a data grid and writes a SQL string for each row. I need to concatenate all the SQL strings that get created into one string for later update to the database. Can anyone help me with that? Any help appreciated. Thanks. 'Loop through the grid For...

I have a problem and this is how I think I need to solve it: I have a grid that gets populate one record at a time by the user with a button click. I need to update the database with the contents of the grid. I think I need to get the data from the grid, populate a variable with the data and...

I have a form with a field box and a third party grid control. Data is keyed into the field and then updates the grid, resulting in a list of data in the grid. Grid name is ssQueued. Can someone point me to some code that will update the database with the data that's in the grid. Any help...

I'm trying to clean up a data file. Is there a way in code to replace spaces with tabs? Thanks for any help.

I have a string that I have to parse - I have to extract data between parenthesis, for example: City (Baltimore) City (Philadelphia) Any help apperciated.

Someone posted a very clever way to create a connection string by creating a text file and then renaming it with a different file extension? I can't remember the details. Does anyone know about this? Thanks for any help.

I have a SQL statement that combines text fields from two different tables. Each field has a label. If the field is null, I don't want the label. I can't seem to make it work. Any help is appreciated. strSQL = "SELECT 'Comments: ' + ISNULL(matter.mdesc2, '') + ' ' + " & _...

I want a line break in the middle of this string. Can I do that? Maybe my syntax is wrong - it's just ignoring my vbcr. Any help appreciated. strSQL = "SELECT 'Matter Comments: ' + ISNULL(matter.mdesc2, '') + ' ' + " & _ "ISNULL(matter.mdesc3, '') + " & vbCr & " + 'Client Comments...

I use the following, but if only one of the fields that I'm concatenating is null, Comments returns as null. Both fields are string. Select mmatter, mdesc2 + ' ' + mdesc3 as Comments from matter Can't seem to find the syntax. Any help is appreciated.

I Open Word in VBA code using below: Set oapp = CreateObject("Word.Application") oapp.Visible = True After I set Word to visible I want to minimize it. Can I do that? Thanks.

I programmer here wrote a COM object with a non-Microsoft platform (Delphi-Borland). I'm using it in VB 6 and can't get intellisense. I use: Dim Obj as Object Set Obj = CreateObject("GwapiAutoMail.SendEmail") He says: "My sample script is using late binding (because most vb scripts vars...

Can I open a recordset in VB and send the results to a text file on a network drive? Thanks.

I pass a variable to the below to check if a document is open. If it's open, fine; however if it's not open, I get an error. I can trap the error, but is there a better way to check if there's a specific document already open? If ActiveDocument = Request & ".doc" Then.... Thanks. Any help...

I have a table with multiple instances of Field 1. Field 2 may be 0 or 1, for instance: Field 1 Field2 ABC Company 1 ABC Company 1 ABC Company 0 DEF Company 0 DEF Company 0 DEF Company 0 Can I write a query to get only...

I combine multiple Word documents into one from my front end. The document will launch and the user will make edits. I've been asked to then save that final Word document as read-only. I can't see a way to do that from Word (well, it looks convoluted and involves passwords, which they don't...

Can someone point me to some code to loop through the results of a recordset and create a string? For instance I have a recordset which is returning one column. There's more than one row, and I want to concatenate the rows together to make a string - Row1, Row2, Row3, etc. Any help is...