Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dhaveedh
  • Order by date
  1. dhaveedh

    Removing commas in fields of a table.

    Does anyone out there have any code that can check through all the fields in atable and replace all occurences of a comma with a space. Any help will be appreciated. Thanks KISS - Keep It Simple Sugar!
  2. dhaveedh

    Mail Merge Problem

    Call this function with the relevant parameters from the onclick event of your button. I hope you have set up the relevant Mail Merge document indicating the data source. Good Luck. Function fn_MergeFromTextFile(sSourceFilePath As String, strTemplateName As String, strLetterPath As String...
  3. dhaveedh

    Problems with Date function in ADO recordset

    Thanks for your responses. I already had that in my query but i have found out the problem to be the Date Format in Oracle. The satandard format is dd-Mon-YYYY so I changed my syntax to CG_DATE >= '" & Format(Date-70, "dd-MMM-YYYY") & "' AND CG_DATE <= '" & Format(Date, "dd-MMM-YYYY") & "'...
  4. dhaveedh

    Problems with Date function in ADO recordset

    Yes it is a date type. KISS - Keep It Simple Sugar!
  5. dhaveedh

    Problems with Date function in ADO recordset

    Sysdate returns today's date in oracle. I have tried using that but it does not work. That line actually reads AND CG_DATE >= '" & Date-70 & "' AND CG_DATE <= '" & Date & "' I know Oracle only accepts date in the format 'Date' That's why I have the dates in '' I also know that Oracle...
  6. dhaveedh

    Problems with Date function in ADO recordset

    Hi, I have an ADODB connection to an Oracle table from VBA code and I want to retrive matching recordsets from the tables into another. Here is my code; Set db = CurrentDb Set rs1 = db.OpenRecordset("ImageA") Set con = New ADODB.Connection Set rs = New ADODB.Recordset sConnection =...
  7. dhaveedh

    How export data from Access ?

    What output format do you require? You can export in various file formats like HTML, TXT, RTF, XLS in access. You can use: docmd.transfertext but you need to specify the output format KISS - Keep It Simple Sugar!
  8. dhaveedh

    Rs.Recordcount returns a value of -1

    Hi, I have an ADODB connection to an Oracle table from VBA code and I want to retrive matching recordsets from the tables into another. Here is my code; Set db = CurrentDb Set rs1 = db.OpenRecordset("ImageA") Set con = New ADODB.Connection Set rs = New ADODB.Recordset sConnection =...
  9. dhaveedh

    Code Help

    How do i do this? KISS - Keep It Simple Sugar!
  10. dhaveedh

    ADO Recordset

    Hi, I am running a query in VBA which is using ADO to connect to an oracle database. While stepping through the code I get this error: ORA00933:SQL Command Not Properly Ended Does anyone know the solution to this aggro? KISS - Keep It Simple Sugar!
  11. dhaveedh

    Code Help

    Thanx for ur help. Thats the easy part. The other part is that I want to check that the time between the payments is 7days for weekly payments and 30 or 31 for monthly payments. That's where i got stuck. Ta KISS - Keep It Simple Sugar!
  12. dhaveedh

    Code Help

    I would appreciate any help with code to carry out this task; I have a table containing information about payments made by different customers thus TransactionsTable AccNo PmtDate Amt 101 10/03/2004 10 101 17/03/2004 10 101...
  13. dhaveedh

    Creating a database link on start up

    Space constraints on the network drive. The databage i could have linked to has one table and it is already 110MB. The working database I am building already has a capacity of 98MB and grows to 150MB once I create the link to this database. I was just wondering if this could be done so that...
  14. dhaveedh

    Creating a database link on start up

    Hi Everyone, I am building a database that will be accessing a large dataset when it is produced at the end of the month. This dataset is required to enable us track performance on a weekly basis until the next large dataset is produced and the previous one archived. I do not want the database...
  15. dhaveedh

    Date Matters

    Can anyone tell me what is wrong with this? I am trying to get the date of Last sunday Function getLastSunday() Dim dDate As String dDate = Format(Date, "dddd") Do Until Format(dDate, "dddd") = "Sunday" dDate = Date - 1 Loop getLastSunday...
  16. dhaveedh

    Folder Contents

    Does anyone know how i can get the list of files in a folder in Access? I want to list all the files in a folder and find out if a particular file exists. Help appreciated. KISS - Keep It Simple Sugar!
  17. dhaveedh

    CDONTS

    I have done this but still get the same problem. KISS - Keep It Simple Sugar!
  18. dhaveedh

    CDONTS

    Hello there! I am sending the contents of a form to an email address using CDONTS. I want to send it with some formatting so I have to change the Body format oj ObjMail.body to HTML. I have done all this but when I do send the mail, It comes through with all the HTML tags showing and no...
  19. dhaveedh

    ASP to outlook

    Yes KISS - Keep It Simple Sugar!
  20. dhaveedh

    ASP to outlook

    Hi folks, I am sending the body of a form through to an email using an ASP page. It works alright but my user has suddenly asked me to format sections of the email output to be in bold while the others are not in bold format. Anyone got ideas? KISS - Keep It Simple Sugar!

Part and Inventory Search

Back
Top