Custom Database Properties
How to read Database Properties
in the MS Access 2007, under menu File -> Database Properties -> Custom tab, I added some custom properties (say 'Source')
How can I read these custom property values via Macro?
The following didn't work:
It says "Property not found"
I am trying to create custom property for data source and out, so I use these to dynamically change when file path changes too
View or change the properties for an Office document
This article explains what document properties are, how you can view or change the properties for a Microsoft Office document, and how you can create custom properties for a document.
What do you want to do?
* Learn more about the document properties
* View the properties for the current document
* View the document properties when you open or save a file
* Change the properties for the current document
* Create custom properties for a document
Accessing database properties
I have an archiving function on a database and want to detect the current size of the database each time it is opened so the user can be prompted at a custom selected level (I have added acustom property for this - ArchiveAt) to consider or request an archive operation be carried out.
Initially this archiving was done on a record age basis (every 2 months or so) but the database is now used so much that 1.5GB | of data can be added in as little as 6 weeks. I am unable to retrieve the database Size property with VBA, although I am sure it must be available as it can be seen manually by looking at File>>Database Properties>>General.
All of a sudden, I can not in design view open the form properties or properties on any database. These are database that I have created and one in particular I havent put any code in yet to lock that stuff down.
Seriously confused. Anybody run into this before and if so how do I fix it?
Also I can not open the properties on a Brand new DB I just started. now really confused
A2007 .accdb file way to store the DB's icon pathless?
I am having a painfully slow day as the server drive is being unresponsive.
Trying to work locally, I was puzzled why even local access to my databases was poor. Then I remembered I set a custom DB icon which is stored on the network drive. (Access Properties \Current Database \ Application Options \ Application Icon)
Is there anyway to still specify a custom database icon, but have the icon end up inside the DB so the DB does not need to access the network share in order to load the icon?
Database Design Help
I am in the process of creating a database for my small business. The business has 142 properties and I am wanting to create a database that contains the properties and the service orders for each.
I would like to be able to share this with my 2 service employees via their ipad. I'm a little confused on whether it would be easiest to create a web database to Sharepoint or other alternatives to accomplish this.
Not really aware of any other possibilities, all I really need is a database that allows me to enter service orders to my properties and have it available to read/edit the status from a mobile platform.
I have a custom toolbar (menu bar) in a database. Is there any possibility to export this custom menubar to an other database or I must re-make the menubar in the new database (the menubar has the same functions in both of the databases)?
Retriving database properties
How can I retrieve information from the database properties so I can display them on the main form of my application?
Refer to Custom Class Object in Immediate Window
I have an object instanced from a custom class.
I can refer to its properties from a VBA sub in either Word or Access.
However the same code in the Immediate Window results in:
Run-time Error '424': Object Required
Method Or Data Member Not Found
Is there something different about custom class objects and the Immediate Window
Add a custom title or icon to a database
Customizing your Microsoft Office Access database with a meaningful title or icon can help make it easier for users to identify the database.
What do you want to do?
* Add a custom title
* Add a custom icon
Moving from Access 97 to 2007 - SHortcuts
I have recently had a need to update my existing databases from Access 97 to access 2007 and I have had problems re-creating the user-interface (custom toolbars.)
While Access automatically re-created the custom toolbars into the new format, they seem to have lost all of the shortcut key features.
Being able to use shortcut keys to interact with custom toolbars is a MAJOR productivity boost and really need to recover this ability.
I have searched for articles relating to this but suprisingly found none that directly address this issue.
I have found a custom ribbon designer ("IDE Ribbon Creator") program for use with access, but even this seems to be missing the ability to assign shortcuts to buttons etc. Also, I dont really want to have to re-invent the wheel and manually create all the existing toolbars.
I heard somewhere that the custom ribbons / toolbars used in Access 2007 (an onward) use xml files to define and store properties used - but I can find no such file anywhere
Output information to outlook custom form
I have a database that tracks event information. We also track the information in an outlook calendar that has custom forms. The boss wants to use the calendar, but the logistical requirement mandates we use an access database to automate the paperwork process.
What I specifically want is a way to fill out the information for the event in access, then export pieces of that information to a custom form in outlook.
It would need to be able to find a specific entry already in the calendar and update the custom form.
Output information to outlook custom form
I have a database that tracks event information. We also track the information in an outlook calendar that has custom forms. The boss wants to use the calendar, but the logistical requirement mandates we use an access database to automate the paperwork process. What I specifically want is a way to fill out the information for the event in access, then export pieces of that information to a custom form in outlook. It would need to be able to find a specific entry already in the calendar and update the custom form
PageSetup properties keep changing
The page setup properties of various reports changes, periodically, 'by iteslf'! I have been able to repeat this behaviour to some extent:
1. preview report - discover that the page setup properties are completely
2. close the report
3. select the report in the main database window, go FilePage Setup, correct the properties
4. preview report - the page setup properties are now ok
5. close the report
6. amend a parameter on the open form that is used by the report
7. preview report - discover that the page setup properties are completely
Change database's creation date
I really need to change the date when my database is created! I manage to change the date in "properties" (mouse right click->properties) with one tool but I need to modify it in the "statistics tab". When we open the database File-> database properties-> statistics tab. There the creation date still remains the original.
Attach custom toolbar to db?
I have created a custom toolbar (PrintReport) that I is set as the Toolbar in several reports in a database. When I put that database on different computers, I have to re-create the custom toolbar.
Is there a way to "attach" the toolbar to a report like you can attach a toolbar to an Excel workbook?
Specify how data displays by using custom formatting
You have the data in a field appear in a specific format by applying custom formats. Custom formatting only change how the data is displayed and does not affect how the data is stored in a Microsoft Access database, or how users can enter or edit data.
Printing the properties of an object
I am attempting to document some of the objects in my database (Access 2007) As an example, how can I print the properties of a form named frmUnpaid_Accts I have tried using HELP, but can seem to find anything - did MS change the way it works, because it looks and feels different to me.
Prospective Client Tracking Database
I want to create a prospective client tracking database for a commercial landscape company. I am looking to collect information on companies, and the properties they manage. One company, for example, may have multiple contact people and those contact people may manage multiple properties. Within those 3 main areas (companies, contacts, properties) there are a bunch of fields relating to the area (phone, email, address, etc.).
I started by creating 3 tables (companies, contacts, properties) and then created relationships amongst the tables be relating the contacts' first and last name with the companies table, relating the properties' street address and the companies' name with the contacts table, and relating the contacts' first and late name with the properties table.
I then created a form with the form wizard that had the companies table as the main form and the contacts and properties tables as the subforms.
Am I going about this the right way? All I want to be able to do is track the companies and be able to add multiple contacts and multiple properties within the companies.
I have read a lot about this, but I'm very new to Access 2007 and custom ribbons and am having a really hard time figuring this out. I want to be able change the default ribbon depending on certain things.
So I started by creating a UsysRibbons table. The table has two records. One with a RibbonName of AdminTab and another with a RibbonName of AllUserTab. I want to programmatically display one or the other of the ribbons. I cannot simply change the form properties because I have way too many forms to do that. I need to be able to change the default ribbon.
So for example, code that would run when the database opens would say:
If certaincondition = True then
What code do I put here to display the ribbon named AdminTab? Else
What code do I put here to display the ribbon named AllUsersTab? end if