Recent content by radek225

I even can't imagine better lesson. Thank you very much MarkK

Interval in Datediff can't be "dd hh:mm:ss" I converting string to data to correctly substract - is it wrong?

I would like to Substract one date from another using dao.recodset and get format "dd hh:mm:ss" My fields in table e.g. strDate = 17.10.2016 08:17:45 endDate = 18.10.2016 09:23:36 the problem is, if trying rst!endDate - rst!strDate then result is "31 01:05:31" I tried various combination e.g...

Why below query is not updatable? sql = "Update Tbl_Raport_hd_sumyTys " & _ "set tbl_raport_hd_Sumytys.SI_MAxxx = (select sum([Tbl_Raport_hd_iloczynyJedn].[I_MAxxx]) from Tbl_Raport_hd_iloczynyJedn where [Tbl_Raport_hd_iloczynyJedn].[nr_wyc] = [Tbl_Raport_hd_sumyTys].[nr_wyc] and...

Ok but this new field only show me when someone change or add new data, but it doesn't help me solving problem locking record.

yes I have sql back end. What is idea for timestamp? Just creating a column with date? how it's working?

No, should I? Why do I need?

I would like to ask if someone working with Access and linked base on Azure? How it's runnig? There's no problem with performance? I think it's matter of time when we all will have to use it in our organization instead of local base. So it's time to go to Azure:)? Or maybe there are some problem...

10 users and I have problem with locking. Records which are not editing are locking - it seems to page level locking instead of record level locking because I have encryption database. So now I need to find a way to get around

Thank You for your insight Please see attachment. If I disable option "Open database using record-level locking" then Access automatically switch to page-level locking, right? And that's mean locking all records which are next to editing item. - No one know what is a scope of records and...

I have application with linked base (*accdb) on LAN NAS storage for few users, designed with row level locking, but since I've made encryption my database, MS Access disabled my row protection and now i have problem with users "I can't edit my box because someone use it" - None use it:/. I...

Some guy told me that Power Apps is the future, Ms Access will be past. What do You think about that? Do you earn from developing Ms Access? Are there programmer earning only in vba?

It's fine for me. Could you tell me how should I set it using VBA? When I do Me.WolumenSumaryczny.Format = "# ###" & "," & "####" & " MWh" then get something like #\ # ###" MWh" :/

it's ok for me. How could I join # ### and &" m³" in a one format?

Hmm ok, but what If my form isn't continous? Is there some solution?