Re: REPORT not displaying

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Aug 16, 12:37 am, "ghostman via AccessMonster.com" <u51724@uwe>
wrote:
I having problem with my report. I have pop up form with a combo box where
you can select the languages. (English, Arabic, Hindi, etc..) based on my
Instructor table and a command button to trigger the report. The problem is
there is no report displayed after selecting the language and clicking on the
command button while if you do it in the query itself, it works fine. (a
parameter value pops up and i type the language). it also works without using
the pop up form, but i want it to be complicated lol!

i don't know what i am missing...

here are some data:

Row source of my combo box [SelectLanguage]:

SELECT [Instructors].[InstructorID], [Instructors].[Language] FROM
Instructors ORDER BY [Language];

Command Button [cmdPreview] onClick Event procedure:

Private Sub cmdPreview_Click()
Me.Visible = False
End Sub

and here's the SQL of the query based on the Instructor table:

SELECT Instructors.InstructorID, Instructors.FirstName, Instructors.
MiddleName, Instructors.LastName, Instructors.Initials, Instructors.
JobPosition, Instructors.Language, Instructors.TimeOfAvailabilityF,
Instructors.TimeOfAvailabilityT, Instructors.VacationScheduleF
FROM Instructors
WHERE (((Instructors.Language)=[forms]![ParamForm]![SelectLanguage]));

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200908/1

Really simple. The value getting passed is the value in the first
column of the combobox, which is InstructorID, and not Language, which
is what I think you intend. If you want to capture the value in the
next column, you need to use:

WHERE (((Instructors.Language)=[forms]![ParamForm]!
[SelectLanguage].Column(1)));

.

Relevant Pages

  • Re: Best Asp.net Resources for Newbie
    ... Therefore as a classroom instructor myself and a perpetual student I recommend textbooks to neophytes as one needs to learn a programming language before using the language with the framework to create applications. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: [C] One last small problem with that code
    ... >> else the instructor does not know. ... C language that's likely to be taught in schools). ... computer user you'll meet will tell you that clearing the user's screen ...
    (alt.comp.lang.learn.c-cpp)
  • Re: student question/ array
    ... > Jim, maybe I didn't make myself clear. ... if you ask your questions to your instructor. ... One part of programming is learning the language that you ... It will be your design, and the small change made will help ...
    (microsoft.public.vb.general.discussion)
  • REPORT not displaying
    ... Instructor table and a command button to trigger the report. ... parameter value pops up and i type the language). ...
    (microsoft.public.access.reports)
  • teaching foreign language to K-2?
    ... I volunteered to the PTA to assist with a foreign language club they're running after school for six weeks at my son's elementary. ... This is only the second year of the program, so there's not a lot of precedent to fall back on, and I don't get the impression my instructor has actually taught anything before. ... I have studied the language we're teaching, and although I don't consider my self fluent, I feel competent enough to teach a K-2 group for one hour. ... I'll be having a meeting later this week with instructor, and while I plan to defer to her lesson plan overall, I would like to have some ideas to bring to the discussion, especially as I will be doing one class on my own. ...
    (misc.kids)