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!

  • Congratulations bkrike 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: *

  • Users: francky
  • Content: Threads
  • Order by date
  1. francky

    How to delete a form in the microsoft visual basic window

    My database is corrupted. In the visual basic windows, a form appears but does not exist. When I open my database, I receive a message : "Erreur d'accès au fichier" (in french) How can I delete this form ? I tried to create a new database and import all the objects but without...
  2. francky

    Disable the msgboxes macro and links when open an excel file

    All is in the subject How can I do to disable the msgbox "Activate macros" ? How can I do to disable the msgbox regarding the links AND DISABLE THE LINKS !!! Thanks in advance Francky
  3. francky

    how to define a recordset

    I want to read the table A and write in the table B Table A Field1 Field2 AA 5 BB 3 CC 2 Resutl in the Table B Field1 AA AA AA AA AA BB BB BB CC CC But how to define the recordsets With access 97 Dim db as database Dim A as...
  4. francky

    how to unlock a recordset

    When 2 persons use the same form, the second can't confirm his operation Here is the code : Dim cn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim StrSql As String Set cn = CurrentProject.Connection cn.BeginTrans StrSql = "Select * FROM QryEtik WHERE etservice =" & Chr(34)...
  5. francky

    how to define the current database

    I have a problem with this source code : A message box appears : Erreur d'exécution '-2147220999 (800401f9)' "La méthode 'Connection' de l'objet'_CurrentProject' a échoué ------------------------------ Dim cn As ADODB.Connection, Rs1 As ADODB.Recordset, SqlCode As String Set cn =...

Part and Inventory Search

Back
Top