Search results

sammy that seems like the simplest way of fixing the problem, but i've never used it before can you explain how I do it? So I put a letter in each of the Tag properties, then how do I loop it?

There are 33 subjects and each will only be visible when the subject is selected from the dropdown box, I cant have a tabform for it because there are too many Subjects and it is already on a tabform

I have the subjects set up in a table called tblSubjects, with the subject and and Autonumber field... not sure I understand how i to save this information in the table though?

Please can someone help me after keying in all the programming to get the buttons to become visible as I need them, it is now coming up with an error that the procedure is too large! Is there anyway at all of simplifying my code. basically on selection from the combo box three text boxes and a...

fixed it, was my own silly fault four hours wasted on an obvious probelem I was right with my origional code [Forms]![frmFulllStudentRecord]![StandardLetterID] would help if I had put it under the field name StandardLetterID instead of StandardLetterType! Sometimes its so obvious you miss it...

right, struggling here. Basically I have continuous form listing all the standard letters sent out when I double click on a letter, I need to to run a query for me. The code I have put behind the button is: If ([StandardLetterType] = "Homework") Then DoCmd.OpenQuery ("qryHomeworkClearMailMerge")...

Yay! Thanks everyone for all your help, the problem was that it needed to be 0.97 etc and not using the whole numbers! I should have got that one! Brain freeze

I havent got any blank records all of them have values. And it is a number field. Field size double, format percent.. Should I have put your code in the on current event property?

Its the name of the field in the underlying table, but yes it is also on the form

sorry did have my end ifs after I've tried doing it the way you suggested but as I've never used it before not sure if I am putting it in the right place? I have placed it in Current(). But nothing is coming up. I didnt quite undertand the (And lose the '%' char when naming objects!)? the...

Can anyone see what I've done wrong here? I cant get it to work and been over it a thousand times :( If ([Present%] >= 97) Then FrmWiseUpGold.Visible = True FrmWiseUpBronze.Visible = False FrmWiseUpRed.Visible = False FrmWiseUpPurple.Visible = False FrmWiseUpSilver.Visible = False Else If...

I just had to have a go before I went home and hey presto it works! I think its just getting used to a different way of designing so used to access forms expected the same and got something entirely different!

i learnt exactly the same way... hey notice you work for the council hmmm.... isnt there some policy of share information.. maybe I could insist upon your temporary transfer to birmingham! (Joke!) thanks for your help will look at that tonight

This isnt going to be easy at all just playing with the personal details screen and I cant even get a combo box to work on it! Any good books on how to do this? Preferably one written in English? I may be not bad at creating databases but doesnt mean I want to be bamboozled with Jargon!

Thought that might be a stupid question? ready for another... can I use Combo boxes to search students etc? I'm looking at the data access pages in Access are they updatable... for example if they will be able to log assessment data?

and is there no way just to open the database through a hyperlink on a website provided the website was secure?

how much would a webserver cost? I doubt this will be a something they will turn down anyway, because they have asked me to do it, can it not be linked through our own website?

Right, I knew this day would arrive and have somewhat been dreading it but excited by the idea of a new development at the same time. We have a database within the school on our server that staff would like to be able to access at home through the internet. They will need to be able to view...

foot in mouth my form might not have been uneditable but my tabform was uneditable and I was convinced I'd checked that! nevermind problem solved

right I have a subform which holds assessment data it is a tab-control form which monthly assessment data each tab has its own form i.e. "frmCurrentAssessment-October2005", "frmCurrentAssessment-November2005" and they are based on their own queries i.e. "qryCurrentAssessment-November2005". It...