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

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

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.

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

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

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.

That is great news!


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.

Curious, like what? can you givce me sopme examples?

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.

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

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

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

What do you mean by you can't get to them?

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

What does this mean?

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

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.

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

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.