Search results

  1. A

    Closing your data base

    Is it appropriate to close out of your database by just closing Access. Could it cause corruption??
  2. A

    The DCOUNT Function

    I tried this and I just keep getting problems with it Error message attached Me.TotNoForSaleFld = DCount("VehicleId", "Vehicles", "[BuyerId] = 0 And [ClientId] = " & Me.ClientsIdFld) Any Help wou;r be appreciated
  3. A

    Access for Office 365 is only opening Acrobat Reader not Acrobat Pro

    When I'm in my Access project and I Application.FollowHyperlink LWordDoc - Where LWordDoc = the location and file name of the file I want opened. in This case the file is a pdf The above opens my pdf document in Acrobat Reader when Acrobat Pro is available. Outside of my...
  4. A

    How can I monitor a field in a table

    I have created a table data macro that will send me an email on after change and the value equals zero
  5. A

    How can I monitor a field in a table

    😃😃
  6. A

    How can I monitor a field in a table

    I don't believe they are It makes more work for every one
  7. A

    How can I monitor a field in a table

    Galaxion, No it's definitely a field that had a value and now it's zero.
  8. A

    How can I monitor a field in a table

    I have a field in a table that randomly changes back to zero. In the program that updates the field as it should is fine, it updates it as it should. I have been right through all update queries that are used else where and not one update touches that field. I have had a look at the...
  9. A

    Can I check if a form is open in one of my query fields

    If a particular form is loaded I want to use a data field from it in my query, if not the field will be left blank. My code is 153: IIf (CurrentProject.AllForms("AddSTraceFrm").IsLoaded = True, DLookUp(" [SkipTraces]![TaxInvNo] ","SkipTraces"," [SkipTraces]![SkipTraceId] =...
  10. A

    Overflow error

    Thank you - fixed (y)
  11. A

    Overflow error

    Run time error 6 Overflow Dim intUniqueNo As Integer Happens after intUniqueNo = DMax("DocId", "DocumentLibrary")
  12. A

    Copying files selected by the user and then saving them in a nominated folder

    Once again thank you
  13. A

    Copying files selected by the user and then saving them in a nominated folder

    I tried with the filename in the destination and it worked. No error I tried it with 1 document, then many - all OK Thanks guys
  14. A

    Copying files selected by the user and then saving them in a nominated folder

    Do I need a filename in the destination address?
  15. A

    Copying files selected by the user and then saving them in a nominated folder

    Minty this is what is printed \\DC01\Togas\TOGAS\ClientMergeFiles\87207-Searcode-haleys.docx \\DC01\UserDir$\JohnHaley\Documents\CopyTo\ arnelgp the above is exactly what I'm after. I select the documents from from the selected list and move them to the given folder
  16. A

    Copying files selected by the user and then saving them in a nominated folder

    I have a document library table , that holds all documents generated and imported for clients. The entries displayed in the clients document library is relative to that client only. The document entries in the document library don't carry the physical file only the files physical name. I am...
  17. A

    Using a variable to change the record displayed in a form

    OrderNumberFld
  18. A

    Using a variable to change the record displayed in a form

    I Have tried the above and it comes back with RT Error 2110 The system can't move the focus to the control OrderNumberFld I then commented out the control setfocus lines and got RT error 2046 The command or action 'FindRecord' isn't available now
  19. A

    Using a variable to change the record displayed in a form

    I tried FindRecord and now I get a data type mismatch - Runt Time error 13
  20. A

    Using a variable to change the record displayed in a form

    The second subform has eight fields that I can enter data and then on the On After Update event it goes to a Private sub Private Sub SearchOrderNumber_AfterUpdate() Dim FindOrderNumber As Long FindOrderNumber = Val(Me.SearchOrderNumber) DoCmd.GoToRecord acDataForm, "OrdersFrm", acGoTo...
Back
Top Bottom