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-
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.
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 RelatedI have a table with job info like: job #, job name, job addy.
I would like my end query to look like this: job #, job name, job notes.
I want the query to list all jobs, job names, and job notes for a particular week(we have a weekly meeting on the status of our jobs), so if I were to query the jobs for 6/26, i would get: job #, job name, and job notes for that date as fields in my query.
I am not sure how to accomplish this. Should I make a seperate table that contains job notes? If so, how would I accomplish this and create a relationship between the job info table and the job notes table?
Thanks in advance!
Please please please help me!!
Firstly to set the scene i am trying to create a training DB.
I have a form with one textbox in it which is for the course title. I then have a continuous subform with all the peoples details in it and whether they are trained or not.
There are nearly 40 courses and 33 people.
The problem i have got is that i want the list of people to stay constant in each course but this the gives the problem of the 'Course Completed' checkbox. BECAUSE if i link the subform to the mainform and a new person starts you have to go through every course and add them and if i dont link the forms the 'Course Completed' checkbox stays the same!
Is there anyway to have it so that the list of people in the subform stays constant even when one is added to the table but the checkbox gets updated?
I have tried this many different ways like adding the checkbox as a subform etc etc but with no luck!
If you can think of a better way i am VERY open to ideas - Thanks in advance!!
I've got an issue I can't seem to get around. I've got a linked table from an ODBC (tbl_1). I then have a make-table query (qry_1) that takes the fields, formats them, and creates a static table (tbl_2). I then have a one-to-many relationship between tbl_2 and another table (tbl_3). When I try to run the make-table query which overrides tbl_2, I get the following error: "You can't delete the table tbl_2; it is participating in one or more relationships". How do I get around this? Any help is much appreciated, thanks.
ps. The main goal is to link a form to the two tables (tbl_2 & tbl_3) for updating purposes.
I am linking to a csv file with the following
Me!JobHolder = mID
DoCmd.DeleteObject acTable, "TempTPSCSV"
On Error GoTo Err_Handler
DoCmd.TransferText acLinkDelim, , "TempTPSCSV", Me!FileSelected, True
Which works fine - except that I intermitently get error 3501 - ie file is already open or user needs permissions. Neither or which seems to be true - as on subsequent tries it eventually works OK.
THis seems to happen when file has circe 50k records , not when it has 100 records.
Any ideas whats causing this - and how to get round it.
Ta
:confused: How can I link a table to one specific item in another table in order to avoid repeating information? (ex: school name that would be narrowed down to its different departments)
View 3 Replies View RelatedOk...I have an issue that I don't know how to resolve.
I have a table called 'orders' in the orders table there is a place for " quantity', 'colours' and per unit. The cost per unit is based on quantity and colours.
For example: 12-35 shirts 1 colour are $2.85 per unit. 12-35 2 colour are $3.50 and so on.
I would like to be able to put in the quantity and # of colours and the Unit price fills in a field.
I don't know how I can accomplish this.
Excuse me for sounding extremely dumb, but I have a question that is really bugging me. I have created a database using two tables. The two tables are called User and Assets. In both tables I have set the primary key to be the field Username. I have also linked these two fields.
I have created a form that is my interface for the database and can add and delete from the table (User). I now want to insert a sub form into my form, that displays the contents of my second table (Assets) and reference's the field Username. Hopefully this will enable me to display my table (User) in the Form, whilst only displaying the relevent data in the subform (Assets) for the particular user.
I'm sorry if this sounds confusing, but I would really appreciate your help ...
:confused: :confused: :confused:
I'm trying to link an excel s/sheet into a database, however the link wizard doesn't give me the option of setting field types (text, double etc). It's skipping that screen.
I've changed the s/sheet so that all cells are text but on linking the table sets 2 fields to number and I'm losing some textual data.
However if I copy the cells in excel, open a pre-built table with field types set and do paste append, all data is visible.
Therefore, I'm trying to see if there's a way in code I can get access to open a specific excel s/sheet, copy all, open database table and paste append.
Any Ideas?
Dear all,
I have a question which I think is probably very straight foward for those who know about these things. I have just created a new database, but there are obviously some problems with the design, because when I enter information into a form, I don't seem to be able to access the information through queries or reports.
I have 11 tables, and one single form (I created the tables, and then used the wizard to create the form). The main table is called 'Client Information,' and the key in that table is the CaseNumber. They key in every other table is called something along the lines of 'ClientDetailID,' 'IncidentDetailID,' etc. When I look at the relationships between the tables, the 'ID' field in each table is linked to the 'CaseNumber' field in the Client Information table. However, I don't have any fields actually duplicated between the tables. Do I need to do this? (ie, should I have the 'CaseNumber' field appear in each table, and then the 'ID' field from every other table appear in the 'ClientInformation' table?)
thanks so much, this is probably a really simple problem but I don't think I really understand the whole relationships and linking tables thing.
Hi,
I have tables in MS Access and the same tables in SQL Server.
I want to link the appropriate tables up so that when i update the table in MS Access, it will automatically update the table in SQL Server. I want to do this using an ODBC link.
Anyone with any suggestions of how to go about this?
Thanks
Hi I need some help linking some tables...
Does anyone knoe how i would go about taking several years of contact information and compine it all into one table
Thanks
I have created an Access database application that is stand alone for each account manager/client at our business except for one table that I want shared as a source of data across all separate databases that are created.
I've investigated automatic Database Splitting and this works, except I only want the one table to be split and the others remain unique to each database.
I tried exporting the table in question to another Access database and then linking the table into each other database, this seems to work except that referential integrity can't be set up as it was. Is there any way to keep the integrity between the external database and the databases it links to?
Thanks in advance for any advice.
Strewth didn't think I was ever going to work with Access again, but I am, so here comes a table link question for you.
Got an access xp FE linking to SQL server via a DSN file. All linked up fine, however the tables in access have been given a 'dbo_' prefix to the original table name in SQL server. :rolleyes:
How to get rid off?
A setting in the DSN file?
Some VBA to loop through each table and rename?
Linked table manager which I haven't got round to installing yet?
Thanks
Dan
I am trying to create a table for an assignment on normalization. It is similar to the problem here : http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=88
I am trying to make it so that if a name appears in the Spouse, Child 1,2 or 3 column it will automatically appear in a dependants database with the EmpID and the Name of the Dependants, as separate objects so that the EmpID could be repeated. I have scoured info and I can't seem to make it work. Any help would be appreciated.