FreddieIT
Last Activity: Nov 23 '10, 07:55 PM
Joined: Feb 9 '10
Location:
-
BTW Gnawoncents, that worked perfectly on my report, just wondering if there's a way to do something similar on a form? -
Thank you Gnawoncents, but what if I need this to work in a form? Basically this is going to be the form master which holds all the data that everyone besides myself and another guy will need to see?Leave a comment:
-
Conditional Formatting for a Report
Hello, I am running Access 2003 and I have a report that shows how much money is being spent per time period, for example:
10:00 am - 11:00 am = $1473.14
11:00 am - 12:00 am = $1274.21
Now I am wondering if there's a way to change the conditional format to bold the top 3 on each report. They are split up by Sections: Breakfast, Brunch, Lunch and Dinner and I want to highlight only the top dollar amounts maybe... -
Event after exporting to excel
I have a database that I am using to print out labels and there are many labels, thousands. All the information isn't on the table as of yet so I created a field saying printed? which is a yes no field. What I was trying to do is have a query that exports the data and once it exports it, make the field Printed? a yes so it wont come up on that query again because I have the query only viewing the fields that are not null and that have a no in the... -
LOL Wow, I could have sworn I checked that and I re-checked and that's all it was! Thank you so much! :)Leave a comment:
-
Form wont read query
I have a database that works (worked until this morning) great. I have it running off of Access 2003. What's happening is that my form named Investigation isn't showing any records when I open it manually. I have a frmMaster that opens it in add mode, but when I open the form from the menu screen it still shows no records. I checked my tables and they are fine, I checked the query it runs off of and it opens with all the records. The only thing... -
How to attach documents using SendObject function
I have a database that I would like to print out 2 seperate documents, which I have done and I also want to e-mail the same 2 documents. I am using the SendObject function, but I can't seem to get the 2 documents to attach, is this even possible? If so, what am I missing?
...Code:DoCmd.OpenReport "rptCommunication" DoCmd.OpenReport "rptCommunicationCoverSheet" DoCmd.SendObject acSendReport, "rptCommunicationCoverSheet" -
Thank you very much Stewart! I have purchased both books and I am going to read up on them and utilize their capabilities.
Thanks again!Leave a comment:
-
Thank you very much Stewart, I will search these books and give them a try, a question I do have is how is the readability?Leave a comment:
-
Microsoft 2003 Code
Hello, first off let me thank you for taking the time to read my question. I just wanted to see if anyone has any informative websites or possibly know of any good books on how to write and understand code in VBA? I know a little, but I want to be able to write modules and code better and I am looking for a starting point. Any help is great appreciated.
Thank you -
Actually, I was grabbing the month value by using Format([DateCompleted],'m') I didn't know that using Month([DateCompleted]) brought back an integer vs a string. Thanks a lot!Leave a comment:
-
Thank you Delerna, the first expression you wrote worked perfectly, the second didn't because when it got to 10, 11 and 12, it acted like they were part of the first 6 months, the other worked to perfection. Also Nico, I actually have a query after this one which grabs the year of each "Date Completed" to either the "First or Second" 6 months, so I will be able to run my reports through the years. Thank you guys, you guys were...Leave a comment:
-
Iff Statement Help
Hello everyone, new to this site, I just wanted to thank you for reading my question. I have a database that I built that has all the records being used by the Date Completed which is the Date of the task being completed. The thing I want to do is have the first 6 months and last 6 months by the date completed. I wrote a query that grabs the months from my field date completed, like Format([DateCompleted],'mmmm') and from their I wanted to change...
No activity results to display
Leave a comment: