Topics Search

Custom Database Properties

Custom Database Properties
Views: 748
Often you get the situation where you want to store a single item of data in the database, eg an Author Name, a version, a language selection. The most usual way to do this is to define a global const in a module. This has two problems, it is not updatable, and it is not easily accessible from outside the database. A better solution is to make use of database properties. Learn how to create custom properties on the objects in a Microsoft Access database.
Sponsored Links:

Similar posts...


View or change the properties for an Office document

View or change the properties for an Office document Icon
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

Accessing database properties Icon
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.

Database Design Help

Database Design Help Icon
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.

A2007 .accdb file way to store the DB's icon pathless?

A2007 .accdb file way to store the DB's icon pathless? Icon
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?

Unable to open Form Properties in design view

Unable to open Form Properties in design view Icon
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

Retriving database properties

Retriving database properties Icon
How can I retrieve information from the database properties so I can display them on the main form of my application?

Change database's creation date

Change database's creation date Icon
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?

Attach custom toolbar to db? Icon
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?

PageSetup properties keep changing

PageSetup properties keep changing Icon
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

Access 2007 Database Properties

Access 2007 Database Properties Icon
I have a split database for tracking help desk issues. The front-end exists on several desktops. The back-end resides on a shared network drive. To do some testing I wanted to move both parts to my personal network drive, then change the database properties if possible to recognize one another. Tried the obvious w/o any success.

and if so, how can I connect or relate the two ends in the new location?