|
|
|
Importing Data Using ODBC Connection
Wed, 3 Sep 2008 03:06:04 -0700
Hi There,
I want to import data into a MS Access database from a SQL Server database
using an ODBC Connection. I then need to create a macro to manipulate the MS
access data. I only want to manipulate the access data, I don't want to
change/manipulate the original data (the data in the SQL) server. If I ...
|
Running Make Table Access Queries from Excel
Tue, 2 Sep 2008 14:53:02 -0700
Hi,
I have an Excel Speadsheet that imports data from a number of Select Access
Tables into different Worksheet. This work well for users that are not
familiar with MS Access since they can just open the Spreadsheet and that
Data fro each worksheet is refreshed for them.
However I need to create a Make Ta ...
|
Preventing extraneous line breaks when exporting report
Tue, 2 Sep 2008 14:03:01 -0700
I am making a report that includes, among other things, a text box that has
a memo field as its source. I have set the text box to "can grow," and when I
look at the report in print preview, it is wrapped correctly and looks fine.
The problem is that when I export the report to Word, there is a carriage
re ...
|
Run Excel Macros
Tue, 02 Sep 2008 20:57:47 GMT
Need some help.......
I've been using a database to log warranty registrations for about 3 years
now. I import the data from Warranty Registrations submitted to me in Excel
format.
I designed the Excel forms so that a user could use drop-downs, checkboxes,
and regular fields to input their data. For the m ...
|
Exporting field names
Tue, 2 Sep 2008 13:54:48 -0700
I would like to export Access table field names to Excel. Only the field
names, no data. Can anyone help?
--
Thank You
Your help is appreciated ...
|
Re-arrangement of data
Tue, 2 Sep 2008 10:40:00 -0700
I am importing a large text file into Access 2007. The first 7 fields import
correctly. However, the 10th field, a text field, is being inserted between
the original 7th and 8th fields. So, the import comes is as fields 1,2 3, 4,
5, 6, 7, 8, 10, 8, 9. No other fields are rearranged. This issue means that ...
|
import dbase tables into access 2007
Tue, 2 Sep 2008 08:48:21 -0700
Can anyone point me to a step-by-step solution in Microsoft Help or in a
forum? I just need to do this once to about 8 tables, and I'm not good
enough at scripting to modify some of the solutions on the net. ...
|
|
|
**Registry Error**
Tue, 2 Sep 2008 06:44:07 -0700
On a a database I designed for a client, I've provided for an export to an
RTF file. However, when they generate the report and then click on File >
Export, the only option in the File Types is **Registry Error** .
I cannot duplicate this error and, since she hasn't tried it on another
machine yet, I'm gues ...
|
Put Date into outlook diary
Tue, 2 Sep 2008 01:37:02 -0700
I have a field called [NextApptDate] and another called [NextApptTime] which
gives that date and time of the next appointment for a client. I would like
these fields along with the [ClientID], [Surname] & [Forenames] to go into my
Outlook diary as an appointment if I Dbl_Click the [NextApptDate] field.
I t ...
|
outllook web access-change
Mon, 1 Sep 2008 08:03:01 -0700
A couple weeks ago after mistakenly downloading an adware called Microsoft
2008 ?? my outlook web access image changed completely wiping out the way it
looked before. I removed it but Outlook webaccess changed its look. For
example I used to be able to move email from the list to the folders with the
mo ...
|
|
|
