LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
University of Maine student
 
Posts: n/a
Default Saving data to a form datasheet

I am having trouble saving data into a forms datasheet. It appears that I am
missing a crucial step when trying to save 'new' data to the datasheet.

Steps:

1. I open the form in 'form view' and enter data within the datafields.

2. I save the existing data using the macro 'save.'

3. I reset the datafields and enter new data.

4. I again save the form, assuming that the data I have just entered is
being saved as a new row. However, upon opening the datasheet I find that the
data I had previously saved has only been overwritten by the data I have just
saved.

Unfotunatley, I don't have the experience with Excel to solve this problem.
I have used the Excel 'help,' but I could not find an article that relates to
my situation.

Many Thanks.

 
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
Can you use the validate function in a data form in Excel? Jolly Excel Worksheet Functions 0 December 12th 05 11:00 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Saving data in a worksheet within a workbook Homeuser Excel Discussion (Misc queries) 2 August 21st 05 10:49 PM
Dowloading internet data to worksheet form a ".ccv" file Duane L Kibby Excel Worksheet Functions 0 April 24th 05 08:24 PM
How do I get an Access form in Excel to Expand the Data RogerN Excel Discussion (Misc queries) 0 February 25th 05 06:04 PM


All times are GMT +1. The time now is 09:09 PM.

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"