Results 1 to 6 of 6
  1. #1
    Roskame is offline Novice
    Windows 10 Office 365
    Join Date
    May 2022
    Location
    Netherlands
    Posts
    2

    Design mode disabled

    Hello,



    I want to make a invoicing program and with some Googling around I got to this nice MS template:
    https://support.microsoft.com/en-us/...a-ac93edad4dd1
    It got me a nice starting DB, which I can now further build from.

    But when I unpacked it, it won't let me get into design mode, form properties, etc.
    I added a blank version of the just unpacked DB as attachment.
    Is there any way around this? I just want this template to be fully editable.

    Regards,

    EdwinTest DB.zip

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    If it is a template, you create a dB from that template, not amend that template.

    Edit: I cannot download it even? but it does say 'The Access 2010 Services web database template' ?

    What on earth have you uploaded?, nothing to do with invoicing at all?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    think this is a web database which was deprecated years ago.

    Most of the objects have the 'web' icon
    Click image for larger version. 

Name:	image_2022-05-22_153826617.png 
Views:	33 
Size:	5.3 KB 
ID:	47870

    You can edit those objects that don't have the icon such as the form GetUserNameClientOnly

  4. #4
    Roskame is offline Novice
    Windows 10 Office 365
    Join Date
    May 2022
    Location
    Netherlands
    Posts
    2
    @Welshgasman,

    Somehow I did manage to download it and it does work.
    When openend, you'll get a save window and it will create your own DB.

    I disagree... you can make invoices, quotes, etc.
    I couldnt get the template to upload... you wanna see that? Maybe I can get it online somehow.

    @Ajax,

    thnx for noticing it's a web DB, I didnt know...it appears there are some ways to convert it to a client DB...
    I'll try the different solutions Google trows at me.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Well the link would not download, but copying it and using that, I managed to download, but my version is too old to open it.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Your database is a Web database. Web databases were introduced with Access 2010 with the intent of allowing Access databases to be published on-line, and available throughout the internet. The tables are actually links to Sharepoint lists. Web databases allow NO VBA in Web Forms, Web Reports or allow code modules at all if they are to be published as such.
    I would advise you to forget this database NOW. It is heavy with data macros. You will find little help here with that. I suspect that not 1 in 5000 Access developers have worked with data macros, and most would not even know how to view them. Data macros cannot be converted to VBA via Access wizards. Data macros are notoriously difficult to debug.
    The database you suppled has had 4 normal (not web) forms and 4 normal (not web) reports added with VBA behind them. All the dozens of others are Web forms and reports with embedded macros exclusively which cannot be converted with native automation.
    Web forms and web reports cannot be exported to a regular DB. A regular DB cannot import web forms or reports. You can import web tables, but you get the data macros along with them.
    I'm using Access 2019 and can open the DB. Office 365 may not be able to work with a web database at all.

    Click image for larger version. 

Name:	webobjects.png 
Views:	27 
Size:	60.3 KB 
ID:	47873 Click image for larger version. 

Name:	DataMacs.png 
Views:	28 
Size:	62.9 KB 
ID:	47874


    Here's the DB file above, unchanged by me.

    Test DB Edit.zip
    Last edited by davegri; 05-23-2022 at 09:28 AM. Reason: clarif

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

Similar Threads

  1. Replies: 1
    Last Post: 11-29-2016, 08:05 AM
  2. Replies: 5
    Last Post: 05-24-2016, 06:08 AM
  3. Toggling Design Mode On/Off
    By Peter Murray in forum Access
    Replies: 3
    Last Post: 09-01-2015, 05:28 PM
  4. Cannot open in design mode
    By kpalar in forum Forms
    Replies: 4
    Last Post: 08-01-2014, 12:51 PM
  5. Replies: 4
    Last Post: 01-14-2011, 10:37 AM

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