Search results

Thank you once again but I think this field Rank in qryRank. Doesn't work properly. I understand logic of base but these field should rank field from highest to lowest amount. So I made code: Rank: (Select Count(NR) + 1 from Data as B where A.NR = B.NR and B.Amount < A.Amount) but it doesn't...

It was my misunderstanding. Just 5 highest offer. Solution from MajP works perfect.

Than you very much ! Have a nice day ! :)

It will look's like this but one more field in tbl1 data. Thank you for help.

In table every nr can has 10 or 0 records. But in query I have to show always 5 columns. From highest amount and date to lowest amount and date. (amount1,date1,amount2,date2,... amount5,date5). If there will be less than 5 records I should show null in the record. I know it is unlogical but I...

Hi , I have table which looks like this nr;amount;date 1;123;2020-04-01 2;321;2020-05-01 1;333;2020-04-03 3;111;2020-01-01 etc. Which option of query I should make to receive result like this nr;Maxamount1;date1;amount2;date2 1;333;2020-04-03;123;2020-04-01; 2;321;2020-05-01; 3;111;2020-01-01...

Topic can be closed. I transposed my record source of picture from verticaly to horizontal. It works. Thank you.

Sorry for my misunderstanding. So I should write in first post that it is not image just link to image in table. Unfortunately that table is automatically downloaded from WebService. But thank you for suggestion I make some operation in queries and transposed this section with picture1...

Hi Guys, thank you for replays. Unfortunately I cannot share my database because it consists confidential data. But for example. Every record in table looks like this: data1, data2, data3.... data20, picture1, picture2, picture3,.... picture20. All data fields are with data in it. Some...

Hi All, at the begging thank you for any replay. I have big problem with report. In my database every record has about from 1 to 20 links to picture (every link to picture in different field). I know how to make report with pictures (I know also that there is problem with picture in 32bit and...

There is solution. https://answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-get-access-to-automatically-refresh-an/7723aabc-c774-44dd-aa5d-7d048b5b4f8f Greetings !

Thank you for replay but I think in that way you refresh only link between access and excel. I need to refresh data between Excel and Internet ;)

Hi, I tried to find topic with solution for my problem but I cannot. I have Office 365 (32 bit) I have to download Excel file from www. with direct link. So I have to do it in Excel (Acccess can only import XML file from www :( ). I made Excel (sample.xlsx) file with connection to table on...

Thank you for replays. Now I know what I have to looking for.

Hi, is it possible to make short link to table in different access database ? What I mean? Now when I connect table from different database these table has full link e.g. “c:\database\test.ascdbb” When I move this database to another folder it doesn’t work. Is it possible to create link to table...

I resolve problem - it was reason of policy. There is solution. https://getadmx.com/?Category=Office2016&Policy=office16.Office.Microsoft.Policies.Windows::L_NoExtensibilityCustomizationFromDocumentPolicy

I've changed header of ribbon code and it still doesn't work. :banghead:

I changed head of code but it doesn't work. I've checked on computer with Office 2010 and ribbon is visible.

Code of custom ribbon <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="false"> <tabs> <tab id="MyTab" label="AVT Menu"> <group id="MyGroup" label="Środki trwałe"> <button id="MyButton1" size="large" label="Tabela...

Hi everyone, I created database in Access 2007. In that base I created custom ribbon in table USysRibbons and everything works. In second computer I have Access 2016. When I open that base in Access 2016 I cannot see my custom ribbon - it is still available in Access 2007 but in 2016 I cannot...