Search results

  1. C

    "Forwarding" a record(s) to another user

    How would you design a database that tracks "issues" that can be forwarded to another user in the database. Users are in a table. A user enters an issue (date, issue type, issue summary, etc. in another table) How could the original person forward that issue to another user in the user table...
  2. C

    Solved Is there a way to "copy" values in a subform to a new record.

    Hello, I have a maintenance database for an instrument that stains biological samples on glass slides. There are a series of containers with different chemicals in them. Of these, a few have Lot numbers and Expiration dates that are necessary to keep track of. The reason for copying them from...
  3. C

    Need help in setting up a database

    I am in the process of making a database to track performance of resident doctors in training in a pathology lab. So far, I have a table that includes cases (basically: Accession number, date rec'd, specimen source, and diagnosis) They are to look at each case and give their diagnosis. To grade...
  4. C

    Solved Is it possible to change a combobox's choices

    depending on a text box? I have a form with a text box containing body sites which is imported from another application. For certain specific body sites I would like the combobox to have different selections available than for "all others". Is this possible? If so, can it be done on a continuous...
  5. C

    DLookup with 2 criteria

    I have read many posts for this situation and have tried quite a few different suggestions, but it still won't work. I believe I am placing fields in the wrong order or I am missing the required double quotes or single quotes necessary for it to work. Could someone assist? Background: 2 tables...
  6. C

    How would I open different forms based on a combobox selection

    On an After Update Event of a combobox, how would I be able to open a specific form depending on the combobox selection. The Row source of my combobox is SELECT tblClinic.ClinicID, tblClinic.Clinic, tblClinic.FKDataModeID FROM tblClinic ORDER BY tblClinic.Clinic; Depending on the value of...
  7. C

    Default value in combobox, but record will not save

    Hello, I have a strange situation which has me stumped. I have a main form with a subform and a combobox. Originally, when you selected an item in the combobox on the main form, the record would save (i.e. an Autonumber was generated). Then you could go about your data entry in the subform. But...
  8. C

    Combobox dependent on a criteria

    Hello, I have a combobox on a form that is a list of usernames. It works in it's present state. However, what I would like to do is to change the list of names if the combobox is Null (no user has been selected). In that case, I would like the list to select the current user that has the...
  9. C

    Find and extract text if it occurs in first 4 characters

    Hello, I've tried searching for this problem in this forum, but no luck. In a field I have a text string (combination of alpha/numeric) What I'm trying to extract is the string if it occurs within the first 4 characters of the string. I probably need to use a combination of Left function and...
  10. C

    Entering values for multiple people on one form, based on Month

    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...
  11. C

    How to repeat fields entered in a subform

    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...
  12. C

    Help setting up a confusing karaoke/music db

    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...
  13. C

    Possible to select a record from subform?

    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...
  14. C

    Trying to set up a relationship

    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...
  15. C

    Hello from new member

    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...
Top Bottom