How To Create Searchable Database
Oct 10, 2012
I have been tasked with creating a database but I have no previous experience using access. I will be using version 2007. I have to create a database of vendors. These are vendors from all round the world who sell my company different products. So far I have 9 spreadsheets with lists of hundreds of vendors from different sections of the company.
I need to create a database that allows someone to search for a vendor and all the details will appear. The excel sheets have columns for vendor name, country based in, commodity type, address, contact name, phone number, email address and which part of my company use the vendor (an abbreviation). Not all of the information is available for each vendor.
Ideally I would be looking for something with search buttons, filters and the option to just show all vendors.
View Replies
ADVERTISEMENT
Apr 15, 2008
I want to create a database of my employees. I want it to include their name, an assigned number, a list of their certifications in certain areas, and a date certified/expires to go with each certification.
I also want to create a form that displays all this info the same for everybody, like a profile page that just draws the info from the database. I also want to be able to put it online and have someone be able to do a search, type in the assigned number or a name,and have the profile page be displayed. If anyone has any ideas or could help, it would be appreciated.
Thank you
View 2 Replies
View Related
Aug 20, 2007
Is there a way to make an MS Access database searchable and sortable when it is online? I have used asp to display records from a database, but would like to know if there is a way to make it sortable/searchable. For example: If there are 300 records displayed, how to make it so that an online user can sort by certain fields, or search for certain records? It would make it easier for the user to "group" things to suit their needs.
View 6 Replies
View Related
Sep 28, 2012
We have a database that has the records of the artwork that we own. (We are a textile company). This database is used mainly to record any new artwork that we buy and to add information such as size, category, style, etc. We now want to be able to link all the scan images for this artwork to each record in the database. I know how to do one record at a time by linking it to the scan image, but is there a faster way to automatically do it because we have about 13,000 pieces of artwork? Each record has a unique artwork number that we also used to save the scan image and all the scan images are in one folder.
Then once we accomplish this, we need to be able to create a way that the design staff can quickly search the artwork. The goal is for the designer to specify certain parameters, like size, category and style and then have Access provide all the images that follow the parameters.
View 2 Replies
View Related
Nov 25, 2014
I've attempted to attach a Word Doc that shows fields I've labeled (customer, date, application & so on). Is there a way to put all this into an Access Document, and create a database that I could search by customer, or by serial #? I've got about 400 of these, but it's all in folders on paper now, would be much easier to do it in an Access database.
View 11 Replies
View Related
Jan 28, 2005
hi
I'm currently designing a searchable ceramic gallery and have a problem with my SQL querying.
I have the artworks entered in the database as unique entries and have entered the artists forename and surname in separate columns so that they can be seached for by the first letter of their surname.
The problem is that when a user searches for an artist the results return as many results as there are artworks, rather than artists, in other words if 'harry potter' has 20 pots he appears 20 times.
Please can anyone advise me how to best ammend my query so that he appears only once!
View 5 Replies
View Related
Apr 18, 2015
Default Searchable Tagged List...I'm trying to create a list of items that allows me to tag each item with essentially unlimited tags and perhaps a limited number of other fields. Later, I'd like to be able to search that list for specific items by the tags that they have. Finally, I'd like to either export or copy/paste the results.
View 4 Replies
View Related
Jan 24, 2012
I am new to access and i found i am struggling to find out how to print record . I have a table with following field :
Name , Bank Account number , picture
I would like to make a form that can search for specific record suppose search for name and show the result in the form.
That result form can be printed in a report ( report only contain one record from the form ).
View 1 Replies
View Related
Jun 14, 2013
I have a table having fields, Group, Subgroup, Emails.
I want to make a searchable form that asks user to select Group and select sub group. And click on some Export button to export the results in to excel file.
As per my data in table, There are some subgroups in group and many emails in subgroups.
How this can be done in ms access 2010.
View 1 Replies
View Related
Nov 24, 2014
I have a searchable form that display information on agreements other companies have with us. If a company requests an inspection we have 30 days to go out and complete it.
I am trying to create a message box that will display all inspections that are due within 5 days when the form loads. No luck so far, only broken dreams.
Is it possible for message boxes to use expressions and display information that fits the criteria?
View 2 Replies
View Related
Aug 28, 2013
I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
View 1 Replies
View Related
Oct 24, 2013
I created a database with forms, querys, etc. Now I was thinking of creating a exe so everyone can use this database without having access to all the design functions.
the only problem I see about doing this is if we need to use the same database for different project, we need to always create a new exe for each project.
Is there a way to make a empty database exe with just the layout, querys etc but with no data on the tables and have a save, open and save as option. So we can have several projects using the same database?
I was thinking to create a VB code for the database to delete all data on the tables when the database is open.
and before closing the database exporting all the data to a txt file or something.
Then the next time someone opens the database goes to the main form which has a open bottom which imports the txt file into the tables.
This way we can have several txt file for several project and use always the same exe database.
View 4 Replies
View Related
Jul 16, 2007
I need to create a database for students going on work experience.
Each of the students will have a rating from 1-6 depending on behaviour, effort and attainment. Each of the work placements also has a rating from 1-6. Each student chooses 6 work placements that they would like to attend (one of each rating)
If all the data for the students and the workplacements are entered into the system is it possible to match appropriate students to appropriate workplacements using MS Access 2003?
View 1 Replies
View Related
Jul 16, 2005
Hi Friends,
I was wondering if there was a way to log all the modifications made to a database in a table with user name and time of modification. I have been searching this for quite a long time but no use. Please help if you know the solution.
Warm Regards,
Darno
View 9 Replies
View Related
Nov 29, 2005
HI,
I'm trying to create my own database from queries. the queries retreive data from and ODBC data source. How do I create table from query but I don't want any old data from table to be deleted whenever there's a change of data in ODBC data source. I just want to keep pushing in new information without deleting the old ones, even though those old information have been deleted from the ODBC source.
thx guys!:D
View 1 Replies
View Related
Feb 6, 2008
Hello everyone. I am a magician entertainer in Las Vegas. I am trying to create a database that will help me access (pun intended) information in my books and dvds.
I need to be able to search for a specific trick or balloon sculpture from among my vast library.
I have gone through the MS tutorials, but when I actually tried to create the forms--maybe I'm doing it backward-- to input data and retrieve data it just didn't work.
Any help would be welcome. I realize from reading the posts that this is a serious forum and that a newbie question like this can be annoying. I assure you that on the entertainer forum that I post regularly I try to help even the most newbie of questions, so please be kind.
View 4 Replies
View Related
Jul 2, 2015
I have Access 2013, part of office pro, and for some reason it now cannot create a new database, ie nothing is created where i told it to It then comes up with "cannot open a database created with a previous version etc".This is NOT a previous version, it physically does not exist.This did work, well last week.Tried doing an office repair, no differance, tried delting system.mdw.If i click OK on previous message, i do get "Close ole server and restart it outside of access"
View 3 Replies
View Related
May 23, 2005
I have a form which a user selects an activity from a combo box. On some occasions a user may need to enter the same activity a number of times. I want to add a text box/combo box that a user can enter or select a number. When the user hits the submit button i want the records created in the database to match the number specied fied in the text/combo boxes.
I think i may need to use an INSERT statement but totally confused how to do this.
View 6 Replies
View Related
Aug 27, 2014
I want to create a simple database so that I can enter childrens names and then add dates to these that they will be attending our Breakfast Club. Out of this I want to be able to create a daily register of children.
View 2 Replies
View Related
Mar 3, 2012
An ancient application I'm working with came with .ini file which looks like an instruction set to create an access database. A sample few lines look like:
TABLE, USER, 13
FIELD,USRID,LONG,2,NODUP,ID,False,0,AUTO
FIELD,USRFNAME,TEXT, 50, NO, , True, 1
TABLE,VISITS,15
FIELD,VISIT,TEXT,12,NODUP, ID,False, 0
and so on.
Is there a way to get Access (2007 in my case) to create a new db by reading from this file? Or do I need to manually enter all this information.
View 1 Replies
View Related
Apr 12, 2013
I've read instructions for making a multi-user Access 2007 database. Summary is:
1) Split the database
2) Put back-end part of the split onto shared drive
3) Make copy of front-end of the split and give to each user of the database
4) Open Tools, Options, Advanced Tab. Set the default open mode to shared and the default record locking to edited record. While in options area, go to general tab and turn off compact on close and name autocorrect.
These instructions were posted by an Ms-Access MVP.My questions is about step 4. How do these settings get saved to the particular database that I am trying to make multi-user? None of these settings are in the Current Database Tab for Ms-Access 2007. Since they are in the general tab, does that mean all database I open with my copy of Ms-Access will take on these multi-user settings?
View 1 Replies
View Related
Aug 13, 2013
I've been trying to create a search function in my database and a " TmprryQryFrLnkFldsCrtn0123456789 " Query has appeared that I cant alter or change.
View 6 Replies
View Related
Mar 31, 2006
When trying to create an MDE using Access 2002 I get the message
"Microsoft Access was unable to create an MDE database"
The database is split and in Access 2002 format.
Could this be anything to do with References? I say this because I recently downloaded a dll for Redemption to make use of the SafeOutlook Library
Thanks
Oliver
View 2 Replies
View Related
Dec 30, 2005
Hey there, can anyone advise if the following is possible and if so how it might be done?
I have created a site using DWMX04, ASP & ACCESS.
I would like to be able to have some sort of report on what is being searched on the database.
Can this be done in ACCESS or by using ASP?
Any ideas or suggestions would be great.
Mally.
View 3 Replies
View Related
Mar 7, 2006
I can edit/open existing linked tables (to Sage Line 50, v12) but not create new ones.
Following the procedure:
- New
- Link Table
- File Type: ODBC databases ()
Nothing now happens!
I can open the Link Table Manager to update previously created links.
Any ideas?
I'm using MSAccess 2003 on a brand new machine.
View 1 Replies
View Related
Dec 28, 2013
I have a database in MS SQL. The users connect to database via MS ACCES ADP applications.
Some tables (like a TV Station or Names of employees) in the database have fields that serve as the flags. If the flag has a value of one, then such a record is used in the query to create a report.
Because there are multiple users of the database, frequently happens that flags overlap. One user sets the flag to one, and second sets the flag to zero. Therefore, it often happens that the received report incorrect.
View 2 Replies
View Related