How to prevent duplicate entry in database?

[IkkeEnGij]

This has been bugging me, because i could not 'see' the database implemented in access
but suddenly it just dawned on me...simple as pie

The Table:
DateTime.....Date/Time
Screen.......Integer (or text)
Movie........Integer (or text)
Seats........Memo (default= a string with a number of '0' chars equal to the number of seats (in the example 476 seats)

chosen for a string to represend the seats, because when seen in the access interface it gives a visual representation of the free/reserved seats : 00110001111100000...etc

the primary key is the combination of Screen and Datetime
referential integrity could be enforced by having a Screen and a Movie table

but maybe this is moot because joshidharmesh101 seems to have disappeared

[joshidharmesh101]

Sorry to be away for some days.

For some reasons I can't upload the database here so I am sharing a link of it.

https://drive.google.com/open?id=0By...0J5Q0tIUjFpNzA

I have few queries but I am in a hurry & post those later.

Thanks all for you valuable guidance.

Dharmesh Joshi

[sirtrung]

Thanks joshidharmesh101

Regards,

[joshidharmesh101]

Well, I am running following code to resize the grid to form width.

Private Sub Form_Resize()
With Grid
    .Move 0, 1560, Me.ScaleWidth, 4935
    For I = 0 To .Cols - 1
        .ColWidth(I) = Me.ScaleWidth / .Cols
    Next

End With
End Sub

My problem is that after resizing the grid, I can not select multiple cells even if I run a line ".AllowBigSelection = True"

Can someone help?

Thanks,

Dharmesh Joshi

[IkkeEnGij]

if you can not select multiple cells, it probably is because somehow you have made it impossible to select multiple cells

[techgnome]

Well, I am running following code to resize the grid to form width.

Private Sub Form_Resize()
With Grid
    .Move 0, 1560, Me.ScaleWidth, 4935
    For I = 0 To .Cols - 1
        .ColWidth(I) = Me.ScaleWidth / .Cols
    Next

End With
End Sub

My problem is that after resizing the grid, I can not select multiple cells even if I run a line ".AllowBigSelection = True"

Can someone help?

Thanks,

Dharmesh Joshi

That's a new problem that deserves a new thread.

-tg

[joshidharmesh101]

That's a new problem that deserves a new thread.

-tg

Thanks tg