Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Lightlancer

  1. Lightlancer

    calculate % in a report

    solved, used ProgramError his method. Thanks for the help
  2. Lightlancer

    calculate % in a report

    field give #error with this code....
  3. Lightlancer

    calculate % in a report

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

    if then not working properly

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

    if then not working properly

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

    if then not working properly

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

    A wait msgbox

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

    A wait msgbox

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

    open form with where condition from a variable

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

    Put 2 or more fields into 1 field

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

    Filtering a combobox

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

    this properties or method is not supported by this object

    thanks for the tip:D
  13. Lightlancer

    this properties or method is not supported by this object

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

    this properties or method is not supported by this object

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

    Hide question from a query

    Thanks!
See more

Part and Inventory Search

Back
Top