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 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.
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'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 have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.
Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.
I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.
There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?
How to add the IM Gtalk to my database.I have daily queries running and want to send ta IM to some employees when it is done for them to proceed with normal work. Yes you can do it by email, but normally there are so many emails they will miss it.
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 been asked to develop a new application (not using Access).I have the original Access Database and while I can get the data out I was wondering how I can get the images out of the database.
I want my access database to store information about "tests" and "products" that are in each "test". So "tests" is the "one" and "products" is the "many" (each test has many products).My client needs to routinely send me lists of tests and the products that are in each test. I then need to put this information in to my database
I don't want to type out the information they send me, instead I want to devise a simple form for them to complete and email to me (perhaps in excel) that they populate, and I then import/paste in to my database.How should the excel form be structured so that it is both easy for my client to populate and easy for me to import/paste in to my database. e.g. importing lots of test and product information, rather than type it in. Bearing in mind the 1:M structure.
my database lag whenever i start searching, not really bad but i could notice that it blinks whenever i press a key on my keyboard. computer has a big ram (4gb), i5, with 500gb HDD... lots of free space. the database file is only 6.9MB..maybe there is a code that disable or makes the blinking unnoticed?
I have a database (already splitted in FE/BE) which Clients use on site.Part of the service we offer is Outsourcing: We do all the capturing and when they login on their side, it downloads the latest BE file for them to use "Read-Only".
However we added a new module in which half of the data on a particular table needs to be completed by the Client.So we need for the table to be splitted in such a way that they can capture their info on the form and when we log in on our side, it has to download the data they entered in the same way as when they login and download the data we captured.
Was thinking about adding a 3rd database file to the mix with just one table and in some way link that table to the existing table for the new module. But the intermediate link I created is not updateble.
I made a copy of my database named Stores and named it as Purchasing.I did this as they are basically identical except Purchasing has some other tables, forms, etc..When I click on the Debug/ Compile it says Compile Stores, is there a way to change this so it says Compile Purchasing.Without having to create a new database and import everything.
The database: is for tracking computer issues (this part is complete), also I need to show the on call roster (mostly complete)... This will also have a time sheet that I need to be completed once a fortnight, however I would like it to auto populate the staff members logged information (I will get into that a little later).
Question 1: I do not want the users to log into the database, however I do want the database recognise who they are from their windows logon details.
I've been working on a database for the past month and all of a sudden I'm getting an error "the microsoft jet database engine could not find the object 'database'" and when I click ok nothing is showing (i.e. no project window or anything). I normally do backups on something this large but for some reason I didn't on this one. The size of the file is still large but doesn't look like anything is in it.I've tried opening a new one and link and import everything but I get the same error.
Right at the moment i'm baisically designing and building a software licensing management system fro my boss at the moment but I have had a snag, the face that its 3pm on a friday is not helping with my concentration either.
Ok so my problem is that i've got 3 tables (tblUser_Informantion, tblSoftware_Information & tblHardware_Information) all of which are related via a 4th table (tblReference) which holds the primary keys of each of the other 3 tables mentioned. For all intents and purpose's the primary keys are named according to their tables i.e. (User_ID, Software_ID, Hardware_ID, Reference_ID etc...)
On my main form a User can select via a cmbo-box or search for a Person via Surname or search via Machine Asset number. Upon selection this fills a number of pre determinate box's below that containing you typical standard information. However under this is a subform showing what software the user has installed on the machine and on an alternate tab it shows the software license's purchased and assigned to that machine. So far so good.
However I want to create a button in which the user can add software for that particular person in the fields. The user will select the software from a listbox filtered by combo boxes filtering by Software Vendor etc... My problem is that when the user has selected this software title either via double click or an update button i want it to update the tblReference table. So baisically i need this button to grab the User_ID, Software_ID and Hardware_ID and place it in the tblReference table as a new record.
Hopefully i have explained this well enough for people to understand below is a jpg of my current main screen so you can hopefully get a jist of what im trying to say and do. However im open to suggestions if people feel they know a much better way of achieving my goal.. as i sed its friday afternoon and im feeling particulary slow so you'll have to forgive me!
I have developed a new database using Access 2003, which I need to roll out across various users. Some have XP, some Windows 7, and each of them has different size screens. I guess I will have to adjust the various forms to size to a particular users screen resolutions and sizes.
Is there any way of doing this within the database itself, or do I have have to adjust each form according to the local users PC specification?
I'm sure it's not random, but it doesn't seem to follow any sort of rules. My database has become "Read Only" 3 times now causing all workers using the database to stop work until IT can fix the issue. All IT does is kick everyone out of the folder that my db is in and suddenly it is no longer read only.
