Real Estate template Project

[Dreamweaver]

What I've decide to to with this project is take you though as many of the development steps as I can.

I'm using my site as I can do what I like on there so don't whine about it I'm doing it to help members "You know who you are"

I will update this post when I add more info this will be on a daily basis I will try and be as detailed as posible giving you the reasons why I did x or y and even my mistakes

For this first post I have added 3 posts this starts for the very beginning of the project ERD, Business rules,Project Creation, I wont add a list of tables or queries as the first come from the ERD and the second I haven't got a clue I will create Queries for all objects even lookup lists I don't use SQL Statements except in code.

I'm far from perfect but when commenting on a mistake first think of the project scope this is "To recreate the MS Template of same name making if comply to my rules or good practice", when looking at the ERD i've added an image of the MS template you'll get an idear what I think of the MS templates.

Login

Login

databasedreams.createaforum.com

 

[AccessBlaster]

MickJav,

Are these two fields in some sort of relationship, or am I looking at this wrong. The amount of relationships in this project are mind boggling to me. Good luck with your project, it will be fun to watch the progression.

 

[Dreamweaver]

No It's just the way Draw.IO shows it
EmployeeID Relates to tblEmployees
TenancyID has been updated to LeaseID and relates to tblLeases
I'll see if I can colour code the links

thanks @AccessBlaster

 

[Dreamweaver]

Comleted the Concept, ERD and Tables Task

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

Day 2
thought of a few issues with my ERD while in spar of all places.
done a bit more yesterday plus works today

Login

Login

databasedreams.createaforum.com

Also updated the objects list

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

It was because of a post you made @Pat Hartman a while back that made me change my ways lol

I was just wonder which would be better in a forms record source If no criteria used

A table tblContractors a query?

 

[Dreamweaver]

I've updated the topic with what has been done today have also linked back here to a topic I created to help solve one of my issues.

You'll notice I found a couple of errors in my ERD that I had to fix, I haven't updated the ERD but should anybody want me to just let me know.

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

Got a lot done but if you noticed one of my post I have one of them days where you want to bash yourself on the head lol

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

I don't really get involved with SQL Server Although I have it installed and will get around to it lol.
I did hear once it would be better to use UBound forms where pos with servers limiting the data to one record I.E. the Requested Record or a new record with a dbOpenDynaset, dbAppendOnly

what I ment with the criteria post was I used to use "Select field1, field2, Etc FROM Table and any WHERE Statments needed" in the record source but not I just use a Query .

mick

 

[Dreamweaver]

Another day done and got further along

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

Decided to make a few more changes to the ERD hopefully for the better, moving along with the project nicely

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

Thanks @Pat Hartman

 

[Dreamweaver]

I'm linking it all together now, Still have the payments and the schedule to do but it's coming along nicely.
Made a few more changes One of these days I'll get a ERD done that I don't need to edit LOL

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

Getting to the end of the forms design section now but still got a seach & print screen on the list, Will be adding the schedule creator tomorrow for the monthly lease amount.
I've decided to only run it on the main control when admin logs in otherwise if the systems on a network I would run for every employee who loged in, even though it will only check a date in preferences for when it was last run but I don't see it as a good use of resourses.

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

Done more work today and started data testing which has shown a few errors that I needed to sort.

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

Just about done with the forms now, todays been more about cleaning up and testing with a few updates where needed.

Login

Login

databasedreams.createaforum.com

Also added the code for the schedule s if somebody see's an error they might let me know.

 

[Dreamweaver]

well pleased, Just created a help system linked to my site with a shortcut menu.
I have to create a topic for each Section I want to provide help, but users could add to the topic even asking questions.
Will mean more work for me on my site but now users of my templates/example will be able to get focused help.

Login

Login

databasedreams.createaforum.com

Login

Login

databasedreams.createaforum.com

Now I've got to help the mrs clean the house that must be my punishment

 

[Dreamweaver]

Finally got the forms completed and don't think I can make improvments without risking going backwards.

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

got further along now:
Have uploaded a pdf of the Lease Aggeement plus been updating the help topics, These were not added to the project as I decided to add them all after I got the shortcut menus working.
I still think I can keep it within the 97.50 hrs but think it will be a close run thing.

Login

Login

databasedreams.createaforum.com

 

[Dreamweaver]

started one of the main help topics.
you should note where I think you may need to edit the code i have added the name of the function you may need to replace/alter plus where there are limitations I have listed them like the limit of the file types for attaching images.

Login

Login

databasedreams.createaforum.com

This has not been proof read.