Hi i am working with a database that contains customer information
and sometimes files and attachments will need to be saved into the
database. I presume i will have to save the attachments somewhere
and then link to them, but i really haven't a clue where to start. Does
anybody have any information about this or even know where i can
look for information!
Thanks in advance!
Treasa
I need to add attachments (pdfs, Word documents, JPEGs) that will automatically update to my form when revisions are made to them in their outside folders (not within Access). For example, I have op sketches that are being edited outside of Access and saved under the same name, so I need to make sure that these newly edited documents are automatically being linked and uploaded to my Access form to see. These attachments were added to a field in one of my tables, and I can pull it up in the form. My problem is that the attachments that I pull up are not the currect version; they are the original version that I added into the table. I tried making the Default Picture Type as "Linked" instead of "Embedded", but this isn't working. What can I do so that the current revisions are being shown without having to edit each attachment within the table?
View 2 Replies View RelatedI am trying to find the VBA code that adds attachments currently stored in the database to an email. Currently, I have a button that will email the report refernced on my input form. My attachments are stored in a table, but I have built a query for my attachments that wil filter based off the referenced report on the input form. Below is my VBA code to email a report.
Private Sub Command587_Click()
Dim stReport As String
Dim stWhere As String
Dim stSubject As String
Dim NCRNum As String
[code]...
I have attachments I want to store in my database, most are images, some are excel files, etc. I'm sure its better to store a reference to the file instead of the attachment itself. Whats the best way to do something like this? Id like the attachment to still be displayed in the form if its an image...
View 3 Replies View RelatedI have a split database, using Access 2010, Sharepoint is 2007 I believe. I have a form where I can enter requests onto a log and I've set it up to allow attachments. However, I get an error of "Cannot update. Database or object is read-only." if I try to add/remove attachments on a record. I have no issues adding and updating the data other than the attachments.
I've also found that if I bypass the start-up options (using shift) then the attachments work fine. Unfortunately, through trial and error, I haven't been able to find a database option which I can enable and fix the problem.
How to have this functionality enabled without bypassing startup (I've only intended to do basic things like hide the nav pane).
We're a small shop building a modest database to keep track of our product listings on eBay. Two people on non networked computers are doing the data entry into cloned copies of our database. This includes attached photos for each record. At the end of each week, we want to combine the records created separately into the master database on my system.
It seems like it would be simple enough to just cut and the paste the records from the two databases into the identical master. The problem I'm anticipating concerns the attached photos.
Some strategies are to transfer the records from the data entry computers to the master database while keeping the attached photos intact.
Is there an effective, efficient way to set this up or would it be best to use the OLE format for the pictures instead of attaching them (which I prefer)?
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.
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.
Good morning everyone:cool:
I was wondering if there is a way to link one field from a table to another table?
I have a main table that all of the data goes to and then a second table that the completed data goes to. I have made a query to show info from the main table and one field from the second table and it will only pull the info that is on both tables...i want it to tell me the info that is not on the second table:confused:
Sorry if this is confusing, but any help would be appreciated...thank you
Cori
I am fairly new to Access and i am trying to create a database that stores member's details and records the payments that they make monthly.
I have 2 tables:
Members:Id number
Fname
Sname
etc
and
Fees:
Id number
Fname
Sname
Amt paid Jan
Amt paid Feb
etc
What i want to happen is that any member's details entered in the members table also appears in the Fees table so that only the amout paid needs to be entered.
Is this possible?
Hi everyone,
Having a little problem, have searched the forums but have not been able to find an answer.
I have a single db with 3 tables, artist, gallery and arts.
The main form should show the work details for each artist, i.e. each piece of art they have done. The problem I have is I think I have a link or relationship problem as when I try to create a new record in the arts table, I have a combo box which populates the artist name and gallery name and it should then store these details in the arts table along with the rest of the details I enter but it doesn't.
Each table has an autonumber and there is a one-to-one relationship from arts to artist and arts to gallery.
Can anyone help?
I would like to link 2 fields in a form. If I select data within one field with drop down list it should automatically bring up a name within the 2nd field. How would I be able to do this?
I've managed to lind the subforms to this drop down list which works brilliantly but this is a field within a form that I don't know how to link.
Ok. I have used access before to hold data but have always accessed and used it via asp. I have never actually tried to use the access forms and queries! But for a current project i am having to use it.
So far its been fairly simple but im stuck on one point. I have one table that holds user info and has a foreign key from another table. On my form i want the user to be able to lookup the foreign keyes available. Only i want the lookup to show the description field in the other table not the unique id (primary key) but when they slect the relevant row its obviously need to record the primary key of the other table in the foreign key field in my user info table.
How can this be done? Im not sure if i explained this very well. If anyones unsure what i mean please ask my to clarify.
I have to date fields one called from and the other called to
suppose to look like this frm 07/05/05 to 07/05/05
what i want to do is when i type the date in the from field the same date will automatically appear in the to field
any ideas.
My question is this:
I have a form called Family with a RecID field. When I create a new record on this form the RecID field auto assigns a #. Then the user is supposed to click the command button which brings them to another form called Child. This Child form has the RecID field and another called RecChildID.
The RecID field is linked to the same RecID field as form the previous form. But when I enter the child form and start it's linked record the RecID field is not filling in/ copying over the same # as the previous form. How can I get it to update the RecID from the first form to the second form?
Thanks!
I have two different tables. Table1 contains information such as the name of a patient, which is the primary key, date of birth etc (fields that will not change). Table2, linked by the subject id, contains information about tests that they may have gone through. A form has been made using these two tables, in which table1 is that main form, and table2 is a subform. I want to add a field in table2 called "CurrentAge", which will use the date of birth specified in table1, to calculate their current age, and would like it to be displayed in the subform.
View 9 Replies View RelatedI 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
Hello,
I created a sys admin database and the big problem I am having is linking the hostname field in table 1 to the hostname field in table 2. I have tried making both fields primary keys, I have tried creating a relationship to the two fields between the two tables. I have tried adjusting the join types.
Yet, no matter what I try, the hostnames from table 1 will not populate in table 2. I have even tried adding a new hostname to see if it would populate and it won't.
any ideas?
Thanks,
stillabeginr
Hi.. Junior access user here. Need help fast!
I created 2 tables. [General Info] & [Details]
[General Info] has 2 fields. Name(is a primary Key as well) & Organisation
[Details] has 4 fields. Primary Key, Name, No of products & Type
[Details] is a sub form for [General Info]
It is a one to many relationship. With Name from [General Info] linking to Name from [Details].
I can update via the table directly and [Details] links the name fields automatically. I created a form but the form just cannot register the field automatically and requires the user to type in the Name from [General Info].
I have attached the DB file. Pls help... your help is greatly appreciated!
At the moment i have an exisiting database that was not created by me. It consits of about 7 tables and a main table. Each table has a Primary Key that is a joining field. The Main form is built with subforms and when i enter a number in the primary key filed of the main table it enters that number in all the other primary keys in the other subforms.
i have now tried to create another subform to put into the main form but i cannot get this "link" between the primary fields to work.
can someone please help.
I have a form with contact info, which also has a subform with other data on it. The subform is a continuous mode form. If I go to the "New" line (last line) of the continuous form, I can add information, and the records are linked via the customerID field on both the form and subform.
I want to have a button on that subform that says "New" that opens up a different form in a popup. I can do that part just fine, but when I try to enter data onto the popup form, the customerID field does not populate with the ID number of the person on the main form. It defaults to a value of "0".
So, is there a way to link the 2 forms like you can with forms and subforms? Or is there a way to have the customerID field in the popup form just populate based on the other form?
Not sure if this makes sense, but please help if you can. Thanks.
Hello all-
I'm formatting an Access table and need help linking 1 field to another. I need to specify that Field B will state "N/A" if and only if (back to good old geometry) Field A states "Yes." I've tried using the ValidationRule and Default Value functions but they don't let me refer back to Field A. Any thoughts would be hugely helpful.
Thanks much.
I 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 RelatedIm in the process of developing my first database for my bonsai (small trees) collection. So far, ive developed a table of each of the trees I have, with fields such as Species, Where Bought, Cost etc and ultimately a link to a recent photograph (my next challenge). Ill be adding to this as my collection grows (in number and size). To avoid information duplication I have a separate table of care instructions for each species of tree with type, position they favour (eg Hardy/Delicate), watering requirements, wiring advice etc.
I now want to have a field in each of the records in the first table to its particular species care instructions as simple as that, or so I thought. ie for each different pine I want a link to the care guide for pines, and only pines. And preferably in a table format.
I need a one (second table) to many (first table) relationship and have linked them appropriately through primary field (species) and foreign field (care details). I have tried various Controls in the Design View but cannot get the field to show just one care record (ie the one for that particular species of tree). I realize this is possible, as its a common feature of a good database, and have found it being used in the various templates available - but not how they were created. The best Ive got to is using a Combo Box but this shows all of the care details records and in a column view.
In query design view, I have added a query with column (nameA) of names and a table with a column (nameB) of names. I am linking these two fields (nameA and nameB) which contain names. The names are spelled exactly the same so I should get results. Both fields are of the same data type.
But even when I add only the field with names from the query (the field called nameA), I don't get any results.
What is wrong here? Are there restrictions about linking a query to a table?