Using Access 2010.I purposely disabled the Access Objects to open when the database opens of fear of someone messing with my data. This works. The problem I'm having is when I use the print button (access macro) on one of my forms, as soon as i click the button, the "all access objects" window opens on the left side navigation.Is there a setting that will permanately stop this from opening?
View RepliesUsing Access 2010.I purposely disabled the Access Objects when opening my database for added security. This works.
The problem I'm having is when I use the print button (access macro) on one of my forms, as soon as i click the button, the "all access objects" window opens on the left side navigation. This window shows all of my tables, forms, queires..etc.Is there a setting that will permanately stop this from opening?
I am using Access Runtime for the database for the staff however some reports have print options at the top of report previews and some don't and I can't figure out why..All the buttons and properties seem to be the same as the ones that are working.
View 7 Replies View RelatedHow can I get a form to open when the database opens?
View 5 Replies View RelatedA form that used to automatically open when the db was launched has been deleted. However, the instruction to load the form is still in the db. I would like to remove that instruction, but I can't seem to find where to look for that code. In Access 2007, I went on DB to the Database tool menu, but its not in the switchboard manager.
View 3 Replies View RelatedHi,
I've been given an existing database to modify, and I'm struggling somewhat to see how the author has implemented certain functions.
On a main menu form (autoexecs on starting the database), there are various "Search By" option buttons to generate a report, ordered in various ways. The "On Click" field for each of them refers to a macro, called Buttons, and a line in that macro dependant on the type of search (e.g. OnClick = Buttons.byPerson).
The Buttons macro runs an OpenReport command, the report corresponding to the search type (e.g. Buttons.byPerson has an OpenReport command for the "Report by Person" report).
However, when I click the search buttons (or indeed run the corresponding reports) I instead get another form which allows the search criteria to be specified - this then generates the report (I would assume based on the relevant query - e.g. Person Query), but I cannot understand how this works.
Google searches have not helped much as I can't seem to find an adequate search phrase to use, and I've been staring at the thing for some hours now. Any help getting me off in the right direction would be much appreciated!
I have a database which I can not get to the normal tool bar to change the permissions on.
The startup was set to not display this. I need to modify the security on a form.
Help please.
Thanks
Hey there,
I am wondering if there is somekind of tool that can be used in access that can run and locate any queries that are redundant and not used within a system. Also if there is any kind of tool that can be run that identifies fields that are in tables that are also not used in the application!
Not sure if such software exists but thought id ask before i manually begin to go through the application, this is all done to be done before normalisation of the application data and upgrade of the system
Thanks in advance
Jas
I have a research project. I need to capture numerical values from a scroll bar into a table so they can be used to produce excel charts. I can capture the data no problem, my problem is how to present it in a user friendly format - a form.
I have to capture the following data via a form for each research respondent:
Name
Age
Sex
Occupation
Each respondent is then asked to rank five brands against seven different attributes. In format terms, my researcher wants to display one attribute at the top of a page with five brands listed underneath with the slider beside each brand. For example:
"The Worst IT Information" is the attribute at the page top
"Microsoft" is the brand, with a slider beside it so the resondent can select how much they associate/rank this attribute with Microsoft.
"Adobe" is the second brand with slider
"PaintShop Pro" is the third brand with slider
"Corel" is the fourth brand with slider
"Sage" is the fifth brand with slider
The same respondent then clicks to the next page which has a new attribute at the top, but with the same five brands underneath to rank the attribute against.
eg "full of bugs" is the attribute at the page top
brands and sliders are all as above
There are seven pages in all. At the end of the data collection I need to be able to find the average ranking for each brand against each attribute and apply the demographic information, for example
Microsoft had an average ranking of 7 out of 10 against the attribute "Worst IT INformation" against women 30Plus.
I can't figure out how to do this without collecting the information into tables called PageOne, PageTwo, PageThree, PageFour, PageFive, PageSix, Page Seven and using fields like: brand 1 (text), brand 1 (value), brand 2, (text) brand 2, (value). This seems to fly in the face of how you would normally create a table and will require queries to add together all the values gathered using different fields.
Does anyone have any suggestions on where I might be going wrong?
Hi guys. I want create a tool bar menue in access 2000 that is linked to indvidule forms in my access but i do not know how i to do it. Just like internet explorer tool bar menue that has file edit view ... and u can click and a drop down list comes and u can select one and ....
I want make such menue in access that each drop down list item from menue is linked to form and once it is selected that a perticuler form loads. I be happy if some one show me how to make such tool bar menue.(i want it the menue loads once i click on the mdb file).Thanks
Have you guys ever used this scheduling tool from FMS Software that will do a nightly archive and compact/repair.
I tried it out on our live database (not so smart I guess) on a Friday and when I came in Monay it was corrupted. It seems to point to the FMS software corrupting my db.
I wanted to validate and use this software but ain't sure it I will now.
I like the nightly compact/repair. Is there another way to do that with Windows Scheduling or something?
Take a look:
http://www.fmsinc.com/Products/Agent/index.html
Our organization (a University) has been engaged in becoming "paperless."
As part of that initiative, we have spent the past several months scanning several hundred thousand pages of documents relating to building systems (HVAC, e.g.) as well a a massive quantity of detailed lead and asbestos surveys and abatement records.
The initiative is indeed reducing the quanity of paper stored in binders and file cabinets, however now it is becomming evident that retrieving some of that information is a real problem for some folks.
At a meeting this morning a question arose about whether we could develop an Access application to retrieve the documents (which are very logically filed on a network share, but it seems to be beyond the compreshension of some staff how to actually navigate through the maze).
My question is this: has anyone in this forum ever tried to implement such a solution with Access?
Any advice or insight would be very much appreciated.
Thanks in advance.
I want to create a data base with only one table. The user will be able to add a new line with a tool (several text boxes to fill the blanks).
One the same panel, I want to display the tool, the table and some other functions (like the sum of a column, or print the table).
I think this very easy to do this (only one table). Yon can see on attachment a powerpoint draft of the panel.
For the moment, I have already created the access table and put it into my panel.
DRAFT BASE PROJECT AMS IPD.pdf
I have a Lost/Found property database which we use to keep record of the lost/found property and it is working fine.
As per our organization's policy, we keep the item(s) for up to three months in which if it gets restored to the owner then fair enough otherwise after three months the item(s) can be claimed by the "Finder". But for this very purpose we issue the Finder with a "Claim Receipt" which he/she should bring in when claiming for the item(s) after three months period. Therefore, It's just the right time to upgrade the database to a more professional level.
The database has one table and two forms.
One form (LostFoundForm) is visible to the user in which they enter data, this form has two sections; Item(s) & Finder's details and the second section is about Restoring details.
However the second form (ClaimReceiptForm) is hidden to the users (for manual data entry) and has only one section which is exactly the same as the first form's first section, i.e., Item(s) & Finder's details. This second form takes the data automatically from the first form because the table behind them is same and fields are same (please see attachment). Up to here it's all working fine.
I would like to introduce a Checkbox or a CommandButton in the LostFoundForm which when we click should pull up a msgbox asking "Do you want to print the receipt for this item(s)?" with a Yes/No option. On clicking "No" it should, obviously, settle down but on clicking "Yes" it should print the "corresponding record" from the ClaimReceiptForm.
hi,
i have to create one Master Data transformation tool use Microsoft access. The input file and output file of this tool are excel spreadsheet. There are 2 levels of the data transformation, first level is data mapping and validation on the raw data, second level is data update on the field value.
My question can someone show me step by step how to build this tools using access and read from excell.
Which third party reporting tool is good to work best with Microsoft Access ?
View 10 Replies View RelatedHow many records does MS Access 2003 hold, i.e. is there a limitation & what is it?The toolbox greys out after being selected on the Menu options even though Tools/Startup/allow built-in toolbars is selected - how to activate the toolbox in 2003 version?
View 1 Replies View RelatedWhen printing a form (record) in Access 2007??????? When I go to print preview the form displays (and wants to print) every record!!!! How do i get only ONE record to display and print..
View 1 Replies View RelatedI have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
When one user opens his ACCESS file, it opens in Notepad. He uses ACCESS 2003.
Now he has to right click on that file (on windows explorer) and select open with 'MS Access' to make it to work.
Any one knows how this setting can be changed to open with MS ACCESS?
I have a pesudo forum running on a server which sends emails automatically to a group to indicate that there is a new posting - much like any forum...
I would like to include a link in the email (automatically) that will open the Access Forum and point directly to the relevant post...
I searched the forum but was surprised to find that this question hasn't been raised before... so I'm worried? :p
I know I will get a hundred links from the Mighty Moderators now saying I didn't look properly - as my old mother used to say :rolleyes:
Dave Eyley
I have a couple charts that I would like to show on my switchboard. Right now I only have one that is up everytime I open my database. Is there anyway to have it do a random Sub form show up everytime you open the database up? Thank you for your help. Without this forum I would have shot myself a long time ago!
View 1 Replies View RelatedI was wondering is anyone could help me with a problem thats been vexing me all day..
I have an Access database that has a number of Word documents stored as OLE objects. What I need to do now is create a macro within Word which, based on a few parameters, retreives these Word Docs from access and formats them into a completed document. The ordering and formating bits fine, where I'm stuck is getting at the OLE objects.
Can anyone give any advice on a possible solution?
Thanks, D
Hello Ladies & Gentlemen,
I was trying to access this particular MS-ACCESS file which serves as a DB for a software. But the file opens and closes in a split of a second and was impossible to view its structure. :mad:
I beleive it's made to respond so by the programmers in order to hide the content. Can anyone please help me open this file? PLEASE...
Teddo
Any ideas on how I can get a list of the names of the queries and tables within a different database?
For example, from db1 I want to get a list of the names of the queries and tables within db2.
Thanks!
I am doing bug and enhancement development for an existing Access Application.
Periodically (after testing) I need to take my changed objects and export them to the production database.
My problems are:
1. Is there any easy way to tell which objects have been changed (is there any flag I can set at the beginning of a development cycle and then check to see which objects have been changed)
2. When exporting these objects they don't replace the existing objects in the Production Database they add a new object with the number "1" appended. If there was a form called "fCustomer Input" I end up with a new form called "fCustomer Input1"
This problem must come up with other development efforts.
Help
Thanks