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

    append records in sql Server table from MS access table

    Yes, after droping the table I have recreated the table. Then tried to insert records. I am able to insert records manually from MS access but not able to add new new records using VBA
  2. rkinfo

    append records in sql Server table from MS access table

    How can I append rows to SQL server table from an MS access table? My module was working fine to insert rows to linked sql server table but since I have dropped SQL database table I am not able to append rows. Although I am not getting any error message
  3. rkinfo

    Insert rows into SQL server 7 using MS Access 2003

    How can I append rows to SQL server table from an MS access table? My module was working fine to insert rows to linked sql server table but since I have dropped SQL database table I am not able to append rows. Although I am not getting any error message
  4. rkinfo

    call oracle procedure with in out parameter from ms access

    I am trying to run a pass-through query as following. Set qdf = db.CreateQueryDef("") qdf.Connect = "odbc;dsn=oraacc;uid=msgdrss;pwd=gdrss;server=gdrss" qdf.sql = "BEGIN keepcompile(TO_DATE('" & Format(StartDateTime, "MM/DD/YYYY") &...
  5. rkinfo

    Read Only form

    My table was read only, Changed access to table and it worked. Thanks
  6. rkinfo

    Read Only form

    All these settings are same
  7. rkinfo

    Read Only form

    I have copied a form from one data base to other. I changed to read only form and it is not allowing me to add or edit any record? How to make it wriable form?
  8. rkinfo

    run time error 3065: Can not execute select quer

    Finally: It worked strIN = "INSERT INTO xdatafactorS( MeterID, DATE_, AFApplied, ISDefault, CALCDATETIME, PeriodGrpID) " & _ "VALUES (" & Meterid & ", TO_DATE('" & Format(dateset, "MM/DD/YYYY") & "','MM/DD/YYYY'), 1, 1, TO_DATE('" & Format(Now(), "MM/DD/YYYY HH:MM:SS") &...
  9. rkinfo

    run time error 3065: Can not execute select quer

    It did not work. I think it has some issue with date format as I was able to insert a record if I try to insert string/varchar2 instead of ddate.
  10. rkinfo

    run time error 3065: Can not execute select quer

    Now I am getting error runtime error 3146 odbc-call failed I tried both the syntax strin = "INSERT INTO xdatafactorS( MeterID, DATE_, AFApplied, ISDefault, CALCDATETIME, PeriodGrpID)" & _ "VALUES (" & Meterid & ",# to_date(" & dateset & ",'dd/mm/yyyy')#, 1, 1, #to_date(" & dateset &...
  11. rkinfo

    run time error 3065: Can not execute select quer

    I am trying to indert record in oracle database and getting error run time error 3065: Can not execute select query Any idea? strIN = "INSERT INTO xdatafactorS( MeterID, DATE_, AFApplied, ISDefault, CALCDATETIME, PeriodGrpID)" & _ "VALUES (" & Meterid & ", to_date(" & dateset &...
  12. rkinfo

    insert recordin oracle from access database

    How to insert records in oracle database from access? How can I pass present time to oracle date field?
  13. rkinfo

    Access front end Oracle back end

    How to create connection in access module?
  14. rkinfo

    Access front end Oracle back end

    Will you provide me vb code as I have already configured odbc connection?
  15. rkinfo

    Access front end Oracle back end

    How to set up connection with oracle database using odbc connection
  16. rkinfo

    Access front end Oracle back end

    I have migrated my MS Access database/sql server to Oracle but front end is still MS Access. I have created ODBC Connection. I need to change modulesso that it points oracle database insted of pointing to ACCESS /SQL Server database. I have couple of 1) When should I prefer to use linked table...

Part and Inventory Search

Back
Top