Search results for query: *

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

Mark, Thanks again for all your input. Unfortunately this trigger change didn't help. To make sure the problem is clear now (since I have been dragging this out sooo long): The triggers work great inside a ISQL window and inside access - the bottom line is they prevent the record from being...

I have since found that the trigger error does get raised from triggers that do not have any AND or OR statements. I know this sounds dorky, but the trigger does indeed work - you can't delete the record in ISQL, Access 95 or Access 97, you just dont' get told in your access table view that the...

Wow, thanks. Looked at their web site and it looks like what I need. What do you do about keeping static tables up to date accross sites? My deffinition of a static table is a table that the user can not modify data. It contains data referenced by the front end application. It is the data...

Have you tried disabling all menu bars in your autoexec macro and then set the menubar property on your startup form? Not sure if this will help in your application, but it's probably worth a try. Scott

NetIQ is incredible - check it out. We use it to monitor log space available and to run tasks. It can pull events out of the NT event log or SQL then notify you via pager or email.