Yes I noticed a remarkable learing curve in post #33 and #34
Yes I noticed a remarkable learing curve in post #33 and #34
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.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
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.
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.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
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.
Have you got the Report sheets and Databases done?
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
he is the link to the file
https://www.dropbox.com/s/oec650kzov...sign.v1.01.xls
There aren't any databases in that book.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
this really is getting complicated. i thought that i did everything that you wanted me to do.
CrasherPaul, mate you owe Sam a great deal here, as this clearly is well outside the concept of a single issue thread.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
I... Don't want you to do anything. I am only trying to guide you in doing what you want to do.i thought that i did everything that you wanted me to do.
Refer to: Workbooks("TDR Reports Design v.03.xls").Sheets("Paul, Read Me")
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
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
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
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
this seems to be getting really complicated
Hey SamT are you able to start coding yet please?
Hey SamT are you able to start coding yet
On what?
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.
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
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ