directory mail merge/Office 2007
Thu, 23 Oct 2008 14:54:47 -0700
I want to set up a directory of members of a local civic club. I've created
a database in Access. I've created merge fields in a Word doc. The merge
works except I get the same members name repeated. What am I missing? I am
new to Office 2007 but a long time MS Office User. Thanks! ...
|
.FileSearch Issue
Thu, 23 Oct 2008 12:29:01 -0700
This code is not returning any files, although there are about 20 files in
the specified file location. The file location is valid and the proper
references are available. Any ideas why this isn't working?
strPath = txtFileLocation
With Application.FileSearch
.NewSearch
.LookIn = strPath
.S ...
|
HELP with using a schema.ini to export
Thu, 23 Oct 2008 11:15:01 -0700
I am having a problem exporting a table from SQL to a text using a
custom delimiter. When using a default of csv everything works fine. Below
please see some of the code I am using and below that is the schema file. I
am a little confused because I never want the file name to be the same so I
am not sure wha ...
|
Importing Tables
Thu, 23 Oct 2008 10:19:01 -0700
So I have a series of queries that I run on Table A. Each month, I get a new
updated table, Table B. What I would like to do is change the queries that I
run on Table A to Table B without having to go into the SQL to manually
change their names. I know this is a stupid question, but please help
regardless. T ...
|
Importing in Access from Excel creating relationships
Thu, 23 Oct 2008 08:58:12 -0700
Hi,
I am hoping someone can help me with this question. Problem: we ended up
with 2 copies of the access database and need only one containing all of the
information. Could not copy and paste the data from one table/database to
another and there are too many records to easily re-write them in the table
...
|
Re: '<linked table name> isn't an index in this table' error in
access 97 database
Thu, 23 Oct 2008 08:51:05 -0700 (PDT)
This worked. I'm really shocked since no one else (except the
president) had any problems. They must have installed the "Karma 98"
components! Oddly it wouldn't let me run repair, till after I ran
compact, but otherwise it's all set now. Thanks again (to all)
Mick
On Oct 21, 10:14 am, "Joan Wild" <jw...@nos ...
|
Import Excel to Access
Thu, 23 Oct 2008 07:35:01 -0700
hi,
i have a list box that displays all imported weekly report....
SELECT [Name] FROM MSysObjects WHERE [Type]=1 AND [Name] LIKE
"*exception06W*" ORDER BY [Name];
i have this Command0 that imports my weekly report to Access and i have this
code...
On Error GoTo Err_Command0_Click
Dim i As Integer ...
|
|
|
Incorrect collating sequence
Wed, 22 Oct 2008 21:10:00 -0700
While linking paradox database with the access I am getting the incorrect
collating sequence error?
I tried modifying paradox driver registry entry of collating sequence to
international. It fixed the error but i could not see the data and column
were displayed with header column1, column2 and so on.Actual ...
|
Importing excel data from row 2
Wed, 22 Oct 2008 17:45:01 -0700
How do I just import everything from row 2 in the excel file??
I don't want to define a range, eg A2:V750, as each month when the data is
imported, it will be a different amount of rows. I just want to import data
from row 2 downwards.
Any help would be much appreciated. ...
|
Get External Data2
Wed, 22 Oct 2008 15:46:59 -0700 (PDT)
I am importing data from multiple Excel files into an Access table. I
can perform this task for one table using the code I pasted below of
which I found in this group. The CreateTableFromExcel() function is
designed to receive the Excel file location and name as input. How
could I modify the code below to loo ...
|
