Recent content by Olddogg1

Hi Everyone, Thanks for the help.... PROBLEM: -Pie chart not functioning. It is not visible when I try to add my child/master fields in the properties section of the pie option. ORIGIN: - I had the report (and pie chart) working perfectly last week with a different table acting as the...

It was a trick question 8(

Hey PH.... Could you somehow manipulate that function to count the number of days to the end of the year? Thanks a bunch for that equation!! Jon

Hey Guys, What is the best way to do this? Currently, I am trying to pull the values straight from the form... eg. - Forms!RevenueMain!txtstartdate However, I seem to be getting a lag. The reports do not have the right values on them. The Reports do have the correct values after being closed...

Hi guys, I built a user-interactive form for our company revenue database. One of the features is to enter a "startdate" and "enddate" and then click a command button. I currently have this code in the detail_print section of my report's VBA: StartDate = "#" & Forms!RevenueMain!Startmm &...

Hi Guys... Here is what I'm attempting to accomplish with Access: I am an investment representative. Currently, I have a database that contains all of the holding's of my clients respectively. All of the holdings are seperated by asset class. I want to generate a report for individual clients...

Hi There, I setup a machine that is running windows server 2003. I have configured the DNS myself and not quite sure if I have done everything correctly. The email is not working. It works, however, if the person sending the email has already received an email previously from this domain name...

The database I'm currently building for our little company is to replace the MS Outlook contacts system. A question was asked whether it is possible to have a mailto style link that is derived from a field in an access table? Is it possible to have a button beside an e-mail address field...

I'm trying to put a tab control inside an already existing tab control. I'm wondering if this is even possible. When I put the tab control inside the existing tab control it shows up under all of the tabs of the existing tab control. Is there anyway to put a tab control under one tab of an...

Hey BoyWonder... try this code in the VB event procedure: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, ,acMenuVer70 I'm no expert, but it does work for refreshing my form data.

Ok this is an extremely annoying problem.. When I change the Tab Index numbers in the properties of my form the tab index numbers from the other fields change. Usually they change accordingly and everything is fine. But they are changing in a really wierd pattern... Now when I press the tab...

Hi There Guys, I am not very familiar with Access so I'm looking for a little help on the tek-tip's forums. So far the responses have been great and I appreciate all the help. I am building a database for the financial company that I work for to handle customers. So far the database has 6...

I am not too familiar with access and the relationships / primary keys that I need to define. If I could get a hand with this that would be excellent. -- What the Database is For -- I am creating an access database for office use. It has all of our clients and their respective information. It...

Okay here is the problem... I have built a nice form for operations throughout a database (since the people around our office aren't very computer literate). I have built the form using a tab control and then connected to the tabs are seperate subforms. The problem with the tab control is that...

I'm trying to create conditional formatting in a query... In my particular business we have policies. Some of the policies get cancelled or they lapse. I would like to be able to still have the lapsed policies show up in the query results. Is there anyway to list the lapsed policies with the...