Results 1 to 5 of 5
  1. #1
    Vipercgr is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2023
    Posts
    1

    Modify Database Access 2013 (Noob)

    Thanks for lookingI have a Access Database that generates certificates. The data is old and the format of the certificate is not great and I am looking to make changes. But I have no clue where to start. Tried to google some stuff but the wording I am using is not bringing back the information I am looking for. There is drop down menus that need to have the info changed, not sure where that located.There is text that generated for the certificate that needs to have the font changed, but I have no clue where that is.The document may be locked some way, but I cant seem to see how.I have no clue what I am doing with Access but know my way around other MS ProductsThanks for any help you can provide.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,938
    Hopefully the dropddown menus ( I am assuming they are combos?) are in a table.
    However it seems you have a huge task on your hands.

    Probably best to upload the DB if you can and see what anyone can do for you.
    We are here to help, but you have to do the work for the most part, and if you do not have a clue, then that will be an uphill struggle.

    If you are concerned about GDPR then make a copy and run https://www.accessforums.net/showthr...t=randomize#19 against that copy and upload the cleaned DB
    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
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    Copy the db and play with the copy. If you don't understand what I'm saying, please use the key words as search terms rather than e.g. asking what a navigation pane is.

    Open your play version and look for the navigation pane on the left side. If you can't see it because stuff happens when you open the db (such as a login form opens) close db and reopen while holding shift key. If that doesn't help then you might have to post a zipped copy here. I'm not about to tell anyone how to get around that.

    Left click on the form whose combo list (drop downs is an Excel term, I'd say) and choose to open in design view. If the property sheet is not visible, open it from the ribbon. Now research how to identify what is used for the combo Rowsource property. It could be a value list, table or query name or a sql statement. Which one is used will dictate how you must alter the list results. That should get you started.

    If you select a control on the form, the property sheet Format tab shows font properties for that control. If you have been tasked with administrating this db, you best find some books on basics or find videos. Use general search terms and if the results are not zeroed in, the results usually give you other ideas for search terms.

    I'd say for the most part, a forum like this is for helping you solve issues but teaching someone who knows next to nothing about Access isn't really what the forum is for. You might find a mentor here though as there are people who don't think the way I do about such things.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Welcome.

    Readers need a little more context.
    I have a Access Database... That you built/inherited?
    generates certificates Please tell us more about certificates
    looking to make changes.... Please give us some examples (current vs desired)
    drop down menus........... In Access these are Comboboxes
    needs to have the font changed Samples would be helpful
    document may be locked some way Why do you think that?
    no clue what I am doing with Access Access is database, much different than spreadsheet etc.

    See the Database Planning and Design link in my signature to get to a list of articles about Database and Access. The articles cover topics of various skills. Try a couple and get back if you have specific questions.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,938
    Might be worth also looking on Youtube under the premise of 'a picture is worth a thousand words'

    Here is one such video. https://www.youtube.com/watch?v=ubmwp8kbfPc
    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

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

Similar Threads

  1. Replies: 14
    Last Post: 10-04-2016, 09:29 AM
  2. Modify a Co-Workers Access Database
    By Gary Drumm in forum Access
    Replies: 5
    Last Post: 10-25-2015, 06:37 PM
  3. Modify Access 2010 using Access 2013
    By martinmcnally in forum Access
    Replies: 2
    Last Post: 07-27-2014, 07:51 AM
  4. Replies: 4
    Last Post: 08-21-2013, 07:08 AM
  5. Access 2013 Database Name
    By Sparky in forum Access
    Replies: 2
    Last Post: 06-28-2013, 04:07 PM

Tags for this Thread

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