Search results for query: *

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

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

I'm trying in code to send a screen image of the active form. I've got the email part working to via the DoCmd.SendObject method, however the acForm sends the underlying table picture not the Form view of the active form. Please, let me know .... is it possible to send a capture of the active...

I'm familiar with writing SQL statements in code but the one that I'm working on currently is giving me a headache. I'm trying to narrow my records set to records that match three criteria. One is a numeric field the other two are boolean fields. Right now the query is only returning the...