VBA in Microsoft Access
0
votes
0answers
10 views
VBA Access Page Break
I'm fairly new to VBA and I'm trying to bring data from access form to a word document using bookmarks. The problem I'm having is that I'm finding it very hard to create a new in MS word with the next ...
0
votes
0answers
12 views
How do you programmatically update a linked table in Access that will refresh data types too?
I'm working with a legacy Microsoft Access database that we've recently updated to use linked tables/SQL Server backend.
I'm making some changes to the structure of the data and would like to ...
0
votes
1answer
17 views
Searching Tables from VBA
As much as I hate asking without having a good start I am stuck on something very simple I think.
I have a table with only 3 fields. I want to be able to search them using a InputBox which I call ...
0
votes
1answer
4 views
Setting parent record field value based on Maximum Child record field value
I am working with MS Access 2007.
I have a table called [tblDonors] linked to child records in a table called [tblReceipts].
I am trying to set the value of a new Boolean(y/n) field ...
0
votes
1answer
13 views
MS Access 2000 to MS Access 2007 migration
I have application in MS Access 2000.
It is connected to Oracle 9.2.06 database.
I have to migrate the application to MS Access 2007 and Oracle 11G.
I've created a blank .accdb file and imported all ...
0
votes
0answers
7 views
docmd.openquery times out but manual runs fast
I'm running an update query through vba docmd.openquery on a linked sql view and another table. I get an odbc time out. When I manually run that same update query it runs really quickly.?? I've not ...
0
votes
0answers
7 views
Open Access.Application from VBA with write access
I'm trying to import data into an access database (from excel), then run some queries & macros and export the results into a table. I'm using an Access.Application object to run the macros. The ...
1
vote
0answers
27 views
Export Access Table to dBase file from Excel VBA?
I have an Excel "Application" where users add/edit/etc. data. When ready, they export this data, the final deliverable needing to be a dBase file. Since Excel 2007 no longer has the Save As dBase ...
1
vote
1answer
20 views
Passing information from form to form in MS Access
My setup. I have a form that searches through a table names Students containing student information, ID, Name, Home Room, etc. The form text boxes are parameters in a search Query, which then puts its ...
0
votes
0answers
15 views
MS Access - The Height property remains the same when the CanShink and CanGrow property are set to True
In an MS Access Report, I have text-boxes with the CanShrink and CanGrow property set to true. A procedure runs when the form is opened, dynamically adding data to these text boxes. I retrieve the ...
0
votes
2answers
28 views
combining two SQL SELECT COUNT(*) statements
I'm using Microsoft Access 2007. I have two SELECT COUNT(*) statements which run ok without combining, but I want to combine those statements to use as a form recordsource via VBA.
1. SELECT ...
0
votes
1answer
27 views
Generate Excel Spreadsheet with Macros using Microsoft Access
While generating hundreds of Office Excel spreadsheets with Office Access is certainly possible, it would be great to add macros to the generated workbooks.
I would like to add the functions to the ...
0
votes
0answers
21 views
Type Mismatch when using CreateControl in Access VBA
I am trying to dynamically create controls on a form as needed and I have therefore used the CreateControl Method.
DateControls(i) = CreateControl(Reports!Comments_R, acTextBox, acDetail, , , ...
0
votes
0answers
25 views
Calling a VB.NET DLL from VBA (Access)
another question wich was asked before but got no solution:
System: Windows 7 Ultimate 64, MS Office 2010 64 and VS2010
VS2010: I created a new project "Class Library" enabled both "Visible in COM" ...
-2
votes
1answer
21 views
How to import forms,reports and module data in .accdb file
I am work on office access 2013 database. I need some forms,Reports,modules are import one .mdb file to .accdb file using progmatically (OLE and any other technology).
