Search results

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?

In my form: If I want to have cubic meter format of my control, then I type &" m³" if I want to have thousands separator then I type # ### How should format look like for cubic meter control and thousands separator. In addition, this control should has three decimal places, but only when...

I try to open Excel file from Ms Access do some changes and quit. The problem is, I can't open in readwrite mode:/. my code is Dim mojexcel As Object Set mojexcel = CreateObject("Excel.application") mojexcel.Visible = True Set wb = mojexcel.workbooks.Open("C:\Users\xw\Desktop\Robocza\ww.xlsx")...

I'm using sql string to delete some data from tables. When someone locking rows then Ms Access generates error. So is there some code which could I use before running delete query, to check whether someone is currently blocking records which I want to delete?

I have a several queries to export in another accdb file. code below works great, BUT in every query MS Access shows pop up message about security with macros. It's annoying when I'm using RunTime. I know how to disabled it through regedit. But i need to send this file to my friedns and them...

Could you show me your sample?