help with complicated formula

[snb]

Yes I noticed a remarkable learing curve in post #33 and #34

[SamT]

Paul, I am not going to list all the errors in the latest upload.


I see that you have a serious objection to using long and fully descriptive form control names.

At first glance, the forms seem to be a good start.

You have named this workbook as TDR DB Design Version 1.01, which means that it is the finalized database and only the finalized DB, but doesn't contain any DBs. It only has some user forms and a bunch of sheets with grey tabs, (I can't tell what the grey tabbed sheets are supposed to be, are they Reports [yellow tabs] or what?) It also has some green tabs that appear to be VBA List prototypes. The actual VBA_Lists sheet (Red tab) is incomplete.

[crasherpaul]

ah sorry SamT i see what i did, i did not transfer the userforms over to the last sheet you sent over to me. ill get on to it right away.

[SamT]

Paul, You aren't doing this for me. I am trying to help you learn, You must think about what you are doing. What I say is merely a guide for you.

[crasherpaul]

sorry for the delay in getting back to you only i lost my internet. the tabs that i forget to colour where meant to be yellow. have you by any chance managed to do any coding yet please. also i have had my arse chewed off because of this taking so long as well.

[SamT]

Have you got the Report sheets and Databases done?

[crasherpaul]

he is the link to the file

https://www.dropbox.com/s/oec650kzov...sign.v1.01.xls

[SamT]

There aren't any databases in that book.

[crasherpaul]

this really is getting complicated. i thought that i did everything that you wanted me to do.

[Aussiebear]

CrasherPaul, mate you owe Sam a great deal here, as this clearly is well outside the concept of a single issue thread.

[SamT]

i thought that i did everything that you wanted me to do.

I... Don't want you to do anything. I am only trying to guide you in doing what you want to do.



Refer to: Workbooks("TDR Reports Design v.03.xls").Sheets("Paul, Read Me")

[crasherpaul]

as far as im aware i have done everything that was needed, im just not sure what colour the first lot of tabs are meant to be. (holidiays - nights out) other than that i think it should be ready for coding

[SamT]

DataBase Sheets never get database names at the top of the sheet. The database name is the Tab name.

Database tables always start in cell "A1". Row 1 is always the DB Field names.
Except as noted below, Row 1 is the only cells that should be formatted. The entire row should be number formatted as Text. The entire Row's font should be set to a named Font and in Bold and 1 or 2 sizes larger than standard. The entire Row 1 Bottom border should be heavy and solid. Individual fields can be seperated with borders of any size and style. The entire Row should be Horizontal and Verticle aligned = Center. Excel works better with its Databases this way.

Database Fields (Columns) should be Number formatted only as indicated below:
Numbers that must be treated as text:

• Text
• Money
• Dates
• Times
• Percentages
• Fractions

[crasherpaul]

this seems to be getting really complicated

[crasherpaul]

Hey SamT are you able to start coding yet please?

[SamT]

Hey SamT are you able to start coding yet

On what?

[Aussiebear]

this seems to be getting really complicated

Absolutey, which is why I suggested you owe Sam big time.

[crasherpaul]

Absolutey, which is why I suggested you owe Sam big time.

Again I know!!!!!!!!! can i ask you to PLEASE stop interfering there is no need for it, with respect. thank you

[crasherpaul]

On what?

ive spent so much time on this, and ive done everything that you asked and now you are saying that there are no databases. and you laugh at me with "". have i disrespected you? No! this has been dragging on for far to long.

this is a bit like fly fishing, you have everything that i need and you tease the fish with the fly.

It's annoying how other people come on here acting as if i don't understand how much you have put into this and quote "you owe Sam big time". i know what you have put into this but its funny how people miss just how much time i have put into this as well.....convenient isn't it.

[SamT]

Paul,

I think that your project needs more than I can offer. I have a lot going on i my life right now.

Perhaps one of these links can get you to where you want to be.

http://www.amazon.com/Excel-Programm...371/ref=sr_1_1


http://www.getacoder.com/projects/pr...g_c_87390.html

I wish you the best of luck and truly hope that you get the program to work the way you want.

Regretfully yours,
SamT