+ Reply to Thread
Page 4 of 34 FirstFirst ... 2 3 4 5 6 14 ... LastLast
Results 46 to 60 of 499

Designing an Excel application for simultaneous use and for optimal maintainability

  1. #46
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    Its something that we talked about a while back about what is needed when you are combining tables. When its better to have all the info in the combined table or not. That is the part I remember.

    u3rick
    Last edited by u3rick; 01-27-2016 at 05:20 PM.

  2. #47
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    My goal for the short term is getting the Calendar working and excepting payments from renters so I can use that part of the program while finishing the rest. I am close on everything except using the payment transactions and having a report that I can manually post to QB's in the interim! There is lots of cleanup and updating code and changing forms etc left in the new combined version. But I would like to get it running and then update as needed as I am testing the working parts.?? Now that might not be the right path feel free to re direct me!!

    u3rick

  3. #48
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    I have re-worked some of the code in the frmStayActivity and it mostly works. But of course it has a couple big problems.

    The New Guest checkbox is causing some problems. I tried to use the templet code you sent me a while back, but there was nothing to follow on some of this code so it needs your assistants.

    To reproduce just pick dates and Book a Gueststay and then check new Guest.

    Having trouble with the table GuestStays filling in the formulas in the Properties section which makes the calendar not work.

    To reproduce just pick dates and Book a Gueststay with and existing guest.

    Also in the Dropbox

    Thanks!

    u3rick
    Attached Files Attached Files

  4. #49
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,047

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Got the problem from yr post #41 figured out.

    This piece of code in StoreAdhocAvailability moves the data to all cells in the specified column because no record number is specified.
    Please Login or Register  to view this content.
    Change the code like this and it'll work OK.
    Please Login or Register  to view this content.
    Same problem occurs in StoreMonthlyAvailability. Solution is the same.

    BTW, I've been looking at ES_Reserv_MgmtSys_Step1_v1.0.2, because ES_Reserv_MgmtSys_Step1_v1.0.3 gives other others (you've been changing column names in the tables, but not in the code).
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  5. #50
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,047

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Its something that we talked about a while back about what is needed when you are combining tables. When its better to have all the info in the combined table or not.
    I still think it's a good idea to have copies of columns of other tables to minimize the number of lookups. But I also think these copies should serve a purpose.
    A good purpose would be the use of them in forms. It would be a proper way to have the base table with actual data (property, owner, propertyowner, guest, etc) and for each form have a table (view) with copies of the columns from the base tables which are used in the form.
    That would it more manageable.

  6. #51
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    I am not sure, I have combined ES Reservation and Management Systems and tried to change code and headings as you suggested one table at a time., I have not changed any except when needed as far as I know. I am trying to get everything working and then if a heading needs change for some reason, I would do it one at a time! The version v1.0.3 exists because of a crash of my Excel and it is the recovered version and seemed to crash less than v1.0.2 so its my main version now!!

    u3rick

  7. #52
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    It would be a proper way to have the base table with actual data (property, owner, propertyowner, guest, etc) and for each form have a table (view) with copies of the columns from the base tables which are used in the form.
    That would it more manageable.
    We are not doing that now are we? guess I am not totally understanding how that works or maybe I am doing it and don't see it the same way!Loo!

    u3rick

  8. #53
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,047

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Now that might not be the right path feel free to re direct me!!
    There's not one right path. Yes, there are methods and techniques. That's important when you want to make your job of programming. I don't believe that's the case
    In your case perseverance, focus and prototyping is a good way to go. And that's what I believe you're doing. It is however not a smooth road as you're experiencing
    It all will work one day.

  9. #54
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tijallie

    BTW, I've been looking at ES_Reserv_MgmtSys_Step1_v1.0.2, because ES_Reserv_MgmtSys_Step1_v1.0.3 gives other others (you've been changing column names in the tables, but not in the code).
    I have got the changes working in v1.0.3!! I did delete a couple date columns in two tables as they were doubled with the same info!

    Thanks

    u3rick

  10. #55
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,047

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Ok, 1.0.3 works fine now.
    Will look into the problem with frmStayActivity.

    Edit:
    Apparently the name of the checkbox has changed, but in the chkNewGuestSA_Change the old name is still used.
    May be it's time to switch on "option explicit". These kind of errors would then be automatically detected.
    Last edited by Tsjallie; 01-29-2016 at 04:31 AM. Reason: additional info

  11. #56
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,047

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    There's more about this frmGuestActivity.

    In the sub cboGuestListGI_Change of the form the tables ListStayInfo and ListPymtHis are used.
    Both (view) tables derive the columns from tblGuestStays and tblGuesTrans resp.

    In order to avoid non-contingeous ranges being fed to the rowsources of the lists used a sort is being executed.
    But the sort for the ListPymtHis is done on the view table. As the sort order is defined by the base table, sorting the view table has no effect.

    The sort on the table tblGuestStays doesn't sort on GuestId, so the filter still renders a non-contingeous range.

  12. #57
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    Disregard this post I found them!

    In the sub cboGuestListGI_Change of the form the tables ListStayInfo and ListPymtHis are used.
    Both (view) tables derive the columns from tblGuestStays and tblGuesTrans resp.
    I can't find these. Could you do a screen shot of location? It will help me find where these problems are. I know I should be able to find them!!

    u3rick
    Last edited by u3rick; 01-29-2016 at 12:55 PM.

  13. #58
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    Added it as a Variant (Dim i AS Variant) and it worked so I hope that is correct!

    I added Option Explicit to the code for frmStayActivity! I had made changes in the code and it worked (Found your code templets) but with Option Explicit on get this error message.

    Screen Shot 2016-01-29 at 8.23.07 AM.png

    I await you help! I think we need to keep Option Explicit on!

    u3rick
    Last edited by u3rick; 01-29-2016 at 01:17 PM.

  14. #59
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    I understand what you are saying in post #56. Not sure what to change? The frmGuestActivity works?

    Screen Shot 2016-01-29 at 9.22.31 AM.png

    u3rick

  15. #60
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Re: Designing an Excel application for simultaneous use and for optimal maintainability

    Tsjallie

    ES_Reserv_MgmtSys_Step2_v1.0.4.xlsm is the current version(In Dropbox) and has Option Explicit in all forms except frmDatePicker you can handle that one!

    I am going to start to update code to the templets you made a while back. Most of the code in MgmtSys used the templets but most ES Res were not wish me luck. This project will be second to getting the calendar operating as Vacationville ES reservation calendar and payment system!

    Thanks #gettingthere! lool! This is a Twitter thing my kids do!

    u3rick
    Attached Files Attached Files

+ Reply to Thread
Page 4 of 34 FirstFirst ... 2 3 4 5 6 14 ... LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1