Search results

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...

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...

Thanks! It's really helpful for me

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...

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...

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 ='" &...

THX!!!! This solves my problem:)

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...

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 -...

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...

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 & "', " & _...

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...

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

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...

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...

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"...

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...

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]...

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...

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...