Recent content by Gruung

What is the code to reset a default value to null? thanks

thanks works

Hi, this is just a quick question, i have a command button and i want to run a delete query then an update query, whats the code that i need to input to execute a query? Also how do you make a message box appear that asks you if you are sure that you want to run this query? thanks

Right i have most of this working, it links to the database but one quick question, why do you refer to B8 or B9 or B10 or B11 in the students bit of the spreadsheet, i dont understand that bit. thanks gruung

I am only using it in a dcount expression, while messing around more i have found that if you load it via the switchboard it works fine, but if you load it on hte main reports page it gives the error which is strange.

i have got a report which is based on a query, when you run the query it asks you to input the class value whihc is 12 or 13. If you jsut run the query it works fine, no problems at all. If you run the report and you enter 12 it says that the value is not valid. What I dont get is that when you...

so what link my database to excel, how do you do that? Seems like an ok example, still got to understand it fully though...but my slow mind will get there lol.

Right I have no idea how to go about doing this so I am open to any suggestions. At my school the timetable is split up into blocks, there are 5 blocks, block A, B, C ,D ,E. You can do one subject per block. Currently I have a table: StudentID BlockID SubjectID So the user will fill in what...

thanks got it working

I have searched this forum but i cant seem to find the awnser. I am sure it is something really simple. I have used the combo box wizard to 'find a record on my form based on the value i selected in my combo box'. It searches by last name and first name. My form is based on a query so when you...

I have a combo box, that displays the tutor name e.g 13BI, but saves the data as tutorid. On my form if year 12 is selected i only want the combo box to show all the tutor names starting with 12, and if 13 is selected i only want the combo box to show all the tutor names with 13 at the start...

when i am finished editing a record and reverting back to non-edit mode

I know this topic has been raised a million times, but i cant seem to find the awnser. On my form I have a button to edit the records. Before I press it anything typed on the keyboard will not change anything no data will be added, and when I press it you can edit your record. It also makes a...

I meant more like this type of tab

tab control I want to change the color of my tab control, i have made the background transparent but i dont want the top part grey. Is there a way to do this? thanks