Search results

Works great!

Yes, they are.

I have a master form and a sub-form showing records that meet the required criteria. On the main form, I have one check-box, and on the sub-form (datasheet view), I have a check-box for each record. When I click on the check-box on the main form, the status (checked / unchecked) of the...

Good observation. It must be workbooks, otherwise, it does not work. I did not pay attention to this fact when I read it, but I used workbooks when I tried it.

I guess I find a solution - this piece of the code does the trick: Dim xl As Excel.Application Dim wkbk As Excel.Workbook Dim wk As Excel.Worksheet On Error Resume Next Set xl = GetObject(, "Excel.Application") On Error GoTo 0 xl.Visible = True With xl...

Thanks, Dave, I tried but it still gives me Run-time 9 subscript out of range error.

Thanks for the suggestion, but it is not what I was looking for.

Thanx, I tried with workbook(n).Close method but it gives me Run-time 9 subscript out of range error. I guess I'll just add a warning for the users that the file is open and must be closed before proceeding.

I export data from Access database to an excel file using a macro. It works fine if the excel file is not opened, but it gives an error when it is. I would like to close the excel file before the data export. How can I do that? I'm using this function Public Function IsWorkbookOpen(ByVal...

Thanks for the reply. There is obviously no other way than a daily file downloading...

Hi! I'd like to know if it is possible to import data to access as a linked table from an excel file, stored on a webpage (not in Sharepoint)? This is the link to the file: https://www.jazmp.si/fileadmin/datoteke/seznami/SFE/Prisotnost/Seznam_24_HUM_prenehanja_motnje.xls When I try to...

Thanks arnel, that does the trick.

The ID field (Auto number) is not included in update query.

Thank you both for the answers. Automatic numbering is not a problem, as I'm not adding new records, I'm only updating existing ones. I need to update some of the data, which also includes updating a field with indexed values where duplicates are not allowed. Therefore, it's okay for me to be...

Hi! I have an update query and when I try to run it, it says that not all records could be updated because of keys violation rules. I understand why this is happening but I'd like to know how can I find those records that are violating the keys rule. I'm using access 365 and don't know much...

Thisis not a convenient option for me. I don't have much experience with Access or Excel, so I don't really know what is ADO. However, I've imported data from Access to excel via Insert >> PivotTable >>Use an external data source. Then I chose the access database and appropriate query. But as...

I have a problem that is driving me crazy. They replaced my computer at work and I was forced to start using Office 365 and Windows 10. In Windows 7 and Office 2010 everything worked as it should be. However, in Office 365, I have a problem linking Excel to external data from Access. I have an...

Thank you. That works!

Hi! I was forced to start using Office 365. So now I'm using Access 2016 and Windows 10. I encountered a problem when using one of the files. The file is set to save a copy with the name and the current date at startup (AutoExec macro). In 2010, everything worked perfectly, but in the 2016...

Thank you Minty and ridders, problem solved!:D