Hi
I went into tools, startup and unchecked allow full menus. Now when I open the DB, I don't have the tools menu so I can check the allow full menus. I need to get this back so I can continue working on the DB. There must be someway to get this back/reverse it.
Access 2003
Thankyou
Garry
I am trying to find a way of hiding the icons (bold, italic, font etc.) and menus (file, tools, edit etc) when displaying the forms in form view.
Any ideas guys?
Hello Everyone,
I just finished building my database and i have to install it on a PC. my problem is how to remove access tool bars and menues so that the only thing that appears when you open the databse is the login screen?
I don't want the user of the database to be able to go to design view and change the design of the forms or the reports. I want the user to see and be able to interact with the login form and the switchboard.
I wanna also know how can i install the databse on the PC. do i just copy it and paste it or is there any way else?
I hope you understand what i want.
Thanks in advance for your much appreciated help.
Does anyone know of a good resource to mull through all of the built in functions and learn their syntax, uses, etc?
Thanks
bluke
Hello,
I created a database, and was trying to get the welcome form, to load full screen. So I unchecked all Menu bar and Shortcut bar (allow)
So I now have locked my self out.
Any ideas, I once remember something like ctrl while opening the database, but that does not fix it.
Thanks,
Ranger
Hi, I have a database in Access 2000 format that runs just fine on my work PC which is running XP Pro and Access 2003. When I run it on my laptop (Vista Ultimate and Access 2002) I have a problem where it doesn't recognise the Mid function (or Left, right etc...for that matter). Everytime I try to run the query I get an error 3085 Undefined Function 'Mid' in Expression. Other databases work fine, it just seems to be this one. Can you please explain why this is happening and how I can get around it. Cheers
View 3 Replies View RelatedI built a ms database and I'm just wondeirng about the compatability of using 2007, what kind of issues can i expect to run into and does this sound like there will be a major overhaul needed in the programing, or should it be pretty straight forward.
View 1 Replies View RelatedI am trying to remove the built in form views from access 97. Is it possible to remove the navigational functions of the form while in view mode (ie first record, previous record, search, next record, and last record)? There is also an arrow bar that has no functionality to it placed at the left side of my forms that I would like to get rid of. Is this possible? Thanks for your help!
View 4 Replies View RelatedI have a randomized table named tblRandomBoxes with the following data:
ID RandomID
1 4
2 5
3 2
4 6
5 1
6 3
I have 6 command buttons named command1,command2,command3, etc. and 6 Labels named Label1,Label2, Label3, etc. On Click of each command button, I want to lookup the ID based on the RandomID and set the backcolor of that label number to a different color.
ie) on command1 click me.Label4.backcolor = 39835
How can I 'build' the label number with the lookup? Here's the code I'm trying, but it doesn't recognize my 'built' label number:
Private Sub command1_Click()
Dim ctl As Control
ctl = "Label" & DLookup("ID", "tblRandomBoxes", "RandomID = 1")
Me.ctl.BackColor = 39835
End Sub
Thanks,
Sup
I have a combobox on a form that lets the user select a business name which then populates the rest of the fields in the form appropriately. But when it does this it makes it so that the seach function at the bottom of the screen no longer works, as it only has the selected record as an option. So before selecting a name from the drop down list at the bottom of the screen is says "Record: 1 of 5" but after selecting the name it become "Record: 1 of 1." Is there anyway to still allow the built-in search function to work alongside using a combobox?
View 8 Replies View RelatedI am using an active x control that when you right click on it, it automatically pops up an "About" box showing information about the control. I wouldn't object to this, but I need to use the right mouse down event for another purpose in my program. So far I have discovered that the code I put in the the event works, but only after the "About" box pops up. Is there anyway to cancel or prevent the popup? The reason that I need the right mouse down event is because is that I am already using the left mouse double click event, and I can't use the left mouse down event because then it always fires before the left mouse double click event. This control doesn't have any single click events. Ideas?
View 2 Replies View RelatedI have developed some complex pass-thru queries in Access, looking at DB2 data. I am hoping to be able to make these queries 'prompted' for easy use for my less technical colleagues. If these were developed in IBM's QMF tool, I would build the prompt like &MemberID, for example, if I wanted the user to input a value for Member ID. Access pass-thrus don't recognize this, and it throws an error. Anyone have any ideas on how I can do this?
Thanks in advance for any help...
I need to create a census report from the employees we serve and their dependents, by company. I have a union query of the Employees table and Dependents table to put them all on one list, then a form where you can type the name of the company you need, with a button that opens the report. This works great, except for the fact that sometimes we don't need the dependents; if a company has over 100 Full-Time employees, we only need the employees. I've added a check box ([IncDep]) on the form, asking the user if they want to include the dependents, but I don't know how to get this to filter the report. I have a Relationship field on the tables that specifies an employee as a "Subscriber", so I'd like to filter the report where [Relationship] = "Subscriber" but I don't know how to do this. The union query specifies both Employees.Relationship and Dependents.Relationship to the text box [Relationship], but when I do something like
Dim stDocName As String
If Me!IncDep.Value = False Then
stDocName = "Census"
DoCmd.OpenReport stDocName, acViewReport, , "[Relationship]='" & "Subscriber" & "'"
Else
stDocName = "Census"
DoCmd.OpenReport stDocName, acViewReport
End If
It is my understanding that a custom macro was built to pull text data from a file and import it into Access in the appropriate fields. This macro no longer works and will return the following error message:
"License information for this component not found. You do not have an appropriate license to use this functionality in design mode."
It only gives an option to click OK. When you do it shows a box called "Action Failed" that lists the macro name, condition, action name, and arguments with three button to click on the right of the box: "Step" "Halt" and "Continue". It appears that only the "Halt" button is available to be clicked.
Does this sound like an issue with the Access license or whatever license the macro might have? We're trying to decide if it's possible to restore the functionality of the macro.
I was curious,
How do you add a Menu to a form? Like is there a way to have a Main Menu bar and add the individual menus/menu items with custom events? As well can i cusomize the context menu for the form, or make a popupmenu that is executed upon clickin a command button?
There is a lot of help on how to attach menus to properties and such, but I can't find an item "Menubar" in the access interface.
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
I have an application that hides all the normal Access menus, so that the user can only use the buttons that I have put on the screen forms. Now however, when I open up access, I cannot get to any of the Access menus. It shows the toolbar, but not the normal FILE/EDIT...TOOLS/HELP menu.
How do I toggle this back on? Everything I have been able to find so far tells me to go to the TOOLS menu ---- I cannot get to the TOOLS menu.
Thanks. BTW, I am not really as stupid as this post makes me sound.
Mike Redmond
I'm sure there must be a simple answer to this question but I have been unable to locate the answer.
I recently finished a database program under Access 97 and unchecked the boxes to allow menus. Now I need to fix a few mistakes and need to access my code or the menus to do this. Is there a way to get access to my code.
Any help would be appreciated.
Thanks
rtamd
I did something in the start up options with this database.
Now when I open it I can't get Access to function as normal.
There is no right click, no tool barr or menu.
Any ideas?
Since the introduction of 2003 when you create a custom menu you always get the 'Type in a question for help' tag and the min max close buttons. Is there any way of removing them or disabling them?
:confused:
I have the following code in the on_load of all of my forms to disable all menus:Dim i As IntegerFor i = 1 To CommandBars.CountCommandBars(i).Enabled = FalseNext iThe problem is that when I open a report in preview mode I cannot close, print, etc.Two questions:1. Is the above approach the best way to disable all menus and toolbars?2. How do I add a custom toolbar (already created) to the report preview only. I've tried doing in in the properties and by me.toolbar = "custom toolbar." Neither approach works. I suspect that the code I've used to disable the menus is keeping me from adding custom menus where I want them?I should also mention that I have also turned off all of the menus, toolbars, etc. in the options/startup.Thanks for your help!
View 2 Replies View Relatedhello everybody
I've created 2 menus using macros and everything works perfectly.
The 2nd menu has 2 commands and I want the second command of the menu to be "activated" only if a specific form is open.Otherwise the command must be in the menu, but not enabled. I also want to put a line between these 2 commands. Is it possible? Thanks in advance
Hello everybody
Could someone please explain me how can I create a couple of menus that execute commands in my db? I would like to open certain forms or reports using menus. If it is possible pls give me an example, of 2 menus each having 2 commands. Thank you in advance
In Tools, Startup I deselected all options but now I want to display the toolbar and menu again. I can't figure out how to undo what I've done.
Help appreciated.
How do I make my own menus? Is there some kind of wizard or what? I know how to select a menu to use, but as far as making one I've never done/seen it done before.
View 1 Replies View RelatedI can't figure out how to create drop menus in design view in a table. I put the option in the toolbar but its gray so I can't use the option. I have followed the wizard and its not working so I am doing something wrong!!
View 1 Replies View RelatedHello i would like to ask if there is any way for me to enable the menus , the menu bar and the database window if i disable them from the startup options of my Db ?
View 9 Replies View Related