Search results

  1. J

    Show number of customers per zip code on a map

    Is it possible in Access to create a Form or Report that will show a map (like Google Maps) that shows our 4 Retail Store Locations and then all the Zip Codes around the store and the number of Customers that have addresses in each Zip Code? This may be too complicated for Access? thanks!
  2. J

    Solved Use VBA to Hover over field with mouse causing another form to popup

    I have a continuous main form that has a button on it that opens another form with more information about that particular record that the button was on. I want to just hover over the line on the main form and have that same form with the extra info pop up, then close when the mouse moves off...
  3. J

    Creating an inventory system for serialized products

    I have a well developed inventory system for our company that buys and sells roughly 4000 products. Currently, none of them are serialized. So, to report the inventory value each month (or on demand), I use queries to determine how many of each product we have in each of our 30 possible...
  4. J

    how to unlock one field on a locked subform

    I have a main form that locks the one subform after 12 hours. I need to be able to keep just one field on the subform unlocked at all times. There are too many fields on the subform to lock and unlock each one indivdually. Right now I just lock the whole subform and unlock the whole...
  5. J

    Print Preview and Print to Paper and Print to PDF all changing my Report totals

    I have a Summary Report in Access 2019, running on a high-powered PC with Windows 10 Pro and all updates. It is based on a Summary Query, which in turn, is based on a “Base” Query. The report runs fast and fine as a regular report, but when I change to Print Preview, or try to print on paper...
  6. J

    Error 91

    I have the code below that is supposed to check if a record is locked by any other user, and if so, pop up a warning message. The oncurrent event runs this single line: DisplayLockStatus. It seems to work fine when User1 is in a record and User2 tries to view that same record, but the...
  7. J

    Tab Key causing Access to Crash after open a report

    Very strange. i have an Access 2019 report that opens just fine and filters and prints fine and closes fine, but if I open it and then the very first action is to hit the Tab Key on my KB, it crashes Access. Using Windows 10 Pro with all updates and Access 2019 and the same issue occurs on all...
  8. J

    VBA to change report recordsource is not changing recordsource property box contents

    Hi, I have a sample DB that is a very simple example of a problem I need to solve. A table with color and size. A RED query that filters by red and a BLUE query that filers by blue. A single report has no set record source in design mode. When the report it opened, it is opened with a...
  9. J

    Can send SMS to Verizon Customers but not ATT and T-Mobile.

    I have a form based on a query that has a button on it to send a pre-made SMS message to the customer on that record, asking them to leave us a review. The VBA below works just fine for all our customers who use Verizon, but it does not work for ATT and T-Mobile customers. To use this code...
  10. J

    Front End Deployment of Split Database in a small enviornment

    I have 15 users that use their own copies of the Front End of a single, small (30M) database. Every time I make a change to the FE, which is frequent, I have to push out the new FE to the desktops of all 15 users. All users use the same kind of PCs, the same Windows 10, and the same Access 2019...
Top Bottom