Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. reidfl

    Access 2000 error -2147467259

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

    Access 2000 error -2147467259

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

    ReadOnly Database Access

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

    sql problem

    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"
  5. reidfl

    Combo Box - How to Look Ahead / Auto Fill as you type ?

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

    Dynamically created checkboxes - how to make graphical?

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

    LockType / Cursor Type

    Running Win2k reidfl "Keep Your Code Tight"
  8. reidfl

    sendobject problem

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

    Hi VB experts - I posted in the

    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"
  10. reidfl

    LockType / Cursor Type

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

    LockType / Cursor Type

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

    PrintForm method doing odd things

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

    Hi, Is it possible to create a S

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

    Unrecognized DataBase Format?

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

    Recordset Update Problem

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

    Retrieving TEXT data type from a VB app

    It looks like your coding with DAO. Try coding you data access with ADO (highly recommeded). Keep'n it simple reidfl
  17. reidfl

    How can I disabled at run time, a button created at design time with t

    amarti44, Here is a small code snipet that will solve you problem. Private Sub Form_Load() Toolbar1.Buttons(1).Enabled = False End Sub Keep'n it simple reidfl
  18. reidfl

    Importing Text Data using ADO

    Need to know the symptoms. What problem or error are you getting? reidfl
  19. reidfl

    Validating contents of a text box??

    ftpdoo, This code snipet should do the trick. Private sub Text1_Validate(cancel as boolean) if InStr(1, UCase(Text1.Text), "INSERT INTO") Then MsgBox "Insert Into" ElseIf InStr(1, UCase(Text1.Text), "DELETE FROM") Then MsgBox "Delete From" ElseIf...
  20. reidfl

    Proper way of making a MDI application

    MrMooCow, This is how I create a new form. Dim frm(1) as new form1 frm(1).show It work's every single time reidfl

Part and Inventory Search

Back
Top