Search results

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?

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...

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'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...

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...

What is the current file version for this ocx? I'm currently using 6.00.8804 but the only version I can find online is 6.00.3 or 6.00.5. I want to make sure that I'm using the most up-to-date since this link seems to be the same problem I'm having. Thanks!

I'm new to CR, other than changing the selection expert to find different data and am attempting to create a shipping plackard to go on skids. My problem is that I don't know how to repeat the data for X number of pages. Begin background info: Essentially, the prompt states the number of skids...

Hey there guys, I've created an installer program in .Net 2.0 before finding out that the units to be installed wont have .Net on them yet, so I'm having to re-work it all in VB6. Well my question is about datasets and/or recordsets. In .Net I could get the value from a column/row by Dim cr...

Hey guys, I've run into a problem I can't seem to find a solution for. I've got a packing list that I don't want the user to save over or print without saving to another location; both of which I've interrupted using the BeforeSave and the BeforePrint. Both of these feed into the same module...

Preface: I don't know where to post this since I'm using a VBA executed SQL command or if this is a table issue. I'm trying to import a .csv file into a "master" table of several .csv files. I've figured out how to link them and import them even though they have different field names, but the...

I guess I'm having an off day today, nothing seems to be working for me, and now it's my for loops. I need to go through each field in a table and return the names of those fields to determine what variables need to be set at. Granted I'm not too familiar with Access, but I've tried all the...

I'm attempting to append a table using only a few fields from another table. Unfortunately, I have to take a generalized approach with the "master" table (the one being appended) since it needs to hold a listing of information from several tables. So my thought process was to add a field...