Search results

  1. A

    VBA simple error?

    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...
  2. A

    tracking copies of the same record

    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...
  3. A

    Visible property on a subform

    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...
  4. A

    options for initial design of table

    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...
Back
Top Bottom