Recent content by reidfl

I solve the issue. I just split the database to a front end and back end. Problem solved. "Keep Your Code Tight"

I'm writing code to populate a drop down box using Access 2000. When I open the form I get the following error message (error occurs with cnn.open) " -2147467259 The database has been placed in a state by user 'Admin' on machine 'XYZ' that prevents if from being opened or locked" Has...

Hi, This will solve your problem. Steps: 1. Copy the database (.mdb) to your system 2. Right click on the .mdb file and select properties 3. Remove the check from the read only attribute. 4. Change your connection string to the appropiate drive\path\filename "Keep Your...

Hi, Change the field (mailing) to accept NULLs. Also data type bit only allows 0 or -1. Using 1 as a default value for a bit data type will give you fits. "Keep Your Code Tight"

Change the combobox style property to 2 (dropdown list). reidfl "Keep Your Code Tight"

The checkbox style property is read-only and can only be set at design-time. You may want to consider using the toggle button component. This component can be found by adding the "Microsoft Forms 2.0 Compenent Library" to your project. Reidfl "Keep Your Code Tight"

Running Win2k reidfl "Keep Your Code Tight"

I'm using MS Outlook and the sendobject works just fine. The issue is with Lotus "Keep Your Code Tight"

This should solve your problem. Change the EOFAction property to 2-adDOAddNew in the design-mode. By the way I highly recommend use ADO the data control is very restrictive. reidfl "Keep Your Code Tight"

stnkyminky, I ran your code and made the following corrections. The code connected and disconnectd from the database and released the lock on the database. Option Explicit Dim Project_My_Conn As ADODB.Connection Dim Project_rs As ADODB.Recordset Private Sub Form_Load() ProjectConnect...

Place you disconnect code in the unload event. By the way you may want to take a look at using ADO reidfl

Sypher2, Add the commondialog control to your form(s). I normally add print menu option to my applications and use the below listed code snippet to print forms (hasn't failed me yet). Private Sub mnuPrint_Click() On Error GoTo CancelError Dim iNum As Integer With CommonDialog1...

Are you accessing MS SQL Server? Why would want to create your stored procedures in VB? I would recommend creating them on the Server (MSSQL). reidfl

Have to tried repairing the database? You can find this feature in the tool menu under Database Utilities. reidfl

You must use the UPDATE method of recordset. Example: sRTF = Replace(rtfTasks.TextRTF, "\ulnone", "\ul0") rsActive("Tasks") = sRTF rsActive.update ErrHandler: if err then rsActive.cancelupdate end if reidfl