Send Email using CDO
Fri, 21 Nov 2008 00:46:09 -0800
Hallo
I hope some one can help me im using the folowing code to send emails trough
our company exhange server and its working fine but now they want me to send
it trough a relay server can any one tell me how do i set it up. The PC where
the app is running on is XP
Regards Markus
Option Compare Datab ...
|
Incorporating authors name on text box control
Thu, 20 Nov 2008 21:56:01 -0800
Hi Guys,
I have a risk form that I want to ensure that the author of a risk is
entered automatically onto a text box that is bound to the "Authorsname"
textbox control.
Each authors name is displayed on the form and I want ot utilise this
control to insert into the textbox of the risk subform.
how do ...
|
Form_MouseDown not triggering
Thu, 20 Nov 2008 15:01:00 -0800
I want to trigger an event if the mouse is clicked anywhere on a form. This
seems pretty straight forward, but it does not seem to work in access -
surely I must be doing something wrong?? The code I am using is:
Private Sub form_MouseDown(Button As Integer, Shift As Integer, X As Single,
Y As Single)
MsgB ...
|
SQL Server Express versus Access (In the World Series of Love)
Thu, 20 Nov 2008 14:08:01 -0800
Question - since SQL Server Express is available for free, why WOULDN'T it be
better to use it in stead of Access for a database backend? Other than
overall ease of portability which is minimal (copy & paste a file as opposed
to backup/restore) and system requirements, I can't think of too many other
reasons ...
|
Changing borderColor with a button
Thu, 20 Nov 2008 12:44:00 -0800
In a previous question I was show how to change the color and thickness of a
border with a button and it work great. However two problem have come up.
first I noticed the after I change the bordercolor save and then exit the
form the border defult back to the way it was. How can I prevent this.
Second unlike ...
|
ADO Error in Access calling from Excel
Thu, 20 Nov 2008 11:41:03 -0800
I have the following code. I get an error as conn.open line.
This happens on various machines which run the app. This code is invoked
from an Excel front-end and gets data from Access back-end which is
referenced by \\server\folder.
Any help would be greatly appreciated.
The error is as below.
Error **** ...
|
Is there a good version tracking program someone could recommend.
Thu, 20 Nov 2008 11:27:01 -0800
My problem is that I need to know what changed between versions of an access
2007 database. Because there is two people working on the database we can't
always tell what has changed between versions. I am wanting to know all the
way down to each control on every form/ vba on modules etc. If someone could
...
|
|
|
"Selected collating sequence not supported by the operating system
Thu, 20 Nov 2008 11:22:06 -0800
run-time error '-2147467259 (80004005)':
Selected collating sequence not supported by the operating system" ...
|
Forms ControlSource with DAO
Thu, 20 Nov 2008 08:13:01 -0800
I have this code in the load event of my form.
Private Sub Form_Load()
Dim rst As DAO.Recordset
Dim db As DAO.Database
Dim q As QueryDef
Dim i As Integer
Dim j As Integer
Set db = CurrentDb
Set qdf = db.QueryDefs("AllBalancesByFCandDBPD")
For Each prm In qdf.Parameters
prm.Value = Eval(pr ...
|
Save html to Excel within Access 2003
Thu, 20 Nov 2008 08:11:01 -0800
Is there a way to save an .html file as an excel file within a module in
Access? I need to import the data into Access, but when I import the .html,
the fields get all mixed up. If I open it manually in excel, save it as an
excel file, then import it into Access using DoCmd.TransferSpreadsheet, it
imports co ...
|
