Search results

Sometimes it happens to me too. I think it's cos sometimes if you build an event in code without clicking on the ellipsis for that event in it's properties the code isn't recognised. Sometimes i've checked the properties and the event doesn't appear for some reason

I've made a form for adding new students and their information. The problem is some columns in my students table are ID fields (eg courseID). I want the user to be able to select the name of the course (in tblcourse) from a combo box on the form, rather than having to know the courseID. I built...

Ok, when I click the cmd now, I get a message saying invalid use of property for the rstStudentMod variable. If Pat or anyone else can help I would be grateful. I've put **'s to indicate where the error occurs. Private Sub cmdAdd_click() Dim rstStudentMod As Recordset Dim db As...

It's still giving me the same error about the parameters. I think i've obviously gotta change some of the code further down based on what you've just told me. Call me a retard but I've only just started trying stuff with recordsets and haven't used code that much, so guess i need to go back to...

Thanks for that. I've got a problem now with using the .Parameters collection. I get an error saying: Method or data member not found. The same think has been occurring when i try and use the LastModified code. Would this have anything to do with my references? I've got the DAO 3.6 Library...

When I press the command button on my form i get the following error: too few parameters, expected two. But both the combo boxes for module and student are filled (I assume they are the parameters), so i can't understand why this happens. Any ideas anybody? I've included the code below If i...

Thanx that worked but now it gets further down the code and says: "Method or data member not found" This occurs for the LastModified property. Maybe its because I haven't added any new records yet, but when I try to it still says the same. Do you know anything about this?

If I select the command button i get an error in the code on line 2 (db As Database). Why is this? I based this on a similar example in a book, so thought it would be ok, it's probably simple. Can anyone help? Private Sub cmdAdd_click() Dim db As Database Dim rstCourseModYr As...

I'm trying to build a form which allows the user to select a year and module from two combo boxes for a particular course probably chosen from a dialog box. The form will have 2 cmd buttons- one is add to list, the other is delete from list. When a module and year is selected the module will be...

Mastering Microsoft Access 2000 Development by Alison Balter is a good book to get. It'll teach you what you need to code and examples are quite good. Costs $50 Rich

It's greyed out allright. I think it's because i've got an expression in one of my columns which calls the array. Does this mean i have to call the array from the form or can I get rid of this un-updateable some other way? Rich

I've built a form based on a query. I want to enter information into the form but when i try i get a beep and recordset not updateable. I checked the properties and everything seems to be okay. I reckon it might be to do with the table the query is based on or something. Any ideas, please??

No worries, i've sorted it using the NZ function! Thanx

How do i open the recordset will this code check if staffID exists? or is it totally wrong? I've got really used recordsets yet i'm trying to read about them now! I've not heard of dlookup either! Sub findStaffID(lngValue As Long) Dim rst As ADODB.Recordset Dim strSQL As String...

Cheers, it wasn't working simply because some of the columns have null values in them. How can i get around this apart from telling the person entering info in the form to type zero's in null fields?

Thanks. I'm trying to call the function into my query now. I have put this expression in the field compartment Expr1: GetSumHighest([q1],[q2],[q3],[q4][q5],[q6]) i changed some variables to meet the field names, and the new code is: Public Function GetSumHighest(q1 As Integer, q2 As Integer...

Well that helped, now the name box has to be filled. But the new code, below allows me to enter any old garbage and will still open the form. I need it to only allow corresponding values from columns firstname and StaffID in a table called tblStaff. Any more help anyone?? Thanx Private Sub...

Maybe you are having problems because the values are null, do you wamt to change them to zero? You can build a query based on the table that converts nulls to zero eg TotalCost: NZ([Parts]) +NZ([Time]) NZ determines whether the field has a null value and converts it to zero.

I've built a form where for instance a member of staff enters their name and ID to logon. The problem is i built the form using help from wizard to open the next form. I wanted to link criteria for ID and Name. I linked the open operation by ID and tried to add the code to check if the name...

I have built a query including [Q1],[Q2] ....[Q6]. Each of these columns represents a question on an exam paper. I want to add the 4 highest question scores for each tuple together ignoring the 2 lowest. The sum will go into a total column. I need to build an array in a module that gets rid of...