Recent content by angelandgreg

Using he's example form and reports, it's generating the PDF (converting the snapshot to pdf). just as designed BUT ... when I try to incorporate into what I all ready I get complaints. like for instance, it's complaining with a Compile error on the OnLoad: Private Sub Form_Load() ' Size our...

Well, the SendObject command works find, no Outlook error message. Sends only the report that it's being previewed. The user can select the SnapShot from the available default list. But the email address has to be manually entered. Basically, ideally it'll work like QuickBooks. You view the...

I've read quite a few and of course none that will help me :( I used http://www.lebans.com/reporttopdf.htm and it works the way it's designed. I don't know enough to incorporate it with what I have. Is there a way to incorporate this with the SendObject? None of the options in the default...

I have a similar issue ... I have two .mdb, each has a pass through query. one has the header and the other the details. i have a make query from each so I have a Table in MS Access to work with. This seemed to make it a little faster to run queries. Not to mention each file (table) is 1.4gb...

LOL! gotta be kidding ... well, that was it! thank you very very much! I swore I tried every little variation

Hi Remou, I don't know how to do that. I don't know how else to explain this. I don't have any other forms open except the ByQuote form. This form lists all the existing quotes. I am trying to have this for the users so they can view the quote from a list of quotes instead of having to know...

Hi PHV, well, i have changed it to a single line: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""C:\Documents and Settings\Angel\Angel'sWindows\Schools\CCS\Schedules\Schedule.mdb" /x mcrtest now, i kind of see it run but not like before and it still did not run :-(

Hello, I am having the same issue but from what I can see mine is correct. I'm using a batch file (.bat) "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\Angel\Angel'sWindows\Schools\CCS\Schedules\Schedule.mdb" /x mcrtest what happens: i see the command...

someone please help!

Hi, i still get the Enter Parameter Value prompt Forms!Customers!QuoteSummary subform.Form!QuoteID click OK and it comes up again then the CustomQuote from opens without the quote information. The only thing I have in the ByQuote form is on the QuoteID and on Double-click Private Sub...

Hi Remou, guess my issue is I don't understand what you mean with the "OpenArgument" on the OnActivate code. :-( I modified the code, that's all.

well, how will that work, i am confused. i'm not seeing how what's been provided will do both things depending which form the double-click on the QuoteID will open the CustomQuote form (quote data) the ViewOrders opens th CustomQuote from with the OnActivate which is the quote information. This...

did not work. same message and another about an invalid. here's the code in it's entirety. [code] Private Sub Form_Activate() On Error GoTo Err_Form_Activate ' Me.Requery 'Open the customer form with just the current customer DoCmd.OpenForm "Customers", , , "CustomerID=" &...

here's what I get when I double-click on the QuoteID field from the ByQuote form Forms!Customers!QuoteSummary subform.Form!QuoteID it prompts twice then it does open the CustomQuotes form but it is empty

yes, here's the mod on the ByQuote form Option Compare Database Private Sub CustomQuoteNumber_DblClick(Cancel As Integer) ViewOrder End Sub Private Sub ViewOrder() On Error GoTo Err_ViewOrder DoCmd.OpenForm "CustomQuotes" Exit_ViewOrder: Exit Sub Err_ViewOrder: MsgBox...