Search results

  1. J

    GPS

    Has anyone had any luck with getting GPS coordinates of a tablet from Windows 10 using VBA?
  2. J

    Using FileCopy then deleting the Source Folder

    I was trying to delete it right from the explorer window.
  3. J

    Using FileCopy then deleting the Source Folder

    After doing some further digging, I came across the CHDIR function. This allowed me to change the current directory to something other than the source folder. Once I ran this function, I was able to delete the source folder.
  4. J

    Using FileCopy then deleting the Source Folder

    I am using FileCopy to copy a PDF file from my local hard drive to a network share. The FileCopy part works fine but when I go to delete the folder that the source file is stored, it tells me that the file or folder is in use by another program. One thing that allows me to delete the folder...
  5. J

    VBA FileDialog InitialFileName with Outlook mail Attachments

    I am trying to have a file dialog open to the outlook attachments folder to allow the user to copy the attachment to a file store. When I set the outlook attachment file path as the initialfilename in the dialog, it defaults the initial folder to My Documents. Any thoughts? Private Sub...
  6. J

    Need assistance writing SQL for form recordset

    Your right, there really is no reason to query status at all because all records will either be OPEN or CLOSED. Works good. Thanks! Private Sub FormDef() If ErrOn Then On Error GoTo ErrorHandler If Len(cboStatus & vbNullString) = 0 Then MsgBox ("Choose a Status.") GoTo...
  7. J

    Need assistance writing SQL for form recordset

    Parenthesis around the Or criteria worked... Thanks! Select Case cboStatus Case "ALL" strStatus = "and (Status = 'OPEN' or Status = 'CLOSED') " Case "OPEN" strStatus = "and Status = 'OPEN' " Case "CLOSED"...
  8. J

    Need assistance writing SQL for form recordset

    Can anyone tell me what could be wrong with the SQL string this code generates for strFinal variable??? When it runs, it doesn't take into account the strUser filter when cboStatus case = "ALL"... Cannot figure it out... I included strFinal output below: Private Sub FormDef() If ErrOn Then On...
  9. J

    Unrecognized Database Format Error Displays

    My database is built in Access 2016. When I try to open it, I get the error message "Unrecognized Database Format" followed by the file path. When I click OK, the database closes. It wont let me compact and repair. Decompile switch does not change anything either. The only thing I can think of...
  10. J

    Trigger Windows 10 On-screen Keyboard using VBA

    I was able to create this subroutine to make the keyboard show. Thanks for the post!
  11. J

    Trigger Windows 10 On-screen Keyboard using VBA

    My apologies if this question has already been asked and if so, I cannot seem to find it. I am working on building a front-end Access database that will be running on a Windows 10 Tablet. What I would like to be able to do is trigger the tablet on-screen keyboard that shows up when you click...
  12. J

    Change printer settings with code?

    I am having the same probel as you. I need to be able to programatically change the page size on the printer. Have you found any good ways to do this?
  13. J

    Recordset Findfirst Syntax

    I ended up changing the way I lookup the record. It is working good now, thanks for your help! Dim db As DAO.Database Dim rs As DAO.Recordset Dim strWO As String Dim strPoint As String strWO = Forms!frmdsh_workorder!txtWO Set db = CurrentDb strPoint = "GMP's" Set rs =...
  14. J

    Recordset Findfirst Syntax

    I made the changes that you suggested. When I run the Function now, Access freezes and crashes when I run it like this: Dim db As DAO.Database Dim rs As DAO.Recordset Dim WO As String WO = Forms!frmdsh_workorder!txtWO Set db = CurrentDb Set rs = db.OpenRecordset("tblwoinspection"...
  15. J

    Recordset Findfirst Syntax

    I am trying to lookup a record in a recordset. If no match is found then run an append query. I am having trouble coding the findfirst syntax. Any help is appreciated. Dim db As DAO.Database Dim rs As DAO.Recordset Dim WO As String WO = Forms!frmdsh_workorder!txtWO Set db = CurrentDb...
  16. J

    Caret overlapping text when typing and moving

    I changed it in the text box properties only and it seams to have solved the issue. Thank you for the assistance.
  17. J

    Caret overlapping text when typing and moving

    I would like to be sure that the text isn't permanently changed after I make the text format "Rich Text". This is something I haven't done before.
  18. J

    Caret overlapping text when typing and moving

    Do I need to change the text format to "Rich Text" in the table before I change it on the control?
  19. J

    Caret overlapping text when typing and moving

    Do I need to change the text format to "Rich Text" in the table before I change it on the control?
  20. J

    Caret overlapping text when typing and moving

    Here is the result from the same text in the video.
Top Bottom