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!
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 =...
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 =...
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!
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...
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...
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!
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...
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!
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...
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!
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...
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!
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!
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("LOGON_USER")
' *********
Dim sDSNFile
Dim sPath, sDSN
sDSN =...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.