Search results

This technique still gives me an error becuase a relationship exist between two of the tables used in my query. The error states that my student Id cannot be changed or deleted due to its relationship with another table. The relationship exist in order to prevent the user from placing a...

Yes I do want to use the student id as my choice and I do receive the error. When I removed the text box used for student Id and replaced it with a combo box I was not able to select any options. The information utilized in the student section of my form uses a query to obtains all the desired...

The upper portion of my main form contains student information such as student Id, name, address, etc. Within the main form is a subform which list the classes the student has taken and the grade they received. I would like to enter a Students ID into the ID field and have that students records...

I built a form used to display student grades. The main form displays student informatin such as address and a subform is used to display the student grades. The main fomr and subform are linked together using the student Id. How can I set up the main form so when I change the student Id it...

Is there anyway to tell when you are accessing a new record using the navagation key on a form. I have a field representing a counter on my form and I would like to automatically increment the counter for that group of records when the user goes to a new record. For example A class is...

The form is used to update a file that contains codes used to identify information on other files. The form is used to Enter/Update information on the student file. This file contains codes for the studens major and advisor. It is thse codes that are displayed on the form. I also want to...

I made the changes to my query but after changing the control source for the second control I still get #Name? as the value. the control source for the second control is as follows =[qryQueryName]![Field Name].

The form is based on a file, that contains the field that is displayed in the first control. I would like to used the value in this control to link to another file and find a discription for the code. For example the first text box contains a students major code. The second text box should...

I have two controls on a form One to display a code and another that will display the description or name associated with the code in the first control. Haow can I pass the value in the first control to a query that will produce the value that should be displayed in the second control.

I am attempting to write a module that will generate all the worling days between two dates. This list of dates should exclude weekends and holidays. The NetWorkDays and WorkDays functions available in Access could accomplish this but is there any similar functions in VBA, and how would they be...

Using your suggestion I was able to get the query to at least pass a syntax check but the correct data is still not being displayed on my form. Instead of using the recordset the form is displaying the entire file. The table that is used to create the record set is the record source for the form...

Worked well thank you

I am trying to create a recordset for a form using a query when the record set is opened. Using hte following code I keep getting an error about a parameter missing a value. If i remove the query and just put in the table name it seems to work ok but I only want to access specific records on the...

The field name does not show up on either the field list or the control source drop down list

I am working on a form that is bound to a table with a date field named Date. When I try to obtain the system date in the form open procedure the value that is assigned to my variable is the field date and not the system date. I have tried renaming the field on the table but that has not helped...

I have a form that is associated with a table in my database. I have added a field to the table and am not really sure how to add the field to my form, the new field does not show up in my field list. Is there a way other then recreating the form from scratch to add the field to the form.