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
Devcon 2020 Goes Virtual! LEARN MORE >

Announcement

Collapse

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

2 days spent on a form design HELP

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    2 days spent on a form design HELP

    I have designed a database for a booking and invoicing system that appears to be working ok.

    I have copied the entire database into a new folder and amended all the links and lookups to look in the new folder (we are keeping Euro's business and pound sterling business on separate databases). I should add that when I lookup the table in the invoice form on its own it works fine it's only when I look at it in the bookings entry form that it all goes wrong.

    Everything appears to be ok but when I look up another table to complete some of the fields in the invoice section of my bookings screen Alpha5 just freezes I have to use task manager to close it.

    I have tried everything, I have attached a zip file of my database. To access the control panel there is a hotspot on the lower right hand side of the opening screen. The form I am having problems with is the sub form INVOICE_FORM which is included in the bookings entry form and the field that sends everything wonky is when I click on the Course_No field and select a course from the lookup table. Can anyone spot an error in this. We have lots of bookings waiting for their Euro Invoices and my boss is understandably putting the pressure on.
    Last edited by Judith; 04-15-2010, 11:57 AM. Reason: further explanation of what happens
    Tags: None
    #2
    Re: 2 days spent on a form design HELP

    Hi Judith

    The form I am having problems with is the sub form INVOICE_FORM which is included in the bookings entry form and the field that sends everything wonky is when I click on the Course_No field and select a course from the lookup table.
    I just tried the app and I opened the bookings entry form and the first record came up. I went to the invoice sub form and clicked on the course no and the lookup came up and I selected the second entry and pressed okay and all the data that was supposed to be written to the invoice sub form was done.

    It seems to be working right but I may be taking the wrong steps.

    Can you give us step by step on how to see the "wonky" result?

    One other thing, you have your main menu form based on the stage1.set. When that opens, it opens every table in the stage1.set. You shoud create a dummy table with one field called dummy (or whatever you want) as a character field with a width of 1. Save it and then copy your main menu form (using copy to) to the dummy table. That way when you form is opened it will only open the dummy table. Right now all those tables are opened immediately upon opening the application.

    Tom

    Comment

      #3
      Re: 2 days spent on a form design HELP

      Judith

      edit: Is the other version of this application which you used to copy the one zipped here, is that currently running on Version 9 with the same sub form on the bookings entry as the zipped one? Just added this because if it is working on the copy that you copied from then I would then have to think that there is something wrong with the INVOICE_FORM. I will recreate the entire form later when I have more time and see if that is the case.
      --------------------------------------------------------------------------


      Are you using Version 9 with the new browse. That was the version in which I was testing your zipped application and could not find anything wrong.

      I just tried Version 9 old browse 2095-3264 old browse and I get the same thing that you do - click on the course down arrow and when the list box shows click on a selection and the whole thing hangs up.

      I even tried duplicating your invoice form from scratch and the same thing happens.

      If you are not using the Version 9 new browse patch 2095-3264, I would suggest downloading that patch and see if it works then.

      I am attaching the download link

      http://downloads.alphasoftware.com/A...chDownload.ASP

      When the download screen comes on click on the relese notes hyperlink and it will take you to the page that has the new browse download. Download that and try it (if you don't already have it)

      See if that corrects the problem for you.

      Tom
      Last edited by Tbaker; 04-15-2010, 04:15 PM. Reason: added a new first paragraph with new thoughts

      Comment

        #4
        Re: 2 days spent on a form design HELP

        Thank you for your help, I have downloaded the patch and altered my main menu form so that it opens a dummy table.

        The bookings entry form works better now that it puts in the details from the look up table and doesn't freeze, but when I enter the number of people in the delegate field it doesn't appear to do the calculation that are set for the invoice fields the fields appear on the booking entry form to stay as zeros BUT when the record is saved the values are there - very strange.

        Thank you for your help at least I'm past the stage of the programme freezing.

        Comment

          #5
          Re: 2 days spent on a form design HELP

          Hi Judith

          I played around with your form and have attached a zip file with some changes that I thought might help you. The changes have to do with the booking form and the invoice_form.

          I did not see a need for the subforms on the booking entry form so I made changes to add the invoice fields to the booking entry form as well as the attendance fields - there are no sub forms on the new bookings1 form.

          There is code to change certain things based upon the current mode of the form. If you need to enter a new record into the booking entry form, you press the new record button and a blank form with come up for the booking side but there will be a new invoice button and a blanked out invoice area. The new invoice button uses a revised Invoice_form as a dialog to enter the records into the invoice table - when you are done entering the invoice and click close, the dialog form will close and the invoice details will show on the booking entry form in the invoice area.

          If you don't enter an invoice at the time that you enter a new booking then the invoice area will remain blanked out and the new invoice button will show.

          Once an invoice is entered into the table with a booking reference, it will show as you go form booking record to booking record. You can change information then directly into the invoice area form.

          If you are on record #1 which has an invoice, the form will be complete. If you go to record #2, there is no invoice for the booking so the invoice area will be blank and the new invoice button will show. Again, if you enter an invoice for record #2, when you close out the dialog form, the booking entry form will be complete with booking on the right side and invoice information on the left side.

          The code for all of the different view is in the OnActivate, OnFetch and OnEnter Event. If is fully commented so you should be able to get the idea.

          It is in xbasic - I don't use action scripting very much any more - I like the control of using xbasic.

          This is to get you around the sub form issues that Version 9 seems to have - but then again, I could not see a need for a sub form - but that is my opinion only - you may have a very valid reason for using a sub form.

          Just zip the file to its own folder and open the table in version 9 (new browse). As it did with your original, it will open to the main menu which has not change except for directing the Booking button to go to the new booking1 form.

          Open the booking form and it will open to record #1 which has an invoice linked to it. I filled it out with dummy information as well as the number of delegates. I could not determine what the delegate browse was used for nor the attendance-transfer was used for but I just left them as they were only update to match the new look (I used frames to outine the different sections.

          Regards
          Tom

          Comment

            #6
            Re: 2 days spent on a form design HELP

            Hi Tom I have sent you a private message. Regards Judith

            Comment

            Previous template Next
            Working...
            X