The current database has the following tables (fields):-
1. Salesman List (Salesman, Supervisor)
2. Customer List (Customer No, Customer Name, Salesman)
3. Product List (Product Name, Product No, Price)
4. Quotation list (Quotation No, Salesman, Customer No, Customer Name, Product Name, Product No, Price) - The data of this table is input by a quotation form.
I'm trying to create a quotation form (by using the quotation list) for others to input. My questions are:-
1. In the quotation form, there's a Supervisor field (which is not in the quotation list table). I want the value in the Supervisor field to show up according to the Salesman selected in the form. So, I'm using the sub-form method (Main form:Quotation form; Subform: Salesman List form). Am I doing correct?
2. While inputing data into the form, one should select Salesman first and then Customer Name (by doing so, only the customers of which the Salesman is responsible are shown in the list for selection - this will need to link up the customer list table). How can I do this?
3. For Product No and Product Name in the form, we assume one customer may ask for quotations of many items. When I just copy and paste the Product No and Product Name several times in order to create several fields, I find that when I input one field (let's say Product No), all other Product No fields will show up the same product no as well. They are not treated separately. How should I fix this problem?
4. For the product price, I want the price in the Product List will show up according to the product I choose in the form. But then, it will allow me to amend as needed.
5. Finally, I want to place the save and submission buttons at the end of the form. Once it's done, the form will be sent to the Supervisor. The supervior will review and approve if correct. The Salesman can look up the database and be able to see the status of the quotation as:new/ waiting for approval/ approved by.... by opening the submitted quotation form (the status will be shown on the top of the form).
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
The user will be creating a new project that contains a bunch of releases. The releases have standard names which are stored in a table tbl_ReleaseNames It should be noted that the list of names is not static.
The user selects which of the releases pertains to their project and then based on their selections, new records would be created in tbl_RFP_Release and then a subsequent form would open where it would display each of these newly created releases where they could enter additional information. I thought of creating an unbound checkbox associated with each of the standard names, and then checking to see if the checkbox was checked and then creating the new records followed by opening up the new form.
I've built a PostgreSQL database for some ecology data and am trying to use MS Access 2010 to make a front-end for it.
I've created a form to display site data; it includes such fields as site ID, site name, county, state, landscape, etc. (There are more, but if I can get the idea down with a couple of these, I should be good to handle the rest). One can click through the form and see 14 pages of site details, which is fine because there are 14 sites.
What I want to do now is make a search form in which one can enter values for site ID, site name, county, etc, and somehow get the pages of the display form that match those values. It's not terribly important to me how that output looks - whether it's a list of matches that allows for clicking on a match and showing just one page of the display form, or whether it's a filtered subset of the display form pages that one still clicks through to view them all.
if there is code to write, where do I type it? Do I start my search form by making a form with the search fields as values, or is there some other way? How do I make those search fields into search boxes rather than display boxes?
I have a table with columns: Login, First Name, Last Name
I need to create a form with one text box and a Search button.When i enter the Login in text and click the button it should give me the details.I am able to do it with single Login being entered.But the catch here is i want to enter multiple Login in the single text box and search and it should give me the result.
I am having an interesting time on a project. I am trying to create a small inventory management database with BOM (bill of materials) control.Today I am working on how to create the BOM's. In case your not familiar with inventory management, a BOM is basically a list of items and quantities used when creating a product.
Since it is possible for a single BOM to have over 200 Items associated with it, I can not have a single table with all my BOM's (fields max at 255) So I was thinking I would be able to have a Master table with the BOM list and then create individual tables for each specific BOM.I am not 100% sure how to make this all work together but I am struggling forward on my quest..
I was hoping I could create a form for BOM management, (create/edit/delete) but since I can not keep the BOMS in a single table I would need this form to create the new table.
Is it possible for a form to create a table? or do I have to create the table first than have a specific form per table to do the editing? or perhaps a drop down selector to choose which BOM/Table I am working on.
May not be using the correct terminology here. I have a form that currently does not have a RecordSource. From this form, I want to create a table called "ICEA" with the following fields (which would be entered from the form): OperatingDay, Hour_Ending, Import, Export, and Net.Can this be done with a SELECT statement or does it have to be done through VBA?
I have a form with checkboxes, indicating fields which can be selected for a query. The strSQL variable works fine, and I can use QUERYDEF to create a query from the variable.
I wonder if it is possible to generate a form to display only the fields chosen - i.e. I don't want a general form with all fields, with only the chosen ones displaying data. Instead, if I select only 5 of the 10 fields, I want the form only to show those 5 fields.
Creating textboxes for each field, and using the .visible property, but then I would have lots of gaps on the form.
I hoped it might be possible to use a loop with a value set something like
For i = 1 to fieldcount textbox(i).recordsource = selectedfld(i) 'somehow know where to place the textbox!?!! Next
Is there a way to create a form that anytime i open it , i enter the data, when i hit save. the fields in the form goes blank and the data is saved in the table. Also when i open the form again, and repeat this process , it just adds to the table and does not delete previous data.
I have created a form to be used for data entry, Where i have identified standard data, I have set the Combo Box on the form to be a "Value List" so as to standardise the data entry.This creates two problems for me.
1. When Using the form, instead of saving the text value to my table it is entering a numerical character?
2. On two of my combo boxes, whilst they have been configured the same, when i try to select an option for the list, it does not accept it? when i try to type the same option into the field of the form it tells me that the option is not in the list?
I've developing a QA/QC database for testing chemical products and I'm stuck on the best way to continue with adding multiple records by using one form.
I have two tables:
tblProductSpecs with two primary keys, "ProductName" and "TestName"
tblResults with three primary keys, "ProductName", "TestName", and "LotNumber" and a number field named "Value"
A product can have multiple tests associated with it, e.g:
ProductName - TestName XXX - Density, pH ZZZ - Density YYY - % soluble, cloud point , freeze point This is my tblProductSpecs table
I want to store the "Value" of each "TestName" of the "LotNumber" of that "ProductName" in tblResults by a form. (All TestName values are number values).
I want a form where I can select "ProductName" and have the "TestName"s displayed for that "ProductName". Then I want to store the value of that "TestName" for that "ProductName" and "LotNumber" in tblResults.
The problem is that each test per product per lot number is a record and I can't figure out a way to create multiple records from one form.
trying to understand how to create a form with a Junction table. This design will allow a book to have more than 1 author.
Author table Author ID AuthorName
AuthorID table (Junction table) AuthorFK BookFK
Book Table BookID Book Name
Author table has a 1 to many relationship with AuthorID table and Book table has a 1 to many relationship with AuthorID table. Now how do you create the forms? Do I need a main form FrmAuthor , subform FrmBook and a frmAuthorID
I want to create a form that allows a user to enter criteria that will be passed to an existing make table query. suggestions on a user friendly book on Access 2010 programming, I'd be really interested. I'd like to be able to do more with Access 2010.
I am investigating on the possibility of setting up an approval process for our employee intake procedure by using MS Access and Outlook.
The idea is for the requester to open an intake form in Access and fill in the new employee's information and send an Outlook email to the manager for approval. I know how to trigger off an event on the form to send an email to the manager but my challenge is how to create a hyperlink in the email for the recipient to directly open the intake form with the specific record, without the need to open the database and find the specific intake form.
The intake form is built in a frontend .mde file on a shared drive where all users have access to.
I would like to make a form that can insert more than one row at one time. Something like add first column, then ask the user how many of the second row they would like, then prompt them for what is in the second row then add the information for the rest of the columns and have a separate row for each of the second column. So every row with have the same first column, but from there have a different row for how ever many desired in second column. So lets i enter for the first column, ABC, then I wanted 3 rows with ABC, then prompts me for the rest of the information for each of those rows separately.Something looking like this, oh and it would be updating an already existing table.
EDIT: I would also like to know if it is possible so it does it in ranges and dont have to do it manually like you enter the first column then enter a range for the second column and a bunch of rows are made with each value in between the range that was specified.
I want to create a button that executes an SQL statement in a form. The reason I can't just save a query and run the query from the form, is because the SQL statement needs to use a combobox value from the form. I've learned that docmd.runsql will not work for a simple select query.
I have a continuous form based on a 'start date' - 'end date' query. I would like to be able to select certain records from this form to print.
I have added a 'print' field and have created a new query including this parameter which a report can be based on but when i run this report I am, of course, asked for the original 'start date' and 'end date' again.
Is there any way of linking the command button to only the records on the current form?
I'm working to create a staffing database that houses changes to staffing week over week.
I have one primary table, the "empMaster" table, that stores the employee's name, contact information, etc. I have other individual tables for noting which employee reports to which manager, what their business title is, what group they're in, their training history, etc.
Once I've populated the empMaster table with employee information, I want a form that allows me to update each of the other tables IF there as a change. Some weeks will have a manager change, some only a business title change, some a group change, some a training change, some all of the above. The problem I run into is that I will sometimes process hundreds of changes a week, sometimes only 10-20 so I almost have to use datasheet view for mass edits. I'm relatively new to Access and I'm having a hard time getting my form to allow this level of flexibility and to update all fields needed.
When I build a form that includes more than two tables (let's say I want to update a Manager and a Business Title), the form will not work and populates nothing. I believe it's because Access wants there to be an existing record to match to across all three tables and there will not always be.
How do you create a form that is not tied to one single record source? In other words, I want to be able to select the record source that it updates. I have a bunch of tables that have the same data structure but are separated due to geographical nature among other reasons. Is there a way to do this?
What the database currently has: A payment entry form consistenting of many fields. This form populates a payment entry table. Some of the fields within the payment entry form are linked to other tables and queries for data (such as a recipient list).
What the database now needs: A group payment option. Should ten people attend a dinner, the total cost needs to be divided among the attendees, and then the payment entry form table populated with ten different entries and the subdivided cost of the dinner per person.
My thoughts: The most ideal thing to do is to have a hidden recipients window show up when the user indicates that this is for a group event. The user could then add all the additional recipients (beyond the primary which is already collected on the form), and the total amount for the meal. The database would then generate an entry for each recipient listed, dividing the total cost among them, and then simply duplicating the rest of the information as is.
