Search results for query: *

Try to update the check box ysnSentByMailToStaff if unchecked and dteFUDate = Date(), when ysnSentByMailToStaff = 0 No error shows up but wil not update. Any help greatly apprecaited. DoCmd.RunSQL "UPDATE tblCreditDetails SET tblCreditDetails.ysnSentByMailToStaff = -1 &...

I have this table name Table 1 with the following data ID Name Sin Interest 1 Noel 100 $23.00 2 Tim 101 $34.00 3 Jason 102 $34.00 4 Jason 102 $45.00 5 Andrea 103 $56.00 6 Andrew 104 $100.00 7 Rebecca 105 $34.00 8 Rebecca 105 $70.00 9 Angie 106 $57.00 10 Angie 106 $234.00 11 Andy 107 $23.00 12...

I have this code below to print current record but getting this error "Data Type mismatch in Criteria Expression" I checked all type and seems to be okay. OhipNumber is a Primary key on tblPatient type: Text, input mask of 0000000000;; Fieldsize: is 10 all Numbers Private Sub...

Hello, Im using this code to export table to text file. But some record have empty value or null. Is there a way to show on text file to show blank instead of Null Private Sub cmdTxt1_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = Application.CurrentDb Set rs =...

HEllo Again, WOuld like to thank everyone who have answer some of my problem int access previously. But right now I' again stuck with this syntax on SQL Where(Criteria). Im trying to update a database maintblBankruptcy DateEsent to Date() when DateESent is Null and Relationship = a...

I have this code and getting syntax error; Not sure what syntax for this. Not sure whats the proper syntax for stLinkCriteria to filter form on date range. On Error GoTo Err_Open_Click If Dcount("*", "QryDateRecieved") = 0 Then MsgBox "There are no records to display"...

Hello everyone, I have a email function where to Dlookup the to: and Cc: on a table tblDivision. For some reason if cc is blank on table is not working. If data exsit works okay. I try to use if stCC = "" or Null still not working Here is my code, works okay if stTo and stCC are not blank...

What the correct syntax on this one? So far its not working at all. I'm trying to update a table (maintblBankruptcy) namefiels (DateESent) to now where DateESent is Null. Dim SQL As String SQL = "UPDATE maintblBankruptcy" & "SET maintblBankruptcy.DateESent = Now" & _ "WHERE...

hello the when open form with date is null works okay but when enter date (Short Date) dd/mm/yyyy give me a form with blank fields, but If I enter the (reverse) MM/DD/YYYY works okay. Not sure how to fixed. IUser have to enter a format of date DD/MM/YYYY I try format, validation rule, nothing...

Hello, People, I have a form which user enter date to query certain date fielname "EnterDate, with format/mask short date. WHich is reference to Queries name" QryDateSent with a criteria [Forms]![frmQuerysent]![EnterDate] on thefield name datesent. Somehow works okay when user enter ceratin...

Hello eveyrone I have a report name rptDivision and one of the fields is Relationship. I'm trying to figure out how to open the report with criteria for field Relationship = to Life, Auto or Finance by using InputBox where user enter life and report shows the criteria on life or auto, Finace...

I have a table "tblAgent" with following fieldname AgentID - Autonumber Name - text Agent_Code - text Need to runSQL to delete record when Name & Agen_Code are empty. I try this thiss but not sure what syntax on WHERE. DoCmd.RunSQL "DELETE * FROM tblAgent WHRERE tblAgent.Agent_Code =...

Is there a way for my report on rich text format as part of the body/message instead of a MSword attachment. Send email works okay but just don't want may report as attachment.