|
Table list for ODBC source database does not include all tables
I'm trying to link a table from a sql server database into Access 2000 but
the table list only pulls back a few tables.
I have select permission to the record....
|
1 |
16.08.2006 16:53:01 |
|
|
Excel spreadsheet format
I am using Access 2003 and exporting several tables to separate spreadsheets.
Some cells are empty and these cells display no borders. A macro pastes
each spreadsheet into a section of a report so I don't want to have to format
each spreadsheet each time. How can I have all the cells maintain the border
even when there is no data in them? ...
|
1 |
16.08.2006 14:56:02 |
|
|
importing tables into Access, why can't I adjust field options
When importing tables into Access, as I go through the wizard, I come to a
screen that supposedly allows you to click on the field name, indicate
whether the field is indexed and allows or not allows repeats, and skip the
field altogther. I can't get anything to take after the first column. If I
try to change any properties in the field option box, it applies it to the
first column onl...
|
3 |
16.08.2006 12:19:02 |
|
|
Updating other table
I am desinging a data entry form which enters some data in table "quote".
There are 3 tables in my database
Products, Customers, Quotes
Structure of Quotes Table.
QuoteId (Autonumber)
CustName(Text)
PartNo (Lookup)
Description (Text)
Price (Number)
At first I have to enter Customer Name and then PartNo which is a lookup
field from products table.
CustName is either present in...
|
1 |
16.08.2006 12:12:40 |
|
|
How do I identify the system id for a specific field?
We are trying to link AutoDesk Architectural 2006 to an Access mdb table.
When we view the data in the database the information is in the correct sort
order but when the drawing opens it seems to randomise the data. Is there
any way in which we can identify the system ID of the field and link to that
so that the link is set more firmly? Any ideas and help would be
appreciated. ...
|
2 |
16.08.2006 11:31:13 |
|
|
Importing & Appending
I'm creating an application to import my emails from Outlook and
appending them into a table of previously imported emails in Access 2K
using VBA. If I haven't deleted all my messages from the Outlook
Inbox; how can I prevent old emails from being duplicated in the append
query in Access?
Thanks,
PC
...
|
2 |
16.08.2006 05:49:10 |
|
|
synchronizing data
I have a database that gathers data from 15 different agencies. At present,
the data is submitted by each agency in paper form and then entered into the
database. It has been suggested that each agency enter their own data into a
copy of this database and then import this data into the current and original
database.
As I am testing this process, I foresee problems with the primary key i...
|
4 |
16.08.2006 05:45:05 |
|
|
How do I import a Table of e-mail address w/ names into outlook?
I have a contact list in Microsoft Access that contains names and e-mail
addresses and I need to be able to export that information to some sort of
e-mail list that I can use in Microsoft Outlook to send an e-mail to all of
the contacts. This process needs to somewhat automated because people in my
organization with no computer skills will need to be able to perform this
task on their ow...
|
2 |
16.08.2006 05:28:09 |
|
|
Importing & Appending
I'm creating an application to import my emails from Outlook and
appending them into a table of previously imported emails in Access 2K
using VBA. If I haven't deleted all my messages from the Outlook
Inbox; how can I prevent old emails from being duplicated in the append
query in Access?
Thanks,
PC
...
|
1 |
15.08.2006 22:45:38 |
|
|
Gaining back space in Access tables
I created a SQL Server application which deletes data in access tables and
transmits new data daily through DTS. Is there a way to prevent the need of
Compact And Repair programatically or do I have to have the user Compact And
Repair the database manually on a daily basis ?...
|
5 |
15.08.2006 22:06:02 |
|
|
My upsized table contains no records
I am trying to upsize from access2003 to sql server2005 express, but no table
has any data...
|
1 |
15.08.2006 16:08:01 |
|
|
URGENT! Problem with carriage return & square characters!
Hi everyone,
I have a problem, which many people seemed to have had previously, but with a
bit of a twist.
On importing information into Access tables i get a square character instead
of a carriage return.
I found partial solutions in:
UPDATE Tablename
SET FieldName = Replace([FieldName], Chr(10), Chr(13) & Chr(10), 1, -1, 1);
&
http://support.microsoft.com/default.aspx?scid=kb;...
|
3 |
15.08.2006 14:45:02 |
|
|
Frontend backend exporting to Excel
Hi
I know very little about Access but have converted Tables, Queries to Excel
in the past, however I have run a report from the front end of an Access
database but want to send the results electronically via Excel in an email.
How do I get the report or get to the report to convert it rather than jsut
printing it off? I imagine that if I can get the report in a format that I
can im...
|
2 |
15.08.2006 12:14:01 |
|
|
Opening Excel via code
Good day,
I am trying to import data from Excel into Access via VB. I do experience a
problem to access an add-in to Excel. The add-in is a program to extract
data from a different source into Excel. The add-in is called NetOffice and
is part of a larger program called ProcessNet.
My main problem is when I open Excel via VB from Access the NetOffice add-in
does not load. I mu...
|
8 |
15.08.2006 03:47:06 |
|
|
2006-2007 student attendance record
do you have one for this school year available...
|
1 |
14.08.2006 22:41:01 |
|
|
Text Box To Word Doc
I have a form that has a command button that prints the form as a report. I
would like to add a text box to the form that if nothing is in the text box
nothing happens but if something is in the text box i would like it to
automatically save the contents as a word doc when i click the command button.
I would also like it to prompt me for a file name to save the word doc. How
can i accomplis...
|
4 |
14.08.2006 20:27:43 |
|
|
Saving Access 2007 database in Access 2003 format fails in Access
Has anyone successfully create a large (2m row) database in Access and then
used Save As Access 2002-2003 to allow Access 2003 users to use it. I have
tried this several times and on each occasion the database can not be used in
Access 2003 and I have had to resort to exporting in to CSV and then
importing it....
|
1 |
13.08.2006 07:37:01 |
|
|
Can not open MS outlook containing contacts obtained from old, com
My old computer, a HP Pavilion crashed and the windows operating system would
not open, since a USB port was deleted and when I turned on the computer a
wizard found the new hardware but it was unable to retrieve the drive. I
had my data extracted by a professional service. All the other data opened
except upon attempting to open the contacts in the MS Outlook file, the new
computer...
|
2 |
13.08.2006 06:53:18 |
|
|
Getting Compuserv to Work with Microsoft Outlook E-mail
I currently have a laptop with Compuserv installed. I have just put all of my
Contacts in the Database Manager and was attempting to send e-mails to one of
my contacts and found out that it didn't allow me to send the message.
I am assuming that I need to reconfigure the server or add an additional
e-mail account. Can someone help me do that? ...
|
4 |
11.08.2006 23:45:51 |
|
|
Access and Word
I am using an Access table as my source for a Word mail merge. The database
has a password on it. Is there a way to use VBA to have it automatically
enter the
password when it is opened?
I have a form in Access that contains a button that executes the open and
mailmerge commands on the Word document file....
|
1 |
11.08.2006 21:27:02 |
|
|
Access and Word
I am using an Access table as my source for a Word mail merge. The database
has a password on it. Is there a way to use VBA to have it automatically
enter the
password when the Word file is opened?
I have a form in Access that contains a button that executes the open and
mailmerge commands on the Word document file....
|
1 |
11.08.2006 21:19:02 |
|
|
two append tables?
I have imported a excel file. It started out with names as one field but I
ran a query to split it into two first_name and last_name which is the
format the names in my db are in. I have one table with both name fields and
an employeeID. I have a second table, expenses, with the employee ID and
details about the expenses. Someone yesterday suggested I could run a query
to put the names ...
|
2 |
11.08.2006 20:32:48 |
|
|
Com and printer port trouble
Hello.
I have an application that uses a trigger sent from a scale to the printer
port to signify that data is ready to come from the scale to Com port 1. When
the access application recieves this data it records it and then calculates
the true weight and sends it to com port 3 which in turn is displayed on the
scale scoreboard. however, over time the application looses connection to t...
|
2 |
11.08.2006 18:58:58 |
|
|
How do I not allow updates when linking
I have an external sql database and I am using access to link to the sql
database to do reports but I don't want users to be able to see the tables
and make changes (deletes, inserts, updated) to the actual sql database
using the links. I would like to be able to have real time data from the sql
database when using access to do reporting (don't want to import data). How
can I accomplish secu...
|
7 |
11.08.2006 14:25:52 |
|
|
export to excel
Is it possible to use the "Transferspreadsheet" macro for Forms? I'm trying
to transfer a form over to excel, and I have it set up right now as "Output
to". It works fine, but i would like to have a template excel file that's
already pre-edited with conditional formating that the data goes into....
any ideas?...
|
4 |
11.08.2006 13:38:02 |