Hello out there,
I am looking for some really smart people to help me with a problem.
I have a library forms database full of names of tapes and CDs, like a library. I also have an order form database. I would like to toggle between the library and order form pulling information from the library directly into the order form. I need help
I have a form with several controls. Among them are 3 in particular:
Vendor Price - Unit cost with no tax
Unit Price - Vendor Price w/tax
Old Price
What I am trying to accomplish is a way to track what previous costs were by having the Old Cost control populate with the Unit Price controls value when there is a change to either VP or UP either due to new cost or new tax rates.I found a bit of code online but was not able to get it to work for me...probably because I haven't a clue of how to structure it for my needs.
Hi all ... been awhile since I have had to create a database so I have gotten a little rusty. :eek:
I have a form where some of the fields I have formulated to calculate an amount. Example... =[GrossAmt]*[FeePercent] This is calculating into the form correctly but not writing to my table for that field. What am I doing wrong or missing here?
http://forums.aspfree.com/microsoft-access-help-18/menu-list-values-won-t-pass-to-db-20951.html
Here's a page that shows almost what I am trying to do, but my question is how do I make selecting an item in my listbox pupulate date in multiple field on my form?
For instance, I want to click on a line in a textbox and have the fields "City" "State" and "Zip" all changed on my form, not just "City"
I have a Form in a datasheet view and i would like to be able to double click on a record (ideally any part of the record but if not, on the name at least) and have it open up a form to that record details.
Picture 1 is the table with the records in.
Picture 2 is the form i want it to open and populate.
I have created 2 tables: Client and Routing.
Each client record is unique. A client can have 'several' routing records.
Key field in Client is 'Client ID'.
Routing table has foreign key of: Client IDFK
I created a relationship of one to many from Client table 'Client ID' to Routing table 'Client IDFK'.
I created a form for the Client table and works.
Where I am having issue is: Client data is not populating into the following Routing form.
* I want a 'Routing form' that you can lookup client info and place it into that form.
* The bottom of the form will be all the routing table fields. The new routing info will be entered into it.
My client needs that form printed for the driver. Client will have many routing forms(records) but only one client record. The driver will have one completed form for each time he picks up client.
I'm trying to populate a listbox from a recordset. I will explain what I'm trying to achieve.
I have a (continuous) form with some data from a table. On the form header I have a listbox, showing all (distinct) customers from that form.
The user is able to do some filtering. That all works great. But I want to populate the listbox with ONLY the customers on the form AFTER filtering.
One way I thought might me the solution was using RecordClone. But I'm stuck there. It must be something simple for an expert. I'm not entirely a newbie, at least not to VBA. Is there an easy way to refer the listbox' recordset to the actual recordset on the form?
See this image so you know whats going on:
http://static.flickr.com/65/168560405_1b8ea5cc82_o.jpg
This is a DATASHEET VIEW, not a table.
I have a table that has the part number, the description, and the usage.
I am stumped on trying to get just the 2 fields to populate into this subform (datasheet view), when the part number is selected. I may have several lines of part numbers. How do I go about populating this form? The user will indicate the actual quantity. The quantity changes per order, yet the usage stays the same.
Any suggestions?
Bradley
Hello all.
Does anyone know of a way to populate an access database with data, specifically 1000 entries(These entries would consist of 2 fields one of which is text and other is numbers.) to a database table?
Thank you.
I haven't used access for a long time so I am very rusty.
I have a few tables but I'll just use two for an example:
Table A
Ticket No
Part No
Defect Code
WorkCenter No
Clock No
(Ticket No is Primary Key)
Table B
Clock No
Supervisor
Employee
(Clock No is Primary Key)
Is there a way for me to create a form, that when Clock No is entered it will be placed in both tables?
Thanks in advance.
I have an Access 2007 database with two tables (I will call them table 1 and table 2)
Both tables contain the same two fields. (I will call the FirstName and LastName)
Table 1 has an associated Form where the user enters the two names. When the value in either one of the two fields in Table 1 change I want the corresponding field in Table 2 to automatically update with the same value that were entered in Table 1. Basically I want Table 2 to automatically replicate the same data in Table 1. So if I type the text "John" into the FirstName field in Table 1 then the FirstName field in Table 2 will automatically update with the text "John"
I am new to access and am struggling with the automatic updating.
If the automatic part is too hard then I will be happy to attach the update action to a command button.
I have uploaded my database file with the two tables for reference. I want to get the fields (for all records) in table 2 to replicate table 1 so that when table 1 updates table 2 values changes to show the same text.
I am trying to populate fields from one table into another field in a linked table. Specifically, I have a giving table and a persons table. I have the giving table have the persons primary ID field in the giving table. I cannot seem to automatically link them if I am adding a "gift" record. The gift is a dollar amount given by that person. I have a unique primary key for each financial contribution which is supposed to be tied to a person's primary key and last name in my "person" table. Am I missing something in this design?
View 3 Replies View RelatedI am generating a report from my database that I would like to turn into an invoice. My report generates perfectly, but I need to add an invoice number when I print the report and I need to take the data Customer ID, Invoice Total, and a maybe other data from the report and populate the Invoice Record table. I have VB code that is generating my Invoice No, creating a new record in the Invoice Record table and populating the Invoice Record Table with the Invoice number. I want to add this Invoice No to my report at time of printing, and populate the Invoice Record Table with the fields from the report as stated above.
View 10 Replies View RelatedHi Experts! I'm having a problem that I hope some of the experts can help me with. I am in the process of designing a database for a health insurance company that does health fairs.
I need to have a data entry form for the nurses to enter the Health Fair results. I created a form for them to search for the Employer group. They type first few letters of the group, click "find group" button and it brings up a subform (frmGroup_sub) with the filtered group. I then have the group number (field PARGRP) hyperlinked to bring up another entry form (frmHF_entry) when clicked. I need the user to be able to find the group, click on the group number, then bring up another form which autopopulates that PARGRP from frmGroups_sub into the new form, frmHF_entry and stores that group number in the table tblHF. Further, they will need to do more than one "employee" for the pargrp. So I was going to make a subform of frmHF_entry where they could enter multiple records for that same PARGRP.
I just confused myself and probably all of you...but the problem I am having is I cannot get PARGRP from frmGroups_sub when clicked to open and auto populate the form frm_HFEntry.
Here is a screen print, maybe it will help explain what I need.
http://img82.imageshack.us/img82/1065/frmhfentry1ed.png
thanks in advance for your help.
I have a client table with a field called location. On a reports form that I have, I want to make a combobox for all of the locations, so it could show all the clients from a particular location and also it would reduce the errors due to someone spelling a place name wrong. I could set the source to the location field in the table, but that would show them all in the order they come out and there would be duplicates.
Any help would be cool. Cheers
Bob
I have a parent and sub form in dataset view.
What I would like to do is prepopulate the subform with data from the parent form when I create a new item of data..
i.e.
When I click the "+" button Field1 on my subform is populated by Field1 on the parent.
I have tried beforeupdate on both the subform properties and the subform.Field1 properties.
I want to know a way of populating unbound textboxes with data from a table without using the easy assigning data in the property of the box. I want it to be all done with code, which to me isnt a huge deal but I've yet to find answers on the web pertaining to this issue.
for example:
Say i was searching a primary key in one box and based on what ever is typed in i'd like it to populate the rest of the textboxes.
I am trying to create the form so when the first field (Start Date) has a date selected, it limits the following field (Report Date) to the matching available data, and same with the third field (Production Division) on the previous two.
I also need the form to allow new dates / production division combinations, but not duplicate.
I starting working with a cascade function but got confused and not sure if that is where I should be headed.
I have attached 2 different formats of the same sample data.
I am trying to setup a database in order to demonstrate a tie in between active directory and the HR side of a business.As such, I would like to select two fields from drop down menus that reference in Department and Location tables, but use this data to actually Populate the Personnel Records table rather than Query.I know this is not normally best practice from a DBA perspective.
I have this setup already in Filemaker, just through using relationships.However, I want to move to Access, as it is more industry standard and much lighter weight, so am trying to find the best way.I have attached two pics of my filemaker database, and a zipped copy of my Access file.
I have a simple table with two fields in that table called:
1. BankName
2. BankNumber
Each bank has a bank number. For example Bank XYZ and all of its branches have the same Bank Number 123. There are 5 banks I have listed in a combo list under the BankName field. I can also type in a different bank in that same field if it is not listed in the combobox list.
Now, I want the BankNumber to automatically populate based on what I choose under BankName. If the BankName is manually entered (for banks that are not in the combobox), or if the BankName field is blank, I want the BankNumber field to be able to enter a number manually.
For example, if I go to the BankName field and under the combobox I select Bank XYZ, i want the BankNumber field to automatically populate as 123. If the BankName has a bank name that was manually entered, i want BankNumber field to allow me to manually enter a number.
Thanks for ur help. I couldn't figure this simple request out.
I am new to database and hope this is a simple problem.
I have a few thousand products each with their own code and description.
I would like to create a form that when I type in the code the description self populates in an adjoining box. I would like to enter at least fifteen codes and their descriptions per form.
Have tried related tables using forms and sub forms with child/parent link but any editing of code changes the information back on the table.
Tried parameter query but how can I get more than one code on a form at a time?
Any suggestions greatly appreciated.:confused:
:confused: I recently added a find button, using the wizard in access, i am searching three feilds ( Id, Last name & first name) when i type in these feilds and want other info to populate on the same form. now i need to update the code, so that when i hit the find button it does populate.
can anyone help
Thanks
PS the form is based on a table and not a query, I saw some info in the forum about using a combo :confused: box, but i don't want to do that.
Hi everyone. I'm new to database design and hoping htis is a simple question.
I have nine thousand products each with their own code and description. I want a form that allows me to enter a product code and will then self populate an adjoining box with the corresponding description. I would like to enter at least fifteen codes per form.
I tried a linked form and sub form with a child/parent link but the tables info can be changed if the form user edits/deletes etc a code.
I tried a parameter query but don't know how to do more than one and the format isn't really suitable.
Any suggestions would be very much appreciated.
Thanks
:confused:Sunstar :confused:
Good day,
I have a main form with project data and a sub form that has related financial information. Once the user selects a particular project from the ProjectType drop down box, a field called Project Codes in the subform should be populated with only project codes for that particular Project Type.
Can someone assist?
Thanks
I’m fairly new to Access so I hope I can get the terminology correct. I’ve been working on creating a database which has a one to many relationship. With the help of the people in the table forum, I do have that working correctly, and even have a form and sub form where the data can be successfully input.
In short, I have a main item table to track my widgets. I have a reference or look up table of colors. Third, I have a relationship table that manages the one to many relationship. My main input form has all the fields that need to be plugged into the primary table. The Sub-Form is setup for continuous forms which allow me to input as many colors as I need. Again, this all works great.
Now, to go to the next level. There are times when I want to select many (lets say 8) different colors to my widgets (kept in the primary database and form). To select each all 8 colors each time is somewhat of a pain. It is my hope and intent to create a button on my sub form that would populate my subform with the static 8 colors that I want, thus bringing me down to a single click instead of 16. (1 for the drop down, 1 to select the color).
Is this at all possible? If so, can someone give me a shove in the right direction?
Structure as follows:
TblWidgets
•Widget – Text
•Value – Numeric
•Description – Memo
•Type – Text
TblColors
•Color - Text
•Description – Text
TblWidgetColorRelationship (one to many relationship)
•Widget – points to primary key in TblWidgets
•Color – points to primary key in TblColors
Thanks,
Joiry
I deal with freight carriers and each one is assigned a code. There are over 30,000 carriers so I don't want them all in my carriers table.
I have them all in a CarrierCodes table. I would like to open a form that would allow the user to search for the appropriate carrier and when they choose it would populate that data to my Carriers table.
Any help and suggestions will be appreciated.
Thanks.
Gary