|
Problem with CurrentDB
Hi,
I have set up an access conection to a external database on a sql
server. I am trying to export a filtered subform in ms access to excel
but I understand the best way to do it is to set up a query and change
the sql of the that query to filter the subform and then export the
query.
The problem is that when I set the db = CurrentDb and try to set a
QueryDef using db it throws an erro...
|
4 |
11.09.2006 18:48:39 |
|
|
How do I merge Tables in Access from different files?
I have different but similar tables from different files. I want to merge all
the information into one file. Though I have some different fields most of
them will match up. I may have a problem with some primary keys but I think I
can get by that. Both files have realtional tables but would be similar in
the two files I want to merge....
|
4 |
11.09.2006 16:11:14 |
|
|
Wrong precision when linked to a SQL Server view
Hi all,
In an Access 2003 db I have a linked table to a SQL Server view. This
view is based on a SQL Server table with a column defined as
NUMERIC(4,2).
When I create an Access linked table directly to the SQL Server table,
the column definition in Access is just fine.
When I create an Access linked table to the SQL Server view, then the
column precision is wrong, it will always be 3,1,...
|
2 |
11.09.2006 15:44:43 |
|
|
Check if File exists
Hy,
is there a easy command, to check if a file exists?
Reason: The Field "File" is filled by external DB Update (for example
"C:\Test.pdf").Before a users uses the Field Value for further working,
Access must check, if the file realy exists. If not, a message box should
appear.
Any idea about the file command?
Greetings,
Manuel...
|
2 |
11.09.2006 15:04:33 |
|
|
FrontPage And Access
I'm having trouble finding remotely close solutions on the web.
Is there a way to upload a .csv or .tab file to an MS Access database in a MS
Frontpage web?
Thanks in advance!
--
Excel spreadsheets are NOT databases!! I hate end-users.
Message posted via http://www.accessmonster.com
...
|
2 |
11.09.2006 05:15:46 |
|
|
Is there a way to suppress the overwrite file when exporting data
Is there a way to suppress the overwrite file dialog when exporting data to
an excel file that already exist. We are trying to automate the process
using macros and batch files....
|
5 |
11.09.2006 05:10:57 |
|
|
Insert Object Help
I am having two problems when using insert object.
First I am trying to insert a Excel Spreadsheet that has math formulas build
in to it.
I created a blank form and in design view selected Insert Object, then
selected Create from File, then I selected my spreadsheet, when everything is
done I end up with a photo image of my spreadsheet, none of the cells can be
clicked on.
Next I am...
|
2 |
10.09.2006 15:53:04 |
|
|
creating make table from linked db2 db
I am trying to create a make table from linked db2 files. I am bringing in
about 13,000 records. The problem is that the linked tables contain over 3
million plus records. During this operation Access grows to over 2 gigs and
fails. I am only trying to import 13,000+ records. Could someone tell my why
this happens and is there a work around?
Thanks
Ginny...
|
2 |
09.09.2006 14:57:52 |
|
|
creating make table from linked db2 db
I am trying to create a make table from linked db2 files. I am bringing in
about 13,000 records. The problem is that the linked tables contain over 3
million plus records. During this operation Access grows to over 2 gigs and
fails. I am only trying to import 13,000+ records. Could someone tell my why
this happens and is there a work around?
Thanks
Ginny...
|
1 |
09.09.2006 14:16:01 |
|
|
where can I find a table of educational degrees?
I want to add a table to my database and I do not want to manually type each
and every degree available...
|
2 |
09.09.2006 07:26:39 |
|
|
where can I find access tables
I would like to find some database tables that I can import with State
Abbreviations, Countries, etc. so that I don't have to type them all up. Is
there a place I can find that?...
|
3 |
08.09.2006 19:11:09 |
|
|
export from excel to a csv file in outlook
I am tryiing to export from excel to outlook and then name it as a group.
But it all seems to merge in my whole address book....
|
2 |
08.09.2006 15:51:14 |
|
|
populate Excel spreadsheets from Access
Hi, all,
I want to populate an Excel spreadsheet based on data in Access tables. Can
someone direct me where to go to find info on this? I've searched the past
questions here and found nothing straight forward and simple.
Thanks in advance!...
|
2 |
08.09.2006 15:47:50 |
|
|
Dbase III Driver Issue?
I am currently supporting a client that uses an Access 97 application to
read and update information in a Dbase III database (which others use). The
user is getting a Runtime 2004 error message when attempting to execute
functions in the Access aplication. The error is happening on a macro that
updates the DBase III database (at least that is what the debugger is
showing). The user is ...
|
2 |
08.09.2006 13:05:02 |
|
|
Access is no longer opening ODBC connection window
Access 2003 is no longer opening the ODBC connection window. Excel is still
able to open ODBC. I have been doing this for years and suddenly it stopped
working. I have already tried reparing Office and it did not work. I then
tried a reinstall and still nothing. I then completely uninstalled Office -
rebooted and installed office again. Still I cannot get Access to open the
ODBC window ...
|
2 |
08.09.2006 08:57:30 |
|
|
Duplicating lines
Hello again,
I have a linked text file that contains info from a federal database with
logistical information, price, nomenclature, unit of issue, shelf life codes
etc.. It has a common field NIIN with a table inside the database. This
table has information about the type of part: NIIN, NSN, part number, Supply
Class and system the part is used on. Finally, I have one more table which...
|
4 |
08.09.2006 06:23:17 |
|
|
How do you export more than the maximum number of Records to CSV
I have an Access Table that has upwards of 1 million records. i don't want to
show them all at one time so my "Max Number of Records" is 10,000.
Unfortunately when i try to export the file to CSV, only the 10,000 records
that are showing get exported.
...
|
4 |
07.09.2006 21:45:04 |
|
|
Import Fixed Width with Header rows
Hi,
I've read several posts regarding this topic and they have been very helpful
but I still haven't resolved my problem. I have a fixed width .dat file.
The manufacturer says that each line has 24 characters and the last 2
characters are <CRLF>.
When I use the import wizard and create a spec for the import it imported
fine EXCEPT it imported an empty row between each record....
|
6 |
07.09.2006 21:00:40 |
|
|
Pipe Delimited files with headers
I have a number of files - 2600, which grows by at least 20 every day -
that have about 140 fields each. The first line of each csv file
contains the field names, pipe delimited. The second row of each file
contains the values for each field, also pipe delimited. I have a
vbscript that securely transfers the files from an external server. We
use the stdout to get the list of files, so that sh...
|
3 |
07.09.2006 20:36:33 |
|
|
nonexclusive import from Excel
I have several applications that import Excel files into Access, some
automatically importing a large number of files. I've scheduled the update
process for a time when no one should be in these files, but occasionally
someone has the spreadsheet open and I'm unable to load it into Access.
Is there a way to open and load a spreadsheet without exclusive access? TIA....
|
2 |
07.09.2006 19:27:02 |
|
|
Loading Data into Multiple sheets in 1 book
Hi All
I have 2 questions
1. I am trying to automatically create a workbook with a number of
sheets in it with different data. I see how the command mode allows you
to feed data to a (one/first) sheet (C:\Program Files\Microsoft
Office\Office\excel.exe" H:\':DETAIL.XFER.SHORT.FILENAME) but how do
you get data to sheets 2 3 4 etc in the workbook?
2. Can you format the data going into th...
|
4 |
07.09.2006 18:08:02 |
|
|
Importing data didn't populate related tables
Hi all,
I am building a database in order to track all appropriate information
for my newpaper subscribers, carriers and related items.
All of my data is being pulled from an excel spreadsheet which has been
modified to hold the data in a format Access should be able to identify
including field names and data type (yes for yes/no boxes, that sort of
thing).
My primary concern at the m...
|
3 |
07.09.2006 15:29:58 |
|
|
ODBC microsoft access driver undefine Function
I created a field in my query using the following function:
Dealer to Install: HolidayWorkDayDiff([Date Dealer Rec'd Equipment],[Install
Date])
When I run the query it returns exactly what I am looking for, but when I
return to the excel sheet and try to refresh the spreadsheet it tells me:
[Microsoft][ODBC Microsoft Access Driver] Undefined function
'HolidayWorkDayDiff' in expres...
|
6 |
06.09.2006 23:39:18 |
|
|
Importing multiple Excel sheets into Access
My goal is to import data from multiple (several hundred) Excel files into 1
Access database. All Excel files would have the exact same format; only the
values would differ. Is this possible?
Let me know if you require additional explanation. Thanks in advance....
|
2 |
06.09.2006 21:33:02 |
|
|
Multiple spreadsheets
Hello,
I need to import data from multiple excel file spreadsheets into one Access
table.
All the data in all spreadsheets are in Sheet 1 and in the same format.
I know how to get external data but I was wondering if it was a faster way
being there are
about 20-30 different Excel files but all in the same format.
I'm trying to correct a situation to make things simpler. Right now I am
c...
|
5 |
06.09.2006 14:45:38 |