Access Lookup Tool
Oct 31, 2006
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
View Replies
ADVERTISEMENT
Aug 2, 2006
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
View 2 Replies
View Related
Apr 4, 2006
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?
View 4 Replies
View Related
Jun 17, 2005
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
View 1 Replies
View Related
May 12, 2005
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
View 2 Replies
View Related
Mar 1, 2006
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.
View 1 Replies
View Related
Apr 13, 2012
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
View 14 Replies
View Related
Mar 24, 2008
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.
View 3 Replies
View Related
Jun 18, 2015
Which third party reporting tool is good to work best with Microsoft Access ?
View 10 Replies
View Related
Jan 30, 2013
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 3 Replies
View Related
Jun 25, 2012
How 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 Related
Aug 29, 2005
Is access better or otherwise at looking up data in numeric form as opposed to text in a parameter query?
View 2 Replies
View Related
Jul 24, 2007
I'm wrestling with the issues; in other threads, it became apparent that because I could not know ahead of time what I will need to know about a given entity, I will use a table to enumerate attributes that is applicable for a given entity.
However, the stumper is that what if an attribute should conform to a set list of values? Since they are dynamic, I would have problem predicting what I will need to be able to lookup, and am even don't know whether I will need a one-many lookup or many-many lookup.
I thought that generic lookup table with a table listing "classes" of lookup would allow me to have one big generic lookup table while using "classes" to act like virtual tables so I can then set the query to appropriate "class" to return just right set of values.
But as I thought about it, I ran into some issues which is pulling me toward the crazy idea that I should have freestanding tables, and use a field in tblAttribute to give me the table's name so I'd know which free-standing table it points to, and have the necessary key to lookup the values within that table.
Even though my gut instincts tell me that I shouldn't be going against the conventions of database design (who the frick goes around creating free-standing lookups?!?), I'm simply not sure how I can use a generic lookup table to hold all information.
For example, suppose I was given a list of values that has its own categories. Since the former design allows only for two level (lookup and lookupclass), where am I to insert that extra level?
Furthermore, I found myself needing a set of virtual keys to reference a certain "class" of lookups for report purposes. That means I need an extra field in my lookup table than I originally anticipates. What if I find myself needing one more field that just won't fit the generic lookup table?
So does anyone have suggestions on how we would create a placeholder for a lookup table that will be made just in time?
View 4 Replies
View Related
Jan 3, 2006
Does anyone have a Jet to ANSI SQL conversion tool they could either send me or recommend:confused:
View 2 Replies
View Related
Apr 18, 2008
I want to know how to count the number of records come up for a query
but it keeps coming up like this:
http://img156.imageshack.us/img156/5150/88274572ke4.jpg
This is how i have it now:
http://img245.imageshack.us/img245/5117/98426599lq9.jpg
View 8 Replies
View Related
Apr 20, 2005
I have a form with a check box control on it and a pick list text box.
What I looking for is when the user checks the check box, I want to display a message or tool tip to inform the user to ensure that the correct membeship type has been selected from the pick list, (this has a default setting) so can accept the default in this field.
I am trying to aviod the user having to press a button on a message box to continue. it would be useful if it could be display for a preiod of time.
regards
View 2 Replies
View Related
May 14, 2006
Hi all,
I found this search tool example on this forum which works for my situation. Can someone tell me what changes I need to make so it works with my date field. When I search for data based on Last Name, First Name, or Account # the records appear fine, but when I click on one of the records I get this error message. " Could not locate [8/1/2005]". I would actually like to be able to search by the date field also. Can someone help me modify the database to accomplish this task. Thanks in advance.
View 2 Replies
View Related
Jun 15, 2007
Hi, I have a very simple database with 2 tables:
table: animals
1. Cat NA
2. Dog NA
3. Rat NA
4. Bat NA
5. Garfield NA
table: felines
1. Cat
2. Garfield
3. Simba
what I want to do is:
UPDATE animals.field3 (which starts off as NA's) to "meow" if animals.field2 matches any item in felines.field2.
it is a recursive operation and I'm not sure how to do it
here is what the animals table should look like if the UPDATE query runs as it should
1. Cat Meow
2. Dog NA
3. Rat NA
4. Bat NA
5. Garfield Meow
Any help would be great! I prefer SQL view of the UPDATE query if anyone knows how to do this. Note: I like cats and dogs equally, this is just to learn how to do such an update.
Sasi
View 2 Replies
View Related
Nov 16, 2011
I am trying replicate the northwind web database macro called getproductname getproductlist which is on the products table. this macro has a simple lookup action which looks up a record by a parameter being sent.
the customer order form has a productid combo box. on its after update it finds the product list. this UI macro just passess the product id to the data macro on the table and looks up the price for that id. then sets the value on the form. simple right? however i consistently get an error from the data macro on the table which says the "the identifier (enter field name here) could not be found"
in my case im selecting id and productname from my table. the syntax is correct. but when i run the macro i get "the identifier productname could not be found. ive been struggling with this for hours. and im using a working sample as an example.
View 2 Replies
View Related
Sep 16, 2014
I have created a database with a list of product codes, pricing, costs, and supplier name. Now I have about 100 product codes which I would like to look up for all those information. Is there an effective way to do it in Access? I know I could export the whole datasheet to Excel to do a vLookup, but it may be lots of waiting time if the data are massive.
View 2 Replies
View Related
Apr 20, 2006
please see attachment.
I created a small database to help explain my issue.
When I click on the check box in box 1(train), the text box turns blue...great...and even better the other records stay clear when I scroll down, which is what I want to happen.
But when I scroll back up, from dog to train, the blue in the train box has gone- not what I want!
I would like the blue to stay in every box that I click on. Any ideas?
Thanks,
J
View 3 Replies
View Related
Aug 30, 2005
If I wanted to build a database in Access can I make my own file bar. Let's say that I wanted to build a gun inventory but wanted the tool bar at the top to have the specific files I want people to click on. How is this done? Is it done with another program used as a developer with Access database? Hope this makes sense.
View 6 Replies
View Related
Sep 27, 2005
I can't use the menu TOOLS because it is deactivate for all mdb.
Is it deactivated from portion of VBA code?
How Can I restore this menu?
By Francy
View 3 Replies
View Related
Feb 21, 2008
We have a nasty number of access databases spread around our network and linked to each other like a giant spiderweb.
I can easily open an database and using linked table manager find out what is attached and from where.
I need some sort of tool that will tell me where a table is linked to.
IE - you have a master database that holds the data. You have several other databases that are linked to the master data and run queries, reports etc. I need to find out where the master data is used.
Any ideas?
View 2 Replies
View Related
Jan 4, 2007
Hi All,
Would anyone be willing to somewhat guide me through the cool search tool because coding isn't my speciality.
Thank you in advance.
Josh
View 4 Replies
View Related
Nov 19, 2004
Hi all,
I want to display data from a database I have in MS Access. Any ideas on what sort of tool I can use to display the data locally? Can I get a free VB dev tool anywhere?
Access's reports and data access pages just aren't flexible enough for me. I know ASP and SQL well, but I don't want this database to be stored on our server.
Thanks for any feedback.
View 1 Replies
View Related
