Search results

I filter my subform (datasheet) by fields, everything works great except "date" column. MS Access shows that record does not exist but it isn't true. My code Me![frmAktPD].Form.Filter = "[Data przyjęcia] = " & Me.DataPrzyjecia Me![frmAktPD].Form.FilterOn = True Where is the problem?

It works! THX!!!! Do you have some link where could I find rules of the notation? I was looking for sometime, but I have not found (only short description)

Now MS Access has problem with operator in this line Private Sub Polecenie0_Click() Dim strSQL As String Dim recIn As Recordset strSQL = "SELECT * FROM Zlecenia" Set recIn = CurrentDb.OpenRecordset(strSQL) While Not recIn.EOF strSQL = _ "UPDATE tblDocelowa " & _ "SET...

I would like to paste value from tblZlecenia.nowe_id to tblDocelowa.nowe_id (number fields) in every record where tblZlecenia.id_zlecenia = tblDocelowa.id_zlecenia (text fields). I found some code and remodeled it, so now my code look like this: Private Sub Polecenie0_Click() Dim strSQL As...

I have a query SELECT tblZlecenia.ID_Zlecenia, tblZlecenia.TerminOdbioru, tblOffset.ID_RodzajZlecenia, tblZlecenia.NazwaZlecenia, tblZlecenia.Id_K, tblZlecenia.Id_Rodzaj_Pracy FROM tblZlecenia LEFT JOIN tblOffset ON tblZlecenia.ID_Zlecenia = tblOffset.ID_Zlecenia where In where I would like to...

1) Hmm. e.g. tblOrders and tblTypeOfOrders. When arrows run from tblTypeOfOrders to tblOrders, this means that "Take all records from tblTypeOfOrders and only these records from tblOrders where fields are equal". So I think it isn't wrong. But when I run the arrows in the other side I don't see...

I have a form with 9 text fields and list. If you fill field, on the list, are shown data filtered by this criteria. If you fill another filed, then previous criteria are reset and then we will see data on the list with new criteria. Now I try to indexing tables as good as it could be. So I have...

Microsoft Access does not allow turn it back (autonumber filed)

When I tried paste some data using front end to my database, Access showed error (can't create record because data would be duplicated). I thought it's impossible because it is autonumber filed. So I checked it (manually). I did copy of my database and then for testing, I created record. I was...

What about VPN? How looks work with data from this connection? It's could be good solution? I heard about web aplication in MS Access 2013 someone work with this? It have matter when I will have a SQL server (online work matter)?

Ok, so I have an aplication split to front and backend(61 tables). Everything working in LAN. It's about printing process (Orders, and related technological cards). We can have 1) Active orders and 2) Orders completed. When orders get last active status, then user push "close order" button and...

Why You think that?

I have a code which cut the data from tables and insert to others. The problem is I don't know when I can do this process (when I will cut data and the same time some users lock editing records then I will get an an error). So my question is, there is some procedure which can check that some...

I have a back of my base on ftp. Now I working on my base using front which is in local network. But I would like to work online. So I have to connect to my base from the internet. I read about connection string. But where should I past code of connection string and how to use it? Is there...

I found connection string which I should use. But where I should past this code, and how to use it? Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb; Persist Security Info=False;

How to requery queries? I tried Queries!Query2.requery; Query!Query2.requery but doesn't work.

yes Doesn't work kennejd If I set focus to the control which is on top, then scroll bar will be almost on top (labels will be invisible). Is there any possibilities to push "pg up" button using vba? I think it is solution.

Please see my attachment. Look at the position of vertical scroll bar. When I open my form the scroll bar should be on top.

My form opening with page down screen, how could I open it with page up screen?

exactly that's my problem. Why can't I execute a SELECT query? So What should I do, to take value from that and use it in further vba code?