Search results

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

YES! That worked as far as me now seeing your query! thanks for that education! I will play with it a bit and get back to you. thanks again! JM

I do see the written query but I'm not familiar with how to download it or create my own from it. would you mind creating the query in the front end file of mine and posting the whole file so i can see your query in the manner I am accustomed to seeing it. I know that is amateurish, but its...

Can you post your new queries here so I can check them out. They should be showing the same numbers, as the numbers are correct in my original report. Thank you. jm

thanks for the reply and the tip on the transparency. Can you help build the proper query? I have tried and failed. I have 12 years of access programming but cant seem to get this one done right. can you help? I can compensate. Thanks! jm

Hi, No one seems to be able to help with this issue. would you be willing to create the new query that would accomplish my goal and post it here? Thank you! J

To June7, The regular report view shows 6 line items and a summary. the report preview shows the same, but the WRONG values. Are you not seeing this same issue? Changing the background of the CatCode textbox does nothing to help this issue. The report groups on two fields, neither of...

Hi, the link between line items and the Master items list is based on a calculated field in both tables. That is necessary because the code in that field is generated in the line items table during a user input on a form, which I have stripped out of the DB for troubleshooting purposes for you...

Thank you for your help. I'm pretty good at Access but this one has me stumped. Thanks again.

Can you please re-download the file. I attached a new version to the original questions posted as well as here directly to you reply. Thanks!

I removed the referrence to Selenium and now that Date and Time pop up seems to be gone. Thank you for looking at this,

thanks for the reply. Do you mean make a third query with sums based on the 2nd query (totals)? I tried that and it did not seem to work. Would you be willing to show me what you are suggesting? I can definitely strip out the queries of unneeded fields but I cant imagine that would cause...

Zip file included.