Search results

Found it. :D http://support.microsoft.com/default.aspx?scid=kb;en-us;95931 Hmmm few more questions. On the article it says create a query form.... but in step 2 it says create the following new form that is not based on any table or query.... O_o I guess they meant create it in form? Right...

Link queries to reports dynamically so different queries will call up depending on the # that's entered? Queries: 12345678 Page 1 12345678 Page 2 23456789 page 1 23456789 page 2 Report 1 -> can be linked to either one depending on the # entered. Report 2 -> same as above. Right now my...

Link please.... :) Don't know how you can search post ID's.

Does anyone know how I could automatically create queries with different criterias when a button on the database (form) is clicked? I think you need to do some VB coding, but I'm clueless.... :o

Done and done. :) Thanx. :D

Got it down to 340 KB zipped. What's your email address? PM me if you don't want other ppl to see it. :) I think query will solve most of the problems I'm having (in other word, stuff I'm trying to do). :D

It's 44MB big. :p Though not the same this is kinda what I'm talking about: 'VIEW AU REPORT button. 'This function calls the function AU_query. Private Sub Label124_Click() On Error GoTo ErrorHandler If (IsNull(Me!Box2)) Then MsgBox ("Please first select a student by clicking on GET...

Yep I figured that out. :) For some reason it was displaying grade that's 100% so I had to do <> 100 :p What I meant by automatically... I can't afford creating quiery for each student. We're talking like 200+ students here and this number grows every year. Is it possible to have some sort...

Yep thanx. :D Couple more quick questions... Right now I have bunch student records and new ones will be added... what can I do so this quiery would get created automatically? Also, some of the grades are either P or F. So for the criteria do I do <=.5 and != 'P' ? Thanx. :D

Right now I want to create a new table on my database. This new table is used for the failed course report. To create this table the database needs to go into each student's record and look for grade that's lower than 50%. I'm not too good with coding, so how would I be able to do that...

Hi, Say I have a report that's 10 pages.... is it possible to display only a certain page (ie page 2 only) on the report view? If so how could I do this? Thanx.

Hmmm is it possible to use filter to filter out the pages and then display them separately? :confused:

It's ok to have blank spaces though. I can't really modify the way the report is arranged now. Basically I need to modify the database so everything shows up on 1 page... So there's no way I can tell each subreport to link to a certain page on the main report? :confused: Logically all the...

Help?

Oh a few more things to mention. The main report is not necessary 4 pages. Basically you type a student number and their record would show up. The number of pages is dependent on how many years the student has finished. So sometimes the main report can be as little as 1 page, or as many as 6...

Thanx for the helps so far. Really appreciate it :) Right now the main report is 4 pages or 5 pages (ie 4 years or 5 years). They're separated by a year header. How could I make this main report into 4/5 separte reports?

How do I do that? Please explain.

Hi, I'm working on editing an existing database where I need to change the current report layout. Basically, the database contains bunch records of students such as grades, and which courses they took. Right now I'm working on a report called "APR Report." The repot separates the student data...