Search results for query: *

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

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.

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

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

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

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

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

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

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

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

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

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?

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

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

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

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.

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

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.

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.

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