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!

  • Congratulations strongm 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: *

  • Users: rstrong
  • Content: Threads
  • Order by date
  1. rstrong

    IP phones display DISCONNECTED

    Hey, We have been having this problem for a while now where about 3-4 times a day all the IP phones will display DISCONNECTED when someone picks up the handset to make a call. After about 5 minutes it comes back and works fine. We have some digital phones hooked up and they don't seem to have...
  2. rstrong

    Workaround for a subform within a continuous subform?

    Hey, I have two tables. The first table, tblOrders, has general order information and the second, tblItemInfo, has information about specific items within the order. The primary key for tblOrders is OrderID. Each item within an order will be in tblItemInfo along with the OrderID it is...
  3. rstrong

    SQL Update Statement for first N rows?

    Hey I am having some trouble writing an SQL command. I need to set a field in the first N entries of a table. I thought it would be something like this: UPDATE TOP N table SET field1 = 'whatever' but it doesn't work. It seems I can't use TOP with the UPDATE statement. Is there something else...
  4. rstrong

    Outlook E-mail Templates

    Hey, I am having trouble getting an e-mail to merge correctly from a template. In ACT, when I click Write->E-Mail Message (from template) and then select the template I want, Outlook will open a new e-mail with the correct e-mail address but the body will be completely blank. The template works...
  5. rstrong

    Changing textbox's decimal places on report open

    Hey, I have an invoice report that I need to sometimes display currency to 3 decimal places but most of the time display 2 decimal places. I have the code to determine when 3 decimal places are needed and when 2 are but I am not sure how to change the textbox's format properties when the report...

Part and Inventory Search

Back
Top