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

    code help on form!

    both tables have a primary key. i was told i may need some code and i subed out some work last night and the guys code still dont work i am now getting a compile error "user-defined type not defined" Private Sub Phone_Seeker_Click() On Error GoTo Error_ME2 Dim aCCNT2 As String, phonesee As...
  2. pfunk

    code help on form!

    no dice PHV...
  3. pfunk

    code help on form!

    here is the qry SELECT DISTINCT [enter home phone] AS [Phone Search], * FROM T_Phones INNER JOIN T_Collection_Records ON T_Phones.Account_Num = T_Collection_Records.Account_Num WHERE ((([enter home phone])=[T_Phones]![Phone]));
  4. 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???
  5. pfunk

    code help on form!

    worked like a charm TheAceMan1
  6. 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...
  7. pfunk

    error communicating with the ole server or activex control

    nah no dice dhookom my posts are never that easy. minimally did not work for me. any other suggestions
  8. 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 =...
  9. pfunk

    use one form behhind mulitple option buttons

    aceman here is the code behind my phone search option button. i want it to pull the same form F_Q_T_Collection_Records but use the qry behind F_Q_T_Collection_Records_Phone_Search got me? Private Sub HPHONE_SEARCH_Click() On Error GoTo Err_HPHONE_SEARCH_Click Dim stDocName As String...
  10. pfunk

    use one form behhind mulitple option buttons

    aceman Q_T_Collection_Records_Phone_Search
  11. pfunk

    use one form behhind mulitple option buttons

    SURE DO ACEMAN. DONT WORK IT PULLS THE FORM BUT NOT THE OPEN ARGUMENT
  12. 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?
  13. pfunk

    use one form behhind mulitple option buttons

    DoCmd.OpenForm FormName:="f_q_t_collection_records", OpenArgs:="_T_Collection_Records_Phone_Search" did not work it opens the f_q_t_collection_records form but notn the qry behind it???
  14. pfunk

    use one form behhind mulitple option buttons

    what would the code look like if i wanted to call f_q_t_collection_records form and the query Q_T_Collection_Records_Phone_Search??
  15. pfunk

    use one form behhind mulitple option buttons

    DoCmd.OpenForm FormName:="myForm", OpenArgs:="Query1" pullud up the form but not the qry behind it
  16. pfunk

    use one form behhind mulitple option buttons

    i have multiple queries behind these forms for status codes,different numbers,Tim zones,etc that we call but every time i change my main form i have copy paste rename it then change the control source to pull from the specific qry on each form to make one change any sugestions????????
  17. 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...
  18. pfunk

    Invalid Use of Null error

    no that did not work. mabee i did not clarify what i am looking to do . i have a form called Q_T_Collection_Records if a user is on a phone call and lets say three minutes go by and they have not moved to any field within that form. a message box saying: wrap it up! or get a manager.
  19. pfunk

    Invalid Use of Null error

    like a charm thanks, to bring this a little further how could i force my user to enter a note on theis form if they dont they cnnot move to the next record
  20. 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...

Part and Inventory Search

Back
Top