Recent content by Lightlancer

solved, used ProgramError his method. Thanks for the help

field give #error with this code....

hi all, i a report in access 2007 i have 3 fields, field 1 = Price field 2 = discount field 3 = total to get total working i did have =([Price]*20) then the price will be * 20 in total, now the field total must also calculate the discount, in that field there is 0% till 100% how can i...

solved the problem, created a query, and the query will filter on Serienummer. In condition of the query i put: getSerienummer() then in the call back functions i put this Function getSerienummer() blabla bla getSerienummer = me.Serienummer End function This worked:D Thanks for the tips...

i also tried to use if me.serienummer = me.test then it also doesnt run

hi there, strange thing just happend, I have 2 fields: Me.Test & Me.Serienummer both contains the same value! (12345) When i run this code If Me.Serienummer = "gstrNummerserie" Then gstrFactuurnummer = Me.Factuurnummer gstrAanschafdatum = Me.Aanschafdatum gstrGarantietijd = Me.Garantietijd...

mmmm, Yeah good idea, Stupid i didnt come up with that idea....... Thanks anyway:D

Hi there, When a user logins and clicks the login button, there must popup a msgbox that automaticly disapears after 5 second. there must be no buttons on that msgbox it just appears and 5 seconds later is must disappear and continue the rest of the code. is there a way to implement this...

Hi, I want to open a form with a macro, in that form there is a field named: "NaamMedewerker" Stored in a variable "gstrDezeMedewerker" now the form must open on the right record, so the where condition must be something like NaamMedewerker = gstrDezeMedewerker i Tried this...

Hi, i have 3 fields, that must be put into 1 field, so field 1 is: Test Field 2 is: 12 Field 3 is: 3 Field 4 is the field wich contains all information, so when a user puts in data, VBA must automaticly put all 3 fields into 1 so that Field 4 is: "Test 12 3" How can this be done, is thought...

Hi there, I have a table with 3 fields, "Merk","Type","Productnaam" On a form the first combobox is "Productnaam" The seccond is "Type" The third is "Merk" When the first combobox has the value "Windows" then the second "Type" should show "98, 2000, ME, XP, Vista" then when the second is...

thanks for the tip:D

Solved it, by changing Me.Versie to DLookup("versie", "versie")

Hi there, In my table "tblstatus" i have a field named "Versie" its a Text field. in that field this number is filled in: 211880 In my first form of the database, a field (that is hided) has also a number: "211880" the form must look if this number is the same, higher or lower.... If...

Thanks!