Search results

In my procedure I want to select content of "status" (text) column where "id_status" (number) = "spr_skrocony_obieg" (variable as long) How should I write procedure of this case? dim strSQL as string dim spr_skrocony_obieg as long dim db as DAO.Database Set db = CurrentDb spr_skrocony_obieg...

I forgot about order by, how can I put it in to a code? "order by tblstatus.lp"

thx!!!!!!!!:).

How could I put variable in WHERE? dim waga as byte waga = me.status.column(2) me.kombi11.rowsource = "SELECT [tblStatus].[Id_Status], [tblStatus].[Status], [tblStatus].[waga], [tblStatus].[uprawnienia] FROM tblStatus WHERE tblstatus.waga < waga;"

I checked and the record was created in the tables, so when I refresh form, the new record exist in tables. All I want is open form with new id and only with this id, without options to move to previous or next or new record.

It's really annoying. When I click the button "open new order" after that my form it's open with new id and it's ok, but when I push the key "F5" then Ms Access goes to another record (no new record). Why is that?

I want to refer field "plyty_sa" which is in "RaportZleceniaRobocze" Report, in "RaportRobocze_Offset" SubReport. The problem is that, SubReport is in Report Footer. I tried many possibilities but I can't find solution. Please guys help!

Working gooooooood, thx:D

I want to see if there is some kind of record in "technologia" field in table "tblDolZlecenia" where "technologia" = 1 and where tblDolZlecenia.id_zlecenia = forms!frmZlecenieMarzena!id_zlecenia (id_zlecenia is a text field) So I built DLookUp, the problem is, that two criteria won't work...

I need check all data from list not only selected item so I had to change the code little bit If Nz(DCount("[Priorytet]", "tblZlecenia", "[Priorytet]=" & pozycja), 0) > 0 Then Now it's working. You really helped me SmallTime, Thank you for solving my problem

Id_zlecenia is unique

Thanks for insight. First of all "Priorytet" isn't bound field. I need information not about selected item, but from all of data on the list (where "7" could be in "priorytet" column). Yes there will be variable not "7" (in the future), now I gave some example with "7" I don't need message box...

I want to update "Priorytet" in "tblZlecenia" to 7, but only if there is no "7" in any "Priorytet" in "tblZlecenia". If already some record has value "7" then exit sub.

On event "key press" I want to check that in my field "tblZlecenia.priorytet" there is value "7", if yes then Exit sub. I know how to create query to get results with all rows with "7" in my table, but I don't know how to get it in event using vba. My code: Private Sub Lista0_KeyPress(KeyAscii...

:D:D:D:D:D:D Working! THX!

I have a code on my list Private Sub Lista0_KeyPress(KeyAscii As Integer) Dim strSQL As String Dim db As DAO.Database If KeyAscii = 50 Then strSQL = "UPDATE tblZlecenia SET Priorytet = " & "7" & " WHERE ID_Zlecenia='" & Me.Lista0 & "'" CurrentDb.Execute strSQL End If End Sub When I press...

I have my database on a server. There is some way to have access from Internet to my database (split to front-end)? I mean, I open my front which can automatically connect to my database using Internet and download data from end (server).

THX, now it's ok:)

I can't fill this space with the background color (see attachment). Someone know how to figure it out?

Ok, now is working. That was error which was described in your link pr2-eugin (but not about subform, it's about field in subform). Thank you very much pr2-eugin!!! "id_pracownicy" - name "id_pracownika" - control source BTW What is ".eof"?