Search results

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

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...

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...

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...

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...

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...

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...

I have an Access form that is tied to a recordset. When I Set Focus on 1 text box in particular, I move the caret with the keyboard arrows left-right, and the caret moves and flashes on top of the text characters, basically overlaps the character. When I then try to delete or edit the text, it...

Is it possible to set a property to allow the user to click and drag an open form out of the Microsoft Access 2010 parent window? Specifically to a second monitor.

Good Morning All, I am wondering if it is possible to look up the MAC Address of the WIFI access point of which the computer is connected to? I work in an Enterprise environment that has multiple access points and would like to document the AP mac address periodically through MS Access VBA to...

I am looking to loop through all of the rows in a listbox. For each row in the listbox, I want to check if the last name in the Labor column is contained in any records in the Labor column of a recordset. If it is contained, add the column value to a variable to eventually be shown in another...

I am trying to zoom in a PDF document that opens in a webbrowsercontrol on an access form. I currently am trying to use SendKeys for the zoom in. Here is the code I am trying to use for zoom in. The problem I am having is that when I click cmdzoomin, the PDF rotates clockwise, doesn't zoom...

I have a report that has and 8.5x11 image control on the page. Background of the report: I am using VBA to scan documents in as jpeg files and then using the access report to combine the jpegs and then convert them to 1 pdf document. This process works fine, the issue I am having is when I...

I am trying to copy a form from an accdb database to an mdb database. The form copies fine but when I open the form in Design view, the Web Browser Control is not there. When I try to copy the WBC over from the accdb to the mdb, an error message shows that says "The Web Browser Control is not...

I have a date/time text field on a form with the General Date format and a combo box next to it that has sequencial times as the row source (IE. 12:45 AM, 1:00 AM, 1:15 AM, 1:30 AM, ETC.) When the user chooses a time in the combo box, I want the time portion of the text box to be updated with...

I need to check the recordcount in a subform of a navigation frame form in VBA. Anyone know the proper syntax. I have tried multiple things but cant seem to get it. I would rather not use dcount.

I am kind of new to Access and VBA so please bare with me. When I originally created my access database, I used a text field/column to connect 2 tables together. I would like to change this to reference the Primary Key/ID column instead of the text field. Is there an easy way to go about doing...

I am trying to run a query and filter it by the current authorized user id in my database. =DLookUp("property","tblwoOption","[userid] = #" & auth.userid & "#") auth.userid is in a class module that should show the current user id number and for some reason it isn't working. When I try to run...

I am trying to Run an Append Query using VBA. I cannot seem to get it to work. I am getting syntax error when I try to run it. Can someone take a look? Private Sub cmdloaddefault_Click() DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO tblschedule_lineitem ( labor_name, shift, location...

I am trying to check if a value that is entered into a combo box currently exists in a table, and if it doesn't then I would like to insert it. This is the code that I have come up with but I can't seem to make it work. Any help would be great. Private Sub cboreason_AfterUpdate() If...