Search results

Hi Mark, there is an After Update event for the masterDescription field that is supposed to Requery the subform so that a list of items get added to the record in that subform. I have attached some screen captures and here is the code: Private Sub txtmasterDescription_AfterUpdate() If...

Hello, renewing this post. I am trying to recreate this idea in a database. I have downloaded this sample database (CheckListDB-003). I have also viewed Uncle Gizmo's tutorials. The problem I am running into is in this sample database, when you add a new record, the list of items does not get...

I found a solution that works. It might not be pretty, but it works for what I wanted to accomplish. 1. I made a query "qryEnterCaseCountsByMonth" with conditions. 2. Made 2 forms, 1st one to make a month selection "frmEnterCaseCountsByMonth". The 2nd form would open (using vb code and the...

Yes I have the tables, I will upload a stripped version of the db. Like my first message said, I have a table for Months, a table of names, and a joined table with the months, names, and a field to enter the number for workload. I need to make an entry form for easy data entry which you select...

Hi, I've tried searching for this, but I guess I'm not using the right words when searching. Background: I need to enter workload counts for 10 people, and it is done on a monthly basis. So I have a table of Months (Jan-Dec), a table of names, and a joined table with the months, names and a...

Just wanted to update this thread in case it will help anyone with a similar situation. I have found the solution this question. When entering a records in a form, I wanted fields to be duplicated for the next new record and I found the solution using DMAX and DLOOKUP. I found a tutorial on...

As a side note, before someone asks "Why do you want duplicate records?" ... the user just wants easier data entry, the majority of the fields would stay the same, but 1, 2 or more fields will be changed by the user, so the new record really won't be a duplicate after the user has made his...

I have a form (based on ArtistSong) and a subform tied to the ArtistSongID. This subform is a set of 11 variable attributes of that Artist & Song combination. Also, there can be multiple records in that subform, all associated with the Artist & Song. The user would like, when he makes an...

Thank you jdraw, looking at that tutorial refreshed my memory and helped me to set up what I hope will work-it appears that way.... If anyone is interested here is what I did with a screenshot of my Record Entry Form. I made a table of Artist & Song, made another table with all the attributes...

OK, have been searching and found Allen Browne's tips, I was thinking about Yes/No Checkboxes-then found this: Don't use Yes/No fields to store preferences ( allenbrowne.com/casu-23.html ) This would work for what I want to do, but I'm not sure what tables I need to relate to one another. His...

Thanks for the reply, I have normalized and pulled out the original data into separate tables (Artist, LD, CD, QR, Tag, CR1, and so on). I was looking for an easier way for him to enter new music or make changes to existing entries. The spreadsheet entry method worked for him, but it is a huge...

I'm helping a guy who runs Karaoke shows redo his database of music since his old system (Lotus database which he made himself is way past its lifecycle). I looked at his Lotus database (and I say that loosely-it was bascially a big table with everything in it-it looked like a spreadsheet) which...

How about using a command button that will open the form to the selected record, there is a wizard that will assist you. I cannot post hyperlinks, but there is a good tutorial on youtube. Search for this video "Microsoft Access Open Form to Specific Record" by 599CD computer training.

I have a search form with a subform (it's a query). When you search for an entry, the results show up in my subform. Is it possible to select that record from my subform and have it open up in my main form for making changes to that entry? Either with a control button, macro or coding...

So, would AccessionNum be a foreign key in the above named table? Would PartID be a foreign key as well?

AccessionNum is assigned uniquely as the tissue case is brought to our lab. Yes only one pathologist is assigned, and yes it will always be numerical Basically those are all the tests, but theoretically if a new test is brought in to our lab, we would need to add a new test.

Thank you for explaining steps for me. However, I don't understand why I would need to build a tissue table-the doctors would do that by entering the case accession number, which I made the primary key in my order table. I have a parts table and test table made-to be used for lookup fields. I...

Greetings everyone. I'm trying to set up a database to order and track tests that need to be run on surgical tissue samples. They currently do this with paper request forms, and I wanted to automate the task for the doctors I work for. Basically a tissue sample is identified by an accession...

I'm glad to have found this forum as a learning tool for working with Access. I currently live in Florida and work for the VA, trying to make a difference for our wounded and sick veterans. I'm a beginner with Access trying to build my first database. I took an introductory level course years...