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