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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lppa

  1. lppa

    TAPI and Windows 7 64 bit

    I tried installing the file, but its asking me for an account #, which I do not have, any ideas?
  2. lppa

    TAPI and Windows 7 64 bit

    Good Morning, I have Windows 7 64 bit installed on my computer. My VOIP provider uses Tekelec as the Tapi software, however they are telling me (and I checked myself) that it doesn't work with the 64 bit version of Windows 7. It won't install at all, not even in compatibility mode. I need it in...
  3. lppa

    Access Text Functions

    Thanks Skip, works fine now
  4. lppa

    Access Text Functions

    did you mean Space() function? thanks
  5. lppa

    Access Text Functions

    Here is the code: Private Sub Command266_Click() On Error GoTo Err_Command266_Click Dim stDocName As String 'stDocName = "Empty_Report" Exit_Command266_Click: DoCmd.SendObject acSendNoObject, stDocName, acFormatXLS, , , , "PO# " & Me.InvoiceID, "Dial...
  6. lppa

    Access Text Functions

    Can you show me the sample of the code?
  7. lppa

    Access Text Functions

    I am sending Purchase Order via email from Access form and need to align strings vertically in each line of the email. PO# 39877 Date: 10/16/2011 ------------------------------------------------------------- Quantity Part Number Description...
  8. lppa

    Phone dialer in Access 2003

    I am using Microsoft Windows phone dialer in Access 2003 to dial customer’s phone number, and multiple dialer windows pup up and stay during after call is completed. Is there a way to run phone dialer on a background, so no dialer windows are visible?
  9. lppa

    Populating field in subform from main form

    Thanks I put that all together and it works greate: Private Sub ScheduledTime_LostFocus() Dim stDocName As String Dim stLinkCriteria As String Me.frmInvoiceMemos.SetFocus With DoCmd .GoToRecord , , acNewRec End With Me.frmInvoiceMemos.Form.Memo =...
  10. lppa

    Populating field in subform from main form

    Hi Zameer, Thanks a lot, its inserts date and time in first record perfectly. The reason I need to create a new memo record every time a new appointment scheduled is that some times more then one appointment needed to complete the job and we need to keep track of each appointment. There for...
  11. lppa

    Populating field in subform from main form

    I have a form frmInvoice with Subform frmInvoiceMemos related by invoiceID field. After populating fields “ScheduledDate” and “ScheduledTime” of the main form, I need new record in subform as: “09/13/2005 10:23AM: Appointment scheduled for 09/15/2005, 1-5PM” This is an approach I took, but it is...
  12. lppa

    Duplicate values in combo box

    Thanks. Everything works just fine. Appreciate your help.
  13. lppa

    Duplicate values in combo box

    Thanks. It worked perfectly. The only question I have is how to close dropdown part of combo box after record selected and set focus to another field. Thanks again.
  14. lppa

    Duplicate values in combo box

    In "Customers Info" Form I have unbound combo box used for Company/Last Name Search. In case of two or more same last names it returns only first (used combo box wizard with FindFirst method). How can I solve this problem, so it will return right record selected from combo box. Code: Private...
  15. lppa

    Adding multiple fields using Not In List of combo box

    Having problem with adding multiple fields from one table to another using Not In List event of the combo box. I have two tables: Customers (Customers Name, Address, State, City, Zip) and Invoices (Invoice Name, Address, State, City, Zip). Form Invoices has combo box Customers Name, sourced by...

Part and Inventory Search

Back
Top