User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 360,994 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,489 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser:

Using VBA with Access (was: Please Help!!!)

Join Date: Nov 2005
Location: Montreal, QC (Almost)
Posts: 130
Reputation: Yomet is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 9
Yomet Yomet is offline Offline
Junior Poster

Re: Using VBA with Access (was: Please Help!!!)

  #6  
Jan 19th, 2006
Hi Michelle and JackAssNo1,

First of all I want to thank you for not going the way of letting your users do everything in one form, it'a an approach that often leads to catastrophe.

Now for the problem. I don't know what the 'cure' is for your problem with Form.AllowAdditions = True since I have never used that technique through my years of programming Access. However, I might have a workaround for you.

What I would do is to create a specific form for adding records which contains all the necessary fields for the project. When the user clicks the "Add Program" button this form opens and lets the user enter the details. Once finished, the user would click a "Save" button which would save the new project, close the "Add" form AND update the list form.

This way you don't have to deal with one form doing everything and your users will not be confused trying to figure out whether they're in Add or Read Only mode.

Hope this helps

Yomet
Reply With Quote  
All times are GMT -4. The time now is 6:36 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC