Setup form on website to email me and import data into Acces
Wed, 6 Aug 2008 11:34:01 -0700
I have reviewed collecting data by using emails but wonder if it is possible
to have a form on our website where users can fill in data and have it
emailed to me for automatic input. This is for collecting new names to our
mail list database. Any suggestions will be appreciated!
--
Nancy ...
|
querying between Access and PervasiveSQL
Wed, 6 Aug 2008 11:25:39 -0700 (PDT)
Hi,
Hopefully a stupid question...
I have two databases, one in Access which is my "scratch file"
database - where I do tests and write queries, and then the original
source database in Pervasive SQL, which is a piece of junk that we are
trying to move away from, *but* it contains all our patient data.
I ...
|
Word template merge from Access
Wed, 6 Aug 2008 10:45:01 -0700
I'm trying to run a very simple TransferText to put data from an Access query
into a Word template. I get the message, "Cannot update. Database or object
is read only."
To the best of my ability to tell, nothing is read only. Any debug or
repair suggestions would be deeply appreciated.
--
Carol ...
|
Importing an ODBC database
Wed, 6 Aug 2008 08:59:03 -0700
I am trying to import data from quickbooks pro. I have qodbc and can get to
the information fine however when I create a link table, the very large
tables cause access 2007 to crash. I decided to import the table instead of
creating a link table. I thought that we could just reimport the new data
every we ...
|
Links to named ranges don't update in database
Wed, 06 Aug 2008 04:15:15 GMT
I'm trying to relink existing excel tables to new excel workbooks.
I successfully create new named ranges in the workbooks, and the aclink
command seems to work, but when I examine the excel links, they are still
linked to the old data. Here's my code:
Sub NewXLData()
Dim strXLDir As String
Dim rsTblNames ...
|
question about an imported .csv file...
Tue, 5 Aug 2008 20:24:01 -0700
good day all,
I am working on getting a .csv file imported, and when it imports into my
table, one of my text columns showing a transaction description the imported
tble shows " " " in front of some of the descriptions?
"POS PUR FROM
Any ideas? ...
|
how to edit a prepared application form with access
Tue, 5 Aug 2008 17:13:01 -0700
My business uses a form for every client. I would like to scan it into my
computer and then be able to enter names addresses so forth, on screen and
print it out. it also has boxes that require calculations like inserting a
date 15 days from today's date. I would like to be able to have those
calculations ...
|
|
|
help creating a button to import .csv file... and more..
Tue, 5 Aug 2008 14:45:01 -0700
good day all,
I am trying to create a command button to import a csv file into a
temporary table... once in the temp table have the data added to a main
table?
I have the following:
tblcheckingimport - temp table
tblecheckingaccount - main table
I have tried everything...
Thanks, in advance f ...
|
Memo fields are truncated when including the textdelimiter char e.
Tue, 5 Aug 2008 13:00:04 -0700
Hi Folks,
when I try to export a memo-field that contains one or more of the delimiter
for the textfields into a text (csv) file, the memo-field ist truncated by
512 chars.
The delimiter chars in the memo filed are doubled correct in the assistent
dialogs.
Thanks for every reply ;-)
SL Willi Wipp ...
|
Importing Multiple CSV Files
Tue, 5 Aug 2008 11:42:01 -0700
I have 30 CSV files - all formated the same. Is there a way to import them in
one shot and have all the data records contained in one database ?
Thank you in advance. ...
|
