Recent content by Tanner65

After digging through the registry I found the solution. 1) Find the \HKLM\Software\ODBC\ODBC.INI\<DSN To Set To Readonly> 2) Click "Edit" and select "New" then "String Value" 3) Change the name from "New Value #1" to "OpenMode" 4) Right click and select Modify 5) Make the value 1. (For...

I apologize for not clarifying. I need to query the view using a query that returns the same results as my application. The application allows for the connection string to be changed, but not the linked tables or query. Thanks for the tip though! :)

I have a linked table (which is actually a view) and I need to change the view from being normal to read only. I know I can do this by adding OPENMODE=1 to the connection string, but I'm unable to change the connection string in the Windows ODBC manager or in the MSysObject table. Any suggestions?

I may be wrong, but shouldn't the acDialog setting be made in the designer properties for the form? acDialog should be changed to acWindowNormal or left blank since it is optional. From what I remember, Dialog means that it's modal like a dialog box. Right?

I'm assuming that each file will have a different import spec from what you've provided so far. So in order to do this you can do a few different things: 1) Move the information to a CSV file which makes it easier to read from using ADO and OLEDB. 2) Connect to the Excel spreadsheet using ADO...

Perhaps it would be better to use the Access database as the database for this and create a standalone application using VB6 or VB.Net. In both of these it is much easier to create controls at run time. For both VB6 (VBA is a stripped down version of VB6, just in case you were unaware) and...

Thanks for the help Pat. I've tried moving the sort to the query and it has no impact on either one of those problems. I'm also trying to cut down on the interactions to the database so, I'm attempting to eliminate the need to requery.

This time round, I'm creating an XML file using the ADO.Recordset.Save command and am interested in querying back to the XML file to keep network traffic to and from the database to a minimum. As of now, each time the mshflexgrid I'm using is sorted I have to requery in order to change the...

No one can help or at least lend some direction?

I'm working on a form that has a MSHFlexgrid located in it and have two questions. A preface, the sort events are occurring on a the single click event (shown below). 1)Once it pulls the information, the recordset connected to the database creates a clone and populates the MSHFlexgrid recordset...

I actually just figured it out. I have to do the following to have it show the apostrophed word. Me.ListBox.AddItem """'Tanner65' is a terrible worker.""" That's triple quote (") on both sides of the line to add. If I set the rowsource directly it'll be: ME.ListBox.RowSource="""'Tanner65' is...

Well, that's populating the Tanner65, but not the "is a terrible worker." Although it is still listed in the rowsource. It's like it only sees the area between the apostrophe. After adding it twice, the list box shows "Tanner65" twice And rowsource is 'Tanner65' is a terrible worker.;'Tanner65'...

I'm wanting to populate a list box with phrases and in those phrases some of the words will have an apostrophe around them to denote what is the value that needs to be changed. IE. " 'Tanner65' is a terrible worker." But when I use the same line in the list box it only shows Tanner65 with no...

Well apparently, when I thought I had closed it at least three times, I hadn't. :confused: Really appreciate the input. At least now I can help someone else when I see them asking the same stupid question I did. :o

When I turn on auto resize there doesn't seem to be a change in the layout. Image: