Search results for query: *

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!

Hi there, I have a update query that is running when a form is closed, then the query asks the user if he is sure to delete ** records, or to edit records. is it possible to disable this message? Greetz

Hi there, When i run my app in Full access the form is normal, when i run my app in Runtime access, the form resizes en the letters just go Big, if a label is named: My App 2.0 in Runtime it will show very big: My App 2. its with all forms, any ideas

Well i got it fixed for now, i created an accde instead of accdb, and now all errors are gone......

I think access tries to tell me that the module doesnt exist, i had this problem long time before....... dont know how i solved that, because when i remove in all forms all code that has to do with this module, the DB work perfectly again......

Ok, thanks for the tip, i tried 5 times, and no luck, but i now know where i need to look, its a VBA module called "modHulpprogramma's" in this module stands the following code: Option Compare Database 'Gebruik databasevolgorde voor tekenreeksvergelijkingen Option Explicit...