|
find and replace data in a text file using VBA from Access
I am struggling with VBA. I don't use it. I have an access database
that has a table called Core that only contains two fields called
OldValue and NewValue. This table is udated daily and the number of
records vary. I have a text file C:\Core.txt and I would like to
search this text file for the data in Core's OldValue and replace that
it in the text file with Core's NewValue. Is this po...
|
1 |
5/22/2007 5:57:26 PM |
|
|
Problem importing a table
I have a query that runs OK on local tables in an mdb file that was
originally created in Access2003. But if I import the tables to a new
Access2007 mdb, and try to run the same query, it hangs. I suspect
corruption in the imported tables (the query runs fine against the
original linked tables that the local tables were originally created
from, even when the query is run from the new .mdb)....
|
1 |
5/22/2007 5:29:36 PM |
|
|
Problem importing a table
I have a query that runs OK on local tables in an mdb file that was
originally created in Access2003. But if I import the tables to a new
Access2007 mdb, and try to run the same query, it hangs. I suspect
corruption in the imported tables (the query runs fine against the
original linked tables that the local tables were originally created
from, even when the query is run from the new .mdb)....
|
1 |
5/22/2007 5:17:52 PM |
|
|
can I update a data field in Access to include a prefix?
I have a Data Field of Client numbers that I need to add a prefix to (PRE)
before exporting to a text file to import into another program. Is there a
way the data field could be modified to include this prefix...
|
4 |
5/22/2007 1:43:02 PM |
|
|
Mass rename and import
Need help.
I've got a folder "C:\Documents and Settings\SDF" with aprox 3000 .sdf
files, that I need access to rename to .txt and import automaticaly to table
"SDF" with import specs "importspec" could someone post some VB code for
this. thanks in advanced....
|
10 |
5/21/2007 11:55:01 PM |
|
|
analyze with excel send grouping to separate tabs in excel
i need to be able to use the "analyze with excel function" in access for a
report so that when i send the data to excel the groupings found in access
with the query and shown on the report will each export to a separate tab in
an excel spreadsheet...
|
1 |
5/21/2007 9:40:01 PM |
|
|
OLE DB or ODBC real time connection
I have been reading and reading about A Fast Path to AS/400 Client/Server
Using AS/400 OLE DB Support. In all my research I have not been able to
answer my question. Is it possible to create a link to an AS/400 from an SQL
or Microsoft Access application that is real time? For example, like
spliting a Microsoft Access front end, back end linked table environment. In
my research I hav...
|
4 |
5/21/2007 8:48:27 PM |
|
|
Format prior to E-mail
I am trying to slowly convert most of my bi-weekly send outs to access so
with just a click of the button I can have everything done. I am currently
stuck at trying to get my Excel Document formated to the way it needs to be
prior to send out so that way I can just e-mail it through access and never
even have to see it. Is this possible? I appreciate any help I can get.
Thanks,...
|
1 |
5/21/2007 6:25:02 PM |
|
|
LastUpdated Property
I'm never sure under which topic to post these ?'s... I'd like to access the
LastUpdated info for a table but I get an error message that the object
doesn't support that method. The table I'm referring to is linked and I use
the code:
Dim rst as dao.recordset, mDate as Date
set rst=currentdb.openrecordset("MyTable")
mDate=rst.LastUpdated
I read the help but I don't really understand the...
|
1 |
5/21/2007 12:49:01 AM |
|
|
sum 1 column
i need sum all cell in this column
225
321
654
952
674
265
365
145
-----
3601
what is the Function ??
&
Where can i boot it ??...
|
2 |
5/21/2007 12:46:01 AM |
|
|
Exchange/Outlook IISAM Schema.ini
I'm trying to modify the Schema.ini file to add fields to the Outlook Linked
tables without much success. I added the Categories field and it appear in
the linked table but doesn't show the data I have in Outlook, I have tried
with and without the Tag property...
My Schema.ini file:
[1 - Outlook - Inbox]
IdSize=24
IdBytes=00 00 00 00 96 94 CD B6 F8 DA 92 49 BE 26 83 D3 D8 54 33 EE 82 8...
|
1 |
5/20/2007 8:00:58 PM |
|
|
Importing Excel sheets
I have a workbook with 4 sheets of data that has columns to identify invoice
information, customer information, expense acct information. I would like to
have the customerID as the primary key since it is unique but on importing i
receive the error it cant be done due to duplicates. The many rows have
repeating info so how do you import this?...
|
8 |
5/20/2007 7:48:02 PM |
|
|
Import a dbf or a tab delimited file
Dear friends,
I need to import a dbase file (dbf) / tab delimited text file in my Access
database. I need to import all records and all fields (approxiamately 10000
records and 5 fields).
I need to do that so I can then import some of those records (new records)
in my main table. So, i need to import this file once a week, always using
the same filename(dbase or txt) and the same ...
|
2 |
5/20/2007 4:51:00 PM |
|
|
Error with Linked Tables
Hi I have a main DB and Front End with forms that are linked to the main DB.
When i try to open the main DB from other computer using the front end file
it gives me error
The Microsoft Jet database engine cannot open the file
"file name with path". It is already opened exclusively by another
user, or you need permission to view its data.
But if i try to make my other computer as server i...
|
4 |
5/19/2007 9:44:00 AM |
|
|
What is wrong with this sql (export a linked table)
Sorry if this is a dup post but I got a server error on the first try.
I have a split db and need to export one of the linked tables to a 3rd db as
a table (not linked)
Here is the code I am trying to use:
Dim strSQL As String
On Error GoTo Errorcheck
strSQL = "SELECT * " & _
"INTO tblPrice_Catalog IN " & Application.CurrentProject.Path &
"\PriceList.mdb" & _
...
|
8 |
5/19/2007 6:44:59 AM |
|
|
Error importing large excel file
Hello,
I am trying to import a pretty large excel file into Access. It's 598 rows
and goes to column CU. It's giving me the error "An error occurred trying to
import file 'C:\Desktop\Book3.xls'. The file was not imported.". I've set
up a table for all the fields with the correct sizes and I've also tried
setting all fields to memo which I thought would work regaurdless but it
didn't. ...
|
23 |
5/19/2007 12:36:16 AM |
|
|
Using OLE frame with an Excel sheet for a report template
I am trying to use an Excel file as a template for an Access report.
I Linked the Excel template file through an OLE frame with the properties
set as follows:
Source Doc : C:\sajit\test.xls
Source Item : test1
where test1 is the Excel range name in the sheet in which the template is.
I also have other sheets which are used as templates for other reports. The
templates were made b...
|
1 |
5/18/2007 8:41:01 PM |
|
|
Error while importing text file;
i run the following command:
DoCmd.TransferText acImportDelim, , "TempTable", Me.txtFileName, False
Me.txtFileName = New Raw Data.txt
TempTable is already created and all the fields (F1 - F44) are type double
i dont get any run time error when running the import code but after import
the followingtwo tables are created: New Raw Data_ImportErrors, Name
AutoCorrect Save Failures. below a...
|
2 |
5/18/2007 6:24:01 PM |
|
|
2nd level Subdatasheet will not display in Access 2003 linked tabl
I have linked tables from a different database. I have the new tables as a
one-to-many relationship in the new database. The subdatasheet will not
display. The "insert subdatasheets" is disabled. What can I do to fix the
problem?...
|
1 |
5/18/2007 4:56:00 PM |
|
|
Script out of Range
I am just using the import wizard to bring in an Excel file into an existing
table in my Access database. This excel file has about 10K of records
however before it finishes, it gives me this script out of range error. is
there a maximum number of records it can import? or is it my data types are
not matching?...
|
2 |
5/18/2007 5:31:28 AM |
|
|
The mystery of export specifications !?!
Can anyone tell me if I can resuse an export specification if the column
names are different. There are the same number of columns and thier format is
the same but one or two have changed names (due to circular references this
had to be done)? Or, do I have to create a new export spec.
Thanks....
|
2 |
5/18/2007 5:16:01 AM |
|
|
How do I merge multi Access documents into a Access database?
I have five documents from different depts, I need to put them all in this
previously created database....
|
2 |
5/17/2007 7:37:02 PM |
|
|
Paste values into excel, no formatting
Greetings, and thank you all for looking.
So I broke down and got Office 2007 and I am finding that not only is it
really hard to get orientated, but there appears to be some really weird
changes. This post is in regards to pasting values from Access into Excel
but maintaining the Excel formatting. "Paste Value" was the solution in
previous versions...but paste values is not an option...
|
2 |
5/17/2007 7:17:42 PM |
|
|
Compare import data with current data
I have text table ALID0001 from A: that I currently import to Table ALI0001
in DB. The problem is when I have to update the DB table with the same date,
I must delete said date or I will get duplicate enteries. Is their a way
before importing data from A: to have it compair dates between the two tables
and delete data by date in DB before importing from A:
Macro
Transfer type: Import De...
|
2 |
5/17/2007 1:27:01 PM |
|
|
Access 2002 truncates text when linking to Excel 2002
I want to link into an Excel 2002 spreadsheet worksheet into an Access 2002
table. Some worksheet cells contain long text strings (400+ characters, in
some cases), but Access truncates the field length (apparently at 255
characters) when I link the Excel worksheet as an Access table. How can I get
all the characters in the worksheet into the linked table? I've tried
File/Get External Da...
|
2 |
5/17/2007 5:43:37 AM |