The novice that I am inadverdently deleted a record in a query. (I find it strange that it does not just automatically restore it the next time I run the query.) Is there any way I can get this record back without having to recreate the entire query?
View RepliesI have 2 queries that have been hidden from view by right clicking on them and selecting the hidden button. How do I restore them to view again????
cheers
EQ
Hi there...
Can some one plz guide me how to do restroe access database?
thanks
Danny
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
Hi there, i have looked into this but can't find a real solution. I have decided to keep certain of my forms maximised. I have tried pop up, or just have it ordinary sized but this doesn't work for my purposes.
So, the problem is that when the form is maximised, no matter what you do, you can't get rid of the "Restore Window" button in the menu bar. I have tried to make a workaround by putting "DoCmd.Maximize" in the Resize event of the form. The strange thing is that the event does fire but the form doesn't get maximised. Any idea why this is happening and what I could do to solve this issue?
I am using Access 2013 and I had a column that was accidentally deleted a few months ago. Is there anyway to restore a deleted column? If not, I have the majority of the data from that column saved in an excel spreadsheet with another column that is common to the access file and the excel file. Is there any way to take the data from excel and have it match up using the data from the common column?
View 4 Replies View RelatedHey guys,
I figured out to maximize a window when a report is opened, but now I want to restore the window sizes when this report is closed.
I think I kind of know what to do with the DoCmd.Restore and something about OnClose, but I'm lost in the syntax. If someone could help me out by giving me the syntax and where to put this code that would be fantastic :)
Hi I have had a look on the forum but cannot find what I am looking for!!
I need to back up all the contents of the tables of a database in a certain folder and then restore it. The reason for all this is to be able to update the database with new features so that the final user can receive the update and restore the data.
How can I achieve this???
M
Is it possible to disable the Restore button that's displayed on the menu bar when a form is maximised?
View 2 Replies View Related:confused:
I have a db app that has all forms maximized continually (I have set the vba code to do so on Open, Close and GotFocus events). From my app Home Page form the user can browse to other forms in the db. When another form is opened the window automaically maximizes. However, when the user navigates back to the Home Page it goes in restore mode. I haven't told it to do this anywhere. I have also tried saving the form stretched out to fit the full screen, so that if it goes into restore mode it at least still fills the screen, but it still reverts to a restored window (about half the screen). It doesn't matter what configuration I use in the AutoResize, AutoCenter properties either.
I have been developing custom db apps in Access for over 8 years. However, this seems to be a stupid (albeit simple) problem that is annoying me. I currently use Access 2003 and this issue is new (or so I believe since I never ran into the problem in previous versions).
Any ideas?
Thanks...
This is probably very simple and I am wasting time on it so I thought I would ask for a quick fix.
I have a form "Standby" that minimizes when a buton is pressed to open a second form "Filter." This works great. I want the "standby" form to restore to it's original size when I close the "filter" form.
I have tried several options the last being:
under the on close event
Private Sub Form_Close()
Forms!standby.Restore
End Sub
She no worky.
What is the quick solution for this please.
I'm using overlapping forms in my Access 2010 database.
When the form(s) open I want them maximized and I don't want the restore buttons to be available.
I have the Min Max Buttons set to None.
I have DoCmd.Maximize in the On Load.
I want the border style set to thing.
Is there any way to prevents the Restore button to be enabled?
I open the first form it's maximized as per the DoCmd.Maximize in the On Load. I then open another form (which has nothing to do with the first form) and it opens maximized. When I close the second form the first form is no longer maximized, it's restored.
Is there any way to restore menus/editibility when they have been removed using ACCESS OPTIONS > CURRENT DATABASE then uncheck 'allow full menus'? Database was created in Access 2007. I always keep a back up of the pre-menu-disable state of my databases, but this is someone elses for which I can't find a backup.
View 2 Replies View RelatedHow to hide, or disable the "Minimize", "Restore Down", and "Close" controls in the top bar (ribbon?) when previewing or viewing reports?
View 1 Replies View RelatedHow to disable the Minimise, Restore and Close Buttons at the very top right hand corner of the Access application?
I have got buttons on my database to open / close everything so no need for them, even to hide the full Title bar probably be okay.
I am running Access 2007.
I have a database with several reports that get constantly printed, however I am having an issue with their display properties that sometimes cause errors.I need the report to come up on top of everything, maximized and with the menu bar available to allow for it to be printed or close it. The report window cannot have "minimize" or "restore" available to make sure nobody access any form behind it.
To achieve this in a form I generally use the modal property, however if I do this in a report I cannot get to the menu bar to print or close the print preview.Thinking that modal was out of the question, I went ahead and maximized the report on load and set its properties to the image attached. The db is then compiled (accde) and then distributed.
On my computer (it is being developed on my machine) the report loads fine (maximized) with no min, max or restore buttons and the print preview menu bar is shown with the print and close buttons available. See "My PC" image attached.On any other computer, the report opens up maximized but the report's restore and close buttons are enabled, however the print and close buttons on the print preview menu bar are greyed out. See "Other PC" image attached.Why the inconsistent behaviour when using the same front end?
I have created a custom menu used on my reports which contains all the icons I need and anchored them to the right side of the report. I have been able to remove the min, max and the close icons from the default report menu bar at the top right hand side as well as the "Ask A Question" dropdown. But I am not able to remove the "Restore window" button that comes with the report print preview.
How do I remove the "Restore Window" icon from the report's menu bar?
I'm using Access 2003...
I need to disable or hide the restore, minimize and close window buttons found in the top right hand corner of a form.
I navigation buttons that controls open, close etc already set up.
Hi all - I have my DB on a large network with many pc's and I need to set it so it when users open the program, the DB window will automatically "Restore Down" to a height and width I specify. Is there a way to code this in the DB itself? Any ideas would be great. Thanks.
View 2 Replies View Relatedi want to be able to create an On Click Event when pushing a command button that will run an Update query to update a record and after it has been updated that specific record will pop up on a Form and be displayed. i know a different way is to run the Update query and then have it displayed in a Select query but i want it to be displayed on a Form instead. is it possible?
View 4 Replies View RelatedI have a form that using "Query A" as data source. The Form need add (edit) a field value before save that Query Result to another Tabel. Is it possible to do that?
The PROCESS simply like below: Tabel A --> Query A --> Form -->Edit value a field -->Save to Tabel B
if it is possible, are there some requirements that have to be fullfilled?
In my query, i want to automatically display the value of another field from the previous record in a field in my current record. i.e.
Name Value Previous
Record 1 1
Record 2 2 1
Record 3 7 2
Record 4 1 7
Is it possible to create some kind of simple expression to refer to data in another record?
Cheers,
Ben
What is the best way to impliment a query in a form so that the user can view the query records, and have the option to print or save the selected record using command buttons?
I tried subforms but I could not get the command buttons to work in the subform after it went into the form, it wanted to print the entire form instead of the selected record from the subform.
So in a nutshell I have 3-4 queries that are built, and I want to have them show up on my form in a format that the user can scroll through the results and select a single record of the results and then print or save that individual record from the form, if such a thing is possible.
Thanks in advance
Todd
I'm building a report for annual software license renewals. The report data source is a query that combines the customer information, their computer information, and the licenses purchased for that computer. I am having no trouble with the form displaying the customer info page, then a page with the computer info at the top and a list of licenses purchased for that computer underneath.
That would be great, if that's what my boss wanted. However, she wants the whole list of available licenses displayed on each page, in the event someone want to purchase additional licenses with this year's renewal.
I'm trying to figure out how I can set up a query/report grouping to do that. I've tried making a new query, relating the qryLicense!licenseID to the qryPurchase!purchLicense and setting the relationship option to show all records from qryLicense and only those related from qryPurchase. I added the qryPurchase!purchCPU field to my query, hidden it, and set the criteria to “=1” (the computer ID of one of my dummy computer records). I also have a Sum of the qryPurchase!purchQty field included in the new query that I want to display the total number of that particular license purchased (and 0 if there are no corresponding records). All fields except for the quantity field are set to Group By.
What I’m getting from this is simply a list of the licenses purchased for that computer, not the complete list of licenses available showing the quantity purchased where applicable.
Can someone see where I’m going wrong?
Slaughter
slaughter at mizzou dot edu
I have a combo named cbogroup. I have a tblGroup with several records (active, non-active, nursery, etc.). One of the records is *ALL*. Using the CboGroup the user can pick any of the records. Howeverr, if they pick the *ALL* record, I want the query to pull up animalID based on all records in the TblGroup. If another record is picked (i.e. nursery), then the query will pull up only animalIDs that are in the 'Nursery'.Can I put a (iff then) in a query in order to differentiate a query based on all group records or a query based on only one record?
View 14 Replies View RelatedThe strSql string should find the record that I have already saved in my admin table and then compare it with combusername, where is my mistake.
Private Sub Command7_Click()
'Dim db As Database
Dim strSql As String
'Set db = CurrentDb()
strSql = "Select adminpass From admin"
If ((Nz(txtpassword, "") = "") Or (Nz(combusername, "") = "")) Then
MsgBox "Please Enter A Valid Access", vbOKOnly, "Error"
ElseIf (txtpassword = "admin" And combusername = strSql) Then
DoCmd.Close acForm, "Secure"
DoCmd.OpenForm "Home"
ElseIf (txtpassword = "user" And combusername = "user") Then
DoCmd.Close acForm, "Secure"
DoCmd.OpenForm "Home"
Else
MsgBox "Wrong Password, Please Try Again", vbOKOnly, "Error"
combusername = ""
txtpassword = ""
combusername.SetFocus
End If
End Sub