Search results

  1. R

    Can't modify data

    I think it could be "It has a subquery in the SELECT clause. Uncheck the Show box under your subquery, or use a domain aggregation function instead." or "It uses JOINs of different directions on multiple tables in the FROM clause. Remove some tables." In first case, How can I correctly use...
  2. R

    Can't modify data

    I've created a query from two tables using left join, and it works great. SELECT tblImpozycjaSzczegoly.id_tblImpozycja, tblImpozycjaSzczegoly.id_imp_szcz, tblImpozycjaSzczegoly.NRskladki, tblImpozycjaSzczegoly.SposobUlozenia, tblImpozycjaSzczegoly.IloscUzytkow, tblImpozycjaSzczegoly.Naklad...
  3. R

    count amount of string.

    Thanks! It's really helpful for me
  4. R

    count amount of string.

    In form (datasheet) I have a three columns "RightColors", "LeftColors" and "AmountOfColors" I want to do something like this: If I fill 'RightColors' "red;green;blue;", and fill 'LeftColors' "orange;" then in 'AmountOfColors' column should be "4". Sometimes I can fill only 'RighColors' or...
  5. R

    Design of the table

    I have a 33 columns in my table (in accordance with the normalization, describe one thing). But only 16 of them, every time I complete. Technically I can split this table to two tables. So the questions are: 1) What is better for performance. To Have a one table? Or split to two tables with...
  6. R

    "WHERE" in SQL

    in the following code "id_zlecenia" is text field and "idStarego" is string - This code wokrs well. BUT now "id_zlecenia" is number filed and "id_starego" is long variable. How should look the new "WHERE"? ... "FROM TblDolZleceniaZakonczone " & _ "WHERE ID_Zlecenia ='" &...
  7. R

    INSERT INTO Or UPDATE Multivalued field

    THX!!!! This solves my problem:)
  8. R

    INSERT INTO Or UPDATE Multivalued field

    I want to to copy data from one table to another. I have read about MVF, I know that isn't good solution, can't migrate data between others software and many other problems. But in my situation it's really helpful. Also I have read about work with MVF and all what I know, that there should be a...
  9. R

    Multiple criteria to open a FORM

    I just try to open this form after INSERT INTO. Yesterday You gave me a code that allows me open a form a moment after INSERT INTO and It works, but when I writing an example in post I forgot that my FORM doesn't have only one source (not from one table but two tables). Your code works great -...
  10. R

    Multiple criteria to open a FORM

    SELECT tblZlecenia.*, tblOffset.raport, tblOffset.CieteNaSztuki, tblOffset.edycja_list, tblOffset.Bigowane, tblOffset.Falcowane, tblOffset.NacinaneNaArkuszu, tblOffset.NacinaneOdSpodu, tblOffset.Sztancowanie, tblOffset.Tloczenie, tblOffset.KlejenieWBloki, tblOffset.ZszywkiProste...
  11. R

    Multiple criteria to open a FORM

    How to open FORM which has "inner join" in source? ... Dim idRS As DAO.Recordset, ShowIdentity strSQL = "INSERT INTO tblZlecenia (id_zlecenia_info, DataPrzyjecia) VALUES ('" & _ ostateczne & "', " & _...
  12. R

    Open FORM after INSERT INTO

    THX pr2-eugin, It works (in Form with one source), but I forgot that source of my FORM is not one table:/ I have a inner join "tblZlecenia" and "tblOffset" on tblZlecenia.id_zlecenia = tblOffset.id_zlecenia. Is there any possibilities to applay your concept to inner join? Should I add using...
  13. R

    Open FORM after INSERT INTO

    No it's no the problem. The data in the table are correctly added. Problem is open form with id which was added a moment ago
  14. R

    Open FORM after INSERT INTO

    Is there any possibilities to open form after INSERT INTO? I think Ms Access can't fast refresh data in the table after that, so form opens up clean:/ ... strSQL = "INSERT INTO tblZlecenia (id_zlecenia_info, DataPrzyjecia) VALUES ('" & ostateczne & "', Date())" CurrentDb.Execute strSQL...
  15. R

    WHERE in SQL

    So it could be something like Dim sSQL As String Dim rst As Recordset sSQL = "SELECT id_zlecenia FROM tblZlecenia WHERE DataPrzyjecia = Max(Dataprzyjecia) as LastDate" Set rst = CurrentDb.OpenRecordset(sSQL) Me.Tekst1 = rst!ID_Zlecenia rst.Close: Set rst = Nothing But how to write it...
  16. R

    WHERE in SQL

    I have Two types of ID in my tbl. First (key) "id" - autonumber, and another "id_zlecenia" (relic of paper orders). "id_zlecenia" e.g. "171/14" (number as of this present year/ two last numbers of year), Find youngest date will help me find last "id_zlecenia" then I can create next "id_zlecenia"...
  17. R

    WHERE in SQL

    I want to find field "id_zlecenia" - autonumber where field "DataPrzyjecia" - Date is youngest in table "tblZlecenia", I have a problem with WHERE, I know that, should use "#" for a date field, but I don't know how to write it. Function - I think MAX will be ok. Dim sSQL As String Dim rst As...
  18. R

    hard case with multivalued field

    I have a two tables and I want to transfer data(from tblDolZleceniaZakonczone to tblDolZlecenia). In both cases, type of data are the same, except one. tblDolZlecenia.id_gora_zlecenia - is lookup multivalued field Lookup: SELECT [tblGoraZlecenia].[ID_gora_zlecenia], [tblGoraZlecenia].[Nazwa]...
  19. R

    Jumping Scrollbar

    Spikepl it doesn't work. scrollbar still jumping. In my last version, I had a list instead datasheet and in this variant scrollbar did not jump, but datasheet is more clear...Anyway is there any way to update datasheet without .requery option? The problem is that .requery Set focus on the first...
  20. R

    Jumping Scrollbar

    I hava a list of my orders (subform datasheet based on a query), this list is updating every 30 seconds (status need to be updated). The problem was position cursor after requery, but I found the code: Dim strBookmark As String strBookmark = Me![frmAktPD].Form.Recordset.Bookmark...
Back
Top Bottom