Search results

Hi, I have deleted 2 columns in a table and now everytime I open the table the 'enter parameter value' window keeps popping up. Also pops up when i open a form. I have removed the 2 fields from the code totally so there is no reference to it. The forms are fully functional too. Don't...

Hi, I am trying to do a grading system for total marks students may get in an Exam. A want to show this in a report and i have a Label that should show the Grade accrdint to their Score. This is the code i have so far but i get the runtime error 438, Object doesn't support this porperty or...

Hi, I am trying to do a 'Not In' query in access 2007 but the one below doesn't seem to work. It says that an operator is missing when i use the query builder. When i put it in the code as shown below it does not show anything. If i change the Not to In it shows the correct IN data. Any Ideas...

Hi, Basically i have an unbound form which is populated using recordsets. When I i want to edit i use the first save button which works fine on its own. But i would like to make multiple edits. In the combo box i have StudentID, Name. All i need 2 edit is the Score for a student. I Hope this is...

Hi, Can someone help me format that this Dlookup so it works. I jus cant get the formatting right. Thanks. txtScore.Value = DLookup("[Score]", "tblAQ", "ID = '" & Forms![frmQ]!cboP.Column(0) & "'" And "[Q No] = """ & Forms![frmQ]!txtQ & """")

Hi, I have a table that stores the following fields. Q No, Question, Category, Student and Score. I would like format like a table with Q No and Question on the left and Category and Student at the top. With the scores for the relevant fields. I have attached an example of what I need to be...

Adding Multiple Records to Table using Recordset Hi, Basically i have a an unbounf form where data is entered and added to a single table using teh add recordset function. I have it working at the moment where it can add 1 set of data. I would like to add multiple records. i get this error...

Hi, Basically i have a form where a user selects a student and their score appears in a textbox. I want to show a Green box(created in access) if the score textbox is >=400, Amber box if <=300 and Red box if <=200? Thanks. i used this but doesn't work. Code: If (txtTot.Value) >= 400 Then...

Hi, Is it possible to code a next and previous button to go to the next/previous record based on the records in a listbox? Thanks.

Hi, I have the following code below bet it comes up with a '424' error object required. I cant see what is wrong with the code. I have declared and set the recordset aswel. Any Ideas? Code: If rstP("V") Is Not Null Then txtV.Value = DLookup("V", "tblP", "ID =""" & Forms![frmP]!cboP &...

Hi, i have a form where a user enters their details and when they click save a msgbox appears with a yes or no(vbOKCancel). Is it possible to save without the msgbox but have confirmation message as a label or msgbox that does not require clicking?

Hi, I would like to export the values from a listbox and textbox to appear in excel, is this possible? If so i would appreciate some coded examples please. Thanks.

Hi, How would i go about creating multi user access to a database file? So 2 users can access it at the same time. I have a shared hard drive where both users could access it. I don't want a login form, just to be able to update data and see the changes on both machines in real time. Thanks

Hi, I would like to change a textbox into a combobox when checking a checkbox? Thanks

Hi, Basically i have a set of records for student data and i use a NExt command button to show the next student using this: rstStudent.MoveNext. Which is fine but is it possible to MoveNExt by a Certain field(E.g. Age) as it always goes to the next student using the Primary Key Field? Thanks.

Hi, Basically i have a form withtextboxes that show numbers with 2 decimal places, they have been set to General NUmber and Decimal Places:2. But when i add them to the tables using the Add Recordset function they appear as Whole Numbers? I've tried various formatting styles for the fields in...

Hi, I have a query where a student gives scores for certain statments and the query does a sum of those scores. Is it possible to give the student a ranking in the query based on the scores they got? Thanks

Hi, How would i calculate the average of the values in 3 textboxes to be displayd in a 'Average' textbox? Thanks

Hi, Is it possible to select multiple rows in a listbox and export them to excel on dblclick or using another function. I know how to enable multi-select but don't know how i would code the exporting. Thanks

Hi, Basically i have a Scoring form where a user enters a score but there is a maximum possible score textbox. How could i code the score textbox to only accept values that are less than the maximum score textbox? Thanks