I read all the threads, but still it's not clear for me !
I'll send an email from my db-form. That works !!!
In other threads I read that to get around the security problem it's possible to use the outlook redemption.
Used code:
Titeltxt = "New "
Bodytxt = "User: " & username & "
Set APP =...
Ok I can add all the textfields of an email but still can't send the email automatically. So that the user doesn't have to click on the send button of the email !!!
Code:
Titeltxt = "New email"
Bodytxt = "User: " & username & Datum & "-" & InvestNR
DoCmd.SendObject
x =...
In my Access 2000 database I made some fill in forms for the user.
When the user fills in a new form or changes an existing form then he/she needs to save this form. After saving the form the database opens also an email (to send to me/owner database).
The user has to type text and title of the...
Hi,
I'm using an hyperlink in my database that I display on a form. Because of the lenght of the hyperlink a wanna use only the last part to display on my form. The first part of the string has always the same lenght(68), the part that I wanna use doesn't.
The code I tried :
Index =...
Is it possible to connect one or more fields to the outlook agenda ?
Something like I have a table of employers with their date of birth in it. So when an employer reaches his/her birthday the outlook agenda automatically generates a message ?
I didn't find anything like that in my access...
When I use a password to open/secure the backend I get an error message when I use the frontend !
error 3031: no valid password !
How can I solve this problem ?
I got a big access handbook, but that's not telling what to do. It tells about using/creating a password but doesn't mention about...
I've split my database into a front- and back-end part.
Since I did that I get an error message.
Explanation of the code :
every database user has on his pc a configfile with his/her idnumber. This idnumber will be compared with a number out of the table "gebruikers" column "IdNr".
The code...
I used your suggested code :
docmd.runcommand accmdsaverecord before Rs.Close and Set Rs = Nothing of the first openrecordset when loading the form (see also my 2d thread).
Now I don't get an writing conflict anymore, But I still don't understand it because at loading and editing the form I...
The form (with save button) is not bounded.
When I load the form I'm using the next code :
Set Db = CurrentDb()
Set Rs = Db.OpenRecordset("Select * FROM InvestmentPlanning WHERE IndexNumber=" & Index)
Me.txtInvestNR3 = Rs!InvestNumber
Me.txtInvestDate3 = Rs!InvestDate...
I still got an editting problem !
If I edit field offer or Photo I get an error : "error 438, this property or methode will not be supported by this object".
But I also edit field PowerPointSlide the same way and that's working OK !
See the code:
Private Sub Knop82_Click()
Set Db =...
Now I know what Nz function does (nice one).
But there's something going wrong with the code between-and. Because if I change between into like and skip the Year2 part it works !!!
Does someone have a qlue ?
I'll tried the SQL-code of PHV but then I get an error that I can't open the resultform !
I open the form with this code :
DoCmd.OpenForm "Selection from database", acNormal, , SQLStr
What can be the problem, and what does Nz do in this code ?
The rest of the SOLStr-code :
SQLStr = "[InvestmentPlanning]!IndexNumber > 0"
There are more fields on the fill in form and also included in the SQLStr-code but when I select one of these fields instead of the both fields with Year1 and Year2 it works well. So the problem is probably in the...
I got a fill in form with field year1 and year2.
And I got the code below :
If (Not IsNull(Me.Year1)) Or (Not IsNull(Me.Year2)) Then
If IsNull(Me.Year1) Then Year1 = "2000"
If IsNull(Me.Year2) Then Year2 = "2020"
SStr = "#" & (Me.Year1) & "#"
EStr = "#" & (Me.Year2) & "#"
SQLStr...
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.