Recent content by Schaap

Problem solved with Mapilab free redemption stuff thx 4 all the clues

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

Thanx lupin Me.OfferLink = Mid(StrLink, 69 that's the wright one

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

Ok thanx, you got it wright problem solved

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

Thanx a lot, you did it again !!! it works !!! you're a genius

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

It's working thanx a lot !!! :-)