Search results

Thanks a lot. That didn't occur to me, but seems to be the problem. Cheers Ian

I have probably fooled myself but can anyone see why the following always results in a message box coming up saying "error"? ------------- Private Sub filmid_AfterUpdate() Dim Msg As String If [filmid].Column(3) >= [datefield] Then MsgBox "error" End Sub ----------------- The...

Thanks Guy's - food for thought. I'll have a play and see how far again but I suspect... I'll be back.

Is this of any use? http://www.mvps.org/access/tables/tbl0018.htm First, using Access while in the database window, copy the table's structure only from the corrupt table, if possible. Then using the code below, copy each individual row from the old table to the new one until it encounters an...

I run a touring film circuit called Flicks in the Sticks. We run over 500 films a year and are a registered charity. I couldn't run it without my Access dbase, but there is a problem which I would really like to crack. My main table is the Events table which carried info like which film, which...

Try doing a search on pictures on the forum - there are a couple of links that folk give that will give you a real good start with this problem. Keeping pictures stored in the database will potentially make it huge. But the links mentioed above mean you can show the picture for each record...

links on our page www.artsalive.co.uk then goto the links page. It is all access dbase driven. Let me know if you need any amendments or if it reads ok. Ian

fair enough!

Thanks for taking the trouble to post that. Iwouldn't have spotted that in a long time. Why did you set the visible property to N, if it doesn't have any impact?

The field that you get to not be visible is a text box. The only property I can see that you have used is the visible one - and it says no. I have gone through all the properties of what is a pretty simple set of controls and I have tried to replicate it but mine will not disappear! Bizarre...

Perhaps you would take a quick look at this sample - though I have probably misunderstood something. Mile-O-Phile kindly did it for me. His suform is in datasheet view, has two fields on it - one of which is visible = no - and yet I try to do the same thing and I can't get rid of it! What do...

Hi I have just spent an hour trying to work out why I can't make a field invisible on my subform (in datasheet view). I was working from an example that one of the forums members sent me (which I think was in Access 97 format - I use 2002) where he was able to do this. I then searched the net...

I just did an internet search and came up with the answer - you have to hightlight both fields and do them both att he same time!! Cheers Ian

Hi Mile-O-Phile I have been working on the dbase today and thanks to your example I have managed to get a long way. However at one point in your ArtistToArtform table you have two Primary Key fields. I can't seem to get that on my table - what might I be doing wrong? when I make another...

Wow, you are a star! Thanks. I think it would have taken me some time to make the jump to this, but now i see it... Cheers Ian

What I can't seem to get my head round (though after a day programming my mind is often too mushy to see what is obvious), is how to store the values for each record. An artist can pick say 10 different artforms from the listbox (or combo box), do I just store these in one field - or will this...

Thanks for the reply and the pointers. I have downloaded the two 'many to many' samples on the forum, and will have a look. Never having used junction boxes before, and my own database is littered with check boxes, it is going to be an interesting day!... many thanks Ian

Hi In a weak moment I have offered to write a database for a local charity who also works with artists. They need to keep detailed info on artists, and so one of the fields they want is to record the artists 'artform'. They have drawn up a list of 17 different artforms, which at the moment I...