Combining Records With Attachments From Separate Computers Into A Master Database

Jun 21, 2013

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)?

View Replies


ADVERTISEMENT

Merging Data For One Table From Date Entered On Separate Computers

Jan 9, 2015

We are creating a database to log data on a project. There will be thousands of files. Can we input data, using the same table, at separate locations and then merge the data into a master table? We will need to do that many times.

View 1 Replies View Related

I Would Like To Create 4 Separate Databases From One Master

Dec 12, 2006

I have a large database of Purchase Orders
Orders can be placed by people in one of 4 departments

I would like to automatically make 4 separate databases (so each department can access their own) from the master

Is there a way to do this?

View 4 Replies View Related

Combining 2 Query Columns Into 1 Column With Data In Separate Rows

Mar 29, 2012

I have a database with all the hours employees have logged stored in the database. Our payroll company wants an excel spreadsheet that has very specific info in particular columns and fields on the excel spreadsheet, so I'm trying to design a query which will put the correct info in the correct fields per their system.

The challenge is, I have currently a query with Employee ID, Overtime Hours, and Regular Hours as separate columns.

I need to translate this to a query with a single column for hours and a separate column that designates those hours as OT or Reg, with two rows for those employees who have both types.

Current:

ID / Regular Hours / OT Hours
101 / 70 / 7.5
102 / 30 / 0
103 / 5 / 0

Needed:

ID/ Hours / Type
101 / 70 / Reg
101 / 7.5 / OT
102 / 30 / Reg
103 / 5 / Reg

I don't know how to create a query or a formula in a query to break out each employee row into multiple rows with different data in the hours column. It seems like there's something pretty straightforward that I've done in a similar vein but it doesn't seem to work - I can do the opposite and combine those hours by using the SUM function in a query, but I can't seem to break it out this way.

Access 2007, Windows 7.

View 5 Replies View Related

Cannot Distribute Database To Other Computers

May 26, 2006

I created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work.

Perhaps I'm confused as to what files need to be migrated to each additional computer or I don't have the security setup properly.

Right now, I move 3 files. The main database file with the front end. The shortcut file that is created when you add security and the security file that is created when you add security to the database.

I'm stumped.

View 4 Replies View Related

Managing / Syncing Database On Multiple Computers?

Jun 25, 2015

I have an estimating database, the "main" database is on my desktop, then it is also on a Notebook and Laptop and goes out with the bidders. At the end of the day, I want to sync all 3. I may enter info throughout the day on my desktop (which needs to sync up to the other 2) and vise versa. Using SharePoint is not an option as the Notebook and Laptop will not always have internet access.

View 1 Replies View Related

Add Attachments From Database To Email

Jul 21, 2015

I 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]...

View 4 Replies View Related

Multiple Attachments In Different Records?

Oct 22, 2013

I am creating a database that needs to store a large number of pictures. I have a component that we're working on that needs 100 photos of specific details taken and stored.

I have created two separate tables.

One that includes four fields, ID, Component Number PhotoType and an attachment field.

The second table has ID,Photo Type and in this table I've coded 100 records detailing the photos I need. This is used as a lookup field for the first table.

What I would Like to accomplish from this point is to be able to add 100 fields onto the form for the user to click on the attachment and then save the specific photo that corresponds. How do i edit the control source of the attachment item on the form so that it is specific to one component number, and one phototype?

View 1 Replies View Related

Linking Database Fields To Attachments.

Aug 19, 2004

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

View 2 Replies View Related

Proper Way To Store Attachments In A Database?

Apr 29, 2014

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 Related

Queries :: Records With Attachments In Table?

Feb 6, 2015

I am working with access 2010 and I have a database that has attachments in the table. I have set up a query to in by database but every time I have a record with 2 or more attachments on it it shows that record as two different records in my query. I am wondering if there is a way I can make the query show one record and to be able to view attachments like in the original table.

View 1 Replies View Related

Adding Attachments Without Bypassing Database Startup

Dec 12, 2013

I 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).

View 8 Replies View Related

How To Control Multiple Databases From One 'master' Database?

Aug 31, 2007

Hi all, i hope this is posted in the right place first of all :) apologies if not..

I have about 8 individual databases which will be used simultaneously by users. I wish to be able to have full control over these databases from a 'master database' including being able to delete the data in there (possibly import fresh data but not 100% needed) and export data to be analysed in Excel etc
I figure this can be done with access but if i'm on the totally wrong track i would be appreciative if someone could give me a push in the right direction..

If any more infomation is needed then let me know.

Thanks :)

Mikey

View 8 Replies View Related

General :: Access 2010 / Adding Reports To Records As Attachments?

Apr 12, 2013

I have an Access 2010 database connected to several SharePoint lists. I'd like to be able to print a report (based on a query) and add that report as a .pdf attachment to the record I was looking at when I generated the report.

At the moment I can save the report as a .pdf to a local file store, then upload it as an attachment, but is there any way to skip that step and add it to the correct record automatically?

View 3 Replies View Related

Modules & VBA :: Merge Identical Tables From Different Databases Into One Master Database

Mar 4, 2014

I have database for each location. Every location will update some information in the databases and send it back to me. In those location based databases, information will be stored in one table called "consolidate_input". I will store these databases in one specific directory and then I want to accommodate the data of "consolidate_input" into one master database having the same identical table in the database.

View 1 Replies View Related

Two Separate Issues With Same Database

Oct 1, 2006

:o
I know this isn't rocket science, but since I'm not a rocket scientist (read no VBA - I have registered for a self-taught course, so my annoying questions may become fewer) you may have to bear with me.
:o

1. I'm trying to get a subform opened using a command button. The mainform is AddNewTransactions and the subform is SiteDetails. The linking field is TransactionsID. I've tried using the command button wizard, and tried doing it manually with a macro. The SiteDetails shows ALL sites, not just the one connected to the main form. I'm sure there is a simple solution, but I haven't found it here yet.

2. I have to convert English decimal numbers to French numbers with a comma. Replace() did the trick except for one small annoyance. It trims trailing zeroes. 0.240 becomes 0,24. Is there any way to force it to display the zeroes? Unfortunately they're not same number of zeroes from one value to the next, so I can't just add them. This more for visual appearance than accuracy so it is not critical.

Thanks in advance for your help.

View 1 Replies View Related

Combining Records

Jun 22, 2007

I'm modifying a database for someone in our marketing department. The DB tracks shirts that are given to employees.

The area I'm having a problem with has to do with the shirt style.

The current categories offer:

Long Sleeve (White)
Long Sleeve (Black)

etc..

I want to combine those two so they fall under the simple category "Long Sleeve"

The problem I'm having is that when I do a find/replace, it will allow me to change all of the Long Sleeve (White) to Long Sleeve, but then when I go to change Long Sleeve (Black) to "Long Sleeve", it creates duplicate entries because the same order contained x amount of Long Sleeve (White) and x amount of Long Sleeve (Black).

Is there an easy/ automated way to combine these results into "Long Sleeve" and add the quantity fields together to show the total amount of shirts ordered?

View 3 Replies View Related

Combining Records

May 7, 2007

Hello,

I seem to have a similiar problem to others and I tried to read through this forum, but I am not well versed in the code and I frankly find some of the explanations way to complicated. I was hoping someone can help me with a problem. I have data that looks like this:

Name Comments
J Smith 1/1/07-ATO
J Smith 1/10/07-UAU
S Smith 1/13/07-ATO
D Smith 1/2/07-OT
D SMith 1/3/07-OT
D Smith 1/4/07-ATO

I want it to look like this:

Name Comments
J Smith 1/1/07-ATO, 1/10/07-UAU
S SMith 1/13/07-ATO
D Smith 1/2/07-OT, 1/3/07-OT, 1/4/07-ATO


ANy suggestions?

View 4 Replies View Related

Combining Records

Aug 18, 2005

Hi

Currently in our database we several companies entered several times. Due to different branch addresses. What we are looking to do is create a form that combines displays all the addresses related to that customer name.

Does anybody know of a way we can do this?

Regards

Paul

View 2 Replies View Related

Separate Records By Column

Apr 26, 2006

I have a table set up as the following:

ssn account
01234567 1234567890
01234567 9876543210
01234567 7539514562
98765432 8765432109
98765432 9876541230

and so on...

I would like to create a query that will split the records up like this:

ssn account1 account2 account3
01234567 1234567890 9876543210 7539514562
98765432 8765432109 9876541230

and so on...

It can be in any format, either query or report, I just have to be able to export it into a text file in the same format. Does anyone have any ideas?

Thanks!

Vassago

View 11 Replies View Related

Combining Records From Two Databases

Mar 9, 2007

Is there an easy way to combine records from two separate databases with the same data fields?

View 3 Replies View Related

Combining A Number Of Records Into One.

Jan 17, 2006

I have a table that contains a number of email addresses. I need to combine a number these into a single record to allow me to email a report to a number of different recipients depending on the client the report is for.

At this point I’m not even sure were to start.

View 12 Replies View Related

Combining Records From Two Queries

Dec 10, 2007

Can I use left and right outer join at a time? Means I want all records from both the table, and it should put 'null' whenever value is absent.

View 1 Replies View Related

Combining Records From 2 Tables

Jan 3, 2008

Hello all,

I have two MS Access tables; table1 contains installing records (fields = serial, installdate) and table2 contains de-installing records (fields = serial, deinstalldate). Tables are structured as followed:

Table1:
serialX installdate1
serialX installdate2
serialX installdate3

Table2:
serialX deinstalldate1
serialX deinstalldate2

I'd like to combine the above two tables to get:

Table3:
serialX installdate1 deinstalldate1
serialX installdate2 deinstalldate2
serialX installdate3 null

Is it possible? Right now, whenever I joined the two table on serialX I got 2 deinstalldate's for each installdate, e.g.:

serialX installdate1 deinstalldate1
serialX installdate1 deinstalldate2
serialX installdate2 deinstalldate1
serialX installdate2 deinstalldate2
..........

Thanks in advance for your time and help! I'd appreciate it!

Best regards,

Andy

View 6 Replies View Related

Combining Data From 3 Locations Into One Database

Aug 19, 2011

I've been given the task of combining data from three locations into one database in Access, something that is relatively new to me. I'm trying to decide whether to have the locations enter data into an Access database or into an Excel spreadsheet at each location. Regardless of the program used to enter data, I would probably like to link each of the files to my main Access file and combine the three into one database there. I do not want the locations to add data directly to the main database if possible.

My question is, would this be done by an append query? If so, how? Also, my thought is that the data at each location would be added to every day. I would need to be able to add the NEW data only to the database without duplicating the previous day's data.

View 5 Replies View Related

Exluding Records For Separate Table

Apr 29, 2006

I created a report where is lists sales volume by day. I was asked to create a table where data can be excluded from this report. The exclusion table consists of only three fields:

Date Department and a check box

What do I need to do in the query to have it exclude the data listed in this exclusion table. The table only holds data we want excluded, not all dates and departments.

I originally added the table to the source query and made the criteria "False" for the check box but when the query runs it does return any data at all.

Please help!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved