Search results

its Own after update event

How to set combo value to nothing (no delete recrod, no set value to 0) I just want to clear value from combo box in after update event.

Is there any possibilities to increase spacing between rows? When I have font size 10 it's really annoying rows are so close.

Query still return only fields like "id_zlecenia" and "kolejnoscmax" but I also need "id_Procesy_zlecenia" - and that's the problem

Interesting conception, but I need tblProcesyZlecenia.id_procesy_zlecenia to see also in my query. I should tell that datarozpoczecia = tblProcesyZlecenia.datarozpoczecia

Unfortunately no:/

I thought so. THX

I need to add tblProcesyZlecenia.id_procesy_zlecenia to "select" section into my query. But then query will return 3 rows instead of 1 row. So how can select tblZlecenia.id_zlecenia, tblProcesyZlecenia.id_procesy_zlecenia where tblProcesyZlecenia.kolejnosc is max value? SELECT...

My query (which i mentioned above) repositioning the tasks. Sometimes I need to add a new task between the others while processing job. So i need to have sequence to avoid mess

I need it to determine the sequence of production process in specific job. I have many Processes which could be used in different sequences according to the job. It is impossible to define all kind of jobs and sequence of process of these. I need to set every time

In my form (Datasheet), after delete some positions i need to recount my sequence e.g. if i have 1 2 3 4 after deleting position 2, query will change value bigger than 2 to achieve the correct sequence from 1 3 4 to 1 2 3 so my query is strSQL = "UPDATE tblProcesyZlecenia SET kolejnosc =...

Still don't know how can i get name of the columns:/

I have a table with many yes\no fields. Now I need to use some code in Recordset which can check that field is -1 or not and if is -1 then get the name of this field So the problem is use some properties for every fields in my Recordset no matter what is called to check -1 or not, and take name...

Ok REALLY don't know why, but today, syntax which I mentioned in my first post, working fine:). THX Ranman256 for your insight

Yes ofc i used "subform" like an example, my subform is called "Mój monitor zleceń". Is this possible to use this subdatasheetexpanded to set subform?

I have a 3 forms MyForm Subform subform2 Want to turn off expanded subform2 so I need to set subdatasheetexpanded = false on subform, but when I try to do it from myform then ms access return error that can't find subform Forms!Myform!subform.form.subdatasheetexpanded = false Is there any...

Thank you for your insight When you open the file, form should open automatically then you will see records which I descibed If my production process I will choose "Preparing material" - I have two machines where I can do that. These machines They are intended for preparing material. So I...

It's hard to say about Business process because sample it's only part of it. I will try to describe better, than in my last post Open first of the two records - column [ProductionProcess] "Preparing material", then [Machine] combo box should has only two rows for choose (Not five as it's now)...

Is it possible to achieve tailored list of machines to production process in my combo box, every time I click on it? - Please see my sample database Combo Box - Forms!frmProcessOfOrders.Form!frmProcessOfOrdersDetails!machines Please see tblProcessAndMachines table to know tailored machines to...

Right! Sorry! User "x" will be creating a data in local tables then, replicate database to server, where is another *accdb file. Users "y", "z"... will be copy the base from server to local PCs and work with in the local database (only reading, not creating, deleting, updating). So only user...