Recent content by Loranga

  1. L

    [newbie] Is this the right way to do it?

    Hi, Thanks for the input. The design was just a single table for me to work on, trying to get the combobox and query to work. But with the help from your input I'll change it later on. About the file, I don't have any problems you deleting it, but I think boblarsson is on to something when...
  2. L

    Hej! (Swedish for hello)

    Uncle gizmo: Thanks, I'll definitely will have a closer look at that when I'm a little more "warmed up" with Access. Jibbadiah: Kan jag få en korv tack? Yes you can have a sausage, do you want marmite on that? :) This looks like a real friendly and helpful forum from what I've seen. Say hello...
  3. L

    [newbie] Is this the right way to do it?

    Wohooo! I think I made it, my first working project :) What I wanted to achive was a form where I could make three choices with comboboxes and based on the choices made, display the corresponding value from the table in a textbox. My question to you guys is this the "correct" way to do it...
  4. L

    Whats Me. ?

    Ok that make sense. Thanks for clearing that out
  5. L

    Whats Me. ?

    Aloha, I have bought a couple of acces books (but they havent been delivered yet) hopefully they can straighten things out for me but in the meantime I post a question here..... Trying to learn Access I stumble on different code with the the "prefix" Me. EG. Me.txtOne.Value =...
  6. L

    Asap utilities great timesaving tool!

    Aloha, I just want to recomend a real time saving tool set called Asap utilities. http://www.asap-utilities.com/ (free for personal use) If I break any rules posting this I apologise, but I assure you I have nothing to to with this tool besides being a normal user.
  7. L

    Hej! (Swedish for hello)

    Hej, After working with Excel for couple of years now I finaly decided to step into the world of Access. A long time ago I had some database course in school but unfortunately don't remember much about ER charts, primary keys ans so on so I think I'll have to start from schratch... When I'm...
  8. L

    [newbie] Problem combine two working Dlookup

    Thank you very much Trevor for taking your time and creating this exaple. I'm aftraid I did a bad job explaining my problem... If I use your form I would like to write the company name (or even better use a combobox) in the txtOne box and the resource in txtTwo box. Then have some sort of...
  9. L

    [newbie] Problem combine two working Dlookup

    Aloha, I'm trying to learn Access and struggeling with a simple Dlookup... My problem at the moment is that I can't make my dlookup work the way I want to. In this exaple I would like to show the correct price from the table Pricelist based on the input values in the textboxes Company and...
  10. L

    [Newbie] Replace filter values in query

    I have now got to the point where my textbox is populated with a fixed value whenever I change the combobox. Private Sub Resurs_Click() Text34.Value = 999 End Sub Now I only have to dig deaper in how to use the dlookup. :) Edit: Since I'm trying to learn this I tried a different approach and...
  11. L

    New Quick Tutorial - Exclude Data using a table

    Hi bob, Right now this is a little bit to complicated for me but I just wanted to say I think it's great you used the northwind databse for this example. This make it alot easier to follow. I have bookmarked your site for further reading. My regards from a fellow viking (Larsson being a common...
  12. L

    [Newbie] Replace filter values in query

    Thanks for the qiuck answer. I was thinking of a combobox that will show the right price based on selection of Company and resource. Right now my combobox only shows the price for the company "ACEM" where the resource is "1281". (since I manually typed that criteria) But since I'm a real...
  13. L

    [Newbie] Replace filter values in query

    Aloha! Sorry for beeng a newie, maybe this is the wrong category for this post.. I'm just starting to try and learn Access 2007. I have a table named Pricelist wit the fields [Company], [Resource] and [Price]. In another table named [Orders] I also have these fields but when I type in the...
Top Bottom