Recent content by smask

Hi! I've got a table with IN that contains Customer ID etc.. In an other table I've got Customer ID and Customer name. Now I want to create a Query that displays Customer name next to its ID. Ball Blue 7124 Mike's Inc How will I do this?

Hi! Can I have a form (datum) that transmits the criteria to a query? Like the Form gives me [tre] and [fyra] In the criteria field in the query: Between #Forms![Datum]![tre]# And #Forms![Datum]![fyra]# / Smask

Hi! I finaly got it to work. With List7 .RowSource = "SELECT * FROM Datum WHERE [Datum] Between Forms![Datum]![Start] And Forms![Datum]![Slut]" .Requery End With / Smask

Hi! I'm trying to get my form to search between two dates and display all data that lies here. In my fist nive expression i wrote like this. With List7 .RowSource = "SELECT * FROM Datum WHERE [Datum] Between #Me.Start# And #Me.Slut#" End With :confused: :confused...

You really got a point! Didn't think at all of using criteria. Thanks / Smask

HI! Kundnummer is a value that I get from a table and now I only want Kundnummer if it is equal to 100. The whole thing I want my query to do is: From ny table Indata I want to display [ett], [Två],[Tre] if [Kundnummer] is equal to 100. (Kundnummer = Customer ID, so every customer has it...

Hi! I want to do this: Select only [Kundnummer] then [kundnummer] is equal to 100 in a query. Have tried this (in the "field" field) but Access just complains. IIf ([Kundnummer] = 100, [Kundnummer], " ") / Smask

Hi! I'm making a form and want to locate a query. How will I do it? Are there any commands like this but for a query? Forms![frmLookup]![lbxLocationLookup] / Smask

Skips zeros! Hi! I've got a form that shows some data. This data can also be zero (0) and then I don't want to show it in my form. With List7 If .RowSource = "SELECT * FROM Urnaquery WHERE [Expr1]" > 0 Then .RowSource = "SELECT * FROM Urnaquery WHERE [Urna] Like '" & _...

Hi! How will I make my form start when you open my Access file? / Smask

Thanks! Working with charm! Eller vad det nu man säger!? / Smask

Hi! I've got a table with Customer number and Customer name. Now I'm making a form that will show name if you type in number. Any suggestions? / Smask

Hi! Thank you wery much! Tack så jättemycket! / Smask

Hi! I'm trying to figure how to make this work in my form. I want the form to jump to an empty record (after the last entry) when the form is open. Private Sub Form_Load() Me.RecordsetClone.FindFirst "Isnull([Subject]) And Isnull([Date])" Me.Bookmark = Me.RecordsetClone.Bookmark End Sub...

I put the Hi, thanks for the quick reply! It works perfectly! / Smask