Search results for query: *

Back again... My MSHFlexGrid has the following in it (adapted from MS's example) Private Sub Form_Resize() MSHFlexGrid1.Top = 1300 MSHFlexGrid1.Left = 50 MSHFlexGrid1.Visible = True If Me.Height > 2600 Then MSHFlexGrid1.Height = Me.Height - 2600 End If If...

Ok... ok [grin] Private Sub MSHFlexGrid1_DblClick() Dim tmpType As String tmpType = MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 4) If Len(tmpType) > 1 Then tmpType = Right(tmpType, 1) End If useBookmark = True If tmpType = "M" Then frmMarriageDetails.ID.Text =...

YES!!! Worked it out myself. pat on the back for me :-) cheers Howard

Yeah I know another new user question (sigh). I creating a vb6 frontend to an acc2k mdb. This mdb has 2 tables like so Table1: full list of names with id, record type Table2: full details for all records (about 40 fields) unique on id The reason for having 2 tables is that the db is quite...

OK thanks Frederico, I have a play with other types of grids If I don't play I'll never learn so once again thanks. cheers Howard

If I use Redraw I get a different error Run-time Error 91 Object Variable or With block variable not set stopping on line Set MSFlexGrid1.DataSource = rs From the examples here on tek-tips I thought I would not have to do any looping of some sort. cheers Howard

I'm trying to using the following bit of code to fill a flexgrid but get an error stating that the ReDraw is invalid use of property. Can someone please enlighten me why. Private Sub btnShowAll_Click() Set rs = New ADODB.Recordset rs.ActiveConnection = cn rs.Source = "SELECT *...

Thanks Rick. I'll get this app going even if it drives me nuts! Cheers Howard

So the progress bar is not limited to 100(%)? If I have 32K records then I should set the max to 32K? Is it that simple?

firstly, thanks in advanced for any help antone can give me. I trying to develop a VB front to a access db. I have the searching sorted out thanks to SDuke http://www.tek-tips.com/viewthread.cfm?qid=1071854&page=1 As he found out I'm coming from a VBA background. I'm now playing with a...

Ahhh... now it makes sense. Although your right about the surname not needing anything, I will still need it when I search by first name and in this case the AKA name or NEE as well. Now I have some guidence, I reckon I can work the rest out. Thanks

Thanks SDuke So are your saying is that I CAN use a function within a SQL statement but it needs to be re-written in VBA? If that's all the problem is I can handle that. If I learnt to write in VBA, I can learn to write in VB! The code does not need to be portable so I should be right if all...

I thought I would merge my two modules to see that helped but to no avail. Guess I'll keep looking

It's 2am here so I'm off to bed. I'll check on this later tonight. H

The current form has the following fields on it. txtGetSurname (the surname to look for) txtGetFirstName (the firstname to look for) chkSoundex (use soundex or not) flexgrid1 (to display the data - later to double clck on to see the whole record) a button called btnSearch (to start the search)...

The sql statement works if I leave the function off e.g. SELECT ID, Name, ListType, Register FROM tblSearchList WHERE [Name] LIKE 'jones*' But doesn't work with ... WHERE CutSurName([Name])... the relevant bits of code are Private Sub ConnectIt() 'open the database Set db =...

Err... no CutSurName is a function that strips the surname from the Name field. In VBA any functions within SQL statements still get evaluated but it seems that they don't get the same treatment in VB. H

Hi folks I've looked around and can't find anytihng about this so.... I have an Access2k prog that I'm converting to VB6 DAO. In the VBA version I could do the following. SELECT ID, Name, ListType, Register FROM tblSearchList WHERE CutSurName([Name]) LIKE 'jones*' and it would return all...

Make sure you have the following line in your apache httpd.conf file LoadModule php5_module libexec/apache2/libphp5.so This loads php when apache starts. There is no seperate command to start php. To test if php is working, create a file in your web page dir like this <html> <body> <?php...

Hi assets The problem was that even in a new blank database the main menubar wouldn't show. You couldn't select it in customise toolbars because it didn't show in there. The only way to get it to show was to programatically do it in every database even back end databases with no forms or...