Search results

  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.

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

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

    This is essentially a form for a day of tracking tasks. Any number of these boxes can be checked, and I'd like the results saved as one record for that day -- so each day is a record, and each record can have up to 27 total check boxes checked. So Monday any of the 27 tasks would be checked...
Top Bottom