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...

Cheers Mate works fine.

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...

Thanks for the reply. This code doesn't show any results: strSQL = strSQL + "WHERE (((tblQ.[Q No]) <> ([tblAQ].[Q No])) I don't realy understand how the sub query would function.

Thanks for the reply. But i don't see how that can help solve my problem.

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...

Cheers, I will give that a go. If there are any examples you could point me towards that would be greatly appreciated.

isBlank is just an old function i made in a module, just ignore that. The cmdSave works fine it edits the correct data. The cmdSave2 doesn't edit anything. I used the same coding to add multiple records and that works. But i know edits are slightly different and need i just need some sort of...

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...

Thanks for the reply. I get an error message saying 'Reserved Error'. I have never come accross this before?

The 2nd is correct but it comes up with the 'Type Mismatch' Error. When i place my cursor over the code it is showing the correct ID and Q No but just the mismatch error comes up. Dont know why though?

Thanks for the reply. ID is a string.

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 & """")

I am using access 2007, how do I get to the continuous form function. Thanks

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...

If you still are having the original problem in yout first post. Try This: Private Sub ButtonNameClick() DoCmd.Close acForm, "FormName" DoCmd.OpenForm "FormName" End Sub

From what i can tell i think you might need a DSum not DCount.

Open a new form: Private Sub ButtonName_Click() DoCmd.OpenForm "FormName" End Sub

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...

Cheers Mate, works perfectly.