Recent content by dhaveedh

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!

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

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") & "'...

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

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

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

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!

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

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

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!

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!

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

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

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

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