Recent content by Angus_NB

Ok. Let's forget all about the dogs. :) Lets say I want to record the number of days in each month and the number of holidays. For some odd reason I want more than one record of this for each year so I have to use a subform. See attached Months2.JPG below. Tables: tblMonths = Month_ID, Month...

I'll try just attaching the .JPG Maybe I'll have to add the 65 questions to each record, whether they are relevant or not, just to get them in the list.

I will be capturing results for the same list of questions from the same city on the same date. I need the users to answer two questions about each breed. There will be a list of 65 breeds. I was going to attach a graphic to help explain it but I don't have 10 posts yet. I've been a forum...

Thanks John. One thing I have discovered. Because I need to capture more than one dog report per City/Date I am going to need another table. My original Results table will be dropped to 3 fields: ID (Autonumber) IDate (Date) City ID (Numeric) from the City table Then I will need another...

I am trying to create a form using Access 2007 to collect inspection data. There are a list of 65 questions with two answers that are numeric. Essentially, "How many did you see?" and "How many were defective?" I have tried to simplify things by using dog breeds and cities, in my question...

You don't need an ISAM. Just link to the FoxPro tables using ODBC.

I had the same problem. I realise this question was posted over a month ago but just in case someone else has the same problem... Here's what you have to do. Open Access and click on the Tools menu. Select ActiveX Controls. Highlight Calendar Control Click Unregister Click Register... and...

Use two tables. Table 1 would be the text boxes in the form header that don't change often plus an ID field. Table 2 would be the other fields related to table one. Have the unique ID field in table 1 point to a field in table 2 to relate the two tables. The fields in table one would be the...