Search results

  1. P

    Syntax Error Missing Operator

    So simple but eluded me... thanks guys... worked perfect
  2. P

    Syntax Error Missing Operator

    I have a form for looking up records. There is a text field on the form to put in a number that can be found in the table (tbl_data) field named 8DNumber which is a number field. A subform in datasheet view is on the form to show the results of the search with the linked fields being 8DNumber...
  3. P

    Check for newest DB version?

    That is a good idea about the message box... I think I will do that... as far as connecting to their computer... they are in Viet Nam... and I am not a network admin so this probably will be difficult. Maybe I can catch them tonight (their morning) over Skype for business and have them allow me...
  4. P

    Check for newest DB version?

    The printout is UPDATE tbl_users SET Version = 'v018' WHERE ID = 1 ID = 1 is my login I tested the users login that is having the issue on my computer and their login works and their version number is already correct because I haven't published any updates in weeks. I asked them to send me a...
  5. P

    Check for newest DB version?

    This is the whole block of code Private Sub Form_Open(Cancel As Integer) Dim dbs As DAO.Database Dim FEVersion As Variant Set dbs = CurrentDb If Credentials.AccessLvlID = 0 Then DoCmd.OpenForm "frm_loginform" Cancel = 1 End If If Credentials.UserId =...
  6. P

    Check for newest DB version?

    I don't have an issue on my computer... it is happening to one of my users overseas. I have no idea what version of office they have or what version of windows they are using. Terrible language barrier and always 24 hours delay in getting answers
  7. P

    Check for newest DB version?

    I do not know how to do that
  8. P

    Check for newest DB version?

    Sorry to post again in this long thread but Microsoft has done something to access that is causing this line to throw the 3144 Syntax error in UPDATE statement error DoCmd.RunSQL "UPDATE tbl_users SET Version = '" & FEVersion & "' WHERE ID = " & Credentials.UserId What is wrong with the syntax...
  9. P

    Access closing unexpectedly after editing VBA

    Have you tried removing that? Does it crash as you described if you open the database by holding down the SHIFT key and clicking the DB? That should bypass the AutoExec and any other code.
  10. P

    Best Practice for deleting single record from sub form

    I always read and try to help... most times I am not smart enough to help :rolleyes:
  11. P

    Best Practice for deleting single record from sub form

    Sorry about that Colin... I didn't know you had given him code already and the code I posted is from my database (I found it somewhere else) for a form I am working on.
  12. P

    Best Practice for deleting single record from sub form

    use this Option Compare Database Option Explicit Private Sub NameOfYourDeleteButton_Click() Dim strSQL As String strSQL = "DELETE NameOfTable.* FROM NameOfTable WHERE (((NameOfTable.NameOfPrimaryKeyField)=" & Me.NameOfPrimaryKeyField.Value & "));" CurrentDb.Execute strSQL...
  13. P

    Delete created folders when deleting record

    Indeed... the users will name the attachments the same all the time i.e. IMG 1.jpg, IMG 2.jpg etc. which is the reason for the folder creations the way they are. I also do not want to delete any attachments ever unless a record needs to be deleted for whatever reason. I have reports that access...
  14. P

    File copy problem

    Did I actually help someone for a change?!!
  15. P

    File copy problem

    Shouldn't that be: FileStructure = "\\CMASERVER\Data\Louise\SLA\" & msCustomer & "\" & msDate & "\" & msDateFull & " - " & msJob & "\Measurement Report\" & msMethod & " Measurement Report.xlsx" FileMove = "\\CMASERVER\Data\Louise\SLA\Report Masters\" & msMethod & " Measurement Report.xlsx"
  16. P

    File copy problem

    Your code shows .xlxs as the file extension but it should be .xlsx
  17. P

    Delete created folders when deleting record

    I am asking for help on another part of the attachments thread located here: https://www.access-programmers.co.uk/forums/showthread.php?t=247009 I didn't want to add it to the bottom as it is already 3 pages long. Ok... I have an attachments form opened via command button on a form that...
  18. P

    Run-Time Error 3197 (please read anyway)

    In the mean-time... the child table worked to solve the 3197 error
  19. P

    Run-Time Error 3197 (please read anyway)

    I think the misunderstanding may be my lack of explanation. There are not 3 subforms trying to update the same record at the same time. Depending on situations... the 3 subforms may not be used at all... depending on other situations... only one subform OR the other OR the other will be trying...
  20. P

    Code to Upload and Save Attachments External to Access 2007

    That has been worked out in the code I posted above above. @AlphaMike... The code I posted above will do all of that. You will need to change the directory creation code to meet your needs and change it from a WAN address to a LAN address (g:\AllEmployees\DestinationFolder\). From the code...
Top Bottom