Results 1 to 8 of 8
  1. #1
    Dano60 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2015
    Posts
    32

    Urgent need some input

    Private Sub cmd_FicheProd.jpg.zip



    frm_DetailProduit_Scolaire_E.jpg.zip

    Here what I would like to do. In the frm_DetailProduit_Scolaire_E (see above attachment) there is a field called binding color, within that field you can choose various color and also the option "To be determined".
    When I click on the View Production Sheet at the bottom of that form, there the above code that calculate a "DateTerminaison", then open the Production sheet (see below the attachment), (sorry guy's this report is only in French) which is printed and sent to the production floor.
    I would like to put in that code a vbCritical which would prevent the report to open if in the color field the option "To be determined" is selected. The "To be determined" option as to stay because it's put there for the purpose when the salesman as to send a order form to the client to be approved and sign even though the client as not chosen is finale choice on binding color. The vbCritical has to informed the salesman that he as to change the "To be determined" choice.

    All this to prevent the chaos of having a production sheet reach the production floor which would require the production personnel to contact the salesman and to have the said binding to be produce in house according to the querry generate by this program. (about 1500 order to process in 2 month).


    rpt_FicheProductionAupel.jpg.zip

    Hope this is enough explanation.

    Thanks very much.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    about?...........................................

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Post explanation of issue and your code (use CODE tags) directly into thread, not images. I took a quick look at your first image. Not going any further.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Duplicate of https://www.accessforums.net/showthread.php?t=67947

    Again, post lengthy code to thread between CODE tags so it retains indentation and readability.

    I provided a suggestion in other thread. Did you try it?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Dano60 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2015
    Posts
    32
    VIP,

    I'm very new to this and have zero traning.

    Don't know how to do this.

    I tried the suggestion that you provided. Did not work.

  6. #6
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    can you turn Off the button if the code ="To be determined"

    Code:
    sub form_onCurrent()   'when user changes record
      EnablePrintBtn
    end sub
    
    sub cboBox_AfterUpdate()  'when user changes the Color Status
      EnablePRintBtn
    end sub
    
    sub EnablePrintBtn()
       btnPrint.enabled = (cboBox =
    Code:
    'To be determined')
    end sub
    
    

  7. #7
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the stupid code box wont print right. it keeps inserting characters (above).

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I suggest you post a copy of your database --remove names etc if that is confidential.
    All readers need is enough data to highlight the problem.
    I also suggest you tell readers exactly
    -what you want to happen(with example)
    -what is happening now (with example) and a clear description of what you think the steps are (in simple terms) to get you from what you currently have to what you want.

    Readers can't guess at your requirement. Be specific with what you require.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 09-23-2015, 02:29 PM
  2. Replies: 1
    Last Post: 11-04-2014, 12:07 PM
  3. Replies: 6
    Last Post: 10-27-2014, 08:05 PM
  4. Input Forms - How To Input Multiple Fields/Records?
    By butterbescotch in forum Forms
    Replies: 1
    Last Post: 04-04-2013, 06:30 AM
  5. please help urgent...thanks
    By dadas in forum Access
    Replies: 4
    Last Post: 10-13-2011, 01:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums