Tagged Questions
2
votes
2answers
56 views
Operation must use an Updateable Query / SQL - VBA
I am trying to create a very dynamic macro that will update different tables in a Database, depending on what the user chooses. Each table has of course distinct titles and information. I'm having a ...
0
votes
4answers
11k views
How do I clear a table in Access with VBA?
What I'm trying to do is, while in Excel, use VBA to push data to an exsisting Access table. I've been able to do this, but am having one small hickup. Before I push the data to access, I want to ...
0
votes
1answer
37 views
Aggregating data from Excel into Access
I am just starting on a project that will require me to aggregate data from multiple Excel files into Access tables. The tricky part is that my Excel data will not be in tables, but in a minesweeper ...
0
votes
2answers
58 views
Handling AddNew Key Violations ADODB.Recordset
My previous Title caused a bit of confusion there...updated
I've encountered this problem recently while using some VBA to bridge Excel and Access.
So I have a spreadsheet containing a table that I ...
0
votes
4answers
40 views
Usage of If in VBA
In one part of my VBA code, I need to import data from excel to access. The importation is now "working" for the ovious types (string, integers). However, In the excel file i have some strings thati ...
0
votes
1answer
43 views
Import from excel to access
I am having some troubles with a VBA code that should import excel data to my access database. When i run the code, i get a RunTime error "Runtime error 1004 Application-defined or object-defined ...
1
vote
1answer
21 views
EXCEL import to Access
I am having some troubles with a VBA code that should import excel data to my access database. When i run the code, i get a RunTime error "Runtime error 438 Object doesn't support this property or ...
0
votes
1answer
36 views
How to convert this MS Excel Visual Basic code to work with MS Access
I need help converting this Visual Basic code to work with MS Access. Right now I use it in MS Excel to fill out PDFs using the data in the form and I want to migrate my data base to MS Access but ...
3
votes
1answer
278 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 ...
0
votes
1answer
35 views
Stopping NULL Rows and Columns to get imported from excel to access
I am importing some table from excel to access.Sometime some blank columns also are imported as field13 or field-x .
Whats the reason for that.
Also sometimes some blank rows are imported also.Is ...
0
votes
0answers
80 views
Visualize relationships between entries in a database
I'm looking for a way to visualize the relationships between our suppliers by drawing a dynamic graph.
Our suppliers may have one or several addresses (branches). Each branch may have one or several ...
0
votes
1answer
23 views
How to assign Single cell to range?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim TxtRng As Range
Set TxtRng = ActiveCell
If Not Intersect(Target, TxtRng) Is Nothing Then
------------Statements ...
6
votes
3answers
12k views
Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect
I'm trying to connect various VBA projects to an Oracle 10g back end using ADO (2.8) and no TNS. After various attempts, we've decided that the simplest series of steps for a clean installation ...
0
votes
2answers
303 views
Setting range properly in DoCmd.TransferSpreadSheet (VBA Access in Excel)?
For Each Page In Worksheets
PageName = Split(Page.Name, " ")
If UBound(PageName) > 0 Then
Worksheets(Page.Name).Activate
LRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
...
1
vote
1answer
67 views
VBA to insert embeded picture excel
I have seen lots of posts about us xlApp.activesheet.Pictures.Insert(strImagePath) to insert pictures into a spreadsheet with VBA, which works great. The only problem is it inserts it as a linked ...
