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!

  • Congratulations wOOdy-Soft 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
  • Content: Threads
  • 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

    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 =...
  3. 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 =...
  4. 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!
  5. 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...
  6. 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...
  7. 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...
  8. 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!
  9. 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...
  10. 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!
  11. dhaveedh

    Email Problem

    Hi folks, I am using ASP to send the contents of a form to an email address in outlook. On the form I have some fields which are calculated and then set as "Disabled" (in code) on the form so that the user cannot edit them once calculated. My problem is that when I send the form to...
  12. dhaveedh

    Working days

    Does anyone kniow how i can add 15 Working Days" to a date? A working day is Mon-Friday I want Currdate = Date() + 15 Working Days KISS - Keep It Simple Sugar!
  13. dhaveedh

    More help with complex query

    Hi, I have two time fields in a table as Start Time and End Time. They are both in the format 00:00:00. I want to subtract the End Time from the Start time for each record in the table and return the value in minutes. i.e Select StartTime - EndTime As Timevalue(in secs) Can anyone help...
  14. dhaveedh

    Saving an access report

    Can anyone help with code that will save a report to a file? Basically, I have used an access report to create a letter that will be printed off. Howvere, after printing the letter, I want to save it into a file location on my PC. Any ideas? Ta KISS - Keep It Simple Sugar!
  15. dhaveedh

    Saving a Report to a file.

    Does anyone know how i can save a report to a file location? I have created a printable letter from an access report and want to save each letter in a file after printing it out. Can you help? KISS - Keep It Simple Sugar!
  16. dhaveedh

    Data source name too long

    Can anyoe tell me why i get the error message; Data source name too long with this piece of code? <% Response.Buffer = True strUser = Request.ServerVariables(&quot;LOGON_USER&quot;) ' ********* Dim sDSNFile Dim sPath, sDSN sDSN =...
  17. dhaveedh

    Record Locking

    How can I implement record locking in Access in such a way that no two users can retrieve the same record at the same time. By this I mean, User A and User B are logged into the database. There are 5 records in the database. Once User A sees Record 1 or any other record it cannot be seen by...
  18. dhaveedh

    VB6 and Outlook

    I have developed an application with VB6 which is used to send mails over the internet to my clients. MS Outlook 2000 is my default mail client and i have used MAPI. We need to install the same application on my clients systems so that they can send responses back to me. After installing, I...
  19. dhaveedh

    Using a WHERE clause in Docmd.openform

    I have two forms A and B. I want to open form B when I click a button in form A. This is straighforward. What I want to do is specify a criteria in the where clause of the Docmd.openform statement. This criteria is to serve as a filter for Form B so that i only display certain records. The...
  20. dhaveedh

    Where clause in Docmd.openform

    I have two forms A and B. I want to open form B when I click a button in form A. This is straighforward. What I want to do is specify a criteria in the where clause of the Docmd.openform statement. This criteria is to serve as a filter for Form B so that i only display certain records. The...

Part and Inventory Search

Back
Top