Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old November 29th, 2010, 08:29 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default very little compared to a pro

This is my first really functional DB in 2010
I created 2 or 3 little test BD to work out the easy bugs

I have created 3 DBs from a template, 3 simple (5 to 10 tables) DB's in 2003for property management and the modular building industry.

Everything I learn and do I get from the internet or books.

I am here becuase there are not alot of users out their putting information out on 2010 yet.

I have a better understanding of the program then a new user and most that have the program to access a DB and I am propably par with most that have built a DB .

I do not has the terms or formula's down. I cut and paste alot. I keep a file with macros and codes that do the same thing on different forms or queries

the DB i am currently working with is modeled closly with MS templates for Contacts, Call tracking, Pipline and projects.

I have modified the tables and relationships and added a user(employee table)to meet my needs and refer back to the templates when form, query or report need work.

If you were to look at it I would expect a giggle or two only because I probaly went the long way around a short fence on most of the thing I did.

and I have alot of little bugs that pop up as I navigate throw the modifications
Reply With Quote
  #12 (permalink)  
Old November 29th, 2010, 10:10 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default WOW

After looking at your example and some of the code in your modules.
I am a baby taking large steps in a world way bigger then me :)

This helps alot now I juat need to figure out the translation and what to apply to mine

Your autoexe upon start up does that start all the codes in your modules

Boilerplate-form_frmuserlogon (code) does that create your logon form or is tthat just the code because I do not see your logon form in the objects
Reply With Quote
  #13 (permalink)  
Old November 30th, 2010, 03:47 AM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Thank you for the background. That helps me know where you ar coming from.

The forms are all there but there have been set to hidden in the database window/nav pane. You will need to go to the navigation pane's options and turn on the display of hidden objects.

Quote:
I do not has the terms or formula's down
Unfortunately that is a must to really get past being just a beginner/basic Access user.

You mentioned making this web based in the future. Have you made an web based apps using PHP, ASP, ASP.NET, or some other scripting language.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote
  #14 (permalink)  
Old November 30th, 2010, 06:28 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Nope none nil nada

I have no EX in building web based anything.

It's not a big priority, at most a far away goal. getting to to work from the server is on the fore front. Oh and I split the DB today.

I see your user logon utilizes alot of the Modules built in the BoilerDB which was built in access 2002? 2010 automates alot of thoughs functions. Have you recreated that logon in 2010? and did you your own code or the code builder in 2010?

I have imported your form template into my DB and am currently trying to reconstruct the protocals to recreate the actions in the BoilerDB in mine.

I really like and applied the yes/no value in your user table to should admin properties.

also Table VER and VER_1(will not open) can you share how that relates to the DB? its repestented in most of your modules
Reply With Quote
  #15 (permalink)  
Old December 1st, 2010, 04:38 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by lex8058 View Post
I have no EX in building web based anything.

It's not a big priority, at most a far away goal. getting to to work from the server is on the fore front.
It can take at least 10 times longer to create a web based app with the current tools to get the same functionality that an Rich Client app like Access can do.

Quote:
Originally Posted by lex8058 View Post
Oh and I split the DB today.
That is great news!


Quote:
Originally Posted by lex8058 View Post
I see your user logon utilizes alot of the Modules built in the BoilerDB which was built in access 2002?
I did not actually write this code. It was done by Candace Tripp the Utter Angel

Actually I think it was built in an earlier version like Access 97.

No need to convert to a newer format thyatn 2000 since it works great in 2000 to 2010.

Quote:
Originally Posted by lex8058 View Post
2010 automates alot of thoughs functions.
Curious, like what? can you givce me sopme examples?

Quote:
Originally Posted by lex8058 View Post
Have you recreated that logon in 2010? and did you your own code or the code builder in 2010?
Not sure what would need to be recreated to work any better/different in 2010

Since the time I started with Access in verion 2.0 I have not used the Code Builder. I use code templates that provide bette documentation.

Quote:
Originally Posted by lex8058 View Post
I have imported your form template into my DB and am currently trying to reconstruct the protocals to recreate the actions in the BoilerDB in mine.

I really like and applied the yes/no value in your user table to should admin properties.

also Table VER and VER_1(will not open) can you share how that relates to the DB? its repestented in most of your modules
What happens when you try to open the Table VER or VER_1?

These tables are an example of verion control.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote
  #16 (permalink)  
Old December 2nd, 2010, 03:09 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default AUG!!!!!!!!!

Spliting the DB just killed me. Tons of work for the last week gone.

I have forms and tables that have formulas connected to Queries that I can not get to now.

the code build auto fills formulas and runs your code to errors
Reply With Quote
  #17 (permalink)  
Old December 2nd, 2010, 04:43 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by lex8058 View Post
Spliting the DB just killed me. Tons of work for the last week gone.
Sorry to hear that. I have never had any problems splitting a database.

How is the work gone?

You did make a backup before you split the database?

This is also why I urge everyone to split their database from the start. I really do find it makes development easier

Quote:
Originally Posted by lex8058 View Post
I have forms and tables that have formulas connected to Queries that I can not get to now.
What do you mean by you can't get to them?

Note: You edit the design of tables in the back end.

Quote:
Originally Posted by lex8058 View Post
the code build auto fills formulas and runs your code to errors
What does this mean?
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote
  #18 (permalink)  
Old December 2nd, 2010, 04:54 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default The templates I used

The template I used for tables and forms have feilds that pull values back from queries after I split the DB half of the tables lost the links and now there is no way to ling the query back to the field table because they are not in the same part of the DB. Yoes I have it backed up.

I am currently going throught it now checking spelling and titles correcting beginer mistakes like having spaces in titles. And so forth.

I friend told me yesterday to keep the information path simple so that you are not fighting grammer looking for code errors.
Reply With Quote
  #19 (permalink)  
Old December 2nd, 2010, 05:16 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by lex8058 View Post
The template I used for tables and forms have feilds that pull values back from queries after I split the DB half of the tables lost the links and now there is no way to ling the query back to the field table because they are not in the same part of the DB. Yoes I have it backed up.
Did you use the database splitter wizard?

After you split the database did you move the back end database to a new location?

If you moved the back end then you will have to relink the tables to the new location. To do this click the the External Data tab. Use the Link Table Manager to relink the tables.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote
  #20 (permalink)  
Old December 2nd, 2010, 05:26 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ill keep that in mind

Well I think that confurms what hasppened. When I split the DB I did not realize the copy I had been working on all this tme was not linked to the master on our server. ( thought I had created a short cut not copied the entire db) when I split it I saved the back end to the server thinking it was already there.

But now its going alot quiker and I have a chance now to fix all the little stuff that a newbe does :) that I did.
Like using password and company name as primary keys so that you can have them linked n forms rather write the code

Still havent figured out how to control the users data entry issues thought.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
user permission in access 2010?? DivX Access 14 December 10th, 2012 07:23 AM
Using Access 2010 and Access Services with SP 2010 kmaford BOOK: Professional SharePoint 2010 Development 0 September 14th, 2010 04:25 PM
Permissions on DB without user-level security nbourre Access VBA 4 June 7th, 2008 08:09 AM
Chapter 6 Blog - Cannot Login Access DB bmoran007 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 4 November 26th, 2007 10:53 AM
session login with access db surethg Beginning PHP 3 November 19th, 2004 04:34 PM



All times are GMT -4. The time now is 10:36 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.