Recent content by gianniskar

  1. G

    Run-time error '3020': Update or CancelUpdate without AddNew or Edit

    ok.Another question.Can i clear logs ? i mean i want log for 1 year then clear logs and start again log from start Maybe i am thinking wrong....
  2. G

    Run-time error '3020': Update or CancelUpdate without AddNew or Edit

    Can you explain me about that?
  3. G

    Run-time error '3020': Update or CancelUpdate without AddNew or Edit

    thanks but after put these code you tell me i have error again "you must use "dbseechanges" at this line now "db.Execute "Update tblLog Set CloseDateTime = '" & Format(Now, "yyyy-MM-dd hh:mm:ss") & "' Where LogID=" & LastID" and add db seechanges at the end of line db.Execute "Update tblLog Set...
  4. G

    Run-time error '3020': Update or CancelUpdate without AddNew or Edit

    ok i did that.Now i have 2 errors 1) you must use "dbseechanges" ....I tried with that "set rs =db.OpenRecordset("select * from tblLog Where (1=0);",dbseechanges) but not fixed 2)error "3075".Missing operator "2020-08-11 12:48:27" in this line "db.Execute "Update tblLog Set CloseDateTime = " &...
  5. G

    Run-time error '3020': Update or CancelUpdate without AddNew or Edit

    thanks for help.I have error "method or data not found" in this line Set db = DBEngine.Workspace(0).Databases(0)
  6. G

    Run-time error '3020': Update or CancelUpdate without AddNew or Edit

    hi.I have my access tables to sql server and i have this code to "log" forms or reports when closing or opening in sql server.This function working when table is on local pc but when is in sql server and i am trying to close form i have this error "Run-time error '3020': Update or CancelUpdate...
  7. G

    Compile error-ambiguous name detected :sleep

    ok .Sorry for this.Thanks for any help who gave to me all of you
  8. G

    Compile error-ambiguous name detected :sleep

    yes i have 1 another error .Can you unzip now and check mysleep function?
  9. G

    Compile error-ambiguous name detected :sleep

    i cant.its says The uploaded file is too large. 1.4mb
  10. G

    Compile error-ambiguous name detected :sleep

    ok. CJ_London you said to rename function sleep to mysleep to avoid error ok?Then i did that and uploaded the attach file (https://easyupload.io/tjp092 ) to see my changes if is it good.
  11. G

    Compile error-ambiguous name detected :sleep

    ok.So in my last attached file,is it wrong the changes who i made sleep-->mysleep?
  12. G

    Compile error-ambiguous name detected :sleep

    sleep function what really does doing in access?
  13. G

    Compile error-ambiguous name detected :sleep

    https://easyupload.io/tjp092
  14. G

    Compile error-ambiguous name detected :sleep

    pease check my attached file.i believe i made all changes
  15. G

    Compile error-ambiguous name detected :sleep

    well i change again private Sub mySleep(sngTime As Single) to Public Sub mySleep(sngTime As Single) in a module BasShared and i changed name then i changed from form frmEntry_Main the Public Sub HotSpotClick(sControlName As String) On Error GoTo PROC_ERR...
See more
Top Bottom