Search results for query: *

I have an MDI form. On this form I have 2 menu options. Menu option 1 calls frmModal which has MDIChild property = false. It is called by frmModal.Show vbModal as I wish to show it modally. This forms shows a grid with many records Menu option 2 calls frmChild which has MDIChild property =...

Question froma Newbie... I am writing my first project with an MSDE database. I do not have available Microsoft SQL Server Tools such as Query Analyzer. A SQL query returns an error in line 97. My questions are: 1. Does anyone know of any (free) tools like Query Analyzer that will debug my...

I have a text box control. When a value is keyed in the text box I want the remainder of the text to be filled in from a look up. For example I have an array with 3 items: "BOB" "BOB BARKER" "BOB BAXTER" When the user keys "BO" I want to go through the array and complete the text box with the...

I have a MSHflexgrid whose datasource is an recordset set at form load Set flxGrid.DataSource = rst1 I need to, at times, filter the recordset based on values keyed by the user. If I filter the recordset before hand (e.g. rst1.Filter = "Field1 = 'Hello'") the number of rows in the flxGrid...

I have a MSHFlexgrid with 16 columns. Due to width of the form I can not display all 16 columns without the user having to scroll across. The last 10 columns allow the user to key values into the flexgrid using a floating textbox. The first 6 columns are for user information only. I would...

Have come across 2 methods for opening a stored procedure as a recordset. Is either of these (or indeed any other) better than the other: METHOD 1: Set rstRecords = New ADODB.Recordset strSP = "up_parmsel_something (" & lngID & ")" rstRecords.Open strSP, cnn1, adOpenStatic, adLockReadOnly...

I am writing an app using MSDE for the first time. One limitation that had been identified is that MSDE performance is reduced after 5 concurrent connections. Looking through Tek-Tips I am reassured to see this is 5 concurrent executions, not necessarily connections and can be well managed...

I have an MDIChild form with subsequent text boxes. On the lost focus event of each text box I perform a calculation and then call a procedure also on the form: Private Sub Text1_LostFocus 'Do a calculation CallSub End Sub Private Sub Text2_LostFocus 'Do a different calculation CallSub End...

Have a customer with a bespoke label printing utility written in Foxpro 2.6 DOS. They are changing their label printer and the programme needs to be updated to include the new printers control codes. The old code went along the lines of SET CONSOLE OFF SET PRINTER TO "LPT2" ...

I have a tree view. Child items are populated from a recordset queried from a property of the parent item in the tree. When the contents of the recordset change (records added, deleted etc) I would like to refresh just the child items of the affected parent, not have to refresh the whole tree...

Am new to object orientated programming and what to do things right.... I have a recordset and I want to create properties automatically in a class that match the fields in the recordset. I want to, in some way, bind text box controls on a form to the class properties and then have class...

When I select a row in my MSFlexGrid the contents are all highlighted with exception of the left cell. I have set the FlexGrid as: Highlight - always FocusRect - Heavy SelectionMode - By Row How can I get the whole row to be selected? Thanks in advance.

Not sure if this is the best forum for this but here goes... I have a VB app that processes a CSV file, using LINE INPUT to read each line into a string. From what I have read LINE INPUT relies on the lines being seperated by Carraige Returns. For a (currently) unknown reason it appears the...

Question from a Newby... Have installed on a customer's server MSDE. They connect to the server using terminal servers (which I have no experience off). I have a bit of code that I use to text the connection from the terminal to the SQL server: Dim cnnConn As ADODB.Connection Dim...

A question re object orientated programming from a newbie who wants to start doing things "the proper way"... If I have a form that I want to use across numerous projects (e.g. a user login form with a username text box, password box and 'OK'/'Cancel' command buttons) what is the best way to go...

I recently gave some training to a customer on using a COM DLL utility provide by an Accountancy Software package we are resellers for. I only code in VB, whereas my customer's preferred language is Vis C++ - though he reported he had no experience in adding reference to DLL objects in Vis C++...

Whilst a form is loading I would like to display a box (like a msgbox but not awaiting user response) that advises "Form Loading...". Would appreciate any suggestions how this can best be done. With thanks.

Does anyone have any suggestions how I can randomly create a string 8 characters in length made up of any alpha numeric characters? With thanks in advance,

How can I insert records from one ADO recordset to another in one shot rather than having to loop through each record. My two recordsets originate from two different connections - I wish to copy the records from an ODBC connection to a recordset with a SQL connection. The ODBC connection is not...

Is there a way I can print the contents of the watch window in the debugger to, e.g., a text file so I can then search the text file for an object or value? I am developing within another 3rd party application that uses Visual Foxpro and can break into the programme and open debugger to assess...