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 dencom 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: pfunk
  • Content: Threads
  • Order by date
  1. pfunk

    code help on form!

    i have a form that is bound to qry in access 2003 everything was working file until i had to link another table by account_num and it says the records set us not update able???
  2. pfunk

    code help on form!

    i have a form with a button that opens a subform to enter notes. i have changed the control source on my account_num field on the form to T_Collection_Records.Account_Num because the qry behind it is now linked by account_num?? below is the current code how is it suppose to be now?? Private...
  3. pfunk

    error communicating with the ole server or activex control

    the expression on click you entered as the event property setting produced the following error while wcs collections was communicating with the ole server or activex control Private Sub DIAL_HOME_Click() On Error GoTo Err_DIAL_HOME_Click Dim stAppName As String stAppName =...
  4. pfunk

    disable window unhide database option?

    i have a database that the users are able to get in the bacend of datbase by clicking the window unhide option. is there a way to disable that option to click window unhide?
  5. pfunk

    use one form behhind mulitple option buttons

    i have a form called f_q_t_collection_records which is my main form i am also using duplicate forms created behind command button that use different queries behind each form meaning a different control source. but i am running into a problem when i update f_q_t_collection_records form i also...
  6. pfunk

    Invalid Use of Null error

    i get a invalid use of null error if there is not previous note or data in the field. if there is a users note or the field is already been populated it works fine can anyone help me with this one? Private Sub cmdUpdateNotes_Click() On Error GoTo Err_cmdUpdateNotes_Click Dim Msg, Style...
  7. pfunk

    DATE FORMAT CONVERSION HELP!

    I HAVE ACCESS TABLE WITH DATE FIELDS WITH DIFFRENT DATES FORMATED LIKE YYYYMMDD OF HOW WOULD I CONVERT TO MM/DD/YYYY? WHEN FORMATING WITH EXCEL FORMAT FIELD IT ERRORS IN NUMBER SIGNS
  8. pfunk

    PASSWORD RESET

    WE HAVE A INTERNAL USER THAT CHANGED THAIR PASSWORD. HOW DO I RESET OR DELETE FROM USERS PHONE?
  9. pfunk

    get voicemail from external line

    we have an Avaya phone system and are wonder how we get our voicemails from home anyone know how its done?
  10. pfunk

    code not working

    i am having trouble with this code. even thought the payment due date has not arrived it still promts users to change. Private Sub Notes_Click() If Trim(Me![Status Codes]) = "PROMISE" Or Trim(Me![Payment_Due_Date]) <= Date Then MsgBox "Your Debtor has Broken thier promise and you did...
  11. pfunk

    Form on exit event procedure not working any idea why?

    Private Sub Notes_Exit(Cancel As Integer) If Trim(Me![Status Codes]) = "PROMISE" Or Trim(Me![Payment_Due_Date]) = "<date" Then MsgBox "Your Debtor has Broken thier promise and you did not follow up on it therefore please code to Broken Promise ASAP." Me![Status Codes].SetFocus...
  12. pfunk

    Multiple field search based on a qry &quot;Rookie&quot;

    I have two fields in the same table one called home phone and the other called poe phone. I want to be able to search both fields simultaneously meaning if not in home phone then look in poe. any help here here is what i currently have [enter home phone]
  13. pfunk

    Update Qry

    i have a field called zip it is a text field. when i imported to access it dropped the O in front so i am looking to write a qry to identify if it has only 4 characters them update those with a zero in front of it?

Part and Inventory Search

Back
Top