Search results

Hi All, I read a lot of articles about Exif coordinates in Access but maybe you have solution how to deal it in queries. I know there is huge tool https://www.access-programmers.co.uk/forums/threads/get-current-geolocation-data-using-access.299932/ I have table like this ID URL 1...

Hi All, I tried to find a solution on forum but I cannot. I have CSV table which is located on internet: www.example.com/13423532534gfs?@#432 When I press on url I download CSV table. I cannot import CSV table from Web in Access so i decide to put link to it on Excel and I have a connection...

Hi, in my database I have macro which download xml file from url https . Simply macro with that code Application.ImportXML _ DataSource:="https:// xxxxxxxx type=.xml", _ ImportOptions:=acAppendData It worked perfect. But from some update of Windows 10 or Office 365 32 bit I receive error...

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...

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...

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...

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...

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...

Hi all, I have big problem with connection between ODBC and Access 2007. Everything is linked correctly but I have problem with separator in decimal field. In my country this separator is "," not ".". I found information about connection in MSysObjects.connect table that...

Dear All, I want to write code to select records where field yes/no will be selected on yes. I wrote code like this Set rs = Mydb.OpenRecordset("SELECT * from tblCalc WHERE ((tblCalc.taknie)=Yes)") tblCalc.taknie - it is yes no field. I allays has the Error 13 problem, I tried...

Hi, Is there any simple way the create via vba table from ODBC linked table? Tables must have the same name like ODBC tables. Thanks for any replays.

Hi everyone, I have two tables: tbl1 and tbl2. In tbl1 I have filed "howmuch" - it is number. Is is possible to copy records from tbl1 to tbl2 times (3,4 and more) like number in tbl1 ? Thanks for replays.

Dear All, In my database I have one form with two subforms. For example main form name will be 1, and subforms A and B. How can I write simple macro that will check if I put focus on subform A macro will check value in subform B ? Sorry for my English and Happy New Year/

Hi, In my access file I have connections for 7 odbc links tables. Is there any option to make macro that can make normal table from this links ? The name of table will be the same like name of links. And when i run this macro again this macro will delete all information and make table with the...

Hello, Last time i wrote the module to find wensday minimum two weeks later from today. It looks like this: Public Function WyznaczSrode(DataWystawienia As Date) As Date Dim a As Date Dim c As Integer a = DataWystawienia + 14 c = Weekday(a) Do While c <> 6 a = a + 1 c =...