How to structure an access database

[kurai hikari]

you just hit the right point

hay iam so sorry i was late in replying . i had no time at all to sit on my pc becouse of my karate training for the exam so sorry.

you just talked about value. i want to tell you this
i used that code in combobox1 code sub

DoCmd.OpenReport "Mj", acViewPreview, , "[managers]=" & Me![combobox1], acWindowNormal

and it worked but before the report opens amessage box appear asking me to enter aknown value i don't know what does that mean what value does the access programme mean?? so i don't enter any thing and just press ok the report appears but with out data , so what do you think about that?
and i don't think i renamed the reports to match the section value becouse i don't know about value. tell me about it . XD

[NeoPa]

hay iam so sorry i was late in replying . i had no time at all to sit on my pc becouse of my karate training for the exam so sorry.

That's no problem Kurai. Tell me, what result did you get in your grading. I'm currently 3rd kiu but I'm afraid I stopped training last year, to go back to playing football. My son and daughter are both 1st kius but have both also stopped training now.

you just talked about value. i want to tell you this
i used that code in combobox1 code sub

DoCmd.OpenReport "Mj", acViewPreview, , "[managers]=" & Me![combobox1], acWindowNormal

and it worked but before the report opens a message box appear asking me to enter a known value i don't know what does that mean what value does the access programme mean??

My example showed how to call the function with parameter names. This is not important when using the function in your code, but it is helpful when talking about it or trying to explain things to someone.
ReportName ("Mj") should be the name of your report.
View (acViewPreview) indicates how to view the report once opened.
WhereCondition ("[managers]=" & Me![combobox1]) indicates which records of the RecordSource should be included in the results.
WindowMode (acWindowNormal ) indicates the Window Mode to use.

I suspect your missing data prompt was due to the WhereCondition parameter, as I see no [Managers] field in your table. I cannot suggest how this should be done as the names of your fields and much else about your database is in unicode and I don't have the relevant page installed. I don't even know what your objects are really called. I will tell you that where you have [managers], you need to replace this with the field in your RecordSource (I think this is probably the query called Managers) that identifies which record is to be shown. Likewise, I see nothing in your database that would match [combobox1], but that needs to match the type of whatever field you need to use. See these (Quotes (') and Double-Quotes (") - Where and When to use them and Literal DateTimes and Their Delimiters (#)) for how to specify literals in your string).

so what do you think about that?
and i don't think i renamed the reports to match the section value becouse i don't know about value. tell me about it . XD

When I looked at your attached database I saw only three reports, and they were named "governors" , "managers" & "ministries ". No "Gj", "Mj" or anything else there at all. I naturally assumed you had changed them as your first post refers to reports called "Mj", "Gj", "Pj" & "Ej".

[kurai hikari]

it worked

it worked , i don't believe it it really worked finally when i press on the selection in opens the related report omg iam so happy , thank u thank u. hahahaha u r the best . u were right about the where condition , i didn't think itis the recordsource i thought itis the selection that i select to open the report. u r my hero . yes yes yes . yattaaaaaaa, yahooooo i made it no actually u made it thank u sooooo much so much. iam sorry i modified again. i forget so much damn. iam gonna take course in access script i just needed that quick solution for my job u know. besides iam graphic designer more than aprogrammer.tha nk u sooo much for being with me all the way. u still didn't get rid of me though hahahaha XD

by the way , iam a brown belt in karate iam gonna have to stay ayear before taking the black belt. good for ur kids but karate or any martial arts r neccessary this days lol. i adore martial arts

thanks a gain i wish u the best

[NeoPa]

it worked , i don't believe it it really worked finally when i press on the selection in opens the related report omg iam so happy , thank u thank u. hahahaha u r the best . u were right about the where condition , i didn't think itis the recordsource i thought itis the selection that i select to open the report. u r my hero . yes yes yes . yattaaaaaaa, yahooooo i made it no actually u made it thank u sooooo much so much. iam sorry i modified again. i forget so much damn. iam gonna take course in access script i just needed that quick solution for my job u know. besides iam graphic designer more than aprogrammer.tha nk u sooo much for being with me all the way. u still didn't get rid of me though hahahaha XD

You stuck through it too Kurai and I'm sure it was no easier for you than it was for me. I think we can both be happy at a successful conclusion :)

by the way , iam a brown belt in karate iam gonna have to stay ayear before taking the black belt. good for ur kids but karate or any martial arts r neccessary this days lol. i adore martial arts

Excellent! We too are all Brown Belts. 3rd kiu is the lowest level of Brown Belt, and 1st kiu is the highest - Just below Black. I take it that you are 1st kiu yes? Like my children, but two gradings above my own level. Good for you. That's not easy to get to, but is much easier than the Black nevertheless. That's never easy, but I wish you success in achieving it :)

[kurai hikari]

yeah

no here itis not 3 kius itis only 2 grades of brown belt then black yeh it wsan't easy my sensei( captain) is so cruel =( i think u learned another karate school style i learn shotokan style XD. and yes i got the first grade wich means i practice now for the black belt. don't stop training itis very usefull. =)

[NeoPa]

I believe our karate is also Shotokan, but the licenses are in the bedroom and I don't want to disturb anyone upstairs this late.

I have stopped karate training now, but I still intend to keep fit and flexible as much as possible.

Very good luck with your training for the Black-Belt. It is something you can forever be proud of when you get it.

[NeoPa]

A new thread (Access Security) has been split off from this one as it is a separate, unrelated question (although by the same OP).