|
EXTEND A FURMULA WITHOUT CHENGE ARREY TABLE
HI
PLEASE HELP ME TO FIND THE ANSWER OF THE ABOVE QUESTION...
|
2 |
22.07.2006 13:15:57 |
|
|
Exporting from access to excel
Hi, I have a worksheet in excel that is a purchase order. I need to plug in
contact information from access into that worksheet. They are wanting some
sort of drop box or something of that sort. I need help...
--
Dianna Baldwin...
|
2 |
21.07.2006 20:54:02 |
|
|
Import error says "search key not found"?
Trying to import a text file into Access 2002, but am getting the error
message "Search Key not found". What am I doing wrong?
I import this file weekly so this error message is new....
|
1 |
21.07.2006 17:45:02 |
|
|
Importing Excel File From Web
Hi,
The problem is the following:
I have to visit an internal url, example:
http://cmw/htm/e107_files/Signallevel/180CONNECT/180Connect_Assets.xls, and
has no password, every morning and download the excel file to a path on my PC
then upload it to access.
Is there anyway I can automate the part where the file is downloaded
automatically to the path I choose and thus allowing acc...
|
2 |
21.07.2006 14:10:02 |
|
|
avoid loading an empty form
How can I avoid loading a form when the source table is empty?
Thank you for you help!...
|
4 |
21.07.2006 12:44:02 |
|
|
Exporting to dbase IV
Strangly enough i need to be able to export data to dBase IV.
I seem to be only able to do this for queries or tables, can i export to
this format from a form.
Please keep it pretty simple as im only very new to VB, just some ideas
might help to put me on the correct path.
Thanks
...
|
2 |
21.07.2006 12:39:02 |
|
|
Import 'Choice' Data into Access From Excel
Okay, I believe that I'm in over my head on this one, and I'll do my
best to explain.
I have two databases, one in access, and one in excel. The excel
database has been used for years in my facility and is in dire nead of
replaceing. That's where my access database comes in. My boss wants
me to bring in some of the data from the old datbase into the new one
to create an overlap of data ...
|
12 |
21.07.2006 12:31:02 |
|
|
convert from prn files to excel
how to convert a prn files and excel files
...
|
2 |
20.07.2006 20:33:34 |
|
|
mysql linked tables
I have created a working ODBC DSN from Windows to a Mysql 4.1 Server.
When trying to link the tables with Access 2000, I select the DSN and when
it *should* show a form containing all the tables, it shows nothing at all
and I'm right back at the beginning of the process.
I have done the process successfully at work so I know the steps I'm taking
are correct thus far.
...
|
1 |
20.07.2006 20:29:18 |
|
|
how do I link an infopath form to an access data base through sha.
I have designed a form in infopath with a data connection to an access data
base. I need to be able to publish the form on a sharepoint library so
employees can fill out the form and have the database retrieve the
information. Any suggestions?...
|
1 |
20.07.2006 14:51:01 |
|
|
Automated Text File Import
Hello, All:
I'm designing a very simple database that will import data (all text
files, all different names, each text file using the same column
headings, one common directory) basically for reference purposes. I
found a posting (titled "import multiple text files into Access
(different file names)" from February 2005...see link at the end) using
macros and a hidden form. That looks lik...
|
4 |
20.07.2006 14:15:47 |
|
|
A command button (Access) that saves the current record in a file
The command button which would simply create a text file that would contain
some information on the current record selected. For example, the current
record selected (say record no4), contains a Lot ID (say, N12453.1), a device
Name, (AD8618ARCU-SHRT), and Qty (say 200units). I would like to save these
three entries automatically in a text file by simply clicking the command
button.
T...
|
2 |
20.07.2006 08:42:38 |
|
|
Export to Excel - Decimals
Hi,
Is there a way to export a Report from Access to excel or csv format that
will ensure all decimals are included. E.g When i export a 3 decimal column
to excel excel only shows 2 decimals and hides 1 decimal?
Thanks
George...
|
1 |
20.07.2006 05:40:02 |
|
|
Import fails and .mdb file balloons up in size!
Every day I export data from a company application to an excel worksheet. I
run an excel macro that cleans up the data for import to an Access db on a
network drive (used by many). On an Access form in the db, I click a button
that truncates the data table and then uses a command to import the new data.
This works for me every single day using the same computer in my cubical.
I just ...
|
7 |
19.07.2006 15:05:02 |
|
|
Using Excel Speadsheet Data
I would like to imbed an excel spreadsheet into an access database field and
then use date from a particular cell in the spreadsheet for access reporting,
calculations, etc. Is there a way to do this? Thank you...
|
1 |
19.07.2006 10:58:01 |
|
|
Importing Excel
I am trying to create a table with information from an Excel spreadsheet,
that will be continually updated with more information. But, I want to be
able to make adjustments to the table design and properties as well. Is
there a way to do that?...
|
2 |
19.07.2006 08:53:02 |
|
|
Importing Excel tables to Access
Hi, All:
I am currently have hundreds excel tables with same colum IDs, is there an
easy way to import these tables into Access and combined them into one table?
--
Thanks a lot!...
|
11 |
18.07.2006 20:36:01 |
|
|
importing text into access 2002
I did a search on the above, but found nothing useful, and can't believe I am
the first to get this.
Trying to import a text file into Access 2002 SP3. It is delimited with the
tilde (~) I get to the wizard screen where I should be able to select which
fields to bring in, set the type and decide what to call them.
BUT, whatever I do, the top section of the screen only works on field1.
...
|
3 |
18.07.2006 17:04:02 |
|
|
Transferspreadsheet method only imports first 2 rows
I am using the transferspreadsheet method to import 3 worksheets within one
workbook from Excel. I have a 4 tabbed workbook in Excel. The first tab is
a form that is only used for data entry. The other 3 tabs contain tables
that mirror my tables in Access. (tblClaim, tblPartPerClaim, and
tblJobCodesPerClaim)
I have created a button on my "frmClaim" that calls the windows dialog box to
...
|
1 |
18.07.2006 16:39:35 |
|
|
Importing large cell from Excel
I'm trying to import from Excel via VBA; sure, that's easy with
DoCMD.ImportSpreadsheet. Unfortunately, it has the same limitation as using
the Import Wizard: Excel automatically identifies data types, and any alpha
content causes the data to be imported as a Text field. This limits the data
to 255 characters, and I need more than that. I can format the receiving
field to be Memo, but I ...
|
3 |
18.07.2006 15:06:02 |
|
|
Importing large fields from excel to access
I have a spreadsheet that I am trying to import into access. The spreadsheet
import wizard automatically assigns text field to all of the fields. However,
one column has a large amount of data and needs to be a memo field. I don't
see how I can change the data type. How can i change it? When I import text
files, the wizard allows you to select the data type but I don't see that
option fo...
|
3 |
18.07.2006 14:16:02 |
|
|
i bought a kit and haven't got the serial number
i got a windows xp and the instruction said that i should have the serial #
by mail and i haven't got any, so, i can't instal my original xp
...
|
3 |
18.07.2006 05:11:34 |
|
|
How to transfer data from MS Access to FoxPro
Hello all, can somebody tell me how can I transfer data from MS Access
to FoxPro.
...
|
2 |
17.07.2006 21:55:09 |
|
|
Jet Database Engine cannot open the file...
I'm trying to EXPORT the results of a query to a CSV file. I've been
doing this, using different queries, for WEEKS, with no problems. This
file always thinks that the resulting export file is already opened,
but the file resides on my hard drive, and I get the error even if I
delete the file and start from scratch.
I'm not doing this via programming; just FILE > EXPORT.
The errors ...
|
1 |
17.07.2006 18:42:20 |
|
|
Export access report to text
Since we converted to Access 2003, we are having a problem exporting a report
to a text file. The text document is fine on the first page but the second
page does not have the correct number of cr/lf before the heading. All pages
after the second are formatted correctly.
Any help would be greatly appreciated.
Thanks,
Jim Haw
...
|
1 |
17.07.2006 16:21:01 |