Recent content by Scott2S

OK. So far this has been great, but I went to try this on a table that has it's uniqueness spanned across two columns. How do I set my bookmark on the exact match of the record instead of just finding the first match? Thanks in advance

We encourage our users to type CTRL-F to bring up the search dialog and type in what name or whatever they need to find. The problem is that some users don't understand the default of 'whole field' and I would like to change it to 'Any Part'. Two questions: 1) is there an easier way for the...

Wow, this code snippet you posted: Private Sub RecordsListbox_AfterUpdate() Me.RecordsetClone.FindFirst "[RecID] = " & Me.RecordsListbox Me.Bookmark = Me.RecordsetClone.Bookmark End Sub works wonderfull! Thanks again! How did you know to use the recordsetclone and bookmark? I...

Thanks. I'll give it a shot. You said there are at least two ways to do this - what was the other?

Cool. Thanks for the quick reply! So I don't have to do this with a subform?

Is there a way in Access to display a scroll window of record names on a left pane and then when the user clicks on one of these records on the left that the data from that record will populate a form on the right - sorta like file explorer does ? Do I need a custom ActiveX control or do I use...

I'm still a little green with ADO - so please stick with me. We are creating a VB6 application that will be using ADO/ OLEDB to connect to a SQL 2000 database. We don't want to use a DSN - just ADO. The program will actually be using a DLL that will retrieve database configuration...

Where can I get info on the CryptoAPI?

What doesn't work about it? Sounds like permissions to me. Where is the paradox DB located?

You can update the Jet ODBC and all other ODBC drivers by downloading and installing the MDAC 2.5 service pack and Jet 3.5 sp from Microsoft.

How do I find out how to use the Tab Strip ActiveX Control version 6.0(SP4) from Microsoft? I have version 5 in an Access 97 form that I am trying to migrate to version 6 control and the control has some different properties that I would like to find out about. Thanks in advance. Scott

Well, it looks like my references may be incorrect but that doesn't explain why it works on my computer. I didn't know that you have to run a regsvr32.exe if you upgrade a file version. Is that true or do you only have to run regsvr32.exe when the file is new to that computer?

OK - I converted and enhanced a rather large Access95 front end application to Access 97. It runs great on my machine but when I copy it to another machine, some tabstrip activeX controls don't operate. Two out of three of the forms that I use the tabstrip control don't work, but the third...

In your system DSN, click on the client options button and confirm that your protocol settings match that of your server. I have problems connecting to any SQL server version if the DSN defaults to named pipes - I change the default to TCP/IP sockets and it works like a champ. Also be aware...

I need to understand a few more things. Are you talking about two text box controls (city and county) on one form? Are both of these controls bound to a field in the record source or is the county an unbound control? One last question, is there a table somewhere in your database that you can...