Search results

Exactly what I needed, thanks!

RESOLVED: Date()-1 excluding Weekends I have a query that pulls data from a Due Date column based on the date. I want to see what I missed from yesterday. However on Monday it shows me Sunday. I want it to instead skip Saturday/Sunday and use Friday if it is Monday but I cannot for the...

Actually what I've done is used a macro using TransferSpreadsheet, then link the chart via unbound object frame. It's the only way I could get it to work, and the charts look much nicer in Excel than Access.

Anyone have any input?

Not seeing anything there for charts. I have the numbers I need, its just a matter of placing the data in the chart. From the looks of it, I can only compare numbers in a column, not multiple columns.

Never had much luck with the charts in Access, what better time to learn then now? I have a query that in Column A: has a sum of the number of phone calls and column b has the total number of times the phone call had documentation logged, I want to take and compare them in a pie chart but when...

Not quite, let me try explaining a little better. I have a text box that I want to enter a numerical value in, however for the default value I have it so it shows "Input # Received". So when the database is first opened or the form is reset the text box shows "Input # Received". When someone...

Any help is greatly appreciated, in the end I just want it so it has default text displayed, and once they click to type in the # received it clears that text out.

I've searched Google but to no avail (maybe I'm not not being specific enough) but I have a form with a textbox with a default value of "Input # Received" and an input mask for a 3 or 4 digit number, what I would like to have is when a user clicks the textbos the "Input # Received" clears and...

Will always be today's date in the same format. I have a macro that pulls the excel doc into access once its on my desktop using the file name: ="C:\Documents and Settings\JHenson\Desktop\PANYNJ AE-CA Daily Opened Last 60 Days " & Format(Date(),"yyyy-mm-dd") & ".xls"

It did work, I appreciate your help in all of this. I'm not sure if that will work for what I'm wanting to do, the file name changes daily and is a relatively long name (PANYNJ AE-CA Daily Opened Last 60 Days 2009-06-22.xls). Basically what I would like to do is have the module executed by a...

I have a feeling this is way over my head, is there a way to specify in a macro to use the current username of the person logged in? So it will look for the excel doc on their desktop? (C:/Documents and Settings/USERNAME/Desktop) I've tried CurrentUser() but it just returns Admin

I'm just using the database you linked me to download and am putting in my ftp credentials.

The database is unable to connect to my FTP site, I've tried using the internal and external address. Run time error 5 Invalid procedure call or argument

Is it possible either by macro or VBA to import an excel document that is on a FTP site. We have a report that is ran daily that is in Excel, I take the report and add the new information to a access table, then link the excel doc and run an update query to update all the records. Currently I...

That seems to have fixed it! Thanks for your help

I'm new to these forums so I apologize if I'm posting in the wrong section. I'm running multiple reports that I print to PDF using a freeware PDF printer (PDF995). These reports are ran on a weekly basis and will always be merged into one document. Currently what I have setup is a macro to...