General :: Grabbing Web Information Into Database?
May 17, 2015
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.
Hopefully this is an easy one. I've got a table with (for example) a list of books sold (field 1) and the price they each sold for (field 2). There are duplicates in both field 1 and field 2. I'd like to create a new table that has each book's name exactly once, and the maximum value it sold for. How can I do that?
Not sure if this is possible but I have in my db a linked ODBC connection to a table. I use a Oracle 8 login to access the linked table. My question is can I capture the user login in ID somewhere in my table to show who is logged in? Thanks...
I was able to create a very user-friendly pop-up search form : {URL] .....
I would like to take it a step further... Now, I would like to grab the selected record ID from within one of the list box columns and use it in my SQL statement (to copy the record into a new one). Is there any way to reference a highlighted record value within a list box recordset directly and/or any workarounds?
I know one would be to grab the ID and insert it into the text box, just don't know what the coding references would be for this.
I have a report that is generated daily that is a TXT file that is also the has the same file name each morning. One section out of this file is needed in a database that compiles and sends out reports to our customers. This section of the TXT file is variable in length, but is always preceded and ends with a specific text string that I can search for. It is also formatted in columns that are always the same width.
I currently have to hand enter this section into the database every morning. Not the easiest of tasks... I would like to get this automated.
In my database I have 4 tables for a small painting and decorating business.
These are: tblCustomers, tblOrders, tblStock, tblPayments.
I have a form based on tblOrders to add new orders when they come in from customers.
In this form there are 3 important fields: "CustomerID" (Lookup to tblCustomers), "StockID" (Lookup to tblStock) and Quantity (Entered by user).
However, I want a calculated field that will be worked out automatically when the user is entering these details. The calculated field should go to tblStock and grab the "Cost" field.
However the main problem is specifying what price it will grab from the table. I want it to get the "Cost" where "StockID" = (the stock ID selected in the lookup). I then want to multiply the price by the quantity which the user has entered.
The control source should be worded something like: = ([tblStock]![Cost] where [StockID] = StockID)*Quantity
but that isn't valid.
Could anyone point me to a piece of VBA or some way to get around my problem? Many thanks for any help, Stephen
I can't find any info on this error through google, so i'm not sure what step to take next. Any advice would be great, I'm willing to try out other databases (obviously retyping the data would be a pain in the arm but if it works its worth it)
I am brand new to Access. I know a fair amount about excel. However I think Access may provide a better platform for what I am looking to do. With that being said i have some questions.
I am looking to create a database. However this database will very seldomly have new information added. Information may be updated here or there. Most of what i have researched uses access to create a database that will constantly have new info added.
What i am looking to do is to create a database that will have drop downs that merely link to other "databases" to view.
Example: I have have a database in excel that has one main interface. when you click on a cell it takes you to a new worksheet with multiple entries that fall under that group. and repeats itself. each cell on this page will is linked to another worksheet.
Lets say these groups are named; 1,2,3,4. Any time you click on on of these, it takes you to a new worksheet that has info for each group. Once on the new worksheet, it will give you the drop downs for these values and if one is selected it will take you to the new worksheet (show the new info) once again.
Hi I am in the process of designing a new database using Access 2003 for my company. I have very little knowledge of access and what knowledge I do have is self taught!
The database is to hold medical records about patients that we see (we run a small medical centre)
The information that we put on it will include the patients personal details (name address etc..) and also details about treatments given to them.
Could anyone give me some advice on what type of database sounds best for this type of information. At the moment the database will only be used in the medical centre but will be accessed by more than one person at a time (not sure if that is relevant !
I really would appriciate some advice as some of you guys have helped me before and i value your opinions.
I am totally new to access and i want to be able to extract information from my database using a form. Basically I am using the database to generate a bill of materials. I have a product that has many different options. SO I want ot select a checkbox on a form for a particular option and hten have that extract the correct data from the DB into a report or spreadsheet.
My boss wants me to program in visual basic, instead of using queries, a calculation between times, which values are gotten from a table. How do I perform a calculation between two fields from a table in code and what functions are there to calculate the amount of difference in minutes between times in visual basic? THANK YOU SO MUCH IN ADVANCE!
I have not developed a database application before. At my work I was seconded to fill in as a team lead for a change management team. We are in a production environment and need to track the progress of product improvements. The current system is very complicated using an enormous Excel spreadsheet and a very bid MSProject schedule. It is very handraulic in the way it is maintained.
Before I started I reviewed who inputs data, who uses the data, and what metrics are reported. I can reduce the amount of data that is recorded by only generating many of the existing Excel fields through calculation run when a report is generated or a chart populated.
I need to track the state of several hundred minor changes through the production run. The reference data I need to store is serial number against production batch. This is fixed data that is not changed, only used as to show the entry point of a change into the production line and which serial numbers the change is applied to.
I a a new user to Access having only every ceate a couple of small databases using the wizards. I have just started a database where I have created my tables and I am now creating a form to display information. The problem that I am having is that when in Design mode I can see all the information and fields that I have used to create the form, however when i save the form then opening in display mode I do not see any of the fields, revert back to design mode and hey are all there.
I am using Access 2010. I have a database that on a form uses a multiselect listbox. That part works just fine. The list box is for selecting additional people to email. Now I have had no luck with returning just the email address that are in a hidden column (the persons actual name is seen and "selected"). The names come from a separate table and is used as a forgien key. On that same table are the indivuals email addresses. What I did was loop through to get all of the ID numbers I am getting from the list box (the ID numbers are stored in the table that the form is based on).
Once I have all of the ID Numbers I thought that maybe there was a way to retrieve all of the email address associated with the ID Numbers. This is what I have so far. I know that AllQuery returns the first email address from the list box. I just have no idea if the query is returning more than one record, or if it is how to then go to the next record. I have tried a few things with little to no success.
Code: Dim ListItem As Variant Dim AllItems As String Dim AllQuery As String For Each ListItem In Me.EmailAdditionEgineers.ItemsSelected AllItems = AllItems & Me.EmailAdditionEgineers.ItemData(ListItem) & " or " Next ListItem AllItems = Left(AllItems, Len(AllItems) - 3) AllQuery = DLookup("EmailAddress", "AdditionalEmailRequestQuery", "[ID] = " & AllItems) & ";"
I see a lot of requests for this operation, but apparently .DB files are so general that sometimes it's impossible? Any all-encompassing program that can read files like this? I believe they come in different formats and are produced by a variety of different programs. The only thing I ever see though are files with [.db] as the extension.
If I open the one I have with notepad on a windows machine I see some of the info but some of it is not there and is garbled.
setup a data base in Access that collects information from the attached spreadsheet pictures from A1:FO26...Spreadsheet is macro enabled and updates automatically with data.have tried to setup Access data base but when Excel Tab updates it copies over the data that was last copied into Access.
I have created a form and a subform within it, I have managed to populate all the dropdown boxes from the tables I need. but I need to save all the information in putted to a table called bookingstbl and I do not know where to begin?
I downloaded a student template from microsoft and have been able to figure out most of it. I cannot see where to enter the emergency contact information. Also, when I try to see the student and guardian table/list, the guardian list comes up empty even though I entered this information when I entered the student info...
I have a field "Permit_Date_Expired" field automatically is created by adding one year to the "Permit_Date_Issued" field.
when the "Permit_Date_Expired" field exceeds TODAYS() date I want it to automatically change the field "Permit_Holder" to say Expired is this possible?
Using a combo box in the form "product details" I select a "part number " of which the part number and the associated description of the part comes into a fields called "part number " and "part description "
The part number selected then goes into a table called product details
Is it possible that when I select the part number , both the part number and the part description go into the table called product details.
I have a database where on the form we are just put in total deductions. We want to make sure that the total deductions is correct so while we are entering this number we want to do an excel thing by hitting = 1 + 1. Anytime we do that we are getting an error message. I really didn't want to have to set up a table to store these different amounts because we really only need the total. Is there a way to do that? I changed the format from currency to general but I'm still getting the error.
I am having a problem with retrieving the information I am looking for. Basically I am checking to see if a user has selected a TRNumber from a drop down menu and if that TRNumber matches any other records in the table in that field. If it does, is that Number already associated with the user selecting it. If it is I want to get the ID number so I can simply update the record with new information. Here is what I have so far.
Code: Dim Rs As DAO.Recordset Dim Tech As String Dim MsgStr As String Dim IdMod As String Set Rs = CurrentDb.OpenRecordset("PrepStartDateBlankQuery")
Does anyone know how I can create a form which asks for the name or lastname of the customer and does a search throuout the database and brings up all that customers informtation. And if their is more than one thats are the same you can switch through them untill you find the right one.
