Recent content by andrewneal

How do I bind text boxes to a query result? Does the query have to be "open" at the time the report is opened, or will the report run the query in the background?

I need to display exact numbers greater than 100% for my manning database. For instance if there are only 10 authorized and we have 12 currently employed then that position is 120% filled.

I will need to calculate the percentages of each rank under each squadron in a chart type thing. I attached a picture of a general idea of how they want it to look...though it won't be "exactly" like this...it will need to be close. So, the report will be crunching a lot of numbers like an...

I will need to calculate multiple percentages on the report (30+). I have a pretty good grasp on how to do the math part of figuring this out (thanks to previous posts in this awesome forum); question is...how do I get the different "unbound" text boxes to see and compute multiple queries and...

Just so I don't head down the wrong path; what is the best way to show multiple query and table information on a single report? Or is that even possible. I could be running as many as 30 queries on a single report.

:eek:WoW hands down! Content is much better and Blizzard is always adding something new. Every week more quests and items are added to include holidays and things. I have a lvl 80 rogue, 80 hunter, 80 druid, 79 deathknight, 76 paladin, 75 druid, 40 warrior. My daughter has a 79 deathknight...

Thanks for the very quick response. After reading your post I am not so worried about "printing" as much as viewing the data easily. The individuals viewing this data are upper management and do not always understand the efforts involved nor the time used in getting them the data they want to...

Let me start by saying, I am not sure if a Report would be my best option here or if a printable Form would be optimal. Anyway, doing a manning database to calculate number of employees versues number of authorized employees (military). I want this to show as a column for percentages ... ie...

I am helping someone re-do their database and they would like the autonumber id to reset each year back to zero; something like yr&cnt (070001). This would need to be saved as the auto-generated id number for that data entry; again resetting automatically each 1 January. The next data entry...

That was it... It was hidden; not sure why since I thought I checked that! :o I blame the pain medication! :D Thanks again!

Unfortunately this did not work :( ... When I open the report the text box is blank. The control source for the text box is: =Forms!ReportChoice!Combo8 Am I missing something?

How would I get a report label to print exactly what is in a form dropdown list on an open form? I have my sorting and everything else working perfectly (using hidden triggers), now I simply need the report label to simply show what dropdown list I chose on the form. I cannot use a record...

What code would be able to be loaded to get by this security? It might be better to have an email actually pop up and the user just needs to hit the send button on the email, but I am not sure how to get that to happen. The best bet would be to code the ability to bypass this security...

I noticed that there were several threads about hiding the Access Window and have read through them all... It seems like it would be something that I could use, but I can only get it to "grey out" the access window. It will not allow me to click on anything but the form itself (which is...

After some configuring and error checks, I have come up with the following code which is associated with the click function of the "Submit" button. I also loaded the Outlook Object Library 11x as you suggested. Private Sub EMAIL_THIS_Click() Dim OLApp As New Outlook.Application Dim OLMsg As...