Search results

OK so it is saying that in the "INDEXES" that it still says 790 ID. how do i fix the index?

There are no subforms, there are combo but they are working correctly and still opening the drop down list like they should. I went through the documentor for both the parent form and the child form and still can not find where it is.

When I changed the table from 790 ID to 7890ID it changed most of the form and query to match. I have changed it everywhere I can find that it did not and still getting the message. I am ready to just go back and use the old database with the space in the names as it was working, but read...

I changed both the name and the control source, which is why it is for frustrating.

I went though my database table and removed all spaces from the field names inside the tables. Now when I attempt to open a form the key field 790ID that used to have a space 790 ID shows in the Enter Parameter Value message that opens when choosing the button to open the child form. How do I...

Solution Found :D posting solution just in case someone else runs into to something similar. After further checking the combo box information is stored into a table named "Courses" So what I had to do was change from the "510" in the Course Taken table DepartmentID column to "2" which...

I am attempting to make a query to run a report. One of the fields I need information in my report comes from a combo box (column 2). :banghead: More information: The information is in a 5 part combo which fills to different fields on the form. I need to pull the information from the second...

I have also attempted to just set the control source in the Practicum G field to =[Course Taken]![Grade] which does result in an entry of #Name? in the grade field. so at least I am getting something but it is not inserting the "grade"

I was attempting to clean up my own mess and also offer more information I thought would be of help. I did link the two (or thought I was successful...sigh). When I make the query and set is as the record source it still did not fill the three fields but it also would not let me fill the...

OK the table for Course Taken contains the course info CourseTaken Student ID (which ties all tables) DeptID, CourseID, Professor, Term, Year, Grade, etc. all relevant info the Practicum table contains the info unique to a Practicum, such as proposal date, defense date, title, etc. In the...

I really appreciate all the help, I know that I am really new to Access (2010) and Queries especially are hard for me to understand. I am attempting to pull information from the course taken TABLE/FORM and fill the information to the exact same fields on the practicum TABLE/FORM. More...

More relevant information: The course form is a split form that contains courses available. if the course is a "capstone" you select the it hence Practicum = 3. the Practicum form opens off the course form via cmdbutton I want the Term,Year,Grade fields to fill from the information on...

Now the "Join" part comes into effect. How do you join so that it ONLY shows in the secondary form when when (for practicum) capstone = 3?

OK Got it working sort of. :o 1 Create Query in Design View and open table you want to pull the information from 2. Choose Append! in design view and select the table you want the information inserted in (this should be named the same as the form you want to view it in) 3. Below in the...

Way above my level of knowledge. 1. How do you create a query to join two tables ( tho I do know how to change the record source once it is made) 2. How do you bind them to controls on the form

I am attempting to pull information from one form (course taken) to another form (Paper) and fill the information from the course form to the exact same field on the paper form. Not sure which form / field to enter the code on. What I attempted was going to the course form on grade field...

Thanks, As soon as I removed the Input Mask the calendar's showed up.

I am using 2010. I am pulling the fields onto the form using "Add existing field"

John, I like the way that works and looks, but how do you GET them on the form to start with. When I add the date field to the form it does not put the calendar beside it automatically. (did manage to get it there once but not sure how and was never able to do it again)

The problems are: 1) everyone in the department has access to the server, no login required. 2) I have no control of the server to set login 3) I need full access to add, edit, delete but need to restrict everyone else to just the two forms.