Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Smoores

    Sending a form to email.

    junior1544 The report is called from a form.
  2. Smoores

    Sending a form to email.

    I have a report that is to be emailed to a remote user when ever it is updated. I've tried to put the code on the close-event of the report but I get an error (2585?)that states the action cannot be performed while processing a form or report event. If I close the report before this request...
  3. Smoores

    Error 2585

    I was wondering if anyone could tell me what Error 2585 meant. I want to add code to send email to the remote user from the click (Yes) event of the form close. Here is the code: DoCmd.Restore Select Case intReturned Case vbYes: ' Now mark those items selected as...
  4. Smoores

    Update Query?

    Thanks for the heads-up. I developed an update query that does what is needed. I have just the place for that code that you suggested to me, though. Thanks again, Dave! Smoores [thumbsup2]
  5. Smoores

    Update Query?

    I have two tables that share at least one field (ProductID). When a user changes data on a form, the Product Table gets updated correctly but the OrderItems Table does not. Can anyone tell me the correct SQL statement to update the OrderItems Table from the Product Table? Cheers Smoores
  6. Smoores

    Error 3265?

    I am trying to run an update query and the result is "Error 3265 Item Not Found in this collection." The query is rendered from the statement:Call RunQueryParameter_TSB("", gCqryCraigsBOLQuery, "BOLCharge", BOLCharge) where the BOLCharge is the search field of the...
  7. Smoores

    Table & Query upodates from Form Changes

    I am working with form that, when changed, will update one field of a query as it should, but not another field of the same query or the table from which the query is based upon. The query is only updated after it is closed and reloaded. Any help would be appreciated. Thanks Smoores
  8. Smoores

    Reading Listbox Selections (multiselect)

    I have a multiselect list box made. The user is to select as many of the listbox options (they are only order numbers) as necessary. The ones selected refer to the records that get printed; the ones unselected are ignored. Can anyone help me with the code that would identify which numbers...
  9. Smoores

    Textbox Status Change?

    I am trying to make a textbox value stand out after it is updated. I have tried a "Me.statusDesc.FontBold" routine with an on_change, before_update & after_update event to no avail. Could anyone offer any suggestions?

Part and Inventory Search

Back
Top