Search results

Just some quick thoughts. Contract type would be better as a field in contract. It can be a look up field and use a data type table if you wish but this may not be necessary if there really are only two types. What seems to be really missing is a line item table for the contracts. This is...

A linked pic can be in the same folder as the database file. Surely your server will keep the whole folder together. If not you will have a few other problems to worry about as well.

Have looked at the tables One specific question - Why is "current" needed for spouse and child but not for main? The form structure for these tables seems simple enough. One parent form main with two subforms and one linked but independent form for vehicle. Because this is new to you, you see...

The contacts table is going to be the main table with three extension tables for each of the customers etc. This will work OK but I suspect that in using this data users will work with one group at a time so most of the time it is going to be better to include the contact data in each of the...

You can only get so far by looking at different table structures. I think it is time that you looked at some forms and reports. i.e. what the users expect to see. Rough these out with as much involvement from the actual users as you can get. Then look at the alternative table structures. You...

I find it much easier to go from CSV file via Excel which is much less picky about details than Access. Also you can see very clearly what is going on. Insert a first line into the spreadsheet with field names which match your Access field names exactly. You can perform any transforms if the...

I find it much easier to go from CSV file via Excel which is much less picky about details than Access. Also you can see very clearly what is going on. Insert a first line into the spreadsheet with field names which match your Access field names exactly. You can perform any transforms if the...

Does anyone have a basic diary form with appropriate code. I know that most people would use another program for this but I want it integrated into an Access database. There are lots of examples on calendars and date handling functions but I can't find an easy starting point for this. Any help...