Search results

  1. J

    Openform problem

    The only way Form2 should have the same ID in it is as Form1 is if Form2 is the Many side of a One to Many relalationship and the ID in Form2 is the Foreign Key in Form2. If that is the case then Form2 should be a subform of Form1. If you do that then the ID will automatically be added to Form2...
  2. J

    Help with relationships!!

    Can you explain what it is you are trying to do? I don't understand the significance of these tables or their relationships to each other. What is the reason for 'several accounts' and 'single accounts? I do know that 'several accounts' and 'process verbal data' should not have individual fields...
  3. J

    Have users access only specific records

    You need to add a field to the table so you can distinquish VP's, etc., from records that are OK to view. Based on who is logged in to the database you can filter the data so that only designated people can see the restricted records. hth, Jack
  4. J

    Adding data to table

    tblParticipants ParticipantID (PK and autonumber) LastName FirstName tblQuestions QuestionID (PK and autonumber) Question tblResponses ResponseID (PKand autonumber) ParticipantID (FK) QuestionID (FK) AnswerID (FK) tblAnswers AnswerID (PK and autonumber) Answer You do not need the Answer...
  5. J

    it gives me headaches

    Scott - My comment would be how would you easily add more items to the table "tblDailyReport"? Not allowing for the ability to easily add more items without changing the structure of the table is not good practice in my humble opinion. Just my 2 cents worth... Jack
  6. J

    storing two bits of info at once

    I am not quite sure of the reason for a separate database, but be that as it may I would use the table as a 'lookup' and store the value selected or entered in another table. You might want to condsider using the Not In List event of the combo box so that you can add new values to that table. I...
  7. J

    Property value to large

    Have you been compacting and repairing on a regular basis (every few hours during construction)? If not, compact and repair. If that does not fix the problem then import everything into a new, blank db and see if that helps. hth, Jack
  8. J

    storing two bits of info at once

    If you link the table (from db1) that is the Row Source for the Combo box then you can add data to that table. I am not quite sure what you want to do since this data can change so are you sure you want to store the data? If the change is only applicable to the moment then a global variable may...
  9. J

    record notes

    The basic answer is yes. You can use code to see if the comments field contains data when a compound is added/selected and if it does pop up a message box stating so. hth, Jack
  10. J

    Update Query

    Hmmm. How can tbleone have duplicate primary keys? This should not be possible. The first thing you need to do is clean the data or table and then try again.... Jack
  11. J

    it gives me headaches

    You need to make some major changes... Here is a rough idea of what you need: tblStudents StudentID (PK and autonumber) LastName FirstName ...other fields... tblWeeklyReport WeeklyReportID (PK and autonumber) StudentID (FK) Skill AccomplishmentID (FK) DateOfReview Comments...
  12. J

    Adding from a subform into a form

    You will find your answer in the MS Knowledge Base. To save you searching here is the article. Jack
  13. J

    Field names with a . in them eg PO.Items

    I would not put in the dot. POItem works fine but if you have to have something then PO_Item will do the trick. hth, Jack
  14. J

    Error Accessing File! What does this mean?

    See if this article addresses your problem... hth, Jack
  15. J

    Can you think of a better way of doing this? Enquiries form - LOADS of checkboxes?

    I wouldn't show all the possible trips but only select the ones (from a combo box) that you customer expresses interest in. You could modify the table like this: tblCustomerTrips CustomerTripsID (PK and autonumber) CustomerID (FK) TripID (FK) Booked (Yes/No) Then if the customer books a...
  16. J

    Can you think of a better way of doing this? Enquiries form - LOADS of checkboxes?

    Hmmm. You have lost me.... the table 'tblCustomerTrips' has that information.... What am I missing? Jack
  17. J

    Can you think of a better way of doing this? Enquiries form - LOADS of checkboxes?

    Edd - I have not forgotten you. Just been a bit busy... tblCustomers CustomerID (PK and autonumber) LastName ...other fields... tblTrips TripID (PK and autonumber) Destination ...other fields if necessary... tblCustomerTrips CustomerTripsID (PK and autonumber) CustomerID (FK) TripID (FK)...
  18. J

    Help??

    hth = hope this helps! Good luck! Jack
  19. J

    Minor Disaster!

    You are welcome. A hard lesson learned.... You can't have too many backups.... Good luck! Jack
  20. J

    Help??

    You want to add 'validation' code to the forms Before Update event to see if they left any required controls blank before saving the record. There is some sample code in help if you click the F1 key when the cursor is in the Before Update event of the form. hth, Jack
Back
Top Bottom