Search:

Type: Posts; User: joshidharmesh101

Search: Search took 0.04 seconds.

  1. Re: Microsoft Enhanced Cryptographic Provider not running on my machine

    Here is the code

    CryptAcquireContext hProv, vbNullString, vbNullString, PROV_RSA_AES, 0

    DJ
  2. Re: Microsoft Enhanced Cryptographic Provider not running on my machine

    I am trying to access AES and SHA-256.

    I hope this helps.

    Thanks,

    DJ
  3. Microsoft Enhanced Cryptographic Provider not running on my machine

    Dear All,

    I am trying to enter an encrypted date value to registry on Windows 11 machine. When I run the code, I get an error message "Provider not available" I check windows services and find...
  4. Re: Crystal report formula field query

    I got solution from a youtube video. I had to replace "{@Tickets} =" with " Formula ="

    Thanks for replying.

    Dharmesh Joshi
  5. [RESOLVED] Crystal report formula field query

    Hello,

    I am preparing a crystal report. I have following summary fields in it.

    Minimum of SrNo
    Maximum of SrNo


    I want to display (Maximum of SrNo - Minimum of SrNo) +1
  6. Selecting multiple fields in Crystal report

    Hi,

    Can I pass multiple selection parameters when calling a crystal report? I am writing following lines


    Private Sub PrintTicket(Sr_No As Integer, Class As String, Show As String)
    With...
  7. Day of week as field in access database

    Hi,

    I want to store Day of Week of a date picker's date in a database field. I am writing following line.

    Book.field ("DOW") = Format (txtDate.Value, "DDD")

    I am getting an error.

    can...
  8. Replies
    10
    Views
    1,384

    Re: Crystal reports help needed.

    Hello,

    I have created a report already and attaching it. Please review it.

    Thanks

    Sorry, can't upload report as the format is not supported.
  9. Replies
    10
    Views
    1,384

    Re: Crystal reports help needed.

    Hi,

    The database has data for more than 1 day so first filter will be Date of Show, next filter will be Time of show (this will form a group), next filter will be Class of seat (toe classes, Gold...
  10. Replies
    10
    Views
    1,384

    Re: Crystal reports help needed.

    Thanks Tyson for the quick reply.

    I do know basics of crystal reports. I have included ticket printing in crystal report in the same project.

    I need help because the reports has many filters. ...
  11. Replies
    10
    Views
    1,384

    Re: Crystal reports help needed.

    Thanks Tyson for the link.

    I have following fields in database.
    1. Serial Number of ticket
    2. Screen name
    3. Date of Show
    4. Time of Show
    5. Movie Name
    6. Class of seat
    7. Rate of ticket
  12. Replies
    10
    Views
    1,384

    Re: Crystal reports help needed.

    Can anyone suggest other forums to get help on this?
  13. Replies
    10
    Views
    1,384

    Crystal reports help needed.

    Hello,

    I am working on a cinema hall booking project for some time & it is almost complete with adding movie, movie time, rates according to sit class, taxes, printing tickets etc. I have the...
  14. Replies
    15
    Views
    2,610

    Re: MSFlexgrid multiple selection

    Yes Spoo Magenta cells represent Pathway. So they should not be included. I have excluded them by passing
    If .CellBackColor = vbMagenta then Goto R:

    and R: is above Next line.

    Thanks for the...
  15. Replies
    15
    Views
    2,610

    Re: MSFlexgrid multiple selection

    Thank you very much Spoo for the help. I have used selection of text before but I am using selection in flexgrid for the first time.

    Dharmesh Joshi
  16. Replies
    15
    Views
    2,610

    Re: MSFlexgrid multiple selection

    Yes. I have selected multiple cells, now I want to print tickets for selected cells and for that I need to find out position of selected cells e.g. A7 where A is row & 7 is column. Next A8 and so on.
  17. Replies
    15
    Views
    2,610

    MSFlexgrid multiple selection

    I am working on a cinema hall booking project. In the booking form I need to book tickets for the entire selection. Please see attached image for better clarification.

    153499

    I require to book...
  18. Re: MSFlexgrid multiple cell selection disabled after resizing the grid

    After long lag I started working on this project. Got it fixed by commenting Grid_MouseOver event. MouseOver event was preventing multiple selection of cells.

    Thanks all for the help.

    Dharmesh...
  19. Re: MSFlexgrid multiple cell selection disabled after resizing the grid

    Thanks for the clue. I am running code in mouseover event to display cell row & column info in mousetooltip text.

    Will report back.

    Dharmesh Joshi
  20. Re: MSFlexgrid multiple cell selection disabled after resizing the grid

    Thanks Chris,

    Will try this & report back.

    Dharmesh Joshi
  21. MSFlexgrid multiple cell selection disabled after resizing the grid

    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) =...
  22. Re: How to prevent duplicate entry in database?

    Thanks tg
  23. Re: How to prevent duplicate entry in database?

    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
    ...
  24. 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=0By3dxG01YXJQa0J5Q0tIUjFpNzA

    I have few...
  25. Re: How to prevent duplicate entry in database?

    Hello friends,

    My project is moving fast. I am thankful to all who have posted useful suggestions & guided me.

    In the ticket booking page I need to filter data from access table named...
  26. Re: How to prevent duplicate entry in database?

    Thanks Chris & Phill for kindness.

    Regards,

    Dharmesh Joshi
  27. Re: How to prevent duplicate entry in database?

    Thanks for the replies.

    With my ongoing project, I am facing one more challenge. I need to determine index of alphabet. How can I do this in code?

    Let me explain the situation. In ticket...
  28. Re: How to prevent duplicate entry in database?

    Hi Chris,

    This is a multiplex with 2 screens. It does offer seats as per your choice. I have a flowchart on paper & have reached at a point where I am coding booking system with on screen chart of...
  29. Re: How to prevent duplicate entry in database?

    Thanks all for the responses. I really learn something from each reply.

    I did some changes to my code & finally it is working fine. I had to find the way by trial & error just because I am not a...
  30. Re: How to prevent duplicate entry in database?

    Thanks all for the replies.

    Let me clarify that assigning a primary key to avoid duplicates is not possible because every field can be duplicated. I want to avoid duplicate entries of combination...
  31. Re: How to prevent duplicate entry in database?

    Thanks LaVolpe for the response.

    I am using LaVolpeButtons in all my projects. Thanks for those lovely button controls, too.

    BTW, looking at above code, do you smell something fishy?
    ...
  32. Is anyone using Active Lock 1.5 on Windows 7 with success?

    I am using Active Lock 1.5 & 1.7 for protection. I know current version is 3.X but only property I use in 1.5 is LastRunDate which is lacking in 1.7

    I can not register Active Lock 1.5 ocx in...
  33. Replies
    22
    Views
    15,616

    Re: datagrid in vb6

    Hi Siddharth,

    Thanks for precise explanation of Datagrid. I have a question, what is the difference between Data Grid & MS Flex Grid? I mean in which condition should I use a Data Grid & MS Flex...
  34. How to prevent duplicate entry in database?

    Hello,

    I am working on a cinema hall booking project. At many places I have to prevent duplicate entries. I am running a string to find out if there is any previous entry or not. I am running...
Results 1 to 34 of 34



Click Here to Expand Forum to Full Width