Search results for query: *

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...

no, completely separate form so the user can view a quote by the quoteid from the ByQuotes form which lists the active quotes. if they start from the customer form they have to know and look up the customer to locate the quote. this is too time consuming. they will know the quoteid before...

hi dhookom! it needs to link where the order number exists in the SO table as well and update the status in the ControlLogArchives where it's the only one or the lastest one, hence the need to use the DMAX. I think it's working though. I tried it on one that had only once instance in the...

UPDATE (((SO2_SOEntryDetailLine ON OrdersToReprint.SalesOrderNumber = SO2_SOEntryDetailLine.SalesOrderNumber) INNER JOIN ControlLogArchives ON OrdersToReprint.SalesOrderNumber = ControlLogArchives.SalesOrderNumber SET ControlLogArchives.LogStatus = "BrghtBk" WHERE...

I tried searching to see if i can find something first but did not find anything ... I have a query that looks for the last date for an order number. But if the order number only exists once it doesn't show. It only shows the DMAX date IF the order number exists more then once. How or what...

can anyone please help me with this?