I know I can link tables between databases
Can I link queries between databases, or even just export the contents of a query, as formatted, to another database
I've searched the forum, but its like looking for a needle in a haystack, so sorry if I'm missing an appropriate posting.
Hi,
i'm not sure if i'm in the right forum or not, but it is in quries where i am trying to do this.
Basically, due to getting data from 2 different places i have got 2 queries that have got the same field names.
Person Code
Income
Expenditure
There is no overlapping in the person code for the 2 queries, but basically, i want to have just one query that has all the person codes under each other and then the income & expenditure along side these.
i hope you know what i mean.
Hello,
I know there are posts on forums all over the internet on this topic, but it is just one aspect in particular that I would like some simple advice on. I have worked through user-level security suggestions online and made a test back-end database that has a user and a group, named "Developer." All of the privelleges are activated for Developer. Developer is the only user who can access the data of "Table1." I've created an RWOP query that retrieves the data from Table1, Developer is the owner of this query. I've also created a front end and tried to create a link to Table1; which is denied, as I had hoped it would be. My question is this: How should I structure my front-end so that users can retrieve data from this query, but cannot obtain the data using a different front-end?
Thank you very much for any advice you can offer,
Matt
I KNOW I'm making this harder than it needs to be.... I have a union query that pulls from two sales tables. I'm setting up a report where a person can select a manager name, start date, and end date for those union'd sales. I can do all this no problem in the query, but I want to be able to have this information selected on a form, instead of through popups, to bring up the report. How do I link the form information to the query? I can't get the report to show information it "read" from the form. Does that make sense?
Please help!
Hi
I am very new to Access and have been building a database from scratch. It is for inventory management and I have a number of tables, particularly:
1. Stock List
2. Orders (stock coming in)
3. Requisitions (stock going out)
I have created Select Queries for the Orders and Requisitions tables to sum the totals in these tables (i.e. the total number of Pens coming in from all of the orders etc.). These are called StockOrderTotal and StockRequisitionTotal.
I am trying to create a query/report that will allow me list all of the Stock items and the current balance (i.e Orders minus Requisitions) for each item. However, once I add the two queries together (StockOrderTotal and StockRequisitionTotal) the final query/report only lists stock items that are found in both of the underlying tables.
Is there any way that I can tell the query to return all stock items and only list the Order and/or Requisition totals that are in the underlying tables? Sort of like an 'if' statement in Excel, where the value returned will be zero if that particular stock item is not found in the Orders or Requisition tables?
Thanks
Rich
Hi,
Is it possible to link a query in access 2002? It gives me only tables in the menu. Thanks in advance.
Max
When I make a search using a search form, I get a table with the results that match.Can I make a link from this table to a report to display the details of the matching product?One of the reasons I need to do this is because one search may bring up more than one product.
View 1 Replies View RelatedI then have various support queries that group customers based on reason for visit, type of visit etc. I need to be able to link this to my main table so that each customer has a category against them. The issue I have is that some customers will have more than one visit ref, which can also mean they have multiple reason for visits. I need to make sure that when I link my queries back to the main table that the right category appears against the customer and their correct visit ref.
View 1 Replies View RelatedHelp! I'm designing a database for my A level project at college and I just can't get this one section to work. I've spent alot of time linking things up so that you can't double book one of 4 rooms. It's a booking system for a recording studio. The thing is I have 3 basic packages of equipment and you can only choose one for each booking. The price is diplayed at the bottom of each package. I want to be able to check a box and then I want this price to be added to total price. I cannot link update queries to a check box I've tried every songle way I know. I'm not too familiar with access either :S. One more thing, I want to be able to tick a box which says Discount and then I want this to update the total price field again so it is multiplied by 0.9. I have manage to figure this out in an update query and it is also based on the fact that a band has made a deposit that is bigger than £0.00. I just cannot link it to the form.
If anyone can help it'd be much appreciated, I'm panicking too much over this project.
Hiii All.......
I am new to MSACESS........and i am just trying a small project and having a problem .... when ever i use any table / query in the expression builder of a FORM element...i am getting this error mesg " Automation object table / query not found "..........Should we link the objects of same database in some way ?? R they not connected??...Why is it that form elements r not recognizing tables of same database???...i am trying on this in several ways......but not able to solve this.... :( ....plzzzzzzzz can anyone help me out with this??????
Thankz in Advance
daffodils
i have 2 tables that i am linking on a field that matches with null values on both tables but it either pulls nothing or when i put a right join pulls just one tables data.
i have also confirmed both are pulling from the same data source, so no issues with field properties and confirmed they are null values in each field within both tables.
I have a query that does a great job at fining duplicate master records
How to this query so that it fining duplicate master records like the query show and add one more record that will link up as shown in the example.
[sql]SELECT subqry2.maxdatereferral
,[PSB Accout Linkingqry].master
,[PSB Accout Linkingqry].RecordNumber
,[PSB Accout Linkingqry].FirstName
,[PSB Accout Linkingqry].LastName
[Code] .....
I have a staff rota system that works on a rolling 4 weekly basis. I am using a table to store the shifts of a person dependent on week. I want to be able to tell access that Monday on week 1 corresponds to a certain date and then get access to figure out the rolling system based on that date.
eg Monday 21/7/13 is week 1 (7 days later it knows it is linked to week 2)
This is so if a staff member is off sick I can say they were off sick on the 24th and it will populate their timesheet with the corresponding shift without me having to input it manually. Doable?
I have a query that has 2 fields of currency labour rates (current rate and baseline rate), but sometimes there are some blanks in either of the fields and is causing my text field which has a Sum formula (Rates x Hours) to #ERROR and throws out my other calcs. The only way to find out which blank line items are throwing my query numbers out is to manually type in "Is Null" in the criteria.
However, I would like to keep this process fully automated so I tried to create 2 lots of option buttons for my form, one for each of the 2 fields of currency labour rates and after I click on either option button and then run my query it will show all the lines that have blanks. I was able to link 2 text boxes to the option buttons (Select Case - Case 1 - Me.txtBox1.Value = "Is Null") and then link the text boxes to the criteria field using [Forms]![frm_labour]![txtBox1]. However, none of this seems to be driving my criteria in my query.
i am new to databases and have developed a ads site
when the user registers they can post ads for free.
i would like to allow one user to post more than one add.
these are my databases
[members]
memberid = autonumber (primary key)
username unique
password
surname
firstname
address
post code
country
[ads]
adid autonumber (primary key)
adtitle
price
picture
contact
date posted
end date
i am guessing i will have to create a one to many database but i am lost at how to do it.
any advice would be appreciated.
hello,
I've got a back-end/front-end Access database. The front end sits on a user's desktop. There's one table she needs to update, but cannot because it's not linked. It's table called Login that contains passwords/users names. The table did not exist in the front-end. I would like to copy it from the back-end to the front-end and link it, but when I try to do that, I don't see it in the list of tables. I do this rarely. How does this work exactly?
thanks-
Is there anyway to link an excel spreadsheet to an existing database table - so that entries into either update each
other?
Question for someone..... I was looking at the "LinkTables" in Access..... I see that I can link one database to another..... When I do this I can add the table to my relationship window... I have not played with this too much.. But looks interesting. Now, all the info I might add to this linked table is stored in the other database??? If this linked table is also linked to other tables in the other DB can I use those in queries? Not much covered (that I can find) in the Access help files on this sort of thing.
Thanks
I have a field on my Form. The form holds all the information about Artists under our record label. I need to be able to attach a copy of each artists contract to their separate form. I just found out that you can't physically attach this. Does anyone have any ideas and how I could play this. Any ideas would be well appreciated.
Thanks
Shane
I use a packaged software program at the dealership I work at. In the past I have been able to pull queries and information out of the database and into Excel. The query builder pulls the data as read-only and thus no fear of changing the main database. I have developed an access database for doing commissions. I want to be able to link my database with the companies database as read-only. This would save typing a lot of the duplicate information (ie customer name, date etc.). I have been able to successfully link the 2 databases but realized quickly that anything I change in msaccess will change on the main database. I don't want to corrupt the main database and really only want to pull the information for viewing. Any comments or help would be greatly appreciated.
Thanks
Rob
I have a Form that refers to two Reports, both of which refer to two query's one for each. the whole lot(1 Form, 2 Reports, 2 Querys) is in one mdb file and the actual database is another mdb file. How do I get my objects to get their data from the main Data Base File? the 5 objects are acting as a small report making application.
View 5 Replies View Related:confused: Does anyone know if there is any way to link to seperate databases so that any information entered in one will update the same information in the other and visevirsa?
Thanks
I want to use the data contained in Access table in an Excell app. What is the best way to link them - preferably in 'real time' - is there a way excell can read directly from the tables? We need to analyse some of the data in the database through Excell....
Any suggestions welcomed...?
I am looking to lonk tables in a database.
I have one table a pc tables which has a list of pc's
the other table is a pc software table which has a list of software
i want to build a form to show the pc's and their software how do i do this
I am having a hard time linking some certain information. I think I have my relationships formatted correctly but not all the information is connecting.
For example: I have a form where I am creating a sales quote. In the form I have a combo box where I select my product ID. When I select the product ID, the product name automatically populates but the price does not.
I have attached a screenshot of my relationships. Can someone please look it over and see if anything stands out to you as being incorrectly formatted? Or offer any advise in getting my price to connect to the product ID I enter?
Is it possible to link two combo boxes together e.g. i have combo box 1 with a list of products and combo box 2 with a list of each of the products corresponding product codes. basically if a select a product e.g. football from combo box 1 i want the footballs product code e.g. 001 to be displayed in combo box 2. i hope that makes sense, can any one help, thanks.
View 2 Replies View Related