Multiple Lines In Order Form From Single Database
I have 2 databases Product, with 3 entries ProdID, ProdName and UnitCost.
2nd database Order has Order ID, ProdName, UnitCost, Quantity, SaleDate and Total.
I want to create a form to input data into the Order databse that allows me to enter several rows using the data from the product table by selecting ProdName(Product) from list and UnitCost(Product) being inserted into each row automatically as a new ProdName is selected.
Can anyone hsuggest how best to do this.
View Complete Forum Thread with Replies
Related Forum Messages:
Help With Select Query To Get Single Line Instead Of Multiple Lines
Hi, I have a query that selects values from a table and I'm further creating a letter based on this query. The problem i'm having is that if the query pulls 3 rows as result then it creates 3 separate letters. Basically this is how the output of query looks: (refer attachment) Is there any way to write this query so that I can get output as below: Col1 Col2 Col3 10 20 10 Please advise.
View Replies !
Multiple Links On Single Database Field
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 Replies !
Single Form, Multiple Tables...
Sorry for the newbie question but... I've got a form called 'frmStudent' which is linked to 'tblStudent'. I have designed it as a tabbed form, the first tab has "Student name", "Student Number", etc. The second tab is linked to visits by the student to a mentor (such as a tutor etc). Here I'd like to have "Date of visit", "Mentor Name", etc. So far I've been able to get the first tab to work (I'm guessing because it's linked to 'tblStudent'), but can't get my 2nd tab to work as I have no clue on how to link it with 'tblVisits'. Is there a VBA methor or perhaps a nother method to do this? I'm attaching a link to the sample of what I'm doing (please shift-open into frmStudent to view what I'm talking about). Any ideas and suggestions would be greatly appreciated! DOWNLOAD DATABASE: http://www.myfilestash.com/userfiles/sabotage1945/Student_Help.zip Kindest regards, Sab.
View Replies !
Add A Single Field Multiple Times In A Form
I hope someone can help me on my problem below:- A user wanted to key in the data in a single form where she can select where a particular procedure is located. The procedure could be duplicated and placed in a few departments. My tables are as follows:- tbl_Proc_Dept:- ProcNo - Text (Primary) TrgConducted - Yes/No DeptAbbv - Text (Primary) tbl_Dept:- DeptAbbv:- Text (Primary) DeptDetails:- Text I created a form where i have the following fields in the form:- 1. ProcedureNo - Text 2. TrgConducted - CheckBox 3. MainDept- ComboBox (DeptAbbv data field) 4. Finance – CheckBox (DeptAbbv data field?) 5. Admin – CheckBox (DeptAbbv data field?) 6. Purchasing – CheckBox (DeptAbbv data field?) 7. Facilities – CheckBox (DeptAbbv data field?) 8. MIS – CheckBox (DeptAbbv data field?) How can I add multiple deptabbv field in a single form? Pls help. Thanks.
View Replies !
Data From Multiple Tables On Single Form
I have a tabbed form that contains multiple rows of data just like the following: (it's a service checklist for a store where the user makes choices from the combo boxes: e.g. good, fair, poor, etc) Paint (txtHrs), Action (cboPaintAction), Condition (cboPaintCondition) Carpet (txtCarpetHrs), Action (cboCarpetAction), Condition (cboCarpetCondition) Counter (txtCounterHrs), Action (cboCounterAction), Condition (cboCounterCondition) etc. Since the combo boxes describe data that relates only to that element I can't put all the data needed into a single table. There are 40 of these rows so does that mean I have to create 40 tables? If so, how do I add the data to them from the form? Any help with this problem would be greatly appreciated!
View Replies !
Max Value For A Single Date/multiple Time/single Tag ID Combination
Hi, thanks in advance for any help you can offer. I've got a table that has Date Time Tag ID Power Level throughout the day a computer listens to several tags (transmitters) and records the power level of the signal generated by the tag each 3 seconds. What I'd like to do is build a query that gives the Date, Time and Maximum Power level reading for each tag ID. I only want 1 record per tag per day I've tried using "group by" and max in the query but this gives me all the times throughout the day. anyway, thanks again for looking cheers, Shaun
View Replies !
Counting Results Of Multiple Queries And Displaying The The Reults On A Single Form
Im making a database about past bid results. In one table i have a list of bidders and which place they came in (along with some other information). I have 20 positions (1st place, second place and so on...), so i made 20 queries that search through the table for my company's name so we can see how many times we came in first, second, third and so on. Now i would like to bring the number of records in each query to a single form. I tried making another query to using the count feature on the other 20 queries but it keeps returning 0 as the number of results per query. But when i open each query up there are obvisouly more that 0 results in each. Is there a way i can bring up the number of results per query all on one form? Thank you Dan
View Replies !
Limit For To Single Entry? Tabbing Order Question...
Newbie Access user here, with what I hope is a fairly easy task-- I have a form which contains fields for info about clients and a subform which has only one field for a corresponding video tape number. Is there any way to limit the record for this subform to one single entry, so that when I hit Tab after entering the single number, the second record in the subform will not appear, but rather I can jump to the next record in the main form? If not, then can I just tab through the main form, into the sub form and then onto the next record? Is there a shortcut to create the next record other than having to manually mouse click the next record arrow at the bottom of the form?
View Replies !
Multiple Lines In Text Box
i'm no noob, but i'm also not the expert, what i'm trying to do is this, i'm taking multiple string out of an recordset and putting them in one big text box but the problem is that after every record there has to be an enter in the text box So for example: record 1 = -bla bla bla -tja tja tja record 2 = -waa waa my result in the text box must be: -bla bla bla -tja tja tja -waa waa and not (like it is now): -bla bla bla -tja tja tja -waa waa who has a clue? chr(11) & chr(13) do not work, i activated "on enter go to next line" thx in advance for helping out
View Replies !
Importing Multiple Lines Of Text
Good morning. I am new to coding VBA and need some help if possible. I need to import a Comma Delimited Text file into a MS Access table. The records vary in length and may take up multiple lines of text before the next record. The first field contains the type of record and are all prefixed 1###, with the ### being variable. (1001 - 1100). If the record goes over one line the 2nd line with start with 1000. Here is an example: The records with 1001 continue to the next line with 1000 so you know it continues. The other records are all single lines starting with 1100, 1003, 1004, 1006...1017. 1001,00000000,00000000,00000000,00108888,00537906 1000,00100,"CAJUN MEAT ","CHUB "-0020380 1001,00000000,00000000,00000000,00020492,00130534 1000,00108,"RED BEANS ","CHUB ",-0221510 1001,00000000,00000000,00000000,00222572,00796807 1100,0000000000,0009605419 1003,01,000101,263558519,"QQ380427",5,08,19,107,16,07,58 1003,02,000202,263774367,"QQ380428",4,08,19,107,22,22,12 1004,1," " 1004,2," " 1004,3," " 1004,4," " 1006,00000000,00000000,00000000,00000000 1007,"$ OFF ",0000000000,0000000000,0000000000 1007,"FREE ",0000000000,0000000000,0000000000 1007,"SENIOR 10% ",0000000000,0000000000,0000000000 1007,"50% Police ",0000000000,0000000100,0000000001 1007,"CREW 50% ",0000000000,0000000310,0000000003 1007,"CREW 100% ",0000000000,0000001976,0000000009 1007,"MANAGER ",0000000000,0000000260,0000000003 1007,"BONUS ITEMS ",0000000000,0000000000,0000000000 1008,00107,00001,00065,06074,00347,00290 1009,01,"BREAKFAST SALES ",0000114476,02940,000091 1009,02," SALAD SALES ",0000009093,00233,000007 1009,03,"DRIVE-THRU SALES ",0000142716,03666,000106 1010,0000002646,0000009093,0000000000 1011,000,0000000000,003,0000005208 1015,"NET SALES ","+",0000389258 1015,"TAX ","+",0000023434 1015,"GROSS SALES ","=",0000412692 1015,"RESTAURANT BANK ","+",0000000000 1015,"ADJUSTED GROSS CASH ","=",0000412692 1015,"SEPLINE----------------------"," ",0000000000 1015,"AMOUNT DEPOSITED ","+",0000365609 1015,"GIFT REDEEMED ","+",0000000000 1015,"CREDIT CARD ","+",0000044844 1015,"MISC. INCOME ","-",0000000000 1015,"PETTY CASH ","+",0000000000 1015,"NET SALES ","-",0000389258 1015,"TAX ","-",0000023434 1015,"CASH OVER/SHORT ","=",-000002239 1015,"CASHIER OVER/SHORT ","-",-000001839 1015,"OVER/SHORT RECONCILIATION ","=",-000000400 1015,"SEPLINE----------------------"," ",0000000000 1015,"NET SALES ","+",0000389258 1015,"GIFT CERT. SOLD ","-",0000000000 1015,"OTHER NON-FOOD ","-",0000000000 1015,"NET FOOD SALES ","=",0000389258 1016,1,00000000,00000000,00000000 1016,2,00006103,00036415,00118800 1017,0004339338 I will need to do this weekly for many different files. I appreciate all the help that anyone can provide.
View Replies !
Write/update Multiple Lines Belongs To A PO?
Hello all, How are you? Hope everything is well! I have a question. If I have a form, which has underlying source is the table LineItem. The table has these fields PO#, Line Item, Cancel check box, and Cancel Reason list box. Each PO can have 1 to multiple line items. Once in a while, the users need to cancel certain line items and type a reason in the Cancel Reason box. When the users click the Cancel check box, it force the user to enter a reason. However, in cases, some POs have 10-100 line items, and the reason are the same for all line items, and it is time-consuming and tedious to do one by one. I would like to find a way to enter reason in line 1, for example, and copy/update the rest of line items in that same PO with that. Please advise HOW and WHAT COMMAND should I use to update the text in one field of one record (line item) to ALL other records (line items) in the same PO. Please help! Thanks so much.
View Replies !
Multiple Answers For A Single Field
Hi, this is my first post here. My question is this: I am creating a database for a student survey. Some of the questions may have multiple answers. For instance, question 2 reads: "What location/time are you taking courses (select all that apply)" and the possible answers are: 1)Daytime/Oakland 2)Evening/Oakland 3)Saturday College 4)BC - Where a student could be taking classes at multiple locations or times. I am completely lost as to how to set this up. I have tried to set the properties for the field on the form to accept multiple responses, but of course, these do not save to the table and so it's completely useless. Thank you in advance for your help!!!
View Replies !
How To Select A Single Row Multiple Or Certain Time
Here is my problem. I have to select a single row multiple or certain time ( the number given in a field in that row). Here is what i need. Table : Car ------------------- ID NamePrQTY 01Volvo999910 now i need to select this single row 10 ( given in QTY field) time. Like this SlID NamePrQTY 101Volvo999910 201Volvo999910 …………………………………………. ………………………………………….. 1001Volvo999910 Can anyone help me. Thanks Sadi
View Replies !
Multiple Calculations In A Single Query
I have 2 calculations in a single query. 1st - ProdCost: [TBLinvqty]*67 2nd - Gross: [TBLinvamt]-[ProdCost]-[TBLfrtamt]-[TBLocamt] The query runs and works fine but it keeps prompting me for ProdCost but if I hit ok it runs fine. How do I get it to quit prompting me for Prodcost BTW, Prodcost is not a field in a table its only the 1st calculation in this query
View Replies !
Multiple Forms/single Table?
Hello friends,I have a pretty noobish question. I was wondering if it was possible to have several (3 in my case) different forms that apply data to a single table? The main table has three different types of data: 1. Client info 2. Services A 3.Services B. Each type of data has about 7/50/12 different fields of data in each set so that trying to include all this data on a single form is not very user friendly due to clutter.I have three forms that input data into the table, however the record navigation command buttons that I have on the forms do not apply the data to the correct record. For instance, when I input the Client info for client #2, and click the "open services A form" command button, the form opens on client #1 Services A instead of to a new record. Is this something I have done wrong, or is it due more to MS Access limitations? Thanks
View Replies !
Charting Multiple Values From Single Record
This particular database generally looks at reporting individual records as opposed to summary reports. So for a particular data record i have the following data [x1][x2][x3][x4][x5][y1][y2][y3][y4][y5] I need to chart (scatter) these figures as paired x,y variables for display on a feedback report such as x1,y1 x2,y2 x3,y3 x4,y4 x5,y5 For some reason i simply can't wrap my head around haw to make this happen. Many Thanks in advance for any help. Cheers ndeans
View Replies !
Contacts DB - Single Organisation, Multiple Addresses
Hi. Im a beginner-intermediate access user (I guess) and I am working on a stakeholder management database, which essentially enables me to separate organisations, individuals, the affiliation between the two, and addresses of either individual or organisation. (pic of relationships included). Originally, I stored address values on each respective table (ie. org address was on the org table, individual address on the individual table). However then it became apparent that one organisation (in my line of business) can have many address sites, therefore the need to nominate multiple addresses. So I figured that the best method would be to have an address repository, and orgs or individuals are assigned to that address via a MultiAddress table. The preferred postal address would be nominated by an address preferred field in another junction table. Seems to work ok through the form (see form pic attached), but Im concerned that when I try to run queries/reports that I'll get duplications or other anomalies. Can anyone provide me with some tips or advice??? Cheers
View Replies !
Exporting Multiple Csv Files From A Single Table
Hi guys. I'm a bit of a noob with Access. I have a table which is 15 rows by 250,000 columns. So there are about 3.75m records. What I need to do is to get access to export a number of csv files automatically from this table. I need each csv file to contain all the data in the table for a certain range of rows. This is determined by a value in a particular column. This is a sample of the table. http://i30.tinypic.com/aljf5s.jpg Basically Store_Nbr represents a UID for a particular store. All the data is currently in one big table, and I need a single csv file for each different store_nbr (so it contains all the data in the table for each unique store). Also, for each store_nbr, there are different Year Month of Surveys. For each store_nbr, I need a different csv file for each Year Month of Survey. This will probably divide up the 250,000 long table into about 200 csv files, as there are about 50 different Store_nbrs, and there are 4 surveys for each individual store. Sorry if I've not made myself perfectly clear. I'm sure there's a simple way of doing it, but I really do suck with access and was wondering if you guys had any idea. Many many thanks!!! Cheers
View Replies !
Multiple Parameters [for The Same Field] For A Single Query?
I have set up a parameter query in Access 2003 that asks the user for the "Section", such as "Admin", "Accounting" etc. I need them to be able to respond to the prompt with more than one section if they want- sometimes just one, sometimes two or three or four. So they can get "Accounting" and "Admin" both in the records that are returned. The code: SELECT T_ElainesMaster.Section, T_ElainesMaster.Login, T_ElainesMaster.Workstation, T_ElainesMaster.NT, T_ElainesMaster.Barcode, T_ElainesMaster.[PC model], T_ElainesMaster.[Emp Name], T_ElainesMaster.[swap or not], T_ElainesMaster.[Exp Date] FROM T_ElainesMaster WHERE (((T_ElainesMaster.Section) Like [What section would you like to include?])) ORDER BY T_ElainesMaster.Section; Thanks!
View Replies !
Concatentate A Single Field From Multiple Records
I have a table of every reading of every electric meter. This history goes back a couple of years. Field1 = date Field2 = Meter# Field3 = Single digit code identifying method of reading The same meter is read multiple times in a year. The number of readings in the database is 1 or more (no limit). I want to create a single line of text in 1 field that shows a history of the reading method of a particular meter. Reading method translations A=Radio Frequency B=Manual C=Not Read X=Estimated Here's a sample of what I would like to see .....
View Replies !
Consolidating Multiple Queries Into One Single Result
I couldn't find a similar question already answered, so here it goes. I have multiple tables used to store information on different research materials: table Books: - BookID - Author - Title - Year - Cabinet table Papers: - PaperId - Author - Title - Year - Cabinet table Catalog: - CatalogID - Author - Title - Year - Cabinet And I have a query for each of those tables that helps me find information. What I'm trying to do is to consolidate the result of those individual queries into one single query that later I can insert into a form to display a search result. So the resulting query would look like: Type.....ID....Author.....Title....Year....Cabinet Book.....001...John.....Good book....2005....C01 Book....002.....Mary....Other book...2006...C01 Paper....001....Albert...PaperABC....1987....C01 Paper...002....John.....PaperXYZ.....2006....C02 Catalog...001...Mark....Cat00A....1989.....C02 Catalog...002...Bill......Cat00B.....2004.....C03 etc. Is this possible? Any help is appreciated! Thanks. Daniel
View Replies !
Dynamic Multiple Criteria In A Single Field
I have a query that displays all records. I need it to limit based on multiple criteria in a single field. I.E... instead of all employees from every section, I just want it to display employees from section A, C, D, F one time and next time maybe go with section B, C, D. For some reason the solution eludes my little brain.
View Replies !
|
TRACKER
