Recent content by earls

Thanks for the input all, I’m going to try and do more research modifying current setup. If I don’t find a solution tomorrow I will start on building something in google places api. Colin thanks for visual it’s given me a true idea what places api can do.

The access program ties into a PowerApps app that utilizes GPS to navigate employees to customer’s home for pick-up and transport to dr. offices. Problem is human error when creating new customer or destination records (typing errors with addresses, Names), the left window of maps allows me to...

looking to modify google maps window within an access form. Currently ave a map with location info, interested in the left side only location info as i do not need map. Hoping someone has an idea, I've upload screenshot (blue is what I want to eliminate) and access file along with code. Thanks...

I took your suggestion, seems to work will know more tomorrow after end-user test. Thanks.

Initially was getting periotic errors due to font in report (was using Calibri Font), three-page pdf’s became 500kb each. Changed font to Times New Roman now reports are 8kb and running perfect on local computer in batches of 50 reports (my computer), but when running on VM it has periotic...

I have a form that I mark jobs to save as individual pdf’s (than print at different offices), code is below. I don’t want to mess with a union query as everything else is running perfect and it stores values in query, i don't think a union query can store values. I was really hoping to...

I have a report (image below) that is printed for employees to have signed after each leg of a trip. A job can have two legs (two pages to be signed) or a job can be a one-way trip (one page to sign). How can I make it if a job has one leg one page prints (not two), two legs two signature pages…...

A million thank's. worked perfect, just did a large scare run with no issues and perfect results.:D

You are correct about original post being different, went back to source db to start from scratch. Yes the code works, but I’m trying to change the out of the filename to something meaningful. Currently have output file of 175.pdf want it to be Dallas-1-81882.pdf. it's the same record. don't...

I have spent all day working on this problem, so decided to work backwards and start with the version I know works (part of Northwind DB). When I started this journey, I did some research on approaches and found this DB. Originally, I was using only parts of the code in my db but this morning I...

Thank you everyone for your help, below is the outcome of each suggestion. Code gave me correct file names but dumped all records in each file. Option Compare Database Option Explicit '*************************************************************************************** ' Module ...

Was able to comment out “' Dim blRet As Boolean 'NOT USED” and system performed like normal. Tried commenting out lines below. 'What do these 2 lines actually do as they don't seem to be used for anything! 'Try commenting these out as well strSQL = Left(strSavedSQL, InStr(strSavedSQL, ";") -...

Note table name and query do not match original, wanted to clean code for reader/newbie. made changes you suggested and compiled with no issues, code below runs perfect, except the first record gets everything dumped in it. I appreciate you taking the time to help. Private Sub...

Thanks for your help. I’m a novice and the code was created by someone else, I have made minimal modifications to it to get it to this point. Several things 1. Which contains all the records? The first or last presumably? tblTrips contains all records. 2. Why do you set qdf.sql repeatedly? I...