General :: Database For Metal Market Prices To Be Used In Another Database
Jun 24, 2015
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?
I have made a database of locations. Each location has a subform which lists the "products" at this location. There are only about 5 sorts of product, and these are in a look-up table.
I would like to add the price of these products, so that when I open a different form/report, I can see how much money is spent at each location, etc etc. When I add a new product to the list at the location, the price automatically is logged somewhere on the database. I would also like to add another product, which is delivery. The price shouldn't be visible on the subform of the location form.
The thing that bothers me, is that the database is already filled with data. How can I add these details so that existing products have prices attached to them without exporting and reimporting all the data? There are other linked tables which would suffer.
I've tried to look at the sample databases on Access but I am, sadly, none the wiser.
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 am looking for a way to have different prices saved for each individual client.
I would have one main price list but i want to set certain items to have special prices for different clients. How is this possible in Access in excel its so simple.
I have program that downloads the historical data for over 1000 market stocks i.e. open, close, high, low and volume for the last 3 months.
I would now like to interrogate the data by creating a bunch of queries i.e. 30 day moving average, Moving Average Convergence/Divergence (MACD) and RSI etc.
Does anyone have any examples of doing this please or can you point me in the right direction.
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.
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
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.
I split a database (without first making a copy of it) on my local machine and put the front end on a shared network drive. now no one can open any of the forms since the back end is on my machine.
is there a way to undo this or to split the database on the network drive so that users can get in?
i want to avoid having to redo the database from the ground up.
I was exploring using User-level permissions on databases so I, the admin, can have full permissions to edit/change etc. the database and certain users can only add/edit data. But I inadvertently have now set Access to ask me for a password for any db I open. Even if it's my own personal one. Can I set up Access to only ask for login info on certain db's, not all. I know that 2010 did away with User and group level permissions but was able to add it back through customizing the ribbon and adding this feature back to it.
I have a simple database at the moment which I would like to put onto two laptops. The laptops would be used for entering information when out on a job (no network or email connection).
What I would want to do is have a database on a desktop in the office so when the laptops come back into the office they can update the office database with the information on the laptop database.
I have two third-party library programs that allow you to type in an ISBN and the software searches, say Amazon, and grabs particular missing data: author, cover jpg and summary etc, and imports the info to the program. I'd like to replicate this process with Access. If I can type in an author, title or ISBN to Access, I'd like it to search Amazon to gather and input the missing data to my assigned fields. Is this possible? Or am I stuck to typing in the information separately.
I have a database (Access 2003 and I am using it with Access 2007 with user level security) on shared folder on internal Dell server and I have created a shortcut to each user's machine to access it. This days I am facing a problem of db size as every 10 days it's increasing upto 2gb but the strange thing is when I am doing cut / pasting same database to my desktop from the server shared folder it will become 80 mb only and I am again placing that db (80mb db) into the server and it will work. What is a reason behind it? why my 80mb db is showing 2gb db on server?
See the Main form of attached file, I would like to see contacts list box is made from drop-down list Customers. dependent
In the main form needs to select one customer (for example: Klant1), only the contacts 'de Vries' and 'Van der Linden' can be selected in the combo box of contact (in the main form) .. I do not succeed despite several attempts with macros to achieve this.
