Recent content by bobbarker

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

Alternate Query Analyzer found: http://www.msde.biz/msdequery/download.htm

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

Thanks for your input again. I have tried your suggestions but still have the mismatch I have tried some further things out. The recordset I am trying to open and filter is based on a SQL VIEW (Virtual) table. If I create a recordset based on a table and filter the recordset the number of...

Thanks for the response jebenson. Extract of code Private Sub Form_Load() Set mrstSections = New ADODB.Recordset mrstSections.Open "vw_section", gcnnConn, adOpenStatic, adLockReadOnly, _ adCmdTable InitGrid End Sub Private Sub InitGrid() With flxGrid1...

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

Thanks for the response vladk Am I right in thinking that FixedCols works from left to right - i.e. it won't work if I want to fix columns 7 -> 16 and have cols 1 -> 6 scrollable?

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

Thanks for the response - that is what I was suspecting. I'll try your suggestions So my original assumption that no further events would be called outside of the modal form until it is unloaded or hidden is incorrect?

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