Recent content by johnnymac43

Take a look at thread181-511702 for a method of attacking this requirement. John

Acknowledgement, the key ingredient in this thread, is not just about thanks, and certainly not about stars. Essentially, it is one or more of the following: > Got your message. > This is what I did / need / have. > I do / don't need more. > Thanks. Cheers, John

It's a bit messy, but you can export the report from the Documenter to Excel, and then copy the field properties (from a contiguous group of cells for each Access table) to a new Access table. HTH John

Edward, Since you asked, here goes with the brief version: Type A attempts, not always successfully, to understand the questioner as well as the question, and to pitch a response at the appropriate level. Type B assumes that quality advice is always good. Type AB fluctuates wildly between...

Morning All, My, this thread has certainly had a long run, with most of the contributions pretty close to the topic. Thank you all for your input - it has helped to put a lot of other things into perspective. I guess it's inevitable, but it now seems to have drifted a bit. I wonder where it...

OK. Best of luck. John.

Hi JJman Just wondering how things are going Cheers John

Your data structure does not cater for the many to many relationship between StaffDetail and Competency. To achieve this, split your Competency data into two tables. The new table (CompetencyDetail) will have a many to one relationship to StaffDetail and a many to one relationship to Competency...

Take a look at thread181-511702 for a similar situation. John

Hi Richard, You are right to seek help at this stage as it will be so much harder to change your design later on. For this (almost classic) many to many relationship between contacts and categories, you need three tables. These will be for contacts, categories and links. Use an autonumber...

This would be simpler from a processing POV and more logical from a business POV if the latest reading was placed in a separate table until billing was done, and then moved to the main table. A simple extension to this concept would be to also keep a copy of (or a pointer to) the most recent...

Is it possible that you do not have permission to change an import specification? To check, do the following (Access 2000): > Tools, Options, View Tab, Tick Show System objects, OK. > Tools, Security, User and group permissions, Permissions tab, Object type - Table, MSysIMEXSpecs. HTH John

I think I understand your question, but I'm not real sure. If I do, then your tables and relationships are spot on, although I would suggest some changes to the names you have used. I assume that you want a query that will show, for each completion, some batch information, some completion...

Thank you all for your interest in this topic. It has given me a sense of having achieved something worthwhile by starting it. I too have learned a lot by testing solutions before posting them. Apart from all the bad manners stuff already mentioned, some worrying behaviours (closely related to...

This is something that I do frequently, and I have never experienced the problem you describe. The most obvious question is: Are you sure that the memo file links are working in Foxpro? Others: Are the memo files in the same directory as the DBF files? Have you perhaps replaced the DBF file...