General :: Greyed Out Objects In Database

Sep 23, 2013

I have greyed out objects in my Access database. I didn't create them and don't know what they are. I tried to delete them but couldn't. Why did they come to my database -or they were already there but now they are appeared- and how can I get rid of them?

View Replies


ADVERTISEMENT

General :: Two Divisions But One Set Of Database Objects?

Dec 4, 2012

I'm using Access 2007. I have designed a database for one of a two division set up. All of the raw data in the tables is similar yet there is one unique identifier for the two divisions. Let's call it DivID, four characters in length.

To keep the maintenance simple I want to have one set of forms, queries and reports. I do not want to duplicate all of these. To the user they will only see one set of the menus, which will show all of the necessary sub-menus.

The first or main menu will have two buttons, Division A and Division B. The user simply clicks on the appropriate division button, and off they go. I'm thinking that it would be easiest for me if the DivID is stored after they click on their division button, and this value is used for any form or report that they run afterwards. Also, this DivID value would generate custom headers at each menu and submenu to confirm which division they chose.

View 5 Replies View Related

General :: Hyperlinks - Linking To Objects In Database

Sep 24, 2012

I have Access 2007 and I use to be able to Hyperlink to an object in my database 9no upgrade0 But suddenly this option is not available. What can I do?

View 4 Replies View Related

General :: Can't Delete Or Paste Database Objects

Nov 1, 2013

I just upgraded to Access 2010. I can't delete or paste database objects in the table, form, query lists, etc.. Is there a setting that allows this?

View 6 Replies View Related

General :: Importing Objects From Secured To Clean Database

Jun 3, 2015

I have an access database that was set with security about 10 years ago.

I have now created another database in 2010 and I am importing all the objects to make a clean non secured database.

When I import tables it imports system table objects like MSysRelationships, but as it already exists it adds another MSysRelationships with a 1 on the end (MSysRelationships1).

Should I delete the original MSysRelationships and then rename the MSysRelationships1 as MSysRelationships.

There are numerous others like MSysAccessstorage, MSysACEs etc...

I am gathering that if I don't rename MSysRelationships1to MSysRelationships then the relationship data would be incorrect and the database wouldn't work correctly, but maybe I am wrong.

View 9 Replies View Related

General :: How To Change Font In Database Objects List View Windows

Oct 1, 2013

How to change font in database objects list view windows? (not datasheet, table/query windows)

View 1 Replies View Related

Can't Find Database Objects

Jun 2, 2005

Hello,

I am a novice when it comes to the MS Access interface. My experience has been designing the database and then using ASP pages to query, update, etc. I am now in a new position where I have to modify a switchboard to point to other data sources (i.e. databases) who have been renamed. My problem is that when I open any of those databases all I get is a form (switchboard) that has links to reports. It appears to my novice eye that the switchboard is the only thing that exists within the "main" database and it points to other databases -- when I open those databases another switchboard comes up and I still cannot view the database objects. I hope this makes sense -- believe me, I am attempting to understand this all.

I hope someone can explain to me what's going on -- there has to be a database that I can open and see actual database objects by going to the top menu bar and selecting, "View --> Database Objects --> Tables, Queries, Forms, etc.

Please help!

Thank you!
:confused:

View 1 Replies View Related

Thumbnail As OLE Objects In Database

Jul 11, 2005

Hi!

I want to display 8 thumbnail images at a time per form of records that matched a search critera in a form. But it seems like a form is suppose only to have one record at a time? I want to have a "next 8 thumbs"-button so it gets easy to browse the pictures.

I'm very thankful if you could help me with this! Please give me some advice.

Thanks!

Best regards
Johan

View 4 Replies View Related

Access Objects Within A 2nd Database

Jan 4, 2006

Any ideas on how I can get a list of the names of the queries and tables within a different database?

For example, from db1 I want to get a list of the names of the queries and tables within db2.

Thanks!

View 3 Replies View Related

Database Objects Have Gone Missing!

Jul 28, 2006

We have an Access 2000 db, which has been used for some time and is split between a front and back end. We've come in today and tried to open the back-end, which contains only tables, and when it opens it's completely blank. We can't see any of the objects or the normal menu to access the tables, queries, etc. We can, however, import the tables into a new database, so they must be there.

Any idea why this has happened or how to stop it happening again.

Thanks.

View 8 Replies View Related

Hyperlinks - Linking To Objects In Database

Apr 7, 2005

I have recently updated my version of Access.
Within a tbl i have a series of hyperlinks.
All of these hyperlinks are linked to an object within the database, a macro as an example.
When i go to edit these hyperlinks, it does not allow me to link 'to objects within the database'. This options used to be available in my older version of Access. Am i missing something?

View 3 Replies View Related

Sharing Objects With A Secondary Database?

Aug 16, 2014

Imagine you have a split database with two users making reports on their own front end. Lets say user 1 wants to share a report they built with user 2. is it possible to send this Object through vba so that user 2 would received a working editable copy that they can use on their front end without sharing the actual accdb front ends?

I thought about creating a Database that would just host the reports but again if I cannot send or access secondary database objects then this method would not work.

View 3 Replies View Related

Cannot Save Database Objects When Changes Made

May 25, 2011

This has happened to me several times in the past. I make minor changes to a report and when I go to save it or close it out, it asks, "Do you want to save changes?" Of course I say yes and it just sits there, not closing out the report tab. The only way around it that I have found is to re-write the report, from scratch.

View 8 Replies View Related

Is It Possible To Synchronise By Exporting And Importing Database Objects?

Aug 14, 2007

:o:confused:
I'm desperately searching for a way to synchronise different copies of the same access 2003 database i created. I have tried brief case synchronisation, and I have also tried the replication manager that comes with access but they both haven't been much help.
My experience with them leads me to believe that they both work best with a LAN or internet connection.
I'm seeking a solution that will work without a LAN or internet connection. Something that will copy my tables and other required objects to a folder that i can copy and move to another pc where another copy of the database resides. It should then import the same tables and objects and hence synchronise the copy of the database.
I recently saw a visual foxpro database that has the kind of synchronisation solution i'm looking for. I think it works this way;it exports all the tables and necessary objects to a folder that it creates allowing you to copy or move this folder via portable storage device to another computer. It then synchronises by importing the tables and other objects from this folder into the database resident on that computer.
I think there might be a way to do this using macro's or VBA but alas my knowledge of these areas of access is very weak. Is there a way to recreate this functionality in access 2003 using VBA code?

View 9 Replies View Related

How To Show The Database Objects In The Windows Task Bar

Sep 11, 2007

I have a problem. This problem is that I cant see the Database objects (Forms,Report,...) in the Windows task bar. I want the user to be able to see any opened form, or report directly in the task bar as any file opened by the Windows user.

I have tried to check on the (Show Windows in TaskBar) option available in the Tools -> options of the MS Access, but it doesn work with me.

What is happening now that I am forced to show the Menu Bar and use the Window menu to switch between the objects, however, This will not be OK for me because my system hides all the command bars the MS Acccess use.

Is the any way to solve this hard problem?

View 1 Replies View Related

General :: Unable To View Design Of Any Objects

Oct 4, 2012

I am new to MS access 2007 but not new to Access. I am trying to open a form in the design view but that option is disabled along with other menu options. I checked the Ribbon and it appears to be a custom toolbar. I deleted that out of the box but I'm still unable to view the design of any objects. How do I enable the menu items?

View 1 Replies View Related

General :: New Objects Created Don't Appear In Navigation Pane

Oct 30, 2013

I'd like to count the number of objects in my DB to check if I'm running into the 32,768 object limit. I'm experiencing unusual and disconcerting behavior, and all the normal corruption repair techniques aren't working. I've imported all the objects into a new database container, decompiled, compact & repair, and nothing works until the I delete some objects (forms, reports, queries, etc).

New objects created don't appear in the navigation pane until I close and re-open. Also, changing a query type from select to append doesn't result in the icon changing in the navigation pane.Code seems to run fine and everything else appears OK, but I really can't continue development until this issue is resolved. I fear continued development may lead to further corruption.after 20 years, this application has grown, I use a variety of techniques to get the size of the application. Currently:

1. 201,200 lines of code in 910 modules, reports and forms.
2. 544 forms
3. 328 reports
4. 3,617 queries (yes, I know, but it's so much work)
5. 450 tables (about half are linked)

I always thought, without thinking too deeply, that the number of objects in the spec refers to the number of reports, forms, modules, etc. But, now I'm wondering, do they also mean all the controls on the forms, and or the fields in the tables? What do they mean by objects.

I used Point Limited's translation modules recently to extract all the label and caption text for a French language translation project and it pulled out something like 21,000 individual controls, and, combined with this issue, I'm beginning to wonder...

View 5 Replies View Related

General :: Is It Possible To Get File Size Of Access Objects

Feb 24, 2014

Is it possible (using the menu or VBA code) to find out the size of the objects in an Access database file?For example if the .accdb file is 300Mb, is there any way of comparing the size of the numerous tables/forms/reports/queries etc, that make up the database?(I know that if I created a new access file and imported the objects from the working database that could give an indication but that would be quite a repetitive process).

View 4 Replies View Related

Forms :: How To Hide Database Objects And Show Once Closed

Jan 5, 2014

I have a database with a main menu which opens up on start-up it works fine and all but I want to go the extra step, I wish to disable / hide the ribbons (Top and Bottom) - Or Hide the whole Microsoft Access Window and display my form with the desktop behind it.

The next thing is once I click the X or the button to close the form I want Microsoft Access to appear again as in everything to show itself again.

View 1 Replies View Related

Permissions Greyed Out

Jul 22, 2005

Hi,

I have secured a DB and everything is tickety boo except for the fact that I want to be able to administer permissions from the FE (MDE) and the modify permissions button that i have put on a custom toolbar is greyed out when I log in?

I have full admin rights on my group and own all the objects and Access lets me assign all the permissions if I enable the shift bypass and enter the development MDB that way but that's quite a bit of hassle if I want to just change a permission or two.

Can anyone tell me why it won't let me change them?

Thanks, Tom

View 1 Replies View Related

Greyed-Out New Table Button?

Jun 14, 2007

All,

Can anyone please tell me why this button is greyed out as I can't create a new table!?

Thanks.

View 2 Replies View Related

General :: Objects Not Visible In Navigation Pane For Power Users

May 29, 2015

We are encountering a problem that started with Access 2007 and continues in 2010 and 2013. We are using a network system.mdw file with mdb databases and the security seems to be working with one exception while running in Access 2007, 2010 and 2013 but runs fine in Access 2003. We have some power users who are allowed to create/modify objects. The power users and Admins have a unhide command button that displays the database window in Access 2003 and displays the Navigation pane in 2007-13. The problem is that when the Navigation pane is shown there are no objects displayed. These are not hidden or system objects and display in Access 2003 database window properly for the power users.

View 1 Replies View Related

General :: All Objects Toolbar Opens When Hit Print Button On Form

Jan 30, 2013

Using Access 2010.I purposely disabled the Access Objects when opening my database for added security. This works.

The problem I'm having is when I use the print button (access macro) on one of my forms, as soon as i click the button, the "all access objects" window opens on the left side navigation. This window shows all of my tables, forms, queires..etc.Is there a setting that will permanately stop this from opening?

View 1 Replies View Related

Modules & VBA :: Network Crash - Any Way To Reconnect Objects Without Closing And Reopening Database

Oct 23, 2013

I have a database that runs a macro/report every 2 hours, however our network has been up and down lately. This causes the macro to fail when trying to log into the system because the table that is storing your username is no longer in the database. When I check, all tables, linked tables, forms, reports, macros and modules are all gone. I find the only way to get them back is to close the database and reopen.

What I want is a way to reconnect the objects without closing and reopening.

Is there a way to do this?

View 1 Replies View Related

General :: Slow Queries On Objects - Possibly Old Object Refs In MSysObjects?

Oct 10, 2013

I have a db that is having some strange speed issues on some very basic queries. Objects that have a rowsource/recordsource with a SQL statment in particular are really slow to populate. Likewise on deactivate/activate the report query seems to reload. I've put breakpoints in every object event with no stops out of the ordinary, and nothing seems unusual.

While I know MSysObjects is a user read-only table, I came across some records that reference objects that no longer exist in the front-end. Is this table cumulative? Is there any way to purge the deprecated records? I tried to turn on then turn off autocorrect features hoping that would trigger it to repopulate, but no luck.

I'm thinking this may be the source of the issue. Perhaps if it is looking for an object that it can not find (especially the ~sq_ unsaved queries) then it's looking to the wrong place on a lostfocus/activate/deactivate or similar event.

Some history on this file, it has been through many versions of Access starting with 2003, which I think is part of the issue as well. Shy of looping every object and replicating the read-write properties, I'm not sure where else to go with this.

View 2 Replies View Related

Relationship Window, Enforce Referential Integrity Greyed Out

Mar 29, 2007

Hello..

I have a simple database of 4 tables.

luTblJobTitle
JobTitleID (pk)
JobTitle

luTblReason
ReasonID(pk)
Reason

tblDateReason
DateReasonID(pk)
EntryNumber(fk)
Date
Reason
Entered

tblEmpMain
EntryNumber(pk)
EmployeeNumber
Etc//

I have a 1 to many setup between tblEmpMain and tblDateReason.

When I try to setup the relationship between the "reason" field in tblDateReason and luTblReason, Referential Integrity along with the other two check boxes are greyed out.

It still shows one to many but it will not let me enforce referential intergrity.

Why is this? Did I setup the database wrong? Or am I trying to do something I shouldn't be doing??

I have attached the db.. It is split with both the backend and the front end.

R~

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved