Rxport and rename table
Mon, 18 Aug 2008 08:29:01 -0700
Hi,
I am preparing a databse (MIS) which keeps details of work done of about 150
employees.
Idea is that i import lot of data from excel and other systems into the
database and daily i generate a "daily final report".
Point i am stuck is:- I am unable to rename table using today() command. But
I can ren ...
|
Importing Excel files into Word
Mon, 18 Aug 2008 07:36:01 -0700
How can I import an Excel table into Word and still keep the link? Using Win
XP and running Word 2007. ...
|
Importing From Speadsheet
Sun, 17 Aug 2008 14:18:05 -0700
Hi,
I created an application that manages staffing actions. I created a button
that imports an XLS file from a set directory on C drive using the following
syntax:
DoCmd.TransferSpreadsheet transfertype:=acImport, _
tablename:="Candidate Test", _
FileName:="C:\New Promotion Tr ...
|
Using email to get data in access
Sun, 17 Aug 2008 08:31:01 -0700
hi i have tried to get some info fro contacts using create email but a dialog
box keep poping up saying outlook could not be opened make sure outlook is
installed, but am sure i have outlook installed. any ideas guys. thanks to
all. ...
|
Accessing oracle pseudo columns in SQL within Access 2003
Sun, 17 Aug 2008 06:09:22 -0700 (PDT)
Hi folks,
The following SQL statement is valid in Oracle:
select user from dual;
It returns the name of the user (schema) to which the client program
is connected.
How do I refer to the pseudo-column "user" within Access 2003? When I
code something similar the user is prompted to enter a value for the
...
|
Export Delimited
Sat, 16 Aug 2008 08:00:01 -0700
Trying to create macro to automate the export of a query to tab delimited
text file.
Transfer Type: Export Delimited
Specification Name: Tab Delimited Export Specification
Table Name: T558c Table (this is the name of a query)
File Name: C:\Documents and Settings\my name\My Documents\Exports\T558c.txt
Has Fi ...
|
Number does not retain the format 5.00 becomes 5
Fri, 15 Aug 2008 22:07:00 -0700
I've have a query where the number field is formatted as standard and 2
decimal places. I have also hard coded the field as Format (Field Name,
"0.00"). No matter what I do when I export the query as text tab delimited.
It does not retaining the format so 5.50 is 5.5 and 5.00 becomes 5. I have
deadline to m ...
|
|
|
EXPORT ACCESS DATA AND IMPORT ACCESS DATA
Thu, 14 Aug 2008 18:37:01 -0700
I would like to export 1 individual file, send it to another, and then they
can import the file into the same database to review the information. Can
this be done? If so, could you share with me how the other user could simply
import the file and not necessarily have to go through the steps to import
data to ...
|
Open to Suggestions
Thu, 14 Aug 2008 17:25:02 -0700
I work for the Air National Guard - as our planes return from flight the
aircrews report to our maintenance debrief center and report any aircraft
mechanical problems. To track these write-ups I created a database that works
just fine. Next I want to load the program on thumb drives so the Crew Chiefs
can t ...
|
Access 2007 import valid path issue
Thu, 14 Aug 2008 14:43:01 -0700
Using Access 2007, we are importing Category.xls and appending to current
table Category. We have started to receive an error message: "\fpcom\Product
sales\product sales reports รข?? query.mdb is not a valid path". This error has
arisen only recently.
We can do the import fine on pc's with access 2003. I ha ...
|
