New Entry In Table
Nov 23, 2004I have an input box that gets a string from the user. I want to put that string in a table. How would I do that?
View Replies
ADVERTISEMENT
Forms :: Assigning Multiple Entries In One Table To A Single Entry In Another Table
Jul 24, 2013I've got a table tblPatienten, a table tblRechnung and a form frmRechnung.
The primary key in tblPatienten is KundenNummer, the primary key in tblRechnung is RechnungsNummer. The relationship between tblPatienten and tblRechnung is one to many.
Now, every patient (stored in tblPatienten) is allowed to make multiple orders (stored in tblRechnung).
How can I assign each new order entry in frmRechnung to an existing patient in tblPatienten?
Forms :: Display Some Fields From Master Table And Only Last Entry From Child Table
Jul 1, 2013I have 2 tables, master & child. with a one to many relationship.
On one of my forms I want to display some of the fields from the master table and only the last entry from my child table.
How would i accomplish this?
How To Make Two Table Entries Correspond To Single Entry Of Different Table
Nov 18, 2013I have one main table with a list of equipment. I have a second table where there will be a form for damage reports.
What is the easiest way to make multiple entries from the second table correspond with a single entry on the main table?
Some equipment pieces might have dozens of damage reports, while some might not have any.
Why Won't It Update This Table Entry?
Mar 11, 2008Hi there. My mother (who hasn't programmed in say 25 years) has been driving herself absolutely up the wall trying to figure something out. So I'm asking here since my programming knowledge does NOT include Access. We have a form for keeping track of previous appointments and scheduling the next appointment. It's a simple form consisting of a "Date Last Visit" text box, an Interval integer text box, and a Date Next Due text box.
What we're looking for, is to have it so that when the user clicks on or tabs to the Date next Due text box, it reads what's in the Date Last Visit variable and changes Date Next Due to Date last Visit + 3 months. So... here's what we have.
Code:Private Sub Date_Next__Due_GotFocus() 'MsgBox (Interval) If IsNull(Date_Last_Visit) = False Then Date_Next_Due = DateSerial(Year([Date_Last_Visit]), Month([Date_Last_Visit]) + Interval, Day([Date_Last_Visit])) End If 'MsgBox (Date_Next_Due) End Sub
Now if I uncomment that bottom msgbox, it shows the correct Date_Next_Due... But it's not displaying it on the Form, nor is it updating it in the table! We've had this working before, but due to an accidental deletion and some other messing around, I CAN"T FIGURE IT OUT! So why isn't it updating?
If there's anything else you need to know, please ask. We really need this to work. Thanks so much in advance!
Locking Table After Entry
Feb 6, 2007I have created a part number generator for our Manufacturing company. Usualy there are a few changes on some of the information within a few days of being created. Is there a way to lock information in certain rows, after it is finalized?
Thanks,
James
Tables :: First And Last Entry With A Key From Different Table
Oct 13, 2014Can I determine what the 1st and last entries are with a key from a different table
For example I have a job parts table (ID= JOBPARTID). There is a specific part that may be replaced several times. I keep these parts on a separate table called swaps. The swaps table is purely
SWAPID (KEY)
JOBPARTID
PART
PARTDESCRIPTION
SO on file I'll have
SWAPID JOBPARTID PART PARTDESCRIPTION
001 1234 PART1 DESC1
002 4231 PART2 DESC2
003 1234 PART3 DESC3
004 1229 PART4 DESC4
005 3241 PART5 DESC5
006 1230 PART6 DESC6
007 1234 PART7 DESC7
008 3289 PART8 DESC8
For JOBPARTID I want to be able to get the first record (SWAPID =001 for PART1) and the last one (SWAPID = 007 for PART 7).
How do i go about it?
Adding One Entry To More Than One Table At Once
Oct 15, 2015I have created a database and I have the same primary key(SITE) for more than one table. I can not seem to figure out how to create a query to add an entry to all the tables that have site as the primary key. Also, I am running Access 2003
View 1 Replies View RelatedQueries :: How To Trigger By Date To Create A New Entry In Database Based On Old Entry
Aug 6, 2014I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.
Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.
Automatically Create A Table Entry
May 10, 2007In my DB I'm tracking seed. I have a form that I enter in some info in and an ID number is created (based on that info). Then in a different form I track "events" that happen to that ID (drying, moved, bagged). Is it possible to have a button or something like that that after my ID is created from my frmHarvest to automatically generate an event in tblEvents that has the date the ID number and then have something like Harvested in the description field?
If possible can I get some hints on what to do?
Thanks,
Rick
Auto Entry Of Fields From Another Table
Nov 23, 2007I have a simple table called CUSTOMER with contact details on there...First NameSurnameDate of BirthAddress 1Address 2Address 3Town/CityCountyPost CodeemailetcI have a second table called TOWN_COUNTY_REGION that lists all the towns and cities in the UK. Each Town/City is listed with its corresponding County and Region. This table has 3 fields...Town/CityCountyRegionThe TOWN field in the CUSTOMER table is populated by the user selecting from a list of towns in the TOWN_COUNTY_REGION table. When a user clicks the town that they are in, I would like the appropriate COUNTY and REGION fields to be automatically populated in the CUSTOMER table. So, for example, if the user clicks LIVERPOOL from the list of towns and cities, Merseyside and Northwest should automatically be populated in the other 2 fields.How do I do this ??Many thanksAllan
View 13 Replies View RelatedData Entry In A Junction Table
Dec 18, 2007Hello all,
I just wanted to run this by some experts before I go mucking around in my db. Basically, I am creating a data entry form to populate with information about car parts, and the vehicles they apply to. This is what I am working with:
tblParts tblModelsParts tblModels
PartID ModelPartID ModelID
PartNumber PartID ModelNameID
PartDesc ModelID ModelYearID
I am trying to build a form that will allow me to enter new part numbers and descriptions into the table, and then have the user select (through a listbox?) all the vehicles the parts apply to. Is there a way to populate the junction table with each combination of partID and ModelID automatically? NOTE: tblModels is already populated with data.
I am assuming there would be a way to do this... A query of the junction table (and tblModels?) as the recordsource for the form, and then a subform with the tblParts as its recordsource?
I would have posted this in the massive thread I have going already... but I thought it might be nice to give Craig and Adam a break from helping me :o
Updating Table From A Combo Box Entry
Oct 22, 2007I am learning access on my own, so please bear with me.
I am using Access 2000.
I have a form with a combo box. I use this form to enter data into the database. The combo box selections are from a separate table. If the required entry is not in the drop down menu selections from the table, the user needs to type in the proper selection. If this happens I want the table driving the combo box dropdown to be automatically updated with the new entry so that the data will appear in the drop down menu selections the next time. How is the best way of accomplishing this. Thanks for any answers and examples.
Editing Table Entry From Form?
Aug 27, 2015I have a Form that is used for creating entries to fill a table. On the same Form there is also a list that shows everything in the table and a double click on the list will populate the Form with that data. The problem is that "Save Record" command button will not update the table because it thinks it is creating a new record.
The code to populate the form from the list is
Private Sub EmployeeEntryList_DblClick(Cancel As Integer)
Me![Number] = EmployeeEntryList.Column(0)
Me![EmployeeNumber] = EmployeeEntryList.Column(1)
Me![FirstName] = EmployeeEntryList.Column(2)
Me![MiddleInitial] = EmployeeEntryList.Column(3)
Me![LastName] = EmployeeEntryList.Column(4)
Me![Supervisor] = EmployeeEntryList.Column(5)
Me![Group] = EmployeeEntryList.Column(6)
Me![Shift] = EmployeeEntryList.Column(7)
End Sub
how I can make it populate the form if an entry is double clicked and then be able to save a modified version of that record over top the original.
Conjunction Table Data Entry
Aug 22, 2014i have 2 tables, "Items" and "Locations" and i created one to many relation from each table to 1 conjunction table, and Added one extra field called quantity into the conjunction table, so now the conjunction table has 4 Fields, ID AutoNumber and "Item" "location" "quantity" Fields, ok and i turn it into query then put the fields in form and use it as a data entry
im looking for a way, where if I choose an item From the item combobox, the locations where this item has quantity in it, would be available in the locations combobox, so i can add on the existing quantities...or to make it eazier, when i choose an item, it would let me choose all the location names which have this item next to it, so i may ( edit and add) the previously set quantity field
Forms :: Combo Box To Verify With Last Entry And Display Other Options Than Last Entry
Sep 8, 2013I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.
View 3 Replies View RelatedCreating A Table Based On The Latest Entry
Jun 14, 2005I am working on a jobs database where employees enter information where the job is being handed off to. I want to create a table showing the latest job entry by date. The jobs are listed by "Job Number" and when I try to create a table and remove the duplicate "Job Number" it does not always remove the oldest entries.
Any help would be appreciated.
Using A Table For Both Data Entry And Building An SQL String
Oct 8, 2007I have a table that lists county names. On the data entry form only the county names are displayed. However, I have another form that is used to build a custom query based on various criteria, of which county is one.
To make the table compatible with both both forms, the data source for the dropdown list for data entry is: Select * FROM county WHERE county <> "No Selection"
For the SQL form the code is simply: Select * FROM county The default value of the dropdown list is "No Selection". When dropdown list for county is set to "No Selection" the program interprets it as "select all counties". Other dropdown lists provide other parameters such as the project year, nature of the project etc. Each of these other dropdown lists also have a default value of "No Selection". The SQL form thus gives me the ability to mix and match several criteria. For example, it will display all projects in a particular year for a particular county or all projects in all counties that involve the construction of a residence.
My question, instead of physically having the string "No Selection" in the table itself, is there a way to embed the phrase "No Selection" in the SQL expression itself and still have it as an option on the dropdown list?
Clicking On Name In List To Move To That Entry In A Table
Jan 31, 2006http://i9.photobucket.com/albums/a66/bubbajoe12345/workspace.jpgI've created a nice form for entering information into the record -- works for viewing the records as well. Here's the thing, in a traditional Rolodex you can somewhat see the names of nearby records. With this form as is, when using the arrows at the bottom to move around in the records, you can't really be sure how far away the name you're looking for is. See that mini table in the top left corner? I'd like to make it so that, when you click on a name there, the rest of the form changes to the corresponding information.
All of the rest of the form is linked through social security number. When a new person is chosen in the main body, all of the other tables change to reflect his information. Except for that single table in the top left corner. That table is unliked to the other tables and is merely sitting there on the form right now.
So, how can I link them such that selecting a name from that top left corner will change the person in the main body of the table (and thus change the other tables)?
While I'm asking, what's involved with turning this form into one of those Database Web Page things?
Thanks for all of your help, everyone, I wouldn't have made it this far without you.
How Do I Lookup Something From A A Different Table On A Data Entry Form?
Aug 23, 2006Okay, for simplicity's sake, I have a data entry form.
It is bound to tableData.
Inputs are:
ProductID
Customer Name
ProductID is a combo box.
There is another table called tableProduct. In this table, is ProductID and ProductName.
For convenience sake, when a user chooses a ProductID from the combo box, I want it to lookup that ID from tableProduct. However, how can I do this when everything is already bound to tableData?
Thanks in advance.
How Do I Lookup Something From A A Different Table On A Data Entry Form?
Aug 23, 2006Okay, for simplicity's sake, I have a data entry form.
It is bound to tableData.
Inputs are:
ProductID
Customer Name
ProductID is a combo box on the form.
There is another table called tableProduct. In this table, is ProductID and ProductName.
For convenience sake, when a user chooses a ProductID from the combo box, I want a separate textbox to lookup that ID from tableProduct and display the ProductName.
How can I accomplish this?
Thanks in advance.
Multiple Record Entry From A Form In A Table
Nov 9, 2004Hi All,
I am coding in VBA and use Microsoft Access as the front end.
My question is : I have a table(tblStudent) which has two fields Student Name and Gender.
I want to add multiple records in this table through a form at a button click....(Say I want to add least 5 students at a time)
So, I have 5 textboxes for student name, 5 textboxes for Gender and an Add button.
How do I so this programmatically?
Any help will be appreciated.
Thanks.
Multiple Table W/ 1 Multidata Entry Form
Mar 29, 2008The way my tables are organized:
Clients --> OrderInfo --> Ordered Items
I'm trying to do an order form with the following :
select the user < drop down >
upon selection, their information such as cc #, experation date, etc will be visible in the associated data boxes.
if they are not in the drop down list, there will be a button to add a new user
enter the info for location, date, time, etc
enter the purchased items.
submit form either by clicking create new order, or finish which brings the person back to the switchboard.
Thanks in advance.
Forms :: New Combo Box Entry To Add Record In Table
Nov 19, 2013On a form to enter some new client info, I want users to be able to select their UserID from a combo box for future reference to other users (ie; Who made these notes?). For various reasons I want them to be able to add their UserID to the combo list for future selection if its not already on there.
There is a table set up for users, simply called tblUsers, with a single field, UserID. A query from this sorts the list alphabetically, and the combo uses this query to populate its list - qryUserID.
Users can currently select from a list or write their own UserID in the box, however when they write their own ID it doesn't get saved.
I don't need any message boxes or checking, just add it and move on kind of thing. It doesn't need to refresh the list immediately, as the user moves on swiftly once completing 2 more fields.
Adding New Record To All Tables For 1 Table Primary Key Entry
Oct 20, 2006Hi, I have 7 tables in my database and 1 form corresponding to all the fields in these tables (linked by a query by recordsource). My problem is that the form will only show a record if ALL 7 tables have manually had the primary key entered (not good when i have information that needs to be added at different times). How can I make it such that if I create a new record on the form that all primary key fields will be updated, and this record will be present every time i open my the form??
Cheers
Tania :o
Using Table Data Query For Entry Validation Rule
Aug 15, 2007I'm new to access so I thought this would be easier than it is. I have a list of cities in a simple table . I want use this list (or a query of it) to create a validation rule for a field in a second table "City". How, either with VBA or some other method do I use the Cities database to validate entry. These tables are both in the same project.
Any help is appreciated.