Hi.
I lost a bunch of menu option sin my MS Access. In the Tools menu, almost everything is disabled (including Options) and in Add-Ins, all I have is the Add-In manager -and it doesn't seem to work as I readded all the add-ins and there ain't there.
I tried repairing, uninstalling and reinstalling Access from MS Office 2003 but I still have the same issue...
Is there a way to reset to orginial config?
Thanks,
Ben
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
I recently had MS Access 2003 installed on my PC. When I open it up, I get the iconic menu bar, but not the text menu bar. Can anyone tell me how to make the menu come back.
View 1 Replies View RelatedI'd like to disable the options to see the table or query design - and control other thing the user can or can't see.
How can I do that?
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 RelatedHi
I was wondering if any one could help me.
I have a database at work with 5500 records, how ever the first 1000 have been lost. There remains records for each customer but the first 1000 records showing what they ordered have disapeared.
I have back ups of the database going back with the first 1000 records complete.
How would i take the 1000 records and add this to the current database where the information is missing? so it wouldnt mess up recent records?
could some one provide me with a step by step account. Would be much appreciated!
Many thanks
Can someone point me in the right direction?
I have added a popup menu to my form to reduce the number of buttons needed. I would some of the options only available in the add or edit mode. Because its not a traditional button i dont think conditional formatting applies. Can someone give me a hint where I should be heading?
How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.
View 3 Replies View RelatedI have created a front end and put into production for my users but I want to reduce the amount of menu bar options they see so someone cant click on a button wondering what it does and mess something up. What is the best way to reduce the amount of options a user sees on the menu bars when they open the front end of the db?
View 1 Replies View RelatedI'm using Access 2007, with what I think is a normal database that I've built up over the past month (maybe 15 tables, <1000 records, 20 queries, 4 or 5 reports and macros). I'm not an experienced Access programmer, so I don't think I'm doing anything fancy with security settings or any other such stuff. (If I have, it's surely by accident, not by intent.)
When I try to back up the db using the simple office button -> manage -> backup method, access generates a date-stamped backup filename and opens a file save dialog for me, but it ALWAYS fails to backup the database. I always get the same error message when I click save, whether I save on my machine, or on a network drive.
"Could not use '<path to the current database dir><backname>.accdb; file already in use."
This same error occurs when I create a new blank database with a single Table1 in it, so I don't think it's my database.
Does anyone have any idea why this might be happening? I scoured the net for help, but nothing. I checked various Access forums, but nothing. So I arrive here after I've done my homework... thanks
You veterans have probably heard these questions many times, I've had a search around but couldn't find quite what i was after.
This is my first database.
I have 2 tables, one for customer details, and the other is products (holiday packages)
I have made a product form for staff to input new holiday packages. And for the customer form this is also the order form, so a staff member picks up the phone and gets customer details, name, ph, etc and then asks what holiday package they want. I want this to be a drop down list that always fetches all the packages availiable form the product table and when you choose a package it shows all the details on that package.
I need this all to be on the 1 form, if the staff member has to swap back and forth between customer form and product form to get info on a product this will severly hamper productivity.
If my question is abit hard to understand i can take screen shots of my tables/forms to get a better idea. And if someone can really help me finish this database off i'll pay them somethign for there trouble.
Regards, Chris.
I need to update data in a bunch of tables of a sql server database. The database has 300 tables which I have linked via odbc. I'm hoping there is a simple way, using vba, to loop through my linked sql server tables and determine which of them are views as opposed to tables.
View 1 Replies View RelatedHi 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!
i have just had a problem
if i try to edit an open form by clicking the design icon, i get a message
cant find the call back function or macro "fdesign". ican still close the form and open it from the dbs window
this is affecting accessXP and access20003, but not A97
ive tried repairing/reinstalling the XP installation (but not the 2003 yet), but this has not fixed it.
Any thoughts?
I have a table and it has:
namefield
surnamefield
state1
state2
state3
match(Y or No)
importDate
I would like to make a query+ report so that in the report it looks like this:
<<Name>> <<Surname>>
<<state1>> <match>
<<state2>> <match>
<<state3>> <match>
in one line, at the moment I made a query and the name shows 3 times...
can anyone here give me some hints how to show the name once + the match. Thanks in advance
Cheers...
I am new to using MS Access and am already frustrated that a simple task is getting the better of me.
My situation is that I work for a company that has a number of reps, which are allocated their own ticket books(block). Each book is 50 tickets in size i.e say from number 320500 to 320549. All tickets are entered through our internal system for whatever the ticket was used for.
Now here is my problem. Each block is registered to an individual rep which we need to keep record of as to which tickets are allocated to them, other then having to enter each ticket individually into our ticket block records system, I am trying to make a database entry that accepts the reps name, ticket block start number and then automatically adds the next 50 tickets to that rep, so when we use a search field on any ticket it displays the rep that the ticket was allocated too.
In my head i'm looking for the MS Access way of doing the following:
[tickblockstart]+1 until [ticketblockstart] = [ticketblockstart]+50
Can anyone help me with this probably very easy problem, that i can not seem to grasp at the present time.
Regards
2rsGarry
hiya, im trying to create a button my form that will move all 'finished' records from where they presently are, to another table.
the button does work, it moves the records into the 'new' table, however it does not DELETE them from the table i moved them from, so now the records are stored in two tables??
the code i have is as follows:
SELECT * INTO Table2
FROM Table1
WHERE Finished='Yes';
if there is something different that i should be doing, or a better way to do this move, please let me know.
(also if this is in the wrong section feel free to move it)
thanks!
:confused: Fingers crossed I'll get some direction to resolve an issue that I can't even begin to imagine how to search for.My database is used to record detailed work done with clients who are receiving regular support. I'm designing it around a Common Assessment Support Framework that I have no choice but to follow, except for some minor points. There is the potential for approximately 40 different assessments for each client and therefore a lot of duplication in personal details.So far this forum has been a great help and I have learned a lot from those who volunteer their time to those of us who need it from time to time.Following the numerous examples of normalisation posts I have attempted to ensure there is no duplication of information across tables. I've come to a point however where I am stuck:The end result of what I am trying to do is create an individual report called Needs Assessment Planning Tool - rptNAPT.The report will be populated from the fields in qryNAPT that is made up from tblIA1 and tblIA2tblIA1 consists of 17 x 'area of need' that is broken down in to 5 elements: 'Now - Y/N', 'Later - Y/N', 'User Level - Number', 'Worker Level - Number' and 'Disagreement - Memo'. These fields are entered by using frmIA1, and these fields are entered by using frmIA2.So, now I have to enter data in to another form; frmNAPT that includes both theseand thesefields. I only need to show the area of need where Now is True in the form and the subsequent report; rptNAPT.My thoughts about this are (please don't laugh) in the form frmNAPT the 'Area of Need' because in the table there are 17 different areas e.g. Accommodation (improvement), Homelessness, DomesticViolence etc will need to be unbound and in some way filtered to show only those area of need where fldNow is True? and fldUserLevel is NotNull or doesn't equal zero. I will need a minimum of five such fields to show the Areas of Need that the Client and Worker may elect to work on.Sorry for the long post but I'd really appreciate some direction on this, even if it is only to point me in the direction of a link that can be helpful.RegardsDoug
View 5 Replies View RelatedOk, 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!
:)
I created a DB in an old PC of mine for a customer. I set passwords for user accounts to prevent users from accessing the design etc. I bought a new PC lately and I want to open the DB to work in it but I get an error saying that I do not have the rights. I suppose I need to create the same accounts in my new PC as in the old one but I don't remember the username or password that I was using back then. Any Ideas???
View 4 Replies View RelatedWe have lost an MDB file. Is there a log file where command calls to Access are stored so we can try and recreate the database?
View 1 Replies View RelatedMy database queries, tables, and reports is growing. Is there a function/utility that will show me for a particular report what queries, and tables that are used to gather the data that populates the report?
Thanks!
Gunner...:confused:
I'm completely lost on how to get started on security. After reading all these postings I'm more lost then ever. What is a backend and frontend security? How do you create password for each users? etc...
Please help!
FYI I'm using Access 2003
Good morning friends
My database, I don't know what happend to it.
I'm trying to open it but it gives me a message:
"The form name 'Welcome Screen' is misspelled or refers to a form that dosen't exist' If the the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and enter the correct form name."
and then after I click ok it open the database but it doesn't show my forms, Reports, Macros or Modules that I have created before.
what does it mean, may I lost all my previous work and data ??? :(:(:(
Please I'm waiting you ... I'm about to lose my mind
I have been trying to figure out comboboxes and lookup tables on and off for two weeks now and am completly lost. I have read the tutorial on cascading combos. I have downloaded and studied the the autofill db example from Pat Hartman. I have searched and read the threads and am still having a problem. I have several lookup tables. I will use one as example. This a database for my lawfirm. We get a lot of referrals from other attorneys. I have a lookup table with the name, address and phone of all attorneys. I have a combobox on my clientinfo form that looks up the atty info . I put the attorneyid field in my clientinfo table as FK and linked my clientinfo table to the attorney table thru this field. All this did was generate an error message that I could not save my record because there was no corresponding Atty record. I know this should be so simple. Can someone please help me? What do I with data I have lokked yup from a lookup table and how do I link it to the tables that will need it later on? Thank you in advance.
View 2 Replies View RelatedGood afternoon all,
Really struggling with my structure and have been looking at it for so long my head hurts so any advice would be great. (see attached)
Basically, I want a DB for keeping track of service / repair of electronic machines. Many of our customers also call us for tech support. There are a number of other items like purchases but once I have worked out one, I can then copy the methods.
Are my relationships even remotely correct?
I cannot get the calls log to work - loosly based on the sample a supplied with Access "contact managment".
:confused:
Any help / advise would be greatly received