General :: Multiple Entries To One Database Field?
Aug 8, 2013
Basically, I'm compiling a table of funding sources and whilst all the fields are relatively straight forward, how best to approach the matter of where the funding is available. For example, Funding A is available in America only, Funding B is available in America, Canada and Europe and Funding C is available Internationally etc (a huge number of possible options and infinite different combinations). How's best for me to lay this out because there will be hundreds of funding sources all with different availability criteria? If the field name is 'Countries funding is available', can a data type input be multiple entries?
Ultimately I'll want to be able to query show all funding sources available internationally or show those available to America and Canada only etc...and when I query on another field or show all, I'll want to see where each of the funding sources are available, listed out .
View Replies
ADVERTISEMENT
Dec 6, 2012
I have a field named Supplies Expense. As an analyst inputs a business's expenses, it may require multiple entries into this one field. What is the best way to accomplish this?
For example:
Supplies Expense (Field Name) [$0.00]
The analyst has the following data:
2009 Financial Statement
Paper $50
Depreciation Expense N/A
Ink $100
So, going down the list, the analyst goes into access and enters $50 for paper then later needs to enter $100 for ink.
What is the best way to combine these multiple entries into a single Supplies Expense field and allow for a quality check of the individual numbers at the end of the project?
View 8 Replies
View Related
Apr 5, 2013
I have a subformClientOffers on my frmAllProperties. On the subformClientOffers is a field called Outside Agents. This field allows for multiple values to be selected.
The subfrmClientOffers is in datasheet view.
While the field Outside Agents DOES allow me to select more than one, they post in the field one after another:
Ken Shaw, John Doe, Jane Doe, Harlan Bestlyn
Therefore, the datasheet view of the subformClientOffers causes the field Outside Agents to get very long, much too long to view without scrolling. My client wishes for everything on the frmAllProperties to be viewable without scrolling.
Is there anyway, to cause the field Outside Agents to place a return between each selected name (sort of a wrap text kind of thing)?
One thing I might mention is that the field is a drop down field from tblOutsideAgents. The table itself has First Name and Last Name, but I concatenated that into Fullname on the form, so that when the user opens the drop down they see the entire name. I don't know if that would have any effect on making the 'return' thing work or not.
I can't use this field as a subdatasheet because I already have one subdatasheet attached to the subform to show multiple notes on each Client Offer.
View 4 Replies
View Related
May 17, 2013
We have two facilities that receive four different types of shipments. I wanted to set up a database to track these shipments. Is there a way for me to set up tables such that the person entering the information can leverage the same date and location field for each entry type? For example, we may only receive two types of shipments today and four tomorrow. I want to avoid having the clerk enter the date and location two times today and four times tomorrow for each data entry.
Here's an example of what I mean above:
Date Location Type Qty
5/16 1 A 10
5/16 1 B 1
5/17 1 A 1,000
5/17 1 B 100
5/17 1 C 1
5/17 1 D 11
I'd like for the clerk to select from a fixed number of locations (1 and 2) and a fixed number of types (A, B, C, or D) and provide the date and quantity received.
View 4 Replies
View Related
May 17, 2013
I run a database for defect detail, tracking, and resolution. Often times we have the same type of defect occur multiple times before the problem is resolved. Currently the process is that every time a defect occurs, it gets entered into the database, and whenever it gets solved, those who have solved it have to go to the database and mark it as complete.
However, since every time a problem occurs, a record is created, the people who mark issues as complete have to go through and find all similar records of problems which are basically the same problem and mark those as complete as well.
View 5 Replies
View Related
Apr 22, 2006
I'm new to Access and databases so my question might seem dumb, but I need some help figuring something out. Well, I have this database where I'm storing information from different charities. So I created a table with their name, address, phone, contact person, and many othe things. Now I need to create a field with the services that they offer. Each charity could be able to offer more than one type of service. So for the services field, I cannot create a drop down list because that only allows me to choose one service. So what would be the best way to allow the user select more than one kind of service offered from a list and then be able to search that with a query? I have a list with over 50 different possible offered services and each charity usually offers 2 or 3 different services.Thanks
View 3 Replies
View Related
Aug 30, 2004
hello,
I would like to know if there's any way of fitting multiple entires of data into one field in a table. For example, a field for addresses that might be able to hold two or more different addresses. Must I create another column/field to hold how many different addresses that that person might have? Thanks!
-G
View 2 Replies
View Related
Feb 19, 2013
Let's say if I am building a database for a library and in a table the book titles are the primary key and there is a field "authors" to record the authors' names.
But sometimes a book may have several writers and if I type all of them into one field, Access only recognise as one person. So how can I format/set up so that when I use query or filter, each one of names can be identified?
If multiple entries are not feasible, how else should I design my tables?
View 4 Replies
View Related
Jul 26, 2012
What I am wanting is to be able to build dynamic form content/elements based on entries on a table. This is for a gym membership system. What this form is going to be used for is to allow the front desk to scan a membership card which then performs a search on the database. Part of this search is going to be on a table that contains various add-on classes, tanning sessions, etc that a member can add beyond their base membership.
On the left side of the form, I will display a picture of the member and their name. What I am wanting to do on the right side of the form is to build a dynamic list of the add-on perks they are enrolled in.
I know I could hard program elements on the form to be visible or invisible, but that would be static and leave gaps when I have to turn things off b/c that member isn't enrolled in that class, etc.
Is this even possible with Access and VBA? I know I could do this sort of thing with a webpage using PHP, PERL or whatever. I don't know the limits of Access Forms and VBA.
View 5 Replies
View Related
Oct 22, 2012
I've prepared a front end database with forms that allow data to be keyed into linked tables to my main databse.
However, currently the front end database only allows 1 user to do it at 1 time and when another user tries to open the file, an error "The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked'
Is there anyway to allow multiple users to use the front end database at the same time?
View 11 Replies
View Related
Jul 11, 2012
I am writing an application for my personal use. I have 2 Access databases, one contains the data tables and the other has the forms, queries, reports, etc.
So far, I have been able to use the queries in the Row Source property of my form objects to accomplish what I want to do. Now I want to have a button that appends records to a table, the data in the table comes from several different controls on my form. After doing this the button should requery another control to display the new records added.
The OnClick event for the button allows me to use a Macro builder, Expression builder or Code builder. If I choose to use DAO in VBA code to append the records, do I have to define the database to create a database object to use even though the database is already open? Can I use a Macro to do this? Can a macro reference the data that is in the controls on my form?
View 6 Replies
View Related
Sep 20, 2013
I have a split database with the backend on our server. When I go to my server and look at all the open files on the network everyone who is in the backend shows up twice. One has zero locks and the other has multiple locks.
View 2 Replies
View Related
Mar 18, 2013
How do I change the database for multiple users?
There is no "advanced" option in the options tab.
View 3 Replies
View Related
Dec 17, 2012
I have two separate database files, a front end with all my forms and a back end with all my tables. The backend is stored on a network drive, is there any way of being able to store the frontend on the drive with the backend? Users do not use the actual computer to store information or access files, everything is usually saved on the network drive. I have created a shortcut that launches the front end database in the read only kiosk mode.
View 5 Replies
View Related
Feb 13, 2015
Twice a year, a database of mine is accessed and put too use by various staff within a time range of 1 week. the database is on a shared drive and in a location which can be accessed by all.
The staff access the database from different workstations and in some instances at the same time.
This has only led to issues in the database being copied and then confusing staff on what database to click on thus i have 2 databases which i then have to sift through and copy/paste into the correct one.
I want to know the best way i can:
1) Prevent multiple users accessing the database at a time.
2) making a copy of the original and typing into a separate database.
View 7 Replies
View Related
Dec 28, 2006
Hi, this question is more about Microsoft Access than it is about ASP. However it involves a database that I am setting up for a website being written in ASP.
I have a table which is going to store business details. Every business belongs to a business category and related subcategory. For example Garages and MOT Centre.
I want to store up to 5 categories for each business. Is it possible to link to the categories and subcategories tables for each of the 5 category fields in the business table?
Thanks, Steve (Blackpool)
View 1 Replies
View Related
Jul 5, 2005
This might be confusing so I will try to give as much detail as possible.
I have a table that has part numbers and the number of that part used that is based on a construction group lets call it.
I have another table that has all the different products that we sell, it also contains the "constuction groups" that are needed.
My append query looks to see which product is being ordered, gets the "construction groups" then looks at the other table and gets all the part numbers and quantity used in that group. It takes the part number,quantity used and appends them with an order number into another table. This works fine, however because some of the "construction groups" use the same part number I have multiple entries for some parts.
I want to be able to make it so that when there are multiple entries where the order number and part number are the same, it adds the 2 quantities and leaves only one record.
If someone out there even understands my problem could you help me. I have been trying to get this part of my db workign for a few weeks now.
View 2 Replies
View Related
Sep 12, 2006
Hi Folks,
I was just wondering if its possible, i'm sure it is.......
I've got a query to pull out invoices for a certain Project it brings up all project invoices and puts it into a report which works fine...... what i want to do tho is perform the same query but after i type in project code in criteria [] i then want to type peoples name or ID's that i want to print as some will be sent at different time intervals and i don't want to have to sort through invoice's to then send? is it possible? any one got any examples?
Thanks in Advance
View 1 Replies
View Related
Sep 6, 2004
We currently have an Access database that is designed to keep track of a number of calling cards that are issued to our clients.
The serial numbers given to us are sequential when issued in batches of 50 or more but, when another batch is ordered the serial numbers can be out of sequence by anywhere from 100 to 10,000 numbers. At present I am the only one who is entering the serial numbers into the system, this is done by importing from an Excel spreadsheet or from a text file.
What I want to do is, add another form which will allow the other operators to add the data themselves by entering the start and the end of the batch seqence rather than entering them in individually or having to teach them how to import data without overwriting the current information.
Can anyone help me?????
View 1 Replies
View Related
Nov 21, 2005
i have a report that displays 12 fields of date sorted by a case number. I have a problem when there are two or more entries in the db with the same case number, but different data in the other 11 fields. My report displays each of entries in the db for the case number, but carrys the the data from the first of those entries through out all the entries. I'm not looking for an exact solution here, just for someone to get me pointed in the right direction. Is it a sorting and grouping error or something of like?
View 1 Replies
View Related
Dec 16, 2014
I have a tblhealthrecord that has many multiple entries for the same animalID. Would like to pull up all records from this tbl for one animal. I can sort them later but just need to know what to ask for so I can read upon them. I at first thought this could be based on date but not really since you could have multiple entries in one day.
View 7 Replies
View Related
Apr 14, 2014
I have an excel sheet, sent to me by someone else. It contains a column of unique information (site IDs), followed by three columns which each contain either a unique value or a blank, something like this:
Code:
sID|Code1|Code2|Code3
011|1234A|1234B|
021| |2345B|3456C
031|3456A|3456D|
041| | |7890E
The ID represents a particular business with which we interact, whilst the codes represent particular types of contract that we have with them.
This is then followed by a lot of columns containing information about each entry, name, address, post code, contract data etc.
I need to relate this to the employees at those businesses, whose data I have recorded in a separate spreadsheet, so that addresses and such are also related to people, not just the business unit.
This spreadsheet records each person by employee ID (a unique value for each entry) and Code, without taking account of whether it is a code of type 1, 2 or 3. Like this:
Code:
eID|CodeX|FirsN|SecoN
011|1234A|Teddy|Bears
021|1234B|Harry|Horse
031|3456A|Edwin|Eagle
041|3456A|David|Tyrex
I figure the best way to create a relationship between these tables once imported into access is via a third table containing a column with all the Codes in a single field and a second field with the sID related to each code.
Code:
sID|CodeX|
011|1234A|
011|1234B|
031|3456A|
041|7890E|
My question is, how do I get all the Codes from the three different fields into a single field and relate it to the relevant sID for each?
View 1 Replies
View Related
Dec 4, 2012
I am creating a training database and i have a courses table. And I need to somehow record all of the different employees that attended a course?
What i can do to make this happen? My employees have an employee number so is there a way of putting all of the employees together in one field? what field would the attendees be? currently is numeric which doesn't seem to work.
View 2 Replies
View Related
Aug 11, 2005
I have a query that feeds a report. This report shows a "Set" and the "Charge Numbers" associated with it. Each set could have a possibility of more than one set of IT numbers. This means there could be say 2 entries for set "D7" and IT numbers for both of them.
As a result when I run the query, and say the set has 2 Charge numbers, it will bring back 2 results, with 2 charge numbers on each of them, which is correct. So if a set had 4 charge numbers assigned to it, 4 results would show with 4 charge numbers for each result.
Is there any way I can make it only show one of those results as they are identical?
I know this is confusing, bare with me
View 5 Replies
View Related
Mar 3, 2006
Hello, I have searched the forums and found plenty of information about eliminating duplicate values. What I would like to be able to do is run a query and have it show me only the records that have the field "serial number" that contain the same number. That is, I want to be able to query and see which serial numbers have been entered more than one time. The serial number is not the primary key, this database keeps track of product repairs and is used to log them in by the primary key serial number/date. Thanks in advance for any help. Tim
View 2 Replies
View Related
Aug 1, 2006
Hi all
Can someone help me with an Append query problem I am having. The end result I need is a Work sheet that has a Customers details, Plant details, Work required and a Subcontractor name. I have a search function that I use to select either a Customer name or Plant ID. Once I have selected the Customer name/Plant ID, I use a button to append the Customer Name and the Plant Id to a Plant_History table. This table uses an Autonumber field to create a unique identifier for each entry which I am using as the Work Sheet number. I have then added coding to open a form which accesses the Plant_History table directly so I can enter the work required and the contractor to carry out the work.
My problem is that the Customer and/or Plant will have multiple entries in the Plant_History table. Currently, when I select the button to append the details to the Plant_History table, if the Plant ID is already in the table, the number of records is doubled in the Plant_History table (eg if the record has previously been entered 4 times, 8 records will be appended to the table). I am not sure why this happens, if someone could point out the fault in my work, it would be much appreciated.
Regards
Craig
View 1 Replies
View Related
