All Questions
3,211 questions
1
vote
0
answers
81
views
VBA on MS Access from Scheduled Task - The remote server machine does not exist or is unavailable
I have an Access database with an autoexec macro that run from a scheduled task.
It currently runs fine with AdminA user, but I need to switch this user to AdminB (Domain accounts, both are in Local ...
1
vote
1
answer
121
views
Recalculate the result of custom function in VBA for the new rows of existing connection - Excel
I have a custom function in a VBA module and this is used in the column of a table containing an existing connection. So every time I refresh this connection, the calculation takes about 10 seconds at ...
- 11
0
votes
1
answer
69
views
Excel VBA to Access VBA: Filter Function
A while back, I wrote an Excel script to compare two Arrays, A and B. Each array represents the regulations applicable to a document's revision, and this script uses the Filter function to identify ...
0
votes
1
answer
83
views
Subqueries cannot be used in the expression SELECT VBA in MS Access
I need your help once again. This my table [Venda]:
I need to return the value grouped by [Cod Col] of the sum of [QTD Venda] and the sum of [Valor Bonif] multiplied by [QTD Venda] if [QTD Venda] is ...
0
votes
2
answers
91
views
How to pass a variable from MS Access to MS Excel
I am working in MS Access and need to pass a variable from MS Access into an Excel Function using VBA.
I've searched for an hour and can't find the answer to this question.
Any help would be greatly ...
- 29
1
vote
2
answers
60
views
Method 'columns' of object '_Global' failed error - VBA Access
Good morning everyone. I am trying to format an Excel file generated by exporting an Access query, I can correctly export the query and save the Excel file in the relevant folder, but when I call the ...
- 53
0
votes
2
answers
91
views
How to speed up the tranfer of information between Excel and Access?
I am having problems with updating records in MS Access through Excel macro (coded in VBA).
I'll try to explain better what's the issue:
I created a UserForm to input the information inserted in ...
- 19
0
votes
2
answers
68
views
VBA in Access - Comand: docmd.TransferText - Exporting table to CSV text file - Delimiting data with ; in place of ,
good luck for all, :)
I'm trying to export an Access table to a CSV file, but the delimiter I want to use is a ; in spite of the default ,.
I have a table, tUsuarias, like this,
Well, for export that ...
1
vote
0
answers
92
views
What is the "execution mode language" in Office?
Office VBA allows you to query the language used by a particular Office application. For example, executing:
? Application.LanguageSettings.LanguageID(msoLanguageIDUI)
in the immediate window will ...
- 173k
0
votes
0
answers
155
views
VBA, ADO and SharePoint list : retrieving columns of type Person
I am working with VBA and ADODB to retrieve the content of SharePoint lists.
It works well but for some reason, I can't retrieve columns of type Person.
I am absolutely certain these exist in the list....
- 170
1
vote
2
answers
100
views
Get results in a delimited format
I'm attempting to setup a spreadsheet, that when PackNum is entered all the offers for that PackNum will be put in the Offer cell in a delimited format.
For example:
I enter Packnumber 600035 in the ...
- 495
0
votes
0
answers
141
views
Microsoft Excel 12 OLE in Access form connection lost after editing
I have an Access form which contains an emmbeded Microsoft Excel 12 OLE object (class: Excel.Sheet.12), named Feuilles.
When I open the form, with Form_Open I store the workbook into a variable like ...
0
votes
1
answer
105
views
Import recordset from Access to Excel ListBox
I am trying to run a query in Access, then to import the output to a listbox which has been created using Excel. The lisbox will have several columns (less than 10).
'Set the name of the query you ...
- 19
1
vote
1
answer
139
views
Receiving Run-Time error 3436 Failure creating file
Receiving Run-Time error 3436 when running the script below:
Debug highlights "DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
td.Name, out_file, True, Replace(td.Name, "dbo_&...
- 31
1
vote
2
answers
237
views
Excel VBA QueryTable.Commandtext - Select * from [Variable] - (Access Database)
I'm trying to pull Access Queries based on certain input values.
Pulling the correct query works, but it gets stuck on the marked position, because it wont accept a variable and just writes it out as ...
- 15