1. I disabled the tool bars for startup and hence not able to get back the tool bar again after i started the database. Can someone pls help me get back my tool bars again ?
2. How are we able to implement autocomplete in the forms?
I have a subform, which contains only one text box, which works normally, until I set the startup options to hide the menu bars, database window etc...
Can anyone think of any reason why this should be!?
I have a database with certain startup options for the end user. What I would like is for the database to prompt for a password ONLY IF the shift key is used to try and bypass the startup options, so that only an authorized person with the password can see the background of the database. If I simply set a database password from the Tools menu, it asks for that password with the startup options as well, and I actually locked myself out of a database that way! So there needs to be some kind of check for whether or not the user attempted to bypass the startup options, and based on that, ask for a password or not. I am not sure if I can do this through Access options directly, or I will require some coding, but either method is fine.
I have deleted certain content from a table. After it I have compressed and repaired the database but later I found out that I need those deleted data. But now they are gone. Is there any possibility to recover it? Are there any tools or something?
I admin an Access 2007 ADP that is distributed to our user base as an ADE. The back end is MSSQL 2005. Recently, we have begun deploying this software to employees in the field who connect to the corporate network via VPN. Because our field employees are sometimes connecting from some seriously flaky Internet connections, we have seen an uptick in Connection Failure errors.
I've been researching ways to detect and reestablish a failed network connection from VBA so that the user doesn't encounter the errors, or the need to close and reopen the application to continue working. This post appears to get me most of the way there, in that it both suggests a way to detect the failure and reestablish a connection on the fly:
[URL] ....
Basically, it suggests replacing the call to CurrentProject.Connection with a call to your own custom function, looking something like this:
Code: Function fCurrentConnection () As ADODB.Connection If CurrentProject.Connection.State = 0 Then CurrentProject.OpenConnection "YourConnectionString" End If Set fCurrentConnection = CurrentProject.OpenConnection End Function
My problem is that I define my connection in the built in server properties of the project. My users connect using Windows NT Integrated security. I don't know what I should put in the "YourConnectionString" area. Is there a way to tell Access to use the stored settings to reconnect, or alternatively, any example string that connects to a server name and database name using Windows NT Integrated security?
How can i disable the naviation i get on my form? i have a form to add new records, if i accidently scroll the mouse i get previous records shown in the feild, so is it possible to disable the function?
Working in the theatreworld, I'm trying to create something which will usefully combine my contacts and also a database of which shows we have done (dates, actors involved etc, etc) and what shows we have bought in.
So far, I have created my form which has the usual fields (name, address and so on) and also a field which asks users to describe what type of contact they are ie. are they an actor, or a director, or a theatre company. There are also two command buttons, which will either open up another form which lists all the productions they have been in with us over the years (In-house productions), or one that opens up another form which lists what shows each theatre company has brought to us.
I would like to be able to select 'actor' in the category field which will then enable the command button for me to see what productions that person has been in. Or if I selected the 'theatre company' category then the other button becomes enabled.
Can anybody advise me on this please? Alternatively, if this all sounds far too convoluted, then I am open to suggestions!
Just wondered if you might be able to help. I have a form on which I would like to disable some comboboxes until a date box is filled in. Is this possible?
Not too hot with coding - but I have been trying and If Then Else method.
Just wondered if you might be able to help. I have a form on which I would like to disable some comboboxes until a date box is filled in. Is this possible?
Not too hot with coding - but I have been trying and If Then Else method.
We need a way to prevent confidential information from being printed. We have secured the database application itself by disabling all print commands except the ones we want, but PrintScreen still works fine.
We cannot use any system-wide disbaling of that key, because it is the only way that users can print off screens from the BPCS terminal program. We actually have a program that prints off a page directly when the Print Screen button is pressed, and people have become accustomed to using it.
I have searched this topic extensively and found nothing. The only thing I can think of is to make a data access page and use standard browser security code, but that would require an extensive rewrite of our application.
Does anyone know how to disable the PrintScreen key from within the database application? Thanks.
Hello 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 ?
Hello, I have an innoccuous problem with a report I run in Access. The record source for the report is a query that is pulls data from 6 tables. I have a table titled ARInfo that I have to return amost all the fields in the table (big table) so I used * and show all the fields. When I run the report from the button click event on my form, before the query runs that servers as the report's record source, a parameter dialog box pops up titled ARInfo (table name). You do not have to enter anything in the box for the report to run properly. I have only been with the company or 3 months, but we have used Aceess 97 and Access 2000 in the past and it is my understanding that in the old systems, this dialog would not pop up (The query, form, report, and code is unchanged0. Since we converted to Access 2002, this dialog pops up. The code behind the form, report, and in the associated modules is very immense (This report and form that drives it touches many diferent pieces of the system) so I'm not really about to inclued any code in this post. If anybody knows a quick and dirty trick to disable dialogs or any conceptual theories as to why this is occuring, please let me know. Andrew
I got the following Switchboard example somewhere else, and I do understand the code, up to the point where I want to make a change but can't :mad:
The Navi buttons on the right can be chosen by the user to display the different tabbed pages. However, I want sometimes that some of these buttons are disabled at runtime.
I cannot get the right syntax for doing this. I've tried Me.btnPage1.Enabled = False but that just does NOTHING!
Could someone please have a look at the attached DB (frmSwitchboard and the code behind it) and tell me where I am missing something? That would be great, thanks!
Im new to this, and a beginner at database design, but I am currently stuck on disabling a command button.
Basically what happens is the form is loaded and there are two buttons (save and undo) both disabled:
Private Sub Form_Current() Me!cmdSaveAddAd.Enabled = False Me!cmdCancelAddNewAd.Enabled = False End Sub
once a text box has been filled in the next occurance happens:
Private Sub Form_Dirty(Cancel As Integer) Me!cmdCancelAddNewAd.Enabled = True Me!cmdSaveAddAd.Enabled = True End Sub
which enables both buttons. but the problem is when a user clicks the undo button i want both buttons to be disabled again, i cannot get the undo button disabled, the save button was easy enough:
Private Sub cmdCancelAddNewAd_Click() DoCmd.RunCommand acCmdUndo Me!cmdSaveAddAd.Enabled = False End Sub
but if i put (Me!cmdCancelAddNewAd.Enabled = false) i get an error message saying 'you cannot disable a control that is in focus'.
hi, there is this form i want to create which uses a drop down list.... i want to be able to auto enable and disable selective fields upon selecting one of the choices.
e.g. in a drop down list containing: choice 1, choice 2 and choice 3
and there are the fields field no. 1, field no. 2 and field no.3
If i select Choice 1 --> field no. 1 get enabled and the other 2 gets disable... so on and so forth....
For an item being returned I've made a command button that brings up a "return" form which is related to the Items form with a one-one relationship, (so the two primary keys are linked). Obviously an item can only be returned once, (logically and because of duplicate primary keys), so i'd like to disable the command button once it's been clicked. At the moment i have:
Private Sub cmdReturn_Click() Me.cmdReturn.Enabled = False End Sub
This doesn't work because it disables the button for all the records (It's in a continuous form).
Any help is greatly appreciated. Thanks in advance Joe
How do I disable the switchboard after it's been set as the default. I want to get back into the native objects associated with the main database table. I want to design a new report and then re-enable the switchboard as the default method for users.
This may be a very basic question, but I have to ask: how do I prevent the user from switching to design view and messing with tables and queries. Also, once I do that, how do I get to the design view to make changes if necessary?