Search results

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:

Form Sizing problem With Pictures! [SOLVED] Ok, I've dealt with this before, but I'm hope there's an easier solution. I have a form that when in Design View is set to the exact size I want it to open to yet when I got to Form View, the forms size is the the size of the design window. Is there...

I'm 100% positive that Access being closed wont clear the marker from the server. We had a computer that had over 75 markers on the server with the machine being turned off. Deducing that it's a recordset issue. So, my next project is to look into a wrapper. Thanks for your help Banana, really...

Well from the server point of view it's seeing it as the connection to the table the records returned. So if I return 1500 records, it has a marker that I have out 1500 records. The biggest problem occurs if I don't set the recordset to read-only, then if someone modifies one of the 1500...

Yes, very much so. If I'm using probably 15 different recordsets in my code, would you recommend using this wrapper or should I stick to making sure that the recordsets are being closed? The reason I'm so interested in this is that our outdated inventory system is not clearing old connections...

Wow, that seems really complex for my simple brain to comprehend. How would I make sure I have the correct recordset? Or would this essentially keep track of them internally and when I tell it to loop through them and close any open ones, it's going to know which ones are open?