Search results for query: *

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

Hello sirkenj! Are you still out there? Any help will be GREATLY appreciated!!!!! Have the replies to date helped? Just wondering! John

When a question is asked in a technical forum, the first reply is usually a useful piece of advice or a request for more details. In some tek-tips forums, the number of occasions when there is no response from the originator is substantial. In my view, a word of thanks or a simple answer to a...

I hope I'm wrong, but it sounds like you have all the data for these projects in one table. If this is so, you will need many queries to find all projects of interest. If at all possible, build separate tables for Type and Street, with link tables for the Many-to-Many relationships. You will...

So, just in case you are still in doubt, the short answer is No. However, if you really want this, set up a procedure that you can run when nobody else is on the system, to correct the result of any of these events, as follows: > Copy the entire table, sorted, to a temporary table. > Delete the...

If they are entered by date (and include the date) they can be sorted by date. What more do you want? John