Search results

I have got a query running on several tables. The result is: Customer Invoicedate Invoicenumber 100 13-2-2015 10001 200 NULL 20001 200 NULL 20002 I use a RecordSet to modify the field Invoicedate. The recordset has a...

I was experimenting with a Web controls on a form. It works nice in Access 2013. But I forget that older version do not support Web controls. So I removed it from my form. But now when I open the database in an earlier version it keeps telling me that the specific form in which the control was...

I have a generic module for creating Excel reports. This code works, but only once..... Set rstBron = dbOFA.OpenRecordset("SELECT Year([Date]) AS Year, Cint(Format([Date],'mm')) AS Month, Amount FROM Invoices" apXL.Visible = True Set xlWsh = xlWbk.Worksheets(1) xlWsh.Name = "Data"...

For weeks I am trying to read an XML file which needs to be processed in an Access database. I can not find the proper way to: - find a specific node - iterate from there The XML file is an international bank file: <?xml version="1.0" encoding="utf-8"?> <Document...

I have an project with a splitt database. The data is stored in the database_be.accdb I want to know which users are connected tot this database. Somebody got a suggestion?

Hi there, I used the 32-bit library to get a temporary filepath. But was looking for an alternative. I have created one myself: Dim oFS As FileSystemObject Set oFS = New FileSystemObject Dim strPath As String GetPath: strPath = oFS.GetSpecialFolder(TemporaryFolder) &...

Hello, I am using a API to generate a random / unique directory. This an API form a 32-bits environment. I know that you can still use it when declaring it with PtrSafe But does anybody has got a better alternative in 64-bits? This is the code I am using: Option Compare Database...

Hello, My previous post was solved but the problem isn't. I am trying the get specific data out of an XML file. I managed to access a nodelist but I need more data. This is the XML file: <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.008.001.02" xmlns:xsi="removed due to #posts">...

I am using Access 2007. I have got an XML file with the folowwing structure: <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.008.001.02" xmlns:xsi="redirect to the (link is removed!) XMLSchema-instance"> <CstmrDrctDbtInitn> <GrpHdr> <MsgId>006-2012-11-09-12:21:47</MsgId>...

I have an Access 2007 database. In it there are Class Modules but also Modules. I have transferred all modules into Class Modules because of the use of variables and values in a multi user environment. Her is an example of a class module which does a validation check on a bankaccount number...