Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default Shared workbook using a Data Entry form

All...

Can a workbook be set up to share among users if a data entry form is being
used to capture input?
--
Joe Mac
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default Shared workbook using a Data Entry form

I shared workbook can bed used in excel but it is not recommended. Excel
isn't designed to handle multiple access simultaneously. It would be better
to put the database in Access which is designed for simultaneous entry.

You can desing the form in either Excel or Access. Then write a maco to
store the form data into the Access Database. Excel macros can write data
into an Access database. Some people prefer to use Excel as a front end to
the database becaue more people are familar with use Excel than Access.

"Joe Mac" wrote:

All...

Can a workbook be set up to share among users if a data entry form is being
used to capture input?
--
Joe Mac

Reply
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
data entry form AJ Excel Discussion (Misc queries) 2 March 4th 09 01:36 PM
put date and time in cells after entry made in shared workbook robzrob Excel Worksheet Functions 2 April 10th 08 09:13 PM
New record button grayed out on auto form w/ shared workbook Jase4now Excel Discussion (Misc queries) 0 August 31st 07 10:56 PM
Data Entry in shared workbook RUSH2CROCHET Excel Discussion (Misc queries) 0 August 28th 07 09:50 PM
Data Entry in a Shared Workbook SueTinkham Excel Worksheet Functions 0 March 28th 07 12:09 AM


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

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

About Us

"It's about Microsoft Excel"