How to prevent duplicate entry in database? - Page 2-VBForums
Page 2 of 2 FirstFirst 12
Results 41 to 47 of 47

Thread: How to prevent duplicate entry in database?

  1. #41
    Fanatic Member
    Join Date
    Jun 2014
    Posts
    960

    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

  2. #42

    Thread Starter
    Junior Member
    Join Date
    Aug 2017
    Posts
    16

    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

  3. #43
    New Member
    Join Date
    Sep 2017
    Location
    http://instageniusreview.com/
    Posts
    2

    Re: How to prevent duplicate entry in database?

    Thanks joshidharmesh101

    Regards,

  4. #44

    Thread Starter
    Junior Member
    Join Date
    Aug 2017
    Posts
    16

    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

  5. #45
    Fanatic Member
    Join Date
    Jun 2014
    Posts
    960

    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

  6. #46
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    31,012

    Re: How to prevent duplicate entry in database?

    Quote Originally Posted by joshidharmesh101 View Post
    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
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  7. #47

    Thread Starter
    Junior Member
    Join Date
    Aug 2017
    Posts
    16

    Re: How to prevent duplicate entry in database?

    Quote Originally Posted by techgnome View Post
    That's a new problem that deserves a new thread.

    -tg
    Thanks tg

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.