Search results for query: *

Duane, I got the chart by placing both items in the X axis on Chart Wizard. I then created the chart and changed to lines on 2 axis. I am just trying to get the dates to print out correctly. Thanks for your help tho. I can generate the data it's just the charts I'm weak at. Working hard to...

I have a query that generates Date, Line, # of Pieces and # of Parts. I need to have a graph that does this: Chart by Line by date on X axis, # of Pieces on one Y axis and # of Prints on other Y Axis. At the top X axis I want the date. date (by week) # of pieces |...

Just ignore mine then. Didn't realize that. Good luck Kimberly

You can also just copy the table (click on it and Ctrl+C). Then past the table (Ctrl+V) and it will ask if you want structure or structure and data. You can just insert the autonumber field from the table design screen. HTH Kimberly

Daniel, I tried the comma semicolon fix to no avail. I placed the automation you so kindly outlined for me and it worked perfectly. I of course have one more question. Is there a way to have the email 'pop up' so the person can add personalized text to the form email? They would then just...

Robert, AWESOME! I changed my line and it worked perfectly. I am going to try and see if I can tweek the code you gave me to auto name a file They want the word file you helped me create to have a link to the excel file for the financials. Of course it needs the same naming convention...

I double-checked. Would you like me to offline email you the file to look at? Kimberly

I do not get any error messages. It just does not open anything. The link stays blue. Right click on the link and open up Hyperlink/Edit Hyperlink the display name is correct but the actual link is blank. The field is set up as a hyperlink. Did that make any sense? Kimberly P.S. -- I love...

Daniel, I'm hoping to test this out tonight. Thanks for all your help. This is the greatest resource on the Internet. I do have one 'stupid' question. What exactly is Automation? (am I showing how green I am at this yet?) I've been trying to teach myself how to do all the access programing...

pclark -- That was exactly what I needed. Thanks so much for your help (and detailed directions) Kimberly

Thanks, I get it to create the file and display the link name. The link, however, does nothing. The field "Type the file or webpage name:" is blank. Any idea how to get the file name to populate that field so when I click it actually opens the file? my code so far is: postIt...

Iangrand -- did you try this? Does it work for only the database you have open or did it change Access the program so it always opens that form? I am trying to do basically the same thing you were and hope you can help. Thanks Kimberly

That worked perfectly (your star is coming!). The problem I now have and I'm not sure where to find the answer is -- I can get the dynamically named link but there is no file. Any idea how (or where to find the answer to) to get the ecr.dot to become ecr1.doc, ecr2.doc, ecr3.doc without me...

mstrmage1768 -- Thanks. Here is the code -- Dim myolApp, myNameSpace, myfolder, myItem, myNewfolder Dim SenderEmail As String, SenderName As String Dim dbs As DAO.Database, iOrd As Integer, iMax As Integer Dim rstUsers As DAO.Recordset Dim rstSoftOrders As DAO.Recordset Dim emailContents As...

danvlas -- I will be at the company this week and will try out your suggestion. I did want to make sure you understood the email did not need to send to multiple people on the same email -- it's just a reply to each person who filled out the form. Kimberly

I am not sure how to describe the problem so I will start at the beginning. I have an Access db/program. It takes an email and manipulates the data and places it into the appropriate files in the db. The last field is to be a link to external documentation. Herein lies the problem. The...

Hello to all -- GREAT THREAD! I'm hoping someone can help me too. I have a Access Program that works on a single user machine. When I took it to the company and ran it on a network machine the email quit working. Here's the scoop. The program takes an email, parses through it placing items...

Corey, I couldn't wait to try it so I pushed everything else off my desk. Worked perfect the first time. I was hoping FP had an Email-CCAddress or something like that but this is going to work perfectly! Michael -- Thanks so much too (in case you read this)

Thanks Corey, I went to the site and printed off the information. I'm going to give it a try and will let you know (along with the star). Should have time to do this by Wednesday.

I have a form that needs to be emailed to two different email addresses. Is there a way? Can I set it up to email one and bcc another? Form written in FP2000.