Search results for query: *

Hi Duane, How do I search the database for this? Do i go one by one to each form?

Here's the entire code under FORM1 that I created under the Northwind Database:

I get the following error: The expression On Click you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives. I'm using still the Northwind database. The name of my list is lstCategory taken from the...

Duane, I can't seem to get the clearlists and selectall function to work. Where do I call the function code to?

Here's another question: I got the "multi-select list box to filter a report" to work. Thank you very much for the reference... How can I put a note to show that if they selected an item which is not on the report to show "The item you selected does not have a report" For example: They...

I got the following error when I try to do the Clear All and Select All function: The expression On Click you entered as the event property setting produced the following error: Ambiguous name detected:SelectAll. Here's the step I took: Created a form via Northwind database Created a lists...

So what I'm envisioning is: on the left of the form (query displaying the lists of states) on the bottom will be a button [ALL] which would automatically highlights all the states and a button [NONE] which would deselect the highlighted states. on the right of the form will be a report button...

Hello, I would like to create a form where the user would select a category and based on the selection, will click on the report button and report with the category selected would open. I have several reports that I would like to display based on the filter that the user selects on the main...

Ah.. Thank you.. Is there a way to display tblEmployee, tblEducation, tblEmployer all in one query? I tried doing a query through query wizard and I don't think the result is correct. for the database I have posted above, each employee is getting 8 records even after I do a "group by"..

What does this code do?

Hi MajP, Do you have an example of a report with a subreport? Should I be doing a union query?

how do you create a report out of the form? I think I'm able to display what's needed in the form/subform... I'm having trouble creating a query and report to display the following: Joe Smith College: Univ. of Florida Degree: Undergrad Type: BS Accounting College Univ of Miami Degree: Grad...

Here's a copy of my database....minus the sensitive informations.. I'm interested on how to make the tab go back to the Company Info tab when you switched to a different name (record).. http://www.mediafire.com/?1msimwbzzyh

To make the form display like this? Should I be doing the following on the subform: CollegeName: CollegeType: DegreeObtained: CollegeName Data CollegeType Data DegreeObtained Data CollegeName Data CollegeType Data DegreeObtained Data CollegeName Data CollegeType Data...

Let me try another link...http://www.mediafire.com/imageview.php?quickkey=bfwnx1d0mzt&thumb=4

Is there a way to display more than 1 College in the form I've attached? I'm not sure i know how to go about it.. Thank you!http://docs.google.com/Doc?docid=ddjb3m2j_07x8c3nc7&hl=en

Do I need to set up strEducationID and set that as the primary Key?

hmm I do have lookup field in my tblEEINFO under the field Degree Display Control - Combo Box Row Source - table/query Row Source - SELECT tblDegrees.DegreeID, tblDegrees.Degree FROM tblDegrees;

I tried using another table design: tblCertific CertID = auto EEID = Number (link to tblEmployee) Certification = text tblDegree DegreeID = auto EEID = Number (link to tblEmployee) Degree = text tblSchool SchoolID = auto EEID = Number (link to tblEmployee) SchoolName = text...

Cool .. it works now.. Thanks! Another question, when I try to open tblEmployee, I get the following pop up dialog: Insert Subdatasheet Tables tab, Queries Tab, Both What is this? I use to be able to click on the [+] sign next to the employee and I could see another datasheet under the...