Recent content by acarr2032

That seemed to do the trick, I appreciate this very much, I can work with it from here. Thank you.

Did not seem to work. I did this same thing with a print out report, but when I try to apply this to the email report, it give me the error of "The format in which you are attempting to output the current object is not available". I am stumped

I am trying to send this report by way of email in an HTML format, the problem is that its send all records instead of the current record on my form. Here is the code, can someone point me in the right direction to be able to email only the current record? Private Sub Command90_Click() On...

Thanks for the help, I am a newbie, so I am looking for the (easy) button. :)

That didn't seem to work, I get the external programto run, the problem is getting that external program to close after the macro is done. Dim stAppName As String stAppName = "O:\Warehouse\Scan\Scanpal 2\AG Utilities\232_read.exe" Call Shell(stAppName, 1) Dim stDocName As...

I have an external app that is started in the first part of the code, I want it to shut down when it is done doing what it has to do: Private Sub Dump_Data_Click() Dim stAppName As String stAppName = "O:\Warehouse\Scan\Scanpal 2\AG Utilities\232_read.exe" Call Shell(stAppName, 1)...

Nevermind, took sometime but I figured it out myself. THANKS! :P

I have created a report that feeds off of a query and a date form, basically a user types in the date in a date form that triggers a report to shoot off with the appropriate info for that day. The problem that I have come across is that the users also want to break the report down into 3...

I have a report that I created that tells me that a certain product was in excess of a job, on the form there is a check box with a yes/no value. My question is, how do I print this report to only print out the ones that are check box'd? Thanks.

I have a couple of reports that I need to print for specified dates, what is the easiest method to be able to put a start and end date in to print that range only. I know this is an easy one, I am new to using Access. Thanks.

Thanks for the info... got it on your first reply, worked great for me.!!!

I have a form, that when you start it up, it show the record from the previouse use. Is there an easy way to clear those fields when you either click save, exit or when startup the form again?

Works..Thanks ALOT!

I had my database open, went to the tools/startup and check the options to not allow my users to get into the main controls when that database opens and that it brings up the switchboard, the problem I have is that I basically locked myself out of the database(don't laugh) and I cannot get it...

Got it, thanks!