Search results

Hi Drew, I changed it but it still says the same thing. I also tried switching qryPickOption with the table name which i figured should work okay too, then I got a type mismatch. UBNumber is a number field and StudentIDF is autonumber so don't see why a problem occurred. I assumed the second...

I need to parameters in the below code the one is passed ok, but i'm trying to give the first parameter StudentIDF using an SQL statement. I assigned the SQL statement to variable StrSQL, but it's not being recognised as a parameter it seems like it's taking it as a string, but if I remove the...

Which event is the code in? Also you could do what Rich suggested to me in the previous post. Select the control in design view. Select format on the toolbar. select coditional formatting Follow the rest of the instructions. This way is easier anyway. HTH Rich

Thanks for advice, got it working now. Rich

In my subform i've got a column for marks. If a student gets a mark >=50 I want the mark to appear in green, but if below then red, indicating fail. I wrote the code below but it seems to just check the first mark in the subform, so if the first mark was 24 it will change all values in that...

How do you code the after update event of an option group? I've got three options in my group and would like to do something like below: if myOptionButton1 is selected then me.mycontrol.visible = false elseif myOptionButton2 is selected then etc....

I'm making a form where a student can pick from a choice of modules. A student enters their card number and surname and they are then allowed to choose options from a cbo. The problem is I want to add their choice of options by adding the moduleIDF and StudentIDF to another table. The StudentIDF...

That worked fine, thanks for the help everybody. Rich

I've got a form where I can setup new students. Everytime a new student is created the operator has to press a cmdbutton which will append the student to their modules for that year. The problem is the button doesn't work, because the new student is not put in the tblStudent by Access until a...

Does anyone know if there is a quicker way of doing the below rather than declaring all the visibilities one by one. I thought about the with ... end but as there are more than 1 controls in the below I'm not convinced it can be done. Any Ideas folks? Sub ShowCtl()...

Doug and Jatfill, Thanks for your help, it seems to work fine now.

Also check the threads i started called Invalid use of Property and also 2 few parameters. One is in the Module and one in the general forum within the last 20 days. HTH Rich

I had this problem about 1-2 weeks ago and didn't know what it was all about. I got help from Pat which was the following: When parameter queries are run from VBA, you need to supply the parameters. I would change the parameter names in the query so that instead of being...

I'm trying to use the Dcount method to check records in a tblStaffModules for a particular modulecode. If the DCount is zero I want the code to run otherwise I will get it to show a msg. The code assigns a member of staff to the module they selected in the cbo. It worked fine before i put the...

The code below runs a delete query which works fine, but sometimes a user might press the command button and the delete query has no records. What i'm really saying is how can I give the user a error/help message if they press the button and there are no records to delete. I turned off the...

Thanks Drew, it worked a treat. Rich

So, it's the same as concatenating a name for instance in a query. What if I want to put the value of a cbo box in the msg? I tried doing it like this: msgbox "Module " & Me.cboStaff & " is not on " & Me.cboModule but then of course I get the unique ID code (which is meaningless to the...

The help does tell you about it, but I guess sometimes it can be hard to find what you are looking for. The max number of fields in a recordset of a query is 255, with a max of 32 tables. Goto Microsoft Access Specifications in the help, you can see qry specifications from there. HTH Rich

I'm sure this is possible, how can I get an error msg to display values of specific fields. eg I would like to tell the user the name of a module and course that wasn't added "this [modulename] is NOT on [coursename]" as opposed to "this module is not on the course you selected" anyone know...

Cheers ive got it now, stupid mistake got the control source wrong!