Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook



The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic

Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.

If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.

Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.

Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Unwanted Calendar

  • Filter
  • Time
  • Show
Clear All
new posts

  • Unwanted Calendar

    Hi All,

    I have a date field based on a lookup of dates.dbf so that my user can select from a predefined list of date. I do not want the user to enter a date other than from the list.

    My problem is that when I place the field on a form I cannot find a way to hide/disable the Alpha pop up calendar icon even though I set the properties to 'Type In'. There is an option in a browse field to disable the popup but no where can I find this option on a form.

    Anyone know how to hide or disable the Alpha calendar icon?

    I could use an array but this gets tricky if I need to bring in other values from the lookup table


  • #2
    Re: Unwanted Calendar

    One way would be:
    - get rid of any "lookup" field rules for your form's date field
    - in form design, set the date field to Record List-Combo Box (in the Setup tab)
    - then go to the Choices tab; From table: dates; Return value: <whatever your date field in dates.dbf is called>
    - add 2 columns into the Record List. The first column should be an expression: cdate(<date field name>), and the second should just be <date field name>, i.e. whatever you called it.
    - then edit the first column (the expression), and set its width to 0.

    This is because the drop down list always sorts on the first column, so you need a character field in ascending date order - cdate turns a date into yyyymmdd format.

    It works; the only minor annoyance is that for blank records, the field will always display the first date in the drop-down list.

    * Edit *: just realised you can get round this by saving a blank record to the dates.dbf file - it comes up first in the drop-down list.
    Last edited by Bonbon; 09-25-2008, 06:37 PM.


    • #3
      Re: Unwanted Calendar

      This sounds like something I reported 2-3 weeks ago as a bug but haven't heard anything back yet.

      I tested the same form in v7 (where it came from originally) and it works there without the calendar when it's defined as a Type-in field.

      With a little further testing (I love spending my time trying to figure out work-arounds to Alpha issues), I discovered that you could "fix" this by using the
      command in your autoexec. Just be aware that this will move the calendar popup box back inside the field (as it was in v8 and earlier) instead of outside the field as it is now.

      I haven't checked to see if I can switch back and forth - i.e., make it "inside" when I open one form and make it "outside" when using another form. I'm only willing to go so far with work-arounds.


      • #4
        Re: Unwanted Calendar

        Thanks, I had tried the list box option combo box and this is not what I need, there is very little that will force the user to react to the selection, in the meantime I shall use an array.

        Yes it is a bug because it is OK in V8.

        I will report this again



        • #5
          Re: Unwanted Calendar

          Did you try the Record List-Combo Box (not list box) option ? (see screen shot)

          It drops down only the dates in your dates.dbf, and won't allow the user to enter anything else. If user types into the box it goes to the closest match in the list. No calendar icon, as requested.


          • #6
            Re: Unwanted Calendar


            Thanks but the list box does not meet my needs.

            This is definitely a bug because it works as expected in V8 and prior so I have send a replica sample to Alpha bug department.



            • #7
              Re: Unwanted Calendar

              I submitted this as a bug a couple of weeks ago. I received an email from Alpha last Wednesday that this is going to be addressed in the next patch in a form of a command that you can place in the autoexec script.



              • #8
                Re: Unwanted Calendar

                I was told some time ago this is not a bug, this was a change of design feature in V9.
                Keith Hubert
                Alpha Guild Member
                KHDB Management Systems
                Skype = keith.hubert

                For your day-to-day Needs, you Need an Alpha Database!


                • #9
                  Re: Unwanted Calendar


                  I don't want my users to to have access to the calendar under certain circumstances where I want to force them to enter a date from a pre-defined list.

                  Selwyn has sent me a temporary fix in a betapatch that he says will will be showing in the next update patch.



                  • #10
                    Re: Unwanted Calendar

                    Originally posted by Keith Hubert View Post
                    I was told some time ago this is not a bug, this was a change of design feature in V9.
                    Personally, if not a bug then I think it was either a bad choice of "design feature" or they overlooked the issue of "Type-in" vs. "Calendar" format. Adding a design feature to allow the calendar to show up outside the field object is fine with me. (Although I do think the ability to change back to the old format, which is possible as noted above, is important - see note.) However, changing the "Type-in" object format to work the same as a "Calendar" object format doesn't make sense to me.

                    NOTE - Why I want to retain the ability to have the calendar inside the object:
                    Some of my forms show some type of descriptive/explanatory text to the right of the field object. If I'm forced to leave extra space on the right for the calendar, then the explanatory text is likely to appear as thought it's not associated with that field.

                    I put together a dummy xdialog to demonstrate the issue. In this dummy example, the "explanatory text" just describes how that example was set up. In real life it would be something related to entering data in that field. It might even just be a "?" button to get more help about that field - imagine what that would like if the distance to the "Help" button was 3 times the width of the "Help" button itself. Can someone figure it out? Yes - if they try hard enough. But, (a) some users don't seem to be able to figure out anything that isn't staring them in the face and (b) if they do have to "figure it out" then it's my belief that it doesn't look very professional.

                    Edit: And I agree with Michael's concern.
                    Last edited by CALocklin; 09-28-2008, 03:19 PM.


                    • #11
                      Re: Unwanted Calendar


                      As you can see from my previous post, Selwyn has acknowledged this and the next update for V9 will be including an Alpha preference to 'Not show Calendar if field is Type In'.

                      e.g. a5.system_mode_set("Show_Calender_Icon_For_Type-In_Fields", "No")



                      • #12
                        Re: Unwanted Calendar

                        I did see that. I just don't see any reason why it should be an option. If I want the calendar, I should just select "Calendar". If I don't want the calendar, I should just select "Type-in". This is the way it has always been. This is what makes sense. And this is what still happens if you choose the option to show the calendar inside the box.

                        The "new/improved" method is to change it so that these two options both do the same thing (at least it seems that way to me) and then give us an optional command to change one of them back to what it should have been in the first place. And, it's pretty certain that people will have a hard time finding the [unnecessary] option or even realizing that it exists.

                        Can anyone give me a good reason for having the calendar drop-down appear with both the Calendar and Type-in options? Or, is was this perhaps another of those "let's make it easy for the ignorant people" ideas? Those seem to be more and more prevalent lately and I hate them because they almost always make it impossible, or at least much harder, for the non-ignorant to do something they've been doing for years. This would be a perfect example if that's what happened here. At least in this case Alpha decided to give us back the option rather than taking it away completely.

                        <soapbox>I'm sorry. It may not be politically correct but I say "to heck with the ignorant people - make them learn just like I had to." Stupid people might not be able to learn but ignorance can be overcome with just a little bit of effort. I'm getting tired of people making things harder for me just to make something easier for someone who's too lazy to learn. I feel like it's becoming a sin to expect someone to actually learn something. And I'll stop there because if I go any further than that I'd have to get into how ignorance plays into politics and the election process and then I'd really get upset. Keep people ignorant and you can get them to agree to anything. That's why the most dangerous thing to our current way of life is the decline of our educational system - which is getting worse rather than better under "no child left behind".</soapbox>


                        • #13
                          Re: Unwanted Calendar

                          I saw the same issue with v10 so I used your "a5_system_..." in the autoexec and it worked for the forms. In the browses I just checkmarked the "disable popup editor" in the browse setup properties for columns that contained date fields. Allowed me to keep them when I wanted to, kill 'em when I didn't.


                          • #14
                            Re: Unwanted Calendar


                            Thanks, yes I have been using the 'Disable Pop Ups' and it fits my needs but not entirely sure if that is the correct purpose of the property.



                            • #15
                              Re: Unwanted Calendar

                              Guess I spoke too soon. Doesn't appear to be working now.