Search results for query: *

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

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

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

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.

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

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