Recent content by pfunk

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...

no dice PHV...

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]));

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???

worked like a charm TheAceMan1

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...

nah no dice dhookom my posts are never that easy. minimally did not work for me. any other suggestions

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 =...

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...

aceman Q_T_Collection_Records_Phone_Search

SURE DO ACEMAN. DONT WORK IT PULLS THE FORM BUT NOT THE OPEN ARGUMENT

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?

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???

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??

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