Menu Bar Gone Forever?

Sep 11, 2006

I was in a rush and went to tools and unchecked the menu bars for startup. Does this mean I could never edit the database again?

View Replies


ADVERTISEMENT

Program Running Forever, But Won't Use CPU.

Nov 13, 2007

I'm trying to run some VB code (in an Access module). The code executes for 10 seconds or so, and then Windows XP robs it of any CPU. I've tried (many times) using task manager to set the priority to high or real time, but still MSAccess shows as using only 2 or 3% of cpu.

I've got in intel core 2 due, running Windows XP SP2.

I've got a table with about 2 million rows. When I try to append the 2m into another table with an append query, or if I burn through the table with a do loop in VB using recordset.append and then recordset.update it takes forever (hours). What burns me up is that the CUP sits there near idle, varying from 2 to 4 pct usage.

Thanks for any ideas..

Steve

View 1 Replies View Related

Query Taking Forever To Execute!

Oct 9, 2006

SELECT FCST.REF_DT AS [Date Forecasted], ACTUAL.REF_DT AS [Date Shipped], FCST.QT AS [Qt Forecasted], ACTUAL.QT AS [Qt Shipped], FCST.PART_NR, FCST.REGION, FCST.TYPE, IIf(FCST.QT=0,'',formatpercent((ACTUAL.QT-FCST.QT)/FCST.QT,2)) AS MPE

FROM TBL_FCST_WKLY AS FCST, TBL_ACTUAL_WKLY AS ACTUAL

WHERE (FCST.TYPE=ACTUAL.TYPE) AND (FCST.REGION=ACTUAL.REGION) AND (FCST.PART_NR=ACTUAL.PART_NR) AND

FCST.REF_DT = (SELECT DISTINCT DATEADD("ww",-LT.LEADTIME,ACTUAL.REF_DT) AS FORECASTED FROM TBL_FCST_WKLY FCST2 INNER JOIN LEADTIME LT ON LT.COMPONENT=FCST2.PART_NR AND LT.REGION=FCST2.REGION WHERE FCST2.PART_NR=FCST.PART_NR AND FCST2.REGION=FCST.REGION) AND

FCST.MONTH_DT = (SELECT DISTINCT DATEADD("ww",LT.LEADTIME,FCST.REF_DT) AS FORECASTED FROM TBL_FCST_WKLY FCST2 INNER JOIN LEADTIME LT ON LT.COMPONENT=FCST2.PART_NR AND LT.REGION=FCST2.REGION WHERE FCST2.PART_NR=FCST.PART_NR AND FCST2.REGION=FCST.REGION);


i am querying two tables TBL_FCST_WKLY which has 29500 records and TBL_ACTUAL_WKLY which has 798222 records.
When i run this query it sites there forever. Is it because i dint optimize my query or is it because the number of records is too much for access? can someone help plz.

thanks

View 9 Replies View Related

Forms :: Unbound Object Frame Takes Forever To Load

May 6, 2015

I'm experimenting with unbound object frames to embed an excel sheet in Access.If I have an excel application already open and busy, and then open my form, access freeze completely and won't do anything. My users will probably be running excel vba programs when they attempt to view this form, if there is no work around I'll have to drop the idea of embedding excel in access.

whenever an "external" thing wants to use excel (opening a file in explorer, etc), it uses the very 1st excel application open on the computer at this moment, instead of creating its own instance, or at least scanning for how busy the open application is. Because of that, I think that even loading the preview in the access form will try to use the current excel process even though it's completely busy.

View 2 Replies View Related

How To Show A Full Menu On The Menu Bar

Feb 19, 2007

Hi everyone,
I was trying out the options on the startup item of the tools item on the menu bar and my access window has gone except the following menu items: File,Window and Help.
Can someone kindly show me how to bring back these seemingly lost items?
Thank you for your willingness to help me out!

View 2 Replies View Related

Drop Down Menu Inside Drop Down Menu

May 15, 2006

Ok, This is something I have long wanted to do, but cannot figure out.

I am working on a database for a company that orders a large number of Items. I have these all in one table (itemCode, itemDescription, price, categoryCode, etc). I have another table with categorys (categoryCode, categoryDescription) . Each Item is asigned a categoryCode and the appropiate relationship exsists. Right now I have a comboBox in a form that when selected opens a drops down menu with all the Items. Then another one auto loads up (continuous form) and I get the same drop down list of all the Items.

What I would like to have is a combo box then when it is selected shows the categorys, then based on that selection, I see all the Items that are in that category.

I guess another way of saying this simply is, I would like to create a drop down menu inside of a dropdown menu.

Is this possible? Does anyone have another alternative suggestion that might work well? I'm relectant to use a list box, becoase ideally it would be a drop down menu inside of a drop down menu as seen on many websites.

Thanks in Advance!

:)

View 2 Replies View Related

Need Help With Menu Bar

Dec 9, 2005

Before anyone get to upset with me I did search the board looking for the answer but only got more confused. I found the code I wanted to shut down the toolbars and menu bars but I need to allow the print options on the menu bar. How do I allow the menu bar up but only allow printing ?

jon

View 4 Replies View Related

Help With Menu Bar

Apr 4, 2006

I have this code in the opening for of my database but the tool bar "passdown" does not open. Could someone please help me understand why?
thank you
jon


Private Sub Form_Open(Cancel As Integer)
ChangeProperty "StartupForm", dbText, "Frm-UserLogon"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
DoCmd.ShowToolbar "passdown", acToolbarYes

End Sub

View 2 Replies View Related

Menu

Oct 3, 2006

Hi,

I have a question.

I create a custom menu, and then assign hyperlink for running Excel application (C:Program FilesMicrosoft OfficeOffice10EXCEL.EXE). When I click on it, it has security message,

/////////////
Opening C:Program FilesMicrosoft OfficeOffice 10Excel.EXE

Some files can contain viruses or otherwise be harmful to your computers. It is important to be certain that this file is from a trustworthy source.

Would you like to open this file?
''''''''''''''''''''''''

How can I erase this security message? Thanks.

View 1 Replies View Related

Menu Bar

Feb 8, 2007

I was trying to change the form that appeared on Load by going to Tools>Startup and changing the settings there.

However now I have lost most my my menu bar i.e. Edit, View, Tools etc. I only have File, Window and Help. :eek:

How do I retrieve the menu bar in its original state?

View 3 Replies View Related

Menu Bar

Mar 1, 2008

In my access 2003 the principal menu is not more visible.

I have used the command:

CommandBars ("Menu Bar"). Visible = True

but it doesn't make to appear the menù.

What can I do?

View 2 Replies View Related

Pop Up Menu???

Aug 10, 2005

Hello,

I was wondering if there is a way that I can create a 'message' that will appear whent he mouse is scrolled over a button. I have command buttons that launch my reports but would want the user to know what fields are included in each report...therefor, they can put the cursor ontop of a certain button and a small list will show them what is in that specific report

Cheers :)

View 4 Replies View Related

Menu Bar

Apr 29, 2006

I have a question of creating a few menu bars.

I made 3 menu bars.

When the user log in the database, the database program will detect the user name, and then output his own menu bar.

It works fine.
However, I got a problem, when I created the first menu bar, the menu bar have control box for the forms, the other 2 menu bars do not have it.

How can I make 3 menu bars with control box, minimizs, maximinize, close form boxes?

View 1 Replies View Related

Menu Bar And Sub Menu

Aug 25, 2006

Hello, I have created my own Menu bar in access and would like to add sub menus to it.

Any help? Thanks.

View 3 Replies View Related

Menu Design...

Jun 27, 2005

I could not find Menu design in Access...Is it available during design time?
When I searched for it I found AddMenuItem to programatically add menu...
I vaguely remember seeing menu design in VB 3.0 7 years ago...I am looking for something similiar..

This probably the simplest and stupidest question..please excuse me for that.

Thanks

View 2 Replies View Related

No Tools Menu...?

Aug 4, 2005

I was just editing my Access database (stored on the intranet) when a message popped up saying "Disk or network error".

I clicked the only option ("ok") and closed the DB. When I reopened it, it said someone else was viewing it and I only had read permissions. I close it again, and see that in the directory where my .mdb file is stored I have the .ldb file remaining even though it isn't open.

I restart my machine, and try and open it again. I have to compact and repair the DB at Access' suggestion, yet now I only seem to have limited functionality....??

I.e. there is no Tools menu, I can't right click on forms or tables to choose Design View (although if I highlight them in the database pane and click the BUTTON for Design View I am able to proceed)....

What's going on?!!

I've tried going to File > Open and in the little arrow on the Open button choosing "Open Exclusive", but it opens and does the same thing as above...!!

I've checked a different database in Access, and I don't seem to have gone potty, in every other one I'm able to see the Tools menu, etc...?

Anyone got any clues as to how I can get my lovely database back on its feet and functioning properly? :confused: :eek: :rolleyes: :mad:

View 5 Replies View Related

Menu BAr Not Showing

Jan 3, 2006

:confused: hi ,,,
i have this Microsoft Application and i have unchecked the check box (Allow full menus ) in the starup ... So when ever i run the application i only get
the menu bars : File, Window, Help, AdobePDF

how can i get the other menu bars ?


any suggestions

thankx:o

View 6 Replies View Related

Import Menu Bar

Mar 23, 2006

Hi,

I created my own menu bar in one MS Access file, let's say db1.mdb.

Can I import it to another database file (let's say db2.mdb)?

Thanks.

View 1 Replies View Related

Lost My Menu Bar

Apr 24, 2006

Greetings,

I have just opened Access and for some reason my menu bar is gone. I have fiddled for a few minutes try to find and restore it - but I am clueless. It is working fine in all other programs.

How do I restore it?

~rbinder

View 2 Replies View Related

Do Not Want ANY Menu Bar In Application

Apr 26, 2006

Hello,

I do not want any menu bar in some application I have made using a switchboard. In the start-up function I unchecked all the checkboxes but some menu functions keep coming back. How can I overrule this?

View 5 Replies View Related

Menu Struture!

Apr 13, 2007

I am about to create the menu (navigation) structure for my system but wanted it to be fancy. Anyone got any suggestions or GOOD websites that have different menu types. any help/suggestion would be appreciate!

View 1 Replies View Related

Menu Problem

Apr 25, 2007

Ok i admit i think ive done a really stupid thing here.

In my database on the start-up menu (tools > start up) i have disabled all the menus as well as menu bars and short cut menu bar and toolbars.

However now i need to change information about the start up...

How would i go about this?

Much Appreciated

Ben

View 1 Replies View Related

Startup Menu

May 21, 2007

I craeted a startup menu and unchecked all the backend functions - now I cant getinto design view - what should I do?

View 14 Replies View Related

How Do You Reset The Menu Bar?

Aug 10, 2007

I was in the startup options and unchecked a couple of toolbar boxe and now I dont have a full menu any more.

Please help

View 6 Replies View Related

Database Menu

Aug 22, 2007

I've recently noticed that I cannot get back my main table screen. I'm stuck in the forms..Possibly because of the settings.. I'm not sure.


Is there any easy way to get back to get back my main screen?

E.g. http://img518.imageshack.us/img518/1470/mainscreenoh7.jpg

View 4 Replies View Related

Drop Down Menu Help

Feb 22, 2005

Hi there.

I work for an Internet Marketing company and my boss wants me to design a huge huge form in Access - requiring alot of Drop Down Menus. Alot of them are simply Yes/No questions, some, however, are not.

This is what I have done so far:

I have a field called Sector which I have selected as a Yes/No Field.

In the Form Design View I have selected:

Row Source Type = Field List
Row Source = Sector (this is a separate table in which I have put all the options)

In Format, instead of Yes/No, I have changed it to "-" - this is simply because when I view it Normal View the first thing in the Drop Down Menu is a Yes or a No.

This all seems to work fine until I try to select one of the options and I get this error:

"The Value you entered isn't valid for this field - For example, you may have entered text in a numeric field or a number that is larger than the FieldSize settings permit"

I have gone back and forth into the Design View on the Form and the Table trying different things, but nothing I do seems to work.

I don't even know if I have gone about doing this Drop Down menu in the correct way to begin with.

I'm not an Access Expert so please if anyone has any ideas please let me know. It'll be much appreciated :)

Thankyou.

View 5 Replies View Related







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