Recent content by Bettany

  1. B

    When pasting from Excel the rows in Access are blank.

    Just says you're about to paste 20 records and then I see 20 blanks. If I paste one cell it works fine :(
  2. B

    When pasting from Excel the rows in Access are blank.

    Hi there, I am very simply trying to copy a number of cells from excel to access and whenever I try to do this the cells are added in access but they come up blank. I'm using the special paste append option in access but it's still not working. any idea why all the data pasted from excel would...
  3. B

    Currently have a FK field filled with numbers, but would like to replace those with corresponding text values

    Hi again, Maj. The other table is 9 options and it's creating problems in my split form and in my subforms, so I just want to get rid of the number representation of those 9 options and just simplify with the actual values. I know I could do an update query to change those ID numbers to the...
  4. B

    Currently have a FK field filled with numbers, but would like to replace those with corresponding text values

    I was storing FK ID's in a field in a table, but would like to replace those with the actual values. What is this best way to accomplish this? Thank you :)
  5. B

    Trouble grasping one to many and many to many.

    Anddddddd, in reading on in the links, I answered my own question, you have to go with the scenario that has the biggest values for the left and right of what you're considering. So "many customers can transact many sales" is the right way to set up the relationship.
  6. B

    Trouble grasping one to many and many to many.

    As I think about things, I guess I'm a little confused by something else. In looking at a relationship between customers and sales, when do I conclude :"one customer can transact one sale at a time" vs. "many customers can transact many sales." The main difference here seems to be time period...
  7. B

    Trouble grasping one to many and many to many.

    Ok from your reading all of your wonderful links, I see what I was getting confused between say "sales" and "customers." And entities and entity types. How you phrase the question matters - A LOT. For example in trying to establish the cardinality (new word I learned, thank you very much!)...
  8. B

    Trouble grasping one to many and many to many.

    That first link was so amazing. Do you know where to find the rest of the chapters?
  9. B

    Trouble grasping one to many and many to many.

    Hi there, I'm trying to really understand one to many versus many to many, because it's really messing up my database designs I'm pretty sure. To take a common example, courses and instructors. To me, this could BOTH be, one to many and many to many. A course could be taught many instructors...
  10. B

    I'd like to create a form with several checkboxes, but I'm not sure how to structure the tables to capture the checked items

    Thanks so much for your time and effort on this, I really appreciate it. Did you have to use any code to make that form?
  11. B

    I'd like to create a form with several checkboxes, but I'm not sure how to structure the tables to capture the checked items

    Wow, I cannot thank you enough for this. I'm really floored by the generosity of this community, and that people go to these lengths to help others. I know this was a lot of work and I'm extremely grateful! I'm sorry about the delay in replying, dealing with sick family members and trying to...
  12. B

    I'd like to create a form with several checkboxes, but I'm not sure how to structure the tables to capture the checked items

    That would be amazing :) Oh my god! Thank you!!!!! That's EXACTLY what i'm looking for!!! can you share your table structure, and did you have to do a ton of code?
  13. B

    I'd like to create a form with several checkboxes, but I'm not sure how to structure the tables to capture the checked items

    yes, just one person, so no person was actually going to be in the database i didn't want to have individual dates associated with each task, avoiding entering in the date over and over was trying to avoid rows and rows of duplicate data (so much of this stuff seems to be a judgement call...
  14. B

    I'd like to create a form with several checkboxes, but I'm not sure how to structure the tables to capture the checked items

    Looks like the problem is going to be the form. :( Regardless of how the table data is structured, representing it on the form is going to be the hiccup, since one checkbox apparently equals one field and there's no way around that.
  15. B

    I'd like to create a form with several checkboxes, but I'm not sure how to structure the tables to capture the checked items

    Thank you so much for taking the time and effort to write all of that up! Here's what I have: tblCompletionDates -CompletionDateID -CompletionDate TblTask_CompletionDates -taskID (PK) -CompletionID (PK) TblTasks -taskID (PK) -Task TblLevels (not relevant to the problem) tblHabitCategories...
Top Bottom