Search results

  1. G

    Replace

    I had some issues yesterday where excel and word wont open IT reinstalled my office suite, I believe from 32bit to 64bit There after word and excel opened but non of the functions calculates This code in Access word fine for the past 2 year and after the update i am getting quite a few issues...
  2. G

    Replace

    um, no? :)
  3. G

    Replace

    Yes, this is a query
  4. G

    Replace

    Still getting the same error after breaking down the code Replace seems to be giving a compile error
  5. G

    Replace

    Hi all, Please could you advise in any annunciation in the below code Replace could be the problem here I am getting a visual basic module containing a syntax error, compile error
  6. G

    Password masked inputbox

    Hi all, Hope all is well Please could you advise on converting below code for 32 and 64 bit computers
  7. G

    Only update if today's date is not in the table being updated

    Hi all, Please could you assist I want to update a table from another table If the record does not exist, it must be updated If the the record exists and the date updated in the same as todays date in the table being updated (IW73 - Project Leader - History), the record should not be updated
  8. G

    Object invalid or no longer set

    So I found where the error is When I select location downloads on the local pc the error occurs When any other location is selected, there is no error Very strange There is no limit on the size of the download folder as per IT, but I just cleared my folder and it seemed to work
  9. G

    Object invalid or no longer set

    My error is in Which does not make sense as when I open the same file from remote desktop, there is no error
  10. G

    Object invalid or no longer set

    I have the file extention set
  11. G

    Object invalid or no longer set

    it is is an extract to excel
  12. G

    Object invalid or no longer set

    The code works when I run the same copy of the front end on our remote desktop directly from the server though
  13. G

    Object invalid or no longer set

    strGetFileFolderName opens the file save as window to select the location Debug.Print StrFileName gives the desired output
  14. G

    Object invalid or no longer set

    I am not getting an error or any specific line, just the object invalid error when executing. Error happens after I have selected the location to save the file. So not sure where anything went wrong as tis was working well. No changes where made to the code All I amended was setting I disabled...
  15. G

    Object invalid or no longer set

    Hi all, I am getting an object invalid or no longer set on the below code I am no sure why as this has been working fine for months Please could you lead me in the right direction to trouble shoot The query seems to be working correctly
  16. G

    Iff

    Thank you This seems to work quite fine Trying to use the same code on a form
  17. G

    Iff

    My very first post requests all records to be displayed when dummy = 0, if no dummy = 0 then display only Dummy = -1 I used the iff statement as a field value and also tried in criteria Each record with unique sequence will have a dummy record = 0 if there is a record with a dummy -1 Some...
  18. G

    Iff

    [Material Data File] is a table yes
  19. G

    Iff

    Still getting incorrect result
  20. G

    Iff

    Yes this is a report Your criteria is exactly what I need
Back
Top Bottom