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 SkipVought 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: lppa
  • Order by date
  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...
  16. lppa

    Access command bar images

    I am working on Access custom command bar. Access command bar images are very limited. Where can I find more images and how to paste the on the bar. Thanks
  17. lppa

    Open form in Datasheet view

    Hi Henry, Thanks. I’m glad it worked out.
  18. lppa

    Open form in Datasheet view

    Hi Henry, Thanks for following up. This is the code I'm using and everything is working: ' Open a form. Case conCmdOpenFormBrowse DoCmd.OpenForm rs![Argument], IIf(Nz(rs![Argument2], "") = "acFormDS", 3, 0)
  19. lppa

    Time/Date stamp

    It stops at: Me![Notes].SelLength = 0
  20. lppa

    Time/Date stamp

    Thanks again. It didn’t work. Gives me error message: Object doesn't support this property or method (Error 438) at: End If Me![Notes].SelLength = 0 Me![Notes].SelStart = Len(Me![Notes]) + 1 Any tips. Thanks

Part and Inventory Search

Back
Top