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...
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???
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...
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...
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???
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.