Tagged Questions
0
votes
1answer
23 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
68 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 ...
0
votes
0answers
176 views
Checking if a access table exists in Excel vba( dlookup or using sql)?
how to check if table exist and if it doesnt exist create table in sql server 2008
The link above I think shows what I am trying to do using sql in excel vba. I should say I don't really know sql, ...
0
votes
2answers
171 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
49 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 ...
3
votes
1answer
180 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
99 views
VBA error on PageSteup.PrintArea when using Excel 2007, works fine in Excel 2003
I've inherited responsibility for a web app that uses Access for the database and Excel for the reporting (lucky me, I know). Everything has been working fine with Office 2003, however the company ...
0
votes
1answer
37 views
Cannot save file after upgrade to 2007 VBA
I have a sub which I call to save a file
Sub SaveToFile()
maxr = Worksheets("List").Range("H1")
Worksheets("List").Range("G1:AE" & maxr).Copy
Part of the code which is failing after ...
0
votes
1answer
143 views
Complex Import/Export Data Access/Excel
Our organisation has been given a spreadsheet template to do batch imports to a website.
It's quite a faff for users to update as it's structured all on a single page in the following way:
| ...
0
votes
0answers
250 views
Use file name variable to open Excel 2010 file from Access 2010
I need to open Excel 2010 files from Access 2010 by using a variable for the Excel file name. I can't quite figure out how to format the variable names for the file and sheet that need to be opened.
...
1
vote
1answer
502 views
VBA Excel - UPDATE record in ACCESS
I got a problem.
I want to update an existing record in table in Access Database using VBA in EXCEL.
My code:
sqlik = "UPDATE query which works in access"
Set ZAP_QUERY2 = baza.CreateQueryDef("", ...
0
votes
1answer
231 views
Unable to connect to Access database with ADO
I need to import a bunch of tables stored in .txt files into an Access database. When they are done importing, I use an ADO connection to communicate between the database and an Excel workbook. I have ...
0
votes
1answer
515 views
MS Access VBA linking data and updating records from excel
What is the best approach to updating records that are saved in an excel file. For instance I have a MS Access database with a table in it that has Product ID, ProductName, and ProductAge.
I have ...
1
vote
1answer
254 views
Importing data from Excel into Access using DAO and WHERE clause
I need to import certain information from an Excel file into an Access DB and in order to do this, I am using DAO.
The user gets the excel source file from a system, he does not need to directly ...
-1
votes
1answer
3k views
how to read data from an excel worksheet dynamically using VBA 2003
I am new to vba programming hence I need your expert help in trying to be able to able to read all values from the following excel sheet into a ADODB recordset object using VBA 2003
The recordset ...
0
votes
1answer
78 views
Does the recordset close itself when called from within a function?
In VBA Programming I am trying to understand the state of a recordset when it is passes data from within a function to another recordset
for example
Sub Test()
Dim Recordset1 as new ABODB.Recordset
...
4
votes
1answer
256 views
Create a DLL for VBA Class Module or better alternative?
Here's my issue: I wrote a VBA class module that consists of commonly used methods and functions. I am continually refining the module and making changes to it.
The problem is that I include this ...
0
votes
1answer
318 views
Sort/Manipulate Excel data from Access 2003 VBA
I'm trying to run a module in Access 2003 that takes an excel file, if there is info in the cell, then copy the field header and cell in A1, B1, etc... as it loops through each row. There are also ...
0
votes
0answers
110 views
How to read (query), format, and export a sheet to a existing XLS, in a Access/VBA application?
I have an introductory (?) question about Access/VBA to xls exporting.
Here is my scenario:
We have an Access database and a form (created in the Access environment) with some buttons where the user ...
1
vote
1answer
320 views
System Information via VBA code
I was wondering if there is any way to retrieve System Information via VBA code?
Is there such a class as - SystemInfo Class in Excel VBA to do this task?
thanks
1
vote
1answer
2k views
MS Office VBA changes from 2003 to 2010
in my company the IT-department finally decided to switch from MS Office 2003 to 2010. In my department we developped many small Applications running on VBA. Particularly all of them were programmed ...
0
votes
1answer
136 views
Getting different results while running the same stored Access SQL query directly and through VBA excel
Hey the following stored access query is giving POEventCode with "NA" when it is run through VBA excel and is giving the correct result when directly run from access.Why is this anomaly?
SELECT ...
3
votes
1answer
1k views
mySQL-query from Microsoft Access VBA fails if not interactive?
I'm fighting with a VBA non-interactive problem that really bugs me: I have a pass-through query to a mysql database, which works well if double-clicked by the user. But it fails if called from VBA ...
1
vote
1answer
551 views
VBA to write data into excel used by multiple users on a network?
Basically i have a master workbook on a network drive which is used by many to update the sheet,i want to automate this , through my research i found there are many complications with it if i automate ...
0
votes
1answer
149 views
slow exporting array from access to excel
I have a similar performance issue to that in slow exporting from access to excel, exporting data to MS Excel by setting individual cell values looping on:
objSheet.Cells(table_1_row_no + intcounter, ...
0
votes
2answers
1k views
Import data from Excel into MS Access [closed]
I have an excel file with some data, I need to import all the data into MS Access using VBA, and then run a query on it, and finally present the data in a report.
How can this be acheived?
0
votes
1answer
164 views
Get value of variable used in Access report
I have a report ("rptEstimate") used as part of a larger program that runs in Access. This report has a text field, with the expression =Nz([txtTaxTotal],0)+Nz([txtSubTotal],0). Where can I find the ...
1
vote
0answers
590 views
Adding a format condition in Excel through Access VBA
So currently i got these lines in my code,
.Range("C2").Formula = "=IF(B2 = """"," & """REQUIRED""" & "," & """""" & ") "
.Range("C3").Formula = "=IF(B3 = """"," & """REQUIRED""" ...
0
votes
0answers
168 views
how can I control an Excel OLE object from access with vba
I would like to have an access vba procedure to write in an embeded Excel sheet.
I've added an Excel Ole Object to my Access form, but I'm unable to address it.
How shoud I do that ?
