|
dealing with max number of fields
For research and productivity purposes we have been entering and uploading pt
testing information in an Access db. It is not intended for use on the Web.
Recently we’ve joined a research Network that will utilize some of our data.
Instead of re-entering data, I would like to upload it, but have encountered
problems and don’t know how to handle it. The other sites enter directly into
...
|
6 |
11.08.2006 08:51:15 |
|
|
Curious Message When Importing
Access 2003. I am importing a comma-delimited text file into an existing
Access table. When the import is complete I get the information dialog
saying:
>Microsoft Acces was unable to append all the data to the table.
>
>The contents of filed in 0 record(s) were deleted, and 0 records were lost due to key violations.
>
>*If the data was deleted, the data you imported or ...
|
5 |
11.08.2006 12:10:02 |
|
|
broken reference
Hi all,
an access application on a server is run
from two different computer.
On one of the machine it is working correctly
On the other a broken reference make the program stop.
(Because a driver is not installed and not needed)
To manually fix it i go in the reference menu and uncheck the
missing reference. the program can then be run and
the user can have access to the functio...
|
2 |
11.08.2006 00:12:23 |
|
|
How can I import excel file same as excel data.
Carriage return (Alt+del) in excel data in one cell is imported to small
aquare box into the place of carriage return. Some one have magic idea to
import same as excel?
Excal source data
I hope this work
A) It should work this way
After import to Access
I hope this work â–¡ A) It should work this way ...
|
6 |
10.08.2006 20:51:01 |
|
|
Exporting a NumberFormat
This is what I have and It will not select the Columns. I must be missing
something?
Sub Format()
' Excel stuff
Dim xlObj As Excel.Application
Dim wks As Excel.Worksheet
Dim r As Long, c As Long, x As Integer
' DAO stuff
Dim db As DAO.Database
Dim rs As DAO.Recordset
Di...
|
2 |
10.08.2006 20:26:15 |
|
|
Access shuts down when importing excel data
I have been importing excel data when I clean it up to match other data in my
access database. Recently, access shut down when I tried to perform the same
action. Is this a problem with Access or my data. How can I fix this? Help....
|
3 |
10.08.2006 20:17:02 |
|
|
Exporting report to text shows strange line spacing....
Hi All:
Any help would be greatly appreciated....
I have a report that I am creating to eventually export to a Text
File....the Text file has very specific character limits as it goes out to a
vendor who applies scripts and such dependent on the placement of certain
characters....
I tried to limit the character length of individual fields, but to no avail.
What I would up doing wa...
|
2 |
10.08.2006 20:15:39 |
|
|
When I export my file there are more entries than I have entered.
I am exporting my file as a .csv or .txt (tab delimited) for mail merge in
InDesign. I have entered 54 entries but there ends up being 67 entries when I
merge the file. One field is giving me problems on some entries but I can't
figure it out....
|
3 |
10.08.2006 20:07:55 |
|
|
docmd.OutputTo errors
Docmd.Outputto is not working in Access 2002. I'm trying to export query
results to a txt file. I'm getting "not enough memory" errors when I have
the statement in VBA code. statement is "docmd.outputto acOutputQuery,
"qryxyz", acFormatTXT, , False". The query has an underscore in its name but
I renamed it without that and it still didn't work.
When I unhide the database, go into the ...
|
4 |
10.08.2006 20:00:22 |
|
|
Can't update a record in a SQL2000 linked table
Hi there,
I have an application with several linked tables of a SQL Server ODBC.
When I try to update one record only in one of tables, MSAccess shows a
message that other user is making changes to the same record and asks me to
copy this record to the clipboard.
I have no problems with the other tables.
The thing is that I'm the only user connected to the server and also I'm the
dbowner...
|
3 |
10.08.2006 19:06:02 |
|
|
(Leo) ADO Connection Error
--
Thans & Best regards
Leo, InfoSeeker...
|
2 |
10.08.2006 15:44:02 |
|
|
(Leo) ADO Connection Error
Hi,
I have an Access mdb file with exclusive file password. From Excel I attempt
to connect to the file, it produces Automation Error no -2147217843.
the code looks like this;
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open "C:/DB.mdb", "Admin", "MyPassword"
End With
when I remove the password from my mdb file it w...
|
4 |
10.08.2006 12:51:15 |
|
|
How to select parts non related in word2k?Mouse+Ctrl don't work
I tried to sel;ect different non related parts of text. In word 2003 this
function was provided by the mouse+Ctrl key action. But now I have to deal
with word 2000 and this combination doesn't work.
What's the solution?...
|
2 |
10.08.2006 05:48:18 |
|
|
splitting excel spreadsheet fields into multiple tables
I have a table in my db for employees that has First_Name, Last_Name and
EmployeeID fields. I have an expenses table that has the details for the
expenses but only the EmployeeID.
I imported an excel spreadsheet which is now a table with EmployeeName, and
the details I need for the expenses table.. I have a form which matches the
imported spreadsheet. It has an not-in-list event add fe...
|
2 |
10.08.2006 05:28:41 |
|
|
How do I set up a web query in Access?
I am trying to pull data from a web page table into Access. I can do it in
Excell through DATA, IMPORT EXTERNAL DATA, NEW WEB QUERY, but cannot find a
similar procedure in Access....
|
1 |
10.08.2006 05:26:01 |
|
|
Urgent! NA values in table with Number Data Type
Hi!
I have a data table consisting of 10,000 rows with various row headers and
numerical scores, 0 through 10. All the fields containing scores are
formatted as "Number"
Problem is that I'd like, at times, to use the "NA" convention (or some
similar non-numeric convention) in instances when a score was not calculated
or isn't relevant. I'm unable, however to find a way to enter an...
|
2 |
10.08.2006 02:14:19 |
|
|
How do I connect Access to Oracle if Oracle client is not installe
More details:
I have a remote Oracle database to which I need to connect.
My local computer doesn't have Oracle (and can't have).
I know I can browse the Oracle DB from this computer using DBVisualizer (it
uses jdbc connectors, which don't refer to entries in Oracle's tnsnames.ora
file).
Thanks for any info, and best regards
Tebis
...
|
2 |
10.08.2006 00:37:13 |
|
|
create template
i have created a report that is sent via email to recipients through the
SendObject command in a macro. I want to sent the report in the body of the
email not as an attachment. But when I create put in the output format
"HTML" I get an error mesasge that there is no path specified. I believe
this error is referring to the path of a template that is to be used to allow
the data to be i...
|
3 |
09.08.2006 19:47:59 |
|
|
Export to txt files adding unwanted hh:mm:ss not in original data
I am using Access 2003 and am exporting data to a txt file. I have three
date fields. In the original table and in the query, these fields are
formatted as short date, yet they are winding up in the txt file with an
unwanted time stamp:
1/1/1994 0:00:00
There is an export specification attached to the export function, but I do
not see a way to check the field parameters to make sure ...
|
3 |
09.08.2006 17:29:02 |
|
|
Debugging a scale program
I am trying to determine why a Access application keeps hanging. The client
is connected to a scale and uses the printer port (LPT1), Com port 1 and com
port 2 to send information back and forth to the scale.
What the previous developer did was use a program called IO.dll to open
communication between the printer port and the scale. The scale signals that
there is a object on it and th...
|
1 |
09.08.2006 16:36:02 |
|
|
Verify ODBC Connection Available
I have an application with Access as frontend and SQL as backend, using ODBC.
When the User logs on thru his/her frontend, I need the Access frontend to
verify that they are online and the connection to SQL is available, otherwise
I need to restrict their activities to limited offline functions.
How can I have Access verify that the ODBC connection is available?? I
suppose using a tim...
|
3 |
09.08.2006 16:08:06 |
|
|
Access 2003 Import from Outlook 2003
I am trying to link my Outlook contacts to Access. Why does it produce
double entries for most of my contacts?...
|
1 |
09.08.2006 15:41:04 |
|
|
Can scanned documents be merged into an Access database?
Can documents be "scanned" into an Access database?...
|
4 |
09.08.2006 14:26:18 |
|
|
Merge Excel spreadsheets to table
Every month I shall receive Excel spreadsheets in a dedicated folder which I
shall then need to merge into various Access tables. There are a lot of
spreadsheets so it's not practicable to cut and paste the data and there are
new spreadsheets every month e.g. Fuel Sales - Jan '06, Fuel Sales - Feb '06,
Fuel Sales - Mar '06. There are many other categories as well e.g. Shop
Sales, H&S e...
|
3 |
09.08.2006 13:46:02 |
|
|
Import http url - ends up in errors table
When I attempt to import a text file that includes a field that contains
urls, that field ends up in the errors table instead of the table I'm
importing into.
Seems to happen whether the field is set to text or the http. I suspect it
is due to length of the data. Are urls limited to 256 char like text? Is
there a work around?
Thanks in advance.
...
|
3 |
09.08.2006 13:29:01 |