Recent content by Sam63

Question about VB 6.0 interface that accesses a MS ACCESS 97 database. The connection on the form is via ADO control for all functions except in the ADD RECORD button it is via ODBC. On my PC and most everyone elses in my department the ADD works fine, so does the delete, and update. There...

I need to get a random number from a set of numbers that may not be consecutive, i.e. 6, 10, 14, 18 or 2, 4, 6, 8, 10 Math.floor(Math.random * x) does not do this. Any suggestions??

I am familar with using Math.random()... i.e. var i = Math.floor(1 + Math.random() * 10); but I'm not sure how to get a random number in a set of numbers i.e. 2, 4, 6, 8, 10 ....any suggestions. Sam

I did some research on MSDN. Apparently, when you use ADO and DAO recordset objects in the same application you get this error. You have to specify in the declaration of the recordset variable which type you are using. i.e. Dim adoRS as ADODB.Recordset Dim daoRS as DAO.Recordset *** see...

yes, all three ways. I'm thinking the type mismatch has something to do with the recordset variable.

I have tried these suggestions and still receive the error. Any other suggestions? Sam

strBPS is a global variable used throughout my program and does not present an issue with any other code. Even if I assign the variable value explicitly I still get the type mismatch error. Sam

yes, fldEmployeeID is a string. I use UPDATE queries all the time using this field and criteria. Problem is I can't create a recordset object. I keep getting the type mismatch error, even if I remove the WHERE clause.

I keep getting a type mismatch error on the following code. The problem is with the set rst statement. Dim db As Database Dim strTime As String Dim rst As Recordset Dim strMySql As String Set db = DBEngine.Workspaces(0).OpenDatabase("P:\Pension\CheckLOG\BD Check Log.mdb")...

I just have a severe corruption problem. The backend database corrupts about twice a month. I cannot figure out why? and most times I can't repair it, I have to have it restored from LAN backups. Sam

The database is opened and closed frequently by users (approx 50 people). Problem is some sit in it overnight while our LAN does backups and this sometimes corrupts the database. I've figured out how to log people out automatically at 6pm, but haven't worked out the repair so that the first...

I have a vb6.0 interface connecting to a ms access database. The database frequently gets corrupted and I cannot figure out why? Two questions? Can I repair the database from code in vb6.0? Can I run a vb6.0 interface and connect to a .mde file rather than a .mdb file? Supposedly the .mde...

Can you use a VB6.0 interface to connect to an .mde file? Sam

what is an update query??? Sam

I'm getting the run time error: Insuffcient base table information for updating or refreshing. I am designing a login screen and I want to update a boolean field that indicates that someone is logged into the database. I have the login working but cannot get the record to update because of...