Page 3 of 3 FirstFirst 123
Results 31 to 36 of 36
  1. #31
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    249
    Thanks, once again Vlad. I got it all imported and the calendar if functioning correctly except for the frmCalendarSettings. It is still looking for tblCategories, but I can't seem to find where it is looking for it at.

  2. #32
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Try importing this one, its all (I think) in the code.
    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #33
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    249
    Quote Originally Posted by Gicu View Post
    Try importing this one, its all (I think) in the code.
    Cheers,
    That fixed the table issue (you have a "tblttbl" typo in the code, but it was easy to find in fix), but now I'm not able to save the changes. It gives a "Syntax error in UPDATE statement." error when you try to change something and save it via the Setting form. Also of note, on Windows 10 and Access 365, the color picker window never pops up when you try and change one of the Position/Category colors. I don't know if it is Windows 10 or Access 365 that is causing that.

    Edit: While it gives the error, it does actually appear to make the change on the calendar view on Windows 10 and Access 2016.

  4. #34
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Here you go, the error was caused by the empty "categories" on the form, I have edited the code to remove it.

    Cheers,
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #35
    Etoimos is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    249
    Quote Originally Posted by Gicu View Post
    Here you go, the error was caused by the empty "categories" on the form, I have edited the code to remove it.

    Cheers,
    Thanks Vlad, that one is working a treat.

  6. #36
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Glad to hear!
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Using access to schedule help
    By scoobz1234 in forum Access
    Replies: 11
    Last Post: 02-23-2018, 02:05 PM
  2. MS Access Personal Finance Budget Template
    By Kaloyanides in forum Access
    Replies: 0
    Last Post: 01-28-2015, 08:09 AM
  3. Replies: 6
    Last Post: 07-13-2014, 07:12 PM
  4. Replies: 7
    Last Post: 01-21-2014, 11:35 AM
  5. Time Schedule display in access
    By snoopy2003 in forum Database Design
    Replies: 3
    Last Post: 03-23-2011, 04:41 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