Recent content by SmallTime

Easily done my friend, but at least your loins are OK

Just and idea since you're using reserved words. Would it be that you need to explicitly declare the variables. It's the case in queries that don't have definite headers such a cross-tab queries but may also be the case here. Just a shot in the dark but try setting the variables in the...

Ah ha, reading it again I see that's exactly what Mark meant. Sorry combinations of late night and square eyes. Thanks

Many thanks for that, I always thought the opposite was true, but will have a quick read-up in the morning. Ta

Just writing some queries for 500K + records with a various restrictions in the WHERE clause and was wondering if the order in which I restricted the data would have any affect on query performance. Is it better to place the broadest restriction first and then filter down form there or does it...

Can't open your images.

Nice Spot, I'm gonna give you a thumbs up too

or even Nz(DLookup("[technologia]", "tblDolZlecenia", "[Id_zlecenia]=" & Forms![frmZlecenieMarzena]![ID_Zlecenia] & " And [technologia] = 1"), 0)

Really glad it worked out for you Take care

The easiest way is to do this is through a query otherwise you'll have to iterate through the rows in the listbox (I suspect much of the SQL for the query is already held in your Listbox) and a query will help you better visulise your data. Create the query first in the Query Designer so can...

Sorry missed the bit about all items in the list box. Isn't ID_Zlecenia unique?

Couple of ways to do this, but without knowing much more what about If DLookup("[Prioryte]", "tblZlecenia ", "[ID_Zlecenia]=" & Me.Lista0) <> 7 Then Msgbox "This is Not 7" END IF of course you can replace Msgbox "This is Not 7" With your update code try it on the AfterUpdate Event of the...

Sorry I cut my reply off a little short- got called away I meant top point out that this isn't a very good method as people have a habit of clicking a list box and in this case it'll change your recode every time it's clicked without warning. Of you must do it this way then perhaps a message...

Assuming that the list box is bound to Priorytet what about a simple If Me.Lista0 <> 7 THEN so something - Like run your update query END IF Also if you're always changing tblZlecenia.priorytet to 7 you don't need " & "7" & " - a 7 without the ampersands and quotes will do just fine...

Hi Do you mean you want to UPDATE (Change) Priorytet in tblZlecenia to 7 for whatever record is selected in your Lista0 Or Do you you want to Just check if the selected record in your Lista0 is ALDREADY 7 Perhaps it might be better if you explain what your're trying to achieve Take care...