Search results for query: *

I got it fixed thanks...

Hi leslie, Try that one give's me a syntax error....

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

Thanks a lot PHV I wont fine now, your the man....

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

Thanks PHV, That works...I have used Nz previously on some of my project long time ago but sometimes I just forgot. Thanks for reminding.

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

Hi stix4t2, I try the your suggestion but for some reason it update All DateESent to Date() even if the RecievedDate between 01/01/2006 to 31/01/2006. Ex. (DD/MM/YYYY) (DD/MM/YYYY) Relatsionship RecievedDate DateEsent Agents 02/01/2006 03/03/2006 Agents...

Hi stix4t2, I try the your suggestion but for some reason it update All DateESent to Date() even if the RecievedDate between 01/01/2006 to 31/01/2006. Ex. (DD/MM/YYYY) (DD/MM/YYYY) Relatsionship RecievedDate DateEsent Agents 02/01/2006 03/03/2006 Agents...

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

I wrap it with Nz and works okay. Thank You so much.

Sorry, I don't get any error when click on Email, it just don't open the email or do anything.

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

Thanks to everybody, YOu guys are smart. Works fine now.

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

Thanks All, PHV that works...thanks

Thanks Remou...but still not working, it will show a blank form with blank field, should have contain at least 5 record with empty DateESent.