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.
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
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.
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.
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.
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!
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.
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.
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?
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!
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.
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?
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.
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.
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.
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"
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.
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.
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
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?
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.
