Hi, I have been using Access 2000 for quite a while now. I have been using the Immediate Window to call my code, but for some reason, this window won't display now, no matter what I do - I have repaired the installation and reinstalled it but to no avail
Is there any help out there for me?
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?
Hi All.
I created form with unbound listboxs based on query which included Credit field that I want to calculate total and show result in caption of window. If is it possible how to do it?
Thanks.
Hi,
I am used to access 2000 but at the moment I am using access 2003. When I first started using it, I had the usual database window showing - by this I mean the one that has the table, forrms etc listed on the left and when clicking on one of them the created tables, forms etc are listed as will as the option to create.
Somehow, this has disappeared. I have made sure that in the startup "Show Database window" is ticked, but after searching the net, have not been able to find any other suggestions as to how to fix this.
Hope some kind person can point me in the right direction so I can see the tables, queries that I have created.
Thank you for your time
I want the write a code that can be when run shows the Color Selection Window. For example I want the user to select the color of one object in the form by clicking on a button. Then I can store the selected color into variable.
http://cops.msc.tamu.edu/graphics/cset.jpg
Please Help me as soon as possible.
HIGLY APPRECIATIVE,
Hi,
I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.
How does one pass argument back from child window to parent window?
From parent window to child window, I used
docmd.openform ,,,,,,[argument] and me.openargs in the child window
thanks in advance.
The picture i have attached shows how i want a form to show, WITHIN its own window basically.
At the moment on my new database i am making, it will only show in tabs along the top, no matter what i try i cannot seem to get it into its own window if that makes sense.
No matter what i do when i view the form it just fills the screen regardless of the size in the design view, i am about to throw my computer out the window over something so simple!?!?
The picture attached i think i created that database is Access 2010, this new one is in 2013, and i dont know how to do this simple thing!
My application is developed in Access 2003 version. Recently we moved from Access 2003 to Access 2010. Now users are facing usability issues like - in Access 2003 all the forms are opening in different windows and they can move to forms easily. But in Access 2010 all the Forms are opening in same window, if they want to move to different forms then they need to close the current window or press ctrl+F6. How can I enable/open forms multiple window in Access 2010.
View 3 Replies View RelatedI have a parameter query built and am curious if anyone knows of a good way to allow the user to define which fields are displayed in the query results.
i tried looking for other threads discussing this without any luck.. not sure if it was my search terms or what. thanks so much for any help..
Is it possible to convert fields listed down to show across.
IDNo Code Position
AAA B01 1
AAA C01 2
AAA D01 3
AAA E01 4
I want to show it as
IDNo Code Code Code Code
AAA B01 C01 D01 E01
Is this possible using Access 2003?
I wondered if someone could help.
I have 3 columns of data within a table and from a select query am trying to seperate certain groups.
Table 1
yr period valuehome
2006 0 100
2006 0 10
2006 1 1000
2006 1 800
2006 2 60
2006 2 50
2006 3 40
2006 3 10
2006 3 5
2006 3 70
2006 4 50
2006 4 5
I wish to show both results for period 0 and an accumulative total for periods 1-4
so results would be
year period Total sum
2006 0 110
2006 1-4 2090
Can anyone help?
thanks
Paul
For my Access DB, I have unselected the relevant options in Tools – Statup to hide the Objects window so that inexperienced users don’t corrupt the design of the forms, reports etc. However, I find that hitting F12 key brings a pop up window ‘Save Form (name of the form open appears here) To: ……….(blank text box). As ……(form or data access page options here)’ with OK and Cancel buttons. Hitting OK saves the form as it is and typing something after ‘To’ saves the form in that name. Though it doesn’t corrupt the DB in any way, I find this pop up window an irritant. Is there a way to stop this?
View 1 Replies View RelatedI'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code:
ABC Co.
ZYX Co.
123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.
Right now, my code looks like this for On_Click:
Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If
But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?
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
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
In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save ‘frm……’ To: As …..’ with OK and Cancel buttons. Though a user can save the form with a different name and this does not interfere with the proper functioning of the DB, I find this an irritant pop up window. Is there a way to stop this pop up window?
View 2 Replies View RelatedThis 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 RelatedI have a button on a form that opens up a report. However, the report always opens in the background. How can it change so that once the button has been clicked on, the report comes to the foreground and the form in the background. Please see attached example. The button is called 'Label'.
Thanks in advance
Lee
Hi:
In MS Access:
In Forms section
DoCmd.OpenForm "Procedure", acNormal, , , acFormAdd, acDialog
I have one button for doing the above action, it works.
when the form come out, there is only close window (x), it doesn't have minimize window (_) option. How can I make minimize window button at the top right corner?
Thanks.
Hello all you experts and thanks in advance for your help.
I want to issue a message box after a window (a form) is displayed. I have attached it (in VBA code) to the onOpen event but the message displays before the window is displayed. So I tried, OnCurrent, then onLoad, but in each case the event triggers the message box before the window is displayed.
Is there an event which triggers AFTER the display of the window. Note that I don't want the message box displayed several times so onGotFocus is out.
Many thanks in advance,
Phillip
Is there a way to have unlimited parameter boxes to pop up when a query is ran?
Thanks
Hello,
I have a form and would like to add a list box to search and open drives and files directly from access.
I would like to create something similar to the mycomputer window. Is that possible? Any help or sample? Thanks.
Greetings,
I am a bit drained today and can't think clearly.
How do I stop a new window opening everytime I open a new form. When I get going on the latest project, inputting data I can have up to 6 different windows open.
~rbinder
Hello - Here's my problem:
I've created a mdb that i'm trying to run from a command window. When I type "vemacro.mdb" at the command prompt the mdb runs fine. But - after it runs I get a popup error window that says "cannot find the file "f:vevemacro.mdb" (or one of its compenents)." But - it DID find it and ran it just fine.
I'm running ms access 2003 and windows 2000.
Can anyone tell me what is causing this to happen??
Thanks!
Caitlin
hi guys,
easy question.
when the DB is open a login form comes up. The issue is that the properties window for that form comes too.
any suggestion? thx max.
Hi..
Is there anyone can help me?
how to create a form that automatically can make the form longer when user click a button?
thank you..