Recent content by Bettany

  1. B

    Have a list of foods in a table and a list of family members in another, not sure how to make a check list.

    Kind of inclined to agree here. Any UI setup that doesn't have all the of checkboxes available to be clicked just seems too painful and repetitive (particularly combo boxes). Is your idea to have all the foods listed next to the check boxes on a single form, and to use VBA to tie all the info...
  2. B

    Have a list of foods in a table and a list of family members in another, not sure how to make a check list.

    Pat, that solution means a lot o Thanks Pat, from a usability standpoint that seems extremely painful. To be sure I have this right, your solution involves clicking a combo box in a subform, scrolling through 500 options in that combobox, selecting an item, and then repeating that process...
  3. B

    Have a list of foods in a table and a list of family members in another, not sure how to make a check list.

    Hi, I have 500 foods in a table, and the goal is for each family member to be able to go down the list and check the foods they like using a form. So essentially I need a form with the 500 foods listed, a checkbox next to each, and to be able to indicate somewhere on the form, who the person...
  4. B

    Solved Code is executing immediately rather than in 1 second intervals.

    My understanding was that once you set the timer interval to 1000ms that all code operations on the form take place at that speed. But based on what you're suggesting, the demonstrated behavior is what's expected: it's counting down from 50 to 1 in less than one second?
  5. B

    Solved Code is executing immediately rather than in 1 second intervals.

    The following code, I'd expected to take around 50 seconds, but it's executing at CPU speed and finishing instantly. What am I doing wrong? Thanks. Sub Form_Timer() Me.TimerInterval = 1000 Dim Y As Integer Dim Z As Integer Y = 50 Z = 0 Do While Y > Z...
  6. 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 :(
  7. 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...
  8. 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...
  9. 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 :)
  10. 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.
  11. 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...
  12. 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!)...
  13. 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?
  14. 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...
  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

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