Start Up Database Window Problem

Jan 18, 2006

I recently created a database to be posted on a network. In order to eliminate users prying into the mechanics of the database, I unclicked some menus on start up. The database is also password protected. I did such a good job that now I can't get into the database window myself. I used shift while opening the database, which used to work, but now I get the password box which brings me to the switchboard form. F11 doesn't work either.

Does anyone know how I can reverse this process so I can get into my database window and get full menus again?

View Replies


ADVERTISEMENT

Code Window - Appears On Start-up

Nov 9, 2006

Good Afternoon,
Could some kind person please point me in the right direction as to how to
stop the 'VB code' window appearing and remaining on my task bar when I initially open up my DB. When I look at whats in the window there seems nothing untoward, but I would simply like to get rid of it as it is annoying??
Other sample db's that I open up on a regular basis are fine, so I was just wondering what could be causing it and how I could avoid it re-appearing..

Hope you can help....


Kind Regards

CarolW

View 13 Replies View Related

Start Date And End Date In One Prompt Window

Jun 3, 2014

Right now I have this in the query criteria row:

>=[Enter Start Date:] And <=[Enter End Date:]

This makes two prompts pop up one at a time. I was wondering if there was a way to combine both start and end date boxes in one prompt so I can see what dates I decide to type side by side. Is this possible?

View 10 Replies View Related

Emptying Out A Database To Start Over

Jul 6, 2007

I have been testing data entry forms in a new database. Is there an easy way to reset the whole thing, autonumbers and all to new, as if nothing had ever been in the tables?

Thanks for your input.

View 9 Replies View Related

Form Load On Database Start

Dec 7, 2005

Hi

how do I setup a "welcome" form to start on database start?

miha

View 2 Replies View Related

Database Window Help

Mar 12, 2006

hi

ive been disabling the database window from the startup tab in MS access, just now when ive tryed to show it on startup it appears but its stuck in the top left hand corner and i cant move it! so i cant access the tables

help any1 pleassse

View 1 Replies View Related

Database Window

Mar 13, 2007

I've imported somebody's access db which hides the database window by default. When I click the db window button in the toolbar, the db window pops up high up and is somewhat hidden by the toolbar. I can't pull it back down as the top is hidden and when I try to move the toolbar,the db window simple moves up so I can't grab it and move it. Any suggestions?

scratch

View 1 Replies View Related

Database Window?

Apr 14, 2008

This may seem silly and I've seen no mention of it in this forum yet but the "Database Window" from previous versions of Access is now called the "Object Browser"? I had code to hide the database window on startup but can't seem to find a way to hide the object browser on startup. Any ideas? Also, is there another way to view my objects in ACC07 because this way is slowing me down tremendously! It's much more difficult to find the objects I'm trying to work on and visually see where I left off. Any help would greatly be appreciated! Thanks in advance.

View 6 Replies View Related

Forms :: Loading Only Default Form On Start Up Of Database

Mar 23, 2014

I need to load my Default Form at start up of my database while office button,the Ribbon and the Navigation pane will be hidden. And when i go to form design view then i can use the ribbon and navigation pane.

View 2 Replies View Related

Modules & VBA :: Calendar Database - How To Get Week To Start On Monday

Mar 17, 2015

I have found a calendar database witch I wanna use in one of my own databases.

But.. on the form the weeks start on sunday, I want the week to start on Monday but I can't figure out how to do it.

I've posted the original database as an attachment. I'd like to know what I have to change in the code and/or in the form to get what i want.

View 11 Replies View Related

How Unhide Database Window

Sep 13, 2006

Dear Friends I made my a stupid mistake and I don't know how to rectify it.

There is a inventory software built in access xp. In order to protect database I've cleared all the options from that is

a) Display Startup form
b) Display status bar
c) Allow Full menus(Changed with Custome Menu)
d) Allow Default shortcut keys
e) and foolish thing cleared Use special key also

I've given a task to modify program where I may have to add New form. I don't know how to unhide database window. pls suggest me what to do....

View 2 Replies View Related

Database Window Not Opening

Dec 13, 2006

I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.

I tried that database on 3 different PC's with the same effect.

Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.

Thanks for any help and advice

Josef

View 2 Replies View Related

Hide Database Window

May 9, 2006

I need to find a way to not allow users to access the backend by using the database window. Is there a way I can password protect this?

Thanks

View 5 Replies View Related

Hiding The Database Window.

Jun 20, 2006

Think I've seen this posted on here recently but cant find it.

Is there a way to hide the database window so that only a form is visible?

Then if you need to view the database window you can press F11 to make it appear?

View 1 Replies View Related

Database Window Missing

Mar 29, 2006

Hi,

Can anyone tell me how to display the database window that shows all the forms, queries, tables etc in a database?

I have an Access database with startup restrictions and startup login screen. I can open the database by holding down the SHIFT key to bypass the startup options but when Access opens there appears to be no Database Window. I can create new objects in the database ok its just that there is no main database window from where I can browse objects. This is driving me mad - i know it's probably something simple but I rarely work with access

thanks
Maracatu

View 5 Replies View Related

Hide Database Window

Feb 23, 2007

I am looking to minimize the access window when my database is opened. I already set it to do that from the startup menu, but all that did was open my specified form on open. I want it to actually only show my form w/ acces on the startup tray. Any suggestions?

View 14 Replies View Related

Before I Start - Advice/criticism On Small Charity Database (re)design Please?

Aug 8, 2007

I was going to say before I screw it up, but that would have made the title too long.

I've read some forum history and done some searches and can't see that a similar query has come up previously - but if anyone can point me at previous relevant threads then that would be much appreciated. I've looked at some of the design theory threads, but am not really sure whether I've applied some of the good stuff in there effectively - and have put this query here as it's specific to my database rather than a 'general principles' thing.

I am hoping that some kind person/people might be able to pick holes in my planned database revamp as I may not have seen some of the pitfalls - thank you.

Background: I am the first and sole employee of a grant-making trust and set up our (still relatively small) database early on - wish I could have waited, but before my database everything was paper-based and impossible to manage. The data is all on the database, but an exponential growth in number of enquiries/applications over the last year means that it can't be easily manipulated in a way that meets our needs because of my short-sighted (OK, poor owing to inexperience in job) initial design in some areas.

Database:
What it's supposed to do: In brief, the way our organisation works is that we get a phone call or a letter or sometimes an entire application from a charity or community group, decide what to do with it and have to manage the funding contract (regular reviews, grant instalments) if the application is successful.

I think existing data is reasonably normalised (certainly at least equivalent to normalisation in the structure below) so migration shouldn't be a problem, but if anyone spots any normalisation or naming convention issues then please do point them out - I'm an Access amateur, but would like to get it as right as I can (this time). Small letters indicate linked tables, numbers indicate 'footnotes'.

tblProject
ProjID (primary key)
ProjName (a)
ProjDateRecd
Organisation (b)
ProjSource (c)
ProjStatus (d)
ProjResponse (Lookup: Letter, E-mail, No response*) (1)
ProjRespDate
ProjReasonDecline (e)
ProjNote (description)

(a) tblProjEvent
PEvID (primary key)
PEvDate
ProjName
ProjEvent (g)
ProjEvDesc - additional detail - e.g. who involved, topic if not obvious from event field.
ProjEvActWho - who is responsible if future action
ProjEvActDue - due date
ProjEvActComp - checkbox
ProjEvActCompDate
ProjEvNote (NB not to duplicate description - more for 'additional notes arising from completed action' or sensitivities that may need to be considered and kept separate from regular reporting)

(b) tblOrganisation
Details not listed for brevity, but split one field per line of address/detail, org name as primary key - existing table can be migrated as is (2). Includes suppliers, networking orgs. (f)

(c) tblProjSourceLup
How they heard about us - list of sources for speed/consistency of data entry.

(d) tblProjStatusLup
What it says on the tin - where we're at right now with a project. History/status changes recorded in tblProjAction.

(e) tblProjReasonDecline
List of common reasons for speed/consistency of data entry

(f) tblOrgContacts
OrgContact ID (primary key)
Names/personal details of organisational contacts, split one field per item (firstname, lastname, jobtitle, etc).

(g) tblProjEventLup
Letter, Funding contract, review meeting, report, telecon, Board review, etc. May be a future action.

Accounts functions:
Payments in/out linked to organisation with a lookup table for account types (in, out, grant, donation, expenses etc etc). Works fine and can be migrated as is (2)

The current arrangement of relationships has the organisation as the focus - I'm looking to make the project the focus, which seems to make sense as each project is unique - whereas we may get several project applications from the same organisation - and the existing structure makes it impossible to sort these out :o.

Footnotes

1) Vast number of applications that fall into the "arrive, get read, get binned" category make this duplication worthwhile - most applications won't make it into the Project Event table. Apart from the "Greetings in the name of the Lord"/419 e-mails, they do all need recording somehow so we can spot any trends and correct misinformation - save hard-working fundraisers wasting their time*.

2) Of course data validation will be necessary, but in most tables we're talking hundreds or thousands of records only, not tens of thousands so should not be that onerous. Especially as I've been the only person using the database, so there are hopefully not too many inconsistencies!


This post is too long already, but if I've been uselessly unclear in explaining anything or anyone wants any more before they want to comment on efficacy of structure please let me know. All feedback appreciated (as I said, I work alone, so really looking for idea-bouncing to check I can see the wood as well as the trees as much as anything - thanks).


*As charity is always a sensitive area and some of you may be involved with voluntary work, an OT comment: 'No response' might seem rude - but if an organisation is -clearly- excluded by the criteria on our website, or that very same person (or a large charity who should be able to manage its information effectively) has previously been told that they are ineligible by reason of their location, size or type then they have had their response already. I could spend all day every day writing 'No' letters - I'd rather be doing something more positive with my time (like checking out/meeting with organisations that are potentially eligible so they get their answer - and in some cases money ASAP). Not R-ing TFM (aka grant guidelines) apparently applies to fundraisers as much as any other profession :rolleyes:

View 4 Replies View Related

Need To Remove Hash At The Start And End Of Link Address Stored On Database

Apr 16, 2014

I am using asp and database to store info for example link addresses. Unfortunately, they have become stored in database column with a # on either side. I have tried find and replace but this does not work on # symbol. It can not be stored as a hyperlink because I need my website to extract info from remote database and then display info in results page as a hyperlink. Works fine if I remove them by hand but there are 3000 of them!

View 3 Replies View Related

Get The Database Window Back After Hiding It.

Aug 31, 2005

Hi,

I have a question;

If I hide the Database window and uncheck the Allow Full Menu checkbox from Tools--> Startup


The next time I open the application how can I get them back?

Any help will be very appreciated,
Thanks,
CS.

View 1 Replies View Related

Password Protect Database Window??

Sep 6, 2005

Hi,

How can I hide the Database window with password protection?

For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...


Thanks for your help

View 1 Replies View Related

Preventing Access To Database Window

Oct 13, 2005

I have an Access FE app with an Access BE.

I need urgent suggestions as to how to prevent access to the database window even when the SHIFT key is pressed when loading the app.

This is very important so as to increase data security and prevent unauthorised data change by users.

Thanks for the expected response.

Peter
Nigeria

View 2 Replies View Related

Please Help, How To Stop Database Window Poping Up

Mar 22, 2006

Hi
We have recently upgraded our computers and therefore reinstalled Office on the new machines. The opreating system is Win XP + patch 2. The version of MS Access is 2002

For all our databases I have chosen to hide the database window, so other user don't accedentally change tables and queries etc. Now the problem is, with the new computers, whenever I minize the database and then open it, the database weindow pops up right on top of every thing else automatically.

I have no idea why this happens and how to stop it. Could any one please shed some light. Your help would be apprecialted.

Regards

Airdesign

View 3 Replies View Related

Database Window Not Coming To Front

Sep 15, 2006

This is I think a very simple query.

with a number of forms/ queries etc open and you click on at the back it is not coming to the front for amendment.

It is probably an indicator somewhere but I just can't find it

any help appreciated

Ta

humph

View 3 Replies View Related

Database Window Showing Problem

Feb 21, 2007

Hi All,

I have a database that is locked down with user-level security, and also have my startup settings set so Display Databse Window is unchecked.

This all works fine, and when the user opens the database, the form I want them to see appears, and everything else is locked down.

EXCEPT - if anyone minimizes Access, then maximises it again, the Data Window appears in the windows taskbar!! So anyone can click on it to display it in Access and can view all the macros, forms, tables etc that I've tried to prevent access to! :confused:

Anyone come across this before??

Thanks in advance, dglover

View 2 Replies View Related

Show The Database Window When Closing

May 31, 2007

Hi,

When the user open the database, the database window will be hided. But, when the user close the database with one form opening, it will show the database window for a while, and then close it.

How to prevent the database window to show at the moment?

View 1 Replies View Related

My Database Window Has Half Disappeared!

Aug 2, 2007

Can anyone help with this ANNOYING problem?!

The Database Window within Access on my computer seems to have kinda half disappeared under all the toobars at the top of the screen. Each time i open it it seems to have moved further up. The problem is, that because it is underneath the toolbars, I can't click on the window of it to drag it back down! Now, its got so far up that i can't even select any of my tables, forms, queries or reports because i can't see them!

Its SOOO annoying! and i have no idea what to do about it!

Help please.....:confused:

View 3 Replies View Related







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