Search results

I have not yet,. but thanks for the idea. I have lots of experience with VBA and Access in general, but none with APIs. Do you have any resources you could point me to? thansk!

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!

good thinking. i will give that a go. thank you!

Thank you and i agree. i will just use the onclick. thanks!

Your reply is what I was expecting. I was hoping there was just a simple event code already written that someone might have had. No worries. I appreciate your explanation for it and will simply use the onclick as everyone is suggesting. Thanks! jm

Yes, i can do that easily. I was just hoping a simple popup on hover solution might be already there. thanks!

the line (record) of the continuous main form.

I only use these forums once a year. Forgive me that I did not remember that they are two different websites, each with separate login credentials and no indication whatsoever that they might be the exact same website. You have every right to heavily criticize and threaten me. Please accept...

not sure what you are saying. i dont see any solution to my question.

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

Ok. thanks for your help. Enjoy your week! JM

Pat, I totally understand and agree about the naming. but there is just no option to change that at this time. We are a very small company. I work 15 hours a day, 6-7 days a week so its not like I can just fix anything. The banking does in fact need to to accommodate entries in...

Pat, I appreciate your comments. The annoying Column Naming has been a problem for me for a long time. I am self taught, 15 years ago and tried to be organized in the beginning and now its just too much to change all the column names. You are also correct about the other flaws in my...

Hi Pat. I finally got my db scaled down and thinned down enough to show the intent of my question. I hope. I took out hundreds of reports, queries and forms, but I think the basic Inventory functionality is working properly for you to possibly help me. Currently I keep track of ALL items we...

thank you for your fast reply. i will think about what you have said and maybe try playing with some forms and code. I may reach out to you again shortly if that is ok. Thanks again! JM

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

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

I know its very complicated and very difficult to understand other peoples' programming. Thanks for trying.

yes, but the report uses hidden running group summaries that the query can not. I believe that is necessary to get the accurate numbers.

you are correct that the numbers are very wrong. I have set up the two original queries to not include zeros (which would skew the averages) and to manually count the totals and the number of no zero records so the averages would be accurate. Do you want to continue to try to work on it or...