-
Sep 13th, 2017, 04:42 PM
#41
Re: How to prevent duplicate entry in database?
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
do not put off till tomorrow what you can put off forever
-
Sep 16th, 2017, 06:20 AM
#42
Thread Starter
Member
Re: How to prevent duplicate entry in database?
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
-
Sep 16th, 2017, 12:24 PM
#43
New Member
Re: How to prevent duplicate entry in database?
Thanks joshidharmesh101
Regards,
-
Sep 17th, 2017, 12:25 AM
#44
Thread Starter
Member
Re: How to prevent duplicate entry in database?
Well, I am running following code to resize the grid to form width.
Code:
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
-
Sep 18th, 2017, 06:35 AM
#45
Re: How to prevent duplicate entry in database?
if you can not select multiple cells, it probably is because somehow you have made it impossible to select multiple cells
do not put off till tomorrow what you can put off forever
-
Sep 18th, 2017, 07:28 AM
#46
Re: How to prevent duplicate entry in database?
Originally Posted by joshidharmesh101
Well, I am running following code to resize the grid to form width.
Code:
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
-
Sep 18th, 2017, 08:08 AM
#47
Thread Starter
Member
Re: How to prevent duplicate entry in database?
Originally Posted by techgnome
That's a new problem that deserves a new thread.
-tg
Thanks tg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|