Search results for query: *

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

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

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

Is it possible to detect if a form is present at the start of the database/startform without displaying it ? And how will that be done. So I can use to make it not possible (at a easy way) to delete a form of the database(GUI)! I can imagine that I take a variable that will be set only on the...

I made a query for a bargraph (blockdiagram). But it doesn't work the way I want it! Little explanation how it has to be : The graph has a time axis (years). For every selected year (by fill in boxes, value between .... and ....) that's in the dbase, I wanna see the sum of column 1 (of...

Hi, I made a query out of my database. The query consist of 2 columns (BudgetYear, Expense).In the BudgetYear column there are more then one of the same budget years (like 10 times 2005 etc). Because there are more expenses in one BudgetYear! What I wanna do is : The user fills in a start year...

When I close an fill in form, that I saved before (.update all the fields into database) with a save button on the form, I get an access messagebox that there are 2 users who are using this form ! And I (= user 2) can save it again but the information (saved by the save button (= user 1) will...

When I edit a recordset, it will be at the first record of the database instead of the selected recordset, selected by IndexNumber. Code: Dim Db As Database Dim Rs As Recordset Set Db = CurrentDb() Set Rs = Db.OpenRecordset("select Offer, EstimatedPrice From Investmentplanning order...

Is it possible to select a file (photo,doc, power point slide etc) with access 2000. What I wanna do : I have an fill in form for my database. I got 3 directories on HDD : Photo, PPSlide and Offer. I wanna know if it is possible (and how) to have a fill in field that is linked to one of the...

I got a problem with the where condition of the cmd.openform ! See code below : Option Compare Database Option Explicit Dim Plaats As String Private Sub IndexNumber_Click() Plaats = Me.IndexNumber DoCmd.Close DoCmd.OpenForm "ApplicationForm", acPreview, , "IndexNumber = Plaats"...

I made a fill in form, when the user clicks the save button the data of the fields will be saved into a new record with .AddNew and .Update. That's working OK. But when I use DoCmd.close at the end of the sub (or I close the form by hand) an empty record is been added to the database with index...

I'm still a newbie and got a problem with a loop were I use Me.fieldname. I load a form where the user can fill in some fields. I read these fields one by one with Me.fieldname. I read those fieldnames in a loop. The problem is that the user never can fill in all the fields at once (that's why I...

I gotta database and I wanna add a new record to this database. To arrange the next indexnumber for the new record I use rs.RecordCount (see code below) this is possible because the first record has indexnumber "1".So a new indexnumber for the new record will be rs.recordcount + 1 !!! This...

About VBA I'm just a starter ! I wanna know if it's possible to jump out of a loop when I click on knob on the screen. See the code below, the While do loop and the knob "Knop82_Click". According to VBA I only may use a function or a variable in the While loop. Please let me know what to do ...