The reason your first row in your imported data is blank is because in your Excel spreadsheet, you say "Second row is blank". The import VBA is importing as it should. If you don't want the blank row, either delete it in the spreadsheet, or build into your import code not to import blanks or nulls.
Thank you Doc Man for replying to this post, since it was you who replied on the other post. Your prior explanation about a "chop chain" is what I was trying to accomplish. Your new reply has me thinking... My chain of resolvers is not as complicated as your differing tiers. It's more basic, one...
I found a related post where a replier Doc Man explains it perfectly:
https://www.access-programmers.co.uk/forums/threads/sending-records-from-one-user-to-another-user.317158/
You are essentially talking about approval sequencing, or what the U.S.Navy called a "chop chain" - where everyone...
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...
It's really not overly complicated, but that's probably because I work with this procedure/setup everyday. As far as different bottles of material open and in use, we only ever have one bottle of one chemical open and in use at a time. And when we purchase them, we get 2 or 3 containers, and...
Thanks once again Pat! I did make the modifications to my tables and subform. It looks to be working as I wanted. And also thanks for your instructional database you attached in the previous message.
Pat Hartman, thank you for that insight. I did think I should put the chemicals in a separate table. Let me give this a try. I had tried it before, but I just couldn't figure out how to populate the actual Lot and Expiration date fields into my subform, using the chemical ID from another table
Thank you for your assistance! I took your suggestion to make a query looking for the Top value for each of the StainLot. It did find the top value. As I have two items I need to look for, I made 2 separate queries. Now I am running into a roadblock about how to edit the Insert query statement...
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...
Thank you, I was thinking along that same design, having a "Case" table linked to separate Resident diagnosis and separate Doctor (Final/official diagnosis). But, as I re-read your description, I think you are saying have both resident and official diagnosis in one table?
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...