Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. johnnymac43

    Getting duplicate rows using distinct

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

    Why do so many people not acknowledge help

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

    Document - Table Structures... ??

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

    Why do so many people not acknowledge help

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

    Why do so many people not acknowledge help

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

    Receiving and Completion Process

    OK. Best of luck. John.
  7. johnnymac43

    Receiving and Completion Process

    Hi JJman Just wondering how things are going Cheers John
  8. johnnymac43

    How to make sure each staff have their own details in same category?

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

    Need help on a tough query. A challege.

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

    Database design : Mutliple and growing categories

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

    retrieve "previous" reading

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

    Cannot save changes to IMPORT SPECIFICATION

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

    Receiving and Completion Process

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

    Why do so many people not acknowledge help

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

    Cannot located requested xbase memo file.

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

    rocord sometimes comes up as ###### ######

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

    Why do so many people not acknowledge help

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

    Is a query what I want?

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

    Can you insert records in a database in MS access 2000?

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

    Can you insert records in a database in MS access 2000?

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

Part and Inventory Search

Back
Top