Search results

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

So, make the original person/issue a parent table/record, then have a child table that captures other people that the record gets "sent to"?

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

Thanks Pat Hartman, this is an excellent idea I was trying to figure out! How to grade the differences between the dx types. 😃

I understand what you're explaining, I have seen the explanations of not using a lookup at the table level. I assure you, I did not do that.

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?

No, the lookup is not in a table control, it is referenced by foreign key.

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

Thank you arnelgp! I couldn't really grasp how to get the combo associated with the textbox. I downloaded your sample. It is exactly what I was trying to do. I was thinking of making a separate table which held all the combo values too. SOLVED!

Thank you for the responses. I understand cascading comboboxes, this is similar, except I want the combobox to change according to what is in a TEXT BOX, not a different combobox. I would need to use a Like statement, since each text box contains slightly different variations of body sites: For...

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

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

Thank you isladogs! I tried your suggestion and it worked as well! Your response came just minutes after I had tried dbGuy's suggestion.