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

    Excel file hiding

    I have 3 versions of an Excel spreadsheet, (Prelim, v1 and v2), each having been made from the previous version and some additions being made to the latest). I can open and work in all threee successfully. Prelim has been successfully emailed to 2 other users. Now I want to email v2 to my...
  2. Robway

    Group details don't print if no records in sub group.

    Thanks for the help. It's working perfectly now. I'd completely forgotten about this in the months since I've had to work on it.
  3. Robway

    Group details don't print if no records in sub group.

    My report has two levels of sorting/grouping - Provenance and Series. The number of Series for each Provenance varies from none to many. If for a given Provenance it is none, then that Provenance and all its fields doesn't print. I'd like to see the Prov details regardless of whether there are...
  4. Robway

    criteria in a report's underlying query

    Hi Bob, It works like a dream! Exactly what I needed. Thank you very much. I had fiddled and fiddled with things like this, but couldn't get it just right. This will save me heaps of time. Thanks again. Robyn Melbourne, Oz
  5. Robway

    criteria in a report's underlying query

    Thanks Bob, I'm afraid I'm not very expert at this and have never worked with SQL. Do I add this to the SQL version of the existing query? I normally work in design view for these things and add very simple criteria. Cheers, Robyn
  6. Robway

    criteria in a report's underlying query

    I have a report "Provenance" based on a multi-table query. It sorts all the names alphabetically and includes a lot of descriptive material for each provenance. I'd like to print each group (the As, Bs, Cs etc) as separate reports, but not have to go in and put a criteria in the...
  7. Robway

    Can't define relationships for new tables

    Thanks for replying. I haven't got any composite keys - although it's something I'm seriously thinking of introducing to one of my tables, but that's another problem altogether. I'm going to keep checking that all the data in the various linked fields is really compliant, as I suspect that may...
  8. Robway

    Can't define relationships for new tables

    Just realised I have been trying to create a relationship between an auto number field and a text field. I've changed the text one to a number field (long intiger) and made sure all the data in it complies, but still no joy. I get the error message "Relationship must be on the same number...
  9. Robway

    Can't define relationships for new tables

    I've just added two new tables to my existing 14-table database, and can't define the new relationships how I'd like. The 2 new tables are tbContainerType and tbContainer. I want them to link as: tbContainerType 1-many tbContainer 1-many tbAccessionItem I have a field ContainerType in both...
  10. Robway

    relationships for new tables

    This was the wrong forum. I'll repost this to Tables and Relationships.
  11. Robway

    relationships for new tables

    I've just added two new tables to my existing 14-table database, and can't define the new relationships how I'd like. The 2 new tables are tbContainerType and tbContainer. I want them to link as: tbContainerType 1-many tbContainer 1-many tbAccessionItem I have a field ContainerType in both...
  12. Robway

    Can't play cda files

    Thanks guys. We'll test those suggestions out. I've had a look at another Knowledge Base article - 234019 - which lists the formats that Media Player supports and cda files are not there. Could it be that Media Player just won't play these files?
  13. Robway

    Can't play cda files

    I'm trying to play commercial bought audio CDs, but get no sound. I have an ancient system - Windows 95 - and we just loaded an older version of Windows Media Player thinking the latest version was less likely to be compatible). I get all the beeps and fanfares that MS inflicts on us with no...
  14. Robway

    Multiple field primary key

    Thanks, that will get me moving. The reports are all based on multiple table queries already, and I have tried so many different possibilities for grouping etc that I have practically given up in despair - hence this thought that changing the basic structure might have to be the solution. I'll...
  15. Robway

    Multiple field primary key

    Hope someone can help. I have a database with 15 tables which revolve around one core table [tbItemNo]. There is a one/many relationship between it and tbAccession in one direction and several others in the opposite direction, eg tbEvent. tbAccession 1-M tbItem 1-M tbEvent The primary key...
  16. Robway

    Printing design view of form or report

    Thanks for the tip. It serves my purpose just fine. Do you know if you can do this directly from a later version of Access. Being able to print out the relationship screen would also be a great help. Cheers.
  17. Robway

    Printing design view of form or report

    Is there any way of printing the design view of a form or report as shown on the screen? I'm using Access 97 with Windows 95. Thanks
  18. Robway

    No Title. just need ideas

    So the doctors think their responses are anonymous and are inclined to be honest with their responses. But you are deceiving them by using tricky code that allows you to identify them. Seems to me you don't need help in using Access. You need to do a course in Ethics.
  19. Robway

    Making a table with many fields.

    Seriously, don't base your form on a table. Base it on a query. Build your query from multiple tables, then all the fields you select for your query, from each table, will show up in the field list of your form.
  20. Robway

    Making a table with many fields.

    I'm a bit of a novice at this too, so you may get better advice from someone else, but... With regard to tables, I'd have one for the patients and another for diseases. There'd be a many/many relationship between them, so put a link table between them which will show which patient/s have which...

Part and Inventory Search

Back
Top