Recent content by Bird_FAT

Cross Post update Also note that there was another solution posted here, on the cross post! Thanks to all for the help!

:DWho for - Einstien!:D MAN! I'd hate to have to work through something you call complicated, dude!:eek: I love the way you use the *.dll to work out the default program to open the file, very neat! I will work my way through the code involved, and this may take time as a lot of it is over...

The object is to open an excel workbook based on the path given - the path is made up of the students name and IS present as the student area is created before the entries are added to the database. All I'm looking to find out is why does it parse the information differently based on whether I...

[Solved] Command button to open document. (Differences Noted in RED) Can anyone tell me why if I use this code: Private Sub OpenIAG_Click() On Error GoTo Err_OpenIAG_Click Dim stAppName As String stAppName = "explorer.exe " & "M:\Student_Files\My_Students\" &...

Excellent - Thanks JANR! Still getting to grips with all the different states of buttons in Access - BeforeUpdate / AfterUpdate / OnClick / etc. - No wonder I couldn't get the ELSE/IF statement to work! Rep added!

OK - seems that I have it! And - that i HAD it!! The Expression I added in the first post actually works fine ... "SPOKE TOO SOON" - BUT, ONLY in Access 2003!! I have 2007 at home, and 2003 at work, so, while the expression works at work, I created it at home. Anyone got any suggestions as...

My bad - I think I've failed to explain - (or I'm missing something!) In my table, I have a Yes/No field - what I want to have happen is for there to be a toggle button that will allow me to see either: Case 1 - ONLY records that have this option ticked or Case 2 - ONLY records that have this...

Nice one JR - I have a question though - I've been trying to put the code here into a toggle button so that I don't have to have two buttons, but I can't seem to get it to go together! I've tried using IF/ELSE and IF/IF, but I'm missing something If Me.Filter = "[Archived] = True" Then...

Thanks John - off to work now - will give it a go and post result later! Oh - and thanks for just posting the basics - I always prefer to work out answers like this, it makes me feel that I have really done some learning! :):) .

I just added this code to the form code: Private Sub Form_Load() DoCmd.Maximize End Suband then make sure 'Pop Up' and 'Modal' are selected as 'Yes' in the form properties - to make it open when you open the database! Works a treat!

He already could you post the basic code and process that you use to filter your data - this is almost exactly what I am trying to do (In fact I have just posted a thread here after a frustrating search!!) Thanks, I'll keep watching this thread, and hopefully learn how to do this myself! :D:D

He all, I've been searching and playing with this for about 4 days now and I'm still feeling like a noob! I have a form with four subforms that holds various details for my students - all working fine, now I have a tick box on my main form that shows the archived state of students - i.e. if...

Hi all, I'm still new to Access and am enjoying the chance to practice at every opportunity:D I currently have a project where I have a form that has a date box that I want to format based on the following: If the Date box is empty = format one If there is a date in the box AND the Yes/No...

OK - to ensure that this is a completed thread! Thanks for the help stopher; After looking at the posts - I went away and got an access book from the library and sat down to read... I have now simplified the tables a little and realise that this was indeed the problem. So, for any others with...

http://i235.photobucket.com/albums/ee84/Bird_FAT/Relationships.jpg OK I'll have a go at explaining the model There are additional tables that go towards a main form (ones that I have no problem with), that only link to this data through that Username. The whole thing is basically a student...