|
Excel output: Vertical instead of horizontal
I have a query that returns a single row of summary data. I need to
export it to Excel when a user clicks a button. When it exports, I need
the output to run vertically rather than horizontally.
That is, instead of:
Header1 | Header2 | Header3 | Header4 | Header5 ... etc
Result1 | Result 2 | Result3 | Result4 | Result5 ... etc
I need:
Header1 | Result1
Header2 | Result2
Header3 | R...
|
2 |
31.05.2006 12:43:01 |
|
|
Possible to define a relative path for linked table
Hi,
I have an access database with a table linked to an external text file.
Occasionally the location of the database and the text file change (but
are always in the same directory). Is there a way to have the location
of the external text file be a relative, rather than absolute path (to
be .\textfile.txt rather than C:\dir\textfile.txt)?
Any advice that can be provided would be provide...
|
3 |
31.05.2006 12:10:35 |
|
|
access 2003 to paradox
i have been using Access 2002 to import paradox tables which has worked fine
however we have changed over to access 2003 (office 2003) and now i am
getting an ' unexpected error 11265' message
any ideas !...
|
1 |
31.05.2006 11:44:01 |
|
|
Import Column; matching rows
I need to import data from Excel or another Access table (does not matter
which). I need to match up data from column C with new column. When column
B has 12345 entry and I need to import 54321 in the same row but in column C.
This is for cross ref of one part number to an internal part number. Table
with one part number needs to have another table containing cross ref part
number im...
|
9 |
31.05.2006 05:20:20 |
|
|
Editing and adding items to a listbox
Hello all,
I am new to VBA, have built a userform for word template with two list
boxes with several option items. However, in future some of this text
might not be needed. So I am trying to get the user to edit old
items, add new items and sometimes add but without storing in the
listbox. Is it possible that on click of an edit button a text box pops
up to allow such actions? I really...
|
1 |
30.05.2006 21:34:21 |
|
|
linking with excel
I am linked an excel sheet with microsoft access.The Excel sheet contains a
column named Part No
It has data like this
Part No
0P6926
2407602011
0P10664
0P6941
2PBNH12
2513101010
4325989898
After linking Access is not able to determine the type of data like
2407602011 and instead it has "NUM!".The type in Excel for this column is
general and after linking the data type becomes TEX...
|
2 |
30.05.2006 20:43:02 |
|
|
#Deleted
When I tried to link couple of tables from an Oracle 10.g database into
Access 2002, the data came up as #Deleted. How can I see these data? some of
the tables are very small - only 200 rows. I can view them in Excel but not
in access.
Any help will be appreciated.
Thanks....
|
1 |
30.05.2006 20:31:01 |
|
|
Importing access data from an OBDC data source
I need to import data from an OBDC data source. The table from which the
data is taken is very large (many columns). The import fails because the
record is to big. How can I restrict the import to the columns that I need?...
|
2 |
30.05.2006 16:01:02 |
|
|
Export Data to excel
Hi,
I have got the code for importing data to access. I want to know the
code for transfering data from a particular table in my DB to my C:
drive as an Excel file. How to do the same?
I have created a macro using Action OutputTo and then ObjectType as
Table, ObjectName as NotSpecialSKU and Output Format as MS Excel
97-2003 and Auto start as No. Incidentally I tried to call this macro
i...
|
4 |
30.05.2006 13:33:02 |
|
|
convert .csv to .mdb file using ms-access
Hi,
how to convert the .csv to .mdb file in ms-access...
|
2 |
30.05.2006 12:50:34 |
|
|
Create data driven web site
Rephrasing my question dated 5/9/06.
Do I have to download on my PC:
1) Windows Server 2003
2) Microsoft ASP.Net 1.1
3) Microsoft ASP 2.0
4) Microsoft Internet Info Services (IIS) 6.0
5) Microsoft SQL Server
Is all this software necessary and freely available?
Should I turn "Frontpage extensions" off?
...
|
2 |
29.05.2006 22:01:39 |
|
|
Open file and specify export path using single set of code
Hi,
I have to export a spreadsheet (from my harddisk) as a table in DB and
after doing some operations on it I have to export the Ouput
Query/Table as a spreadhsheet to a different place in my Harddisk.
Im presently using 2 set of codes copied from 2 different websites to
do what I want:-
a) The name of the spreadsheet to be exported could change, so I have
to allow user to select the...
|
4 |
29.05.2006 18:21:07 |
|
|
Paste append rows from table on CD
I am trying to paste append several rows from a table on CD into my database.
These databases are identical as the CD is a backup copy of my daily work.
The first thing I did was select and Edit Copy the rows from the CD I
wanted. Then I closed the CD and opened my current database. When I went to
paste append those rows at the bottom of my current database, I received the
following ...
|
6 |
29.05.2006 05:41:01 |
|
|
Importing data to Access
Hi,
I have 2 needs:-
a) I want to import excel data to an existing table in my DB. While
doing so, I want to delete the existing records in the table. If I use
the following code (Pinched from the NewsGroup)
Sub TransferData()
Dim MyPath As String
Dim MyFile As String
MyPath = "C:\Hari\Assorted stuff\For Mohan\"
MyFile = "Copy of April06Fnubextract .xls"
DoCmd.TransferSpreads...
|
3 |
29.05.2006 04:02:18 |
|
|
How to locate a file and extract filename into access table.
I am on a project where I need the capability to locate a file through
MS Access such as a pdf and extract the file name into a designated
table. Is there a way that I can do this in a command button? PS. I
would like to be able to access any folder on my computer in a
directory view screen.
Thanks in advance.
...
|
8 |
28.05.2006 23:42:38 |
|
|
How aobut adding Microsoft Money?
It would be nice to see Microsft Money Added to Office 2007 .
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I...
|
1 |
28.05.2006 21:49:01 |
|
|
When I go to copy folders to a disc it is saying to insert a disc
I'm trying to copy files and folders to a disc, when I do it says to insert a
disc when one is already there....
|
2 |
28.05.2006 19:16:14 |
|
|
Access should let me export grupped report to excel as 2003 does.
I have a report that contains grupping. In Access 2003 you can export it in
excel and holds the gruping criteria. In Access 2007 the export to excel is
disabled.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the butto...
|
2 |
28.05.2006 19:16:09 |
|
|
Unexpected error from external database driver (22)
Trying to export an Access query to Excel. Getting Access popup saying
unexpected error from external database driver (22) - using Access 2002 SP3....
|
3 |
28.05.2006 19:15:56 |
|
|
Need filename only not location
I have figured out how to locate a file and bring it into a text box.
But now I need to only get the filename out of that text box not the
whole location. Example: "D:\Documents and Settings\My Documents\I Many
Stuff\Defaults.xls" out of this I only need the word "Defaults" I know
there is a way I just can't find it.
...
|
6 |
28.05.2006 19:15:52 |
|
|
How can I link to a table that is open in another database?
I've got to use a certain program for my business, but its capabilities are
limited. The data from that program is all stored in a .mdb file.
So... I wrote a small Access database that LINKS to the files in the .mdb
file, and I've got it functioning so that it does what I need it to do.
However, I can't open my database when the main program is open - I get a
message saying that the dat...
|
2 |
28.05.2006 19:15:43 |
|
|
how to import database from cd to computer
I have been trying to import a database from my PC to my laptop with no
success. I seem to be getting on the laptop, but then I cannot use it, or it
just will not come up, as I get an error message. I have studied the help,
and the course, and they say to use the transfer file --- I cannot find a
transfer file or an import on or in my access. Can any one help?????
Oh so frustrated.
...
|
3 |
28.05.2006 19:15:38 |
|
|
Failed Access ODBC connection to Oracle 10.1
Hi all,
I have an Access application with linked tables that are on an Oracle
10.1 back-end. When I create a query in the QBE and select pass-through
query it works just fine. BUT, when I save the query, or include the
connection string in the query properties (without saving), and run it
again it errors out ~ "table or view does not exist". I've don two
things to get the correct connecti...
|
2 |
28.05.2006 19:15:33 |
|
|
How do I format a % in Access and Excel for the same field?
I have a spreadsheet that has a number that is a percent. In the worksheet
it is formatted as general number. It needs to append to my table as a
Percent or as a Number with decimals so that I can perform calculations. I
have tried formatting both the worksheet and the Access field type as
percents and as numbers but I keep getting a paste error message. How would
each end of the exp...
|
3 |
28.05.2006 19:15:24 |
|
|
NEW PORTAL
This is a multi-part message in MIME format.
------=_NextPart_000_0413_01C6829B.AB868760
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D...
|
1 |
28.05.2006 19:14:13 |