|
using a variable as the table name argument in DoCmd.OutputTo
I'm trying to construct a macro that will allow users to export the results
of any query in a database to Excel, by either selecting the query from a
list, or typing the name of the query into an InputBox.
Is it possible to use the value of a control on a form, or the value entered
in a InputBox, as the table name argument with DoCmd.OutputTo or
DoCmd.TransferSpreadsheet?
Is it possibl...
|
5 |
08.08.2006 21:40:02 |
|
|
Export as ascii and append to existing file
I have an ascii file (slsinv.asc) updated daily through my ERP system which
captures invoicing information. I have a DB that contains archived invoicing
information.
I want to APPEND the archived data into the existing slsinv.asc file. I need
the data to be COMBINED since the slsinv file is part of an OLAP cube.
Is it POSSIBLE to APPEND an ascii file to another ascii file?
Or will ...
|
3 |
09.08.2006 13:12:01 |
|
|
Access 2003 FileDialog Save As VBA Code
I have been playing around with using the FileDialog SaveAs object in
Access 2003 VBA. After searching I see that the standard is to use the
code at:
http://www.mvps.org/access/api/api0001.htm
However, I modified some code in a thread that Amy Blankenship tossed
out as untested and came up with the following.
*** Code Start ***
Private Sub ExportCB_Click()
Dim dlgSaveAs As FileD...
|
2 |
08.08.2006 20:35:34 |
|
|
Exporting to txt file problem
I have a report that I am exporting to text file but when looking at the
tetxt file the report starts with a blank line shows 2 records then a blank
line, then three records. This pattern repeats, probably at the page break
point.
Any ideas what causes this and how to fix it so my records are together?
thanks...
|
2 |
08.08.2006 20:12:02 |
|
|
how do i set up automatic backup
I manually back up my office data bases (copy and paste), is there a setting
to make this automatic at any time of the day?...
|
2 |
08.08.2006 16:28:02 |
|
|
Help, Failing at linking a Word document in Access
Hello,
I have finally completed a database I've been working on for sometimes (with
much thanks to Access Monster). After completion, I tested all aspects of
the database to see if there were any glitches. Fortunately, I only have one.
I created a form that includes links to two word document. Because the word
documents are on my C:drive, the opened without a problem for me. When
anoth...
|
2 |
08.08.2006 16:24:02 |
|
|
External data messing up the data type ...
Hi:
I am trying to "Get External Data" by "Link Tables" in MS Access 2003 from
Excel 2003 spreadsheet. After linking, I opened the table to notice that
one of the fields is TOTALLY screwed up. It displays " #Num! " in some of
the records. I checked the design of the table and it shows that the field
is "Number" . HUH? I checked the format of the Excel sheet and the format
is "Tex...
|
2 |
08.08.2006 05:35:43 |
|
|
SQL Server Login prompt on some reports
Hello. The Access db has several linked tables to SQLServer. Does anyone
know why some reports prompt for the SQLServer login and some don't? The SQL
Server login prompt can appear on Run mode and sometimes Design mode. But
not on all reports.
Thanks for your help.
...
|
2 |
07.08.2006 22:19:42 |
|
|
Array to Access
I am creating reports in Excel. From those reports I am generating a summary
array that I would like to output to Access. How do I import that array?
Does anyone have sample code?
...
|
5 |
07.08.2006 18:34:23 |
|
|
import access from quick books
Hi,
I am trying to convince my bosses to purchase Access. We are a small company
and have not been using anything but word for our customer orders and such.
Our accounting firm uses quick books and I would like to know if it is
possible, and how, to import all of our customer records from them. We are
growing and I think it would be beneficial to have a program that allows us
to crea...
|
6 |
07.08.2006 17:25:25 |
|
|
exporting to excel
,I am trying export a report to excel. This is working however, when I open
the file in excel, the fields are arranged in different orders that they were
in the original report, and I cannot thing of why this is happening. How
frusterating! Any Suggestions?...
|
3 |
07.08.2006 16:13:02 |
|
|
File Size Multiplying?!
I apologize first off, if this is in the wrong section...
------------------------------------------
I'm not an amazing and experienced database user/maker... but I know enough
when something isn't working right, to see it's not working right.
Here's the problem...
I am using MS Access 2003 in FP2003. When I create a Database, there's no
problem. I make a few tables, and then save. T...
|
3 |
07.08.2006 12:41:02 |
|
|
SQL syntax
Hi all,
I have a function (copied from another thread) like this:
'--------Code start-----------
Function AutoExec()
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sqlCmd As String
Set conn = New ADODB.Connection
conn.ConnectionString = "DSN=Visual FoxPro
Tables;SourceDB=C:\Temp;SourceType=DBF;Exclusive=No;Deleted=Yes;"
conn.Open
sqlCmd = "SELECT...
|
2 |
07.08.2006 11:52:56 |
|
|
File Transfer
Hello, I am making a music database. Right now i have all of my music
files in one folder and what i want to do is find a function that will
search through all of these files and look at their artist and then
move them to the folder corresponding to the artist. any ideas?
...
|
2 |
06.08.2006 20:14:54 |
|
|
Transpose data on import
I have a program which generates a tab delimited text file in a column
format (see below)
ID 12345 12346
12347
Username Joe Bloggs Riley Briggs Liam
Gallagher
Noise 2.1 2.3
1.8
Background 62.1 43.1
51.2
Date 01/08/2006 ...
|
4 |
06.08.2006 18:13:09 |
|
|
Link/import/drop link DBF file via VBA
Hi expert,
I'm looking for some code that create a link to DBF file via ODBC Database,
append it to a blank table (that has been delete all records), and then drop
the link to that DBF (since the DBF file is often open exclusively by another
application). Could someone give me a simple example to do this ? Thanks, in
advance....
|
1 |
06.08.2006 14:20:02 |
|
|
Error 3011 Jet database engine cannot find object
I have a new error and I'm hoping that the solution is easy.
Until recently I could click on a DBase IV file of type DBF in
explorer and Access would open and the .DBF file would appear as a
table. I could then look at the data contained in the file and its
field names.
This no longer happens.
When I click on the .DBF filename in explorer Access opens. But the
file is not loaded as a ...
|
1 |
05.08.2006 23:30:23 |
|
|
Error 3011 Jet database engine cannot find object
I have a new error and I'm hoping the solution is easy.
Until recently I could click on a DBase IV file of type DBF in
explorer and Access would open and the .DBF file would appear as a
table. I could then look at the data contained in the file and its
field names.
This no longer happens.
When I click on the .DBF filename in explorer Access opens. But the
file is not loaded as a table...
|
1 |
05.08.2006 23:30:00 |
|
|
Access Errors
WE have a unix system with muliple files, on openining some of the files, all
that is returned is the word ERROR in each of the field's.
Most of the other files open up with the correct data,
Can anyone suggest the reason and cure
--
Message posted via http://www.accessmonster.com
...
|
2 |
05.08.2006 15:09:10 |
|
|
Search for lines from text file and import
I have a text file that contains text that will look a bit like this:
======================
UserName: Joe Bloggs
Password: orange1
Register Address: False
<StartName>Joe Bloggs<EndName>
<StartAddress>1 Long Road<EndAddress>
<StartTel>0123 333555<EndTel>
======================
I want to use VBA Access to open the file and import these lines of data
in...
|
4 |
05.08.2006 14:25:31 |
|
|
Linking Tables to SQL Server Issue
I am able to link an Access table to SQL Server from my computer. When I do
the same on another computer with the same operator/password, I get the
following error:
Connection failed:
SQL State '01000'
SQL Server Error 2
[Microsoft] [ODBC SQL Server Driver][Named Pipes] Connection Open (Create
File()).
Connection Failed:
SQL State '08001'
SQL Server Error: 6
[Mic...
|
3 |
05.08.2006 13:48:02 |
|
|
export email addresses to Outlook
How can I export email addresses and the other info (phone, address, city,
state, etc) to Outlook? I can build a query having all the fields I need,
but what do I do with the results?
--
Rick...
|
4 |
05.08.2006 08:56:21 |
|
|
open/save dialog, user clicks cancel
I'm fairly new at this, so sorry if it's a stupid question.
I've used the code from the http://www.mvps.org/access/api/api0001.htm to
create dialog boxes for both importing and exporting data. I have 2
questions, though:
1.) I've had to create 2 separate macros for exports, 1 for csv files and 1
for xls. I've tried putting both in 1 module, but I kept getting errors when
I'd test for...
|
3 |
05.08.2006 05:09:02 |
|
|
Export query results using fields as content and file names.
I have a query that displays these two fields: [html] and [filename].
I need to make small html files from the content displayed in [html] and
name them using the results from [filename].
This would be an easy task if I could deliver the pages dynamically using
..asp. Unfortunately, my situation demands that I make static html pages. The
resulting pages are not large, but there are too...
|
1 |
04.08.2006 22:27:01 |
|
|
MDB file to ADP
I want to use the microsoft Genealogy Template as a Microsoft Project on a
webhost's server. Is there something special I need to do in order to have
it work correctly? On my webhost I am using MYSQLDB. I imported the
genealogy database onto my webhost's server and now some of the forms don't
work and I'm getting Authorization errors and runtime errors....
|
4 |
04.08.2006 21:29:32 |