Search results for query: *

I'm using VB 6 SP5 with Access 97. I created a database app in the textbook fashion using ADODC's. Now that I'm in the testing phase, I'm finding all manor of problems with multi-user access using ADODC. I need to reconfigure my application so that I have one connection string, one connection...

I have a datagrid that displays an age (in years) based on a date of birth (mm/dd/yyyy). The following SQL is the data source for the grid. I want to truncate the Age field such that only the whole number appears, rather than a number with decimals. I tried using Format$ to format the result...

I'm trying to make a menu editor that functions similar to the way that MS Office apps do. I have a File/Close menu option in the MDI application, but I can't figure out how to code it. If the user clicks close (or uses the shortcut) I want to close the MDI child that has focus. I want the...

I declared a Public Constant in a .bas module. Public Const iConnectionString As String = _ "Data Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\TCJPD\VB Project Files\Test_TCJPD_Data.mdb;" & _ "Jet OLEDB:Database Password=tcjpd" Now I'm trying to...

I'm using VB 6 SP5 with an Access 97 database. Here's the scenario: I call AddNew on a recordset, change some fields in the recordset and then call Update. The recordset is still on the same row and then I change one of the fields, and then call Update again. When I do this, I get: Run-time...

I have an MDI application. At times, I need to make a call to a form only if the form is loaded. So, for instance, I might have a line of code on frm1 that says: With frm2.Adodc1 .commandtype = blah .Recordsource = blah .refresh End With There are two problems: I only need to perform...