LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Transfering data from form to database

Hi all,

I'm setting up a form for users to submit details of
telephone calls. I've tried using the Template Wizard with
Data Tracking, but have found too many things that people
don't like about it.

What I want is for users to click a 'submit' button, and
for the data from the form to be sent as the next row in a
database. I have no idea where to start writing a macro
that would do this.

Also, as a secondary issue, I then want to be able to take
an entry in the database and return it to its original
format, ie in form style.

I realise that all this would be easier in Access, but I
don't have it on my computer.

Thanks in advance for any help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfering information form one cell to another work sheet Stephanie Excel Worksheet Functions 11 September 25th 09 12:56 AM
transfering data from word form to an existing spreadsheet Jose Excel Discussion (Misc queries) 1 October 15th 07 07:56 PM
Excel template as form for data entry in Access database B. Ardolf Excel Discussion (Misc queries) 0 August 24th 07 04:00 PM
getting data from a database into a form Brendan Excel Worksheet Functions 2 October 8th 06 10:24 PM
Transfering Database From Excel to Works Alex Excel Discussion (Misc queries) 0 April 19th 05 03:09 AM


All times are GMT +1. The time now is 07:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"