Recent content by RichardatManAlive

Thanks Jeremy, I downloaded your copy of Paul Litwin's "Fundamentals of Relational Database Design". Good stuff, some I knew already but I know have a more robust explanation, so thanks. I issue I am now facing is a normalise database design can lead to more work creating the forms...

Thanks John, I agree this little structure is very elegant. I just tryed a mock up of the tables and am now realising what you alluded to at the end of your post, the data entry and management form will be the challenge! Seems I'll need combo boxes or option groups for the user to select...

This is weird I had an Access 2000 database runningon ME with many reports. I inserted a coloured logo in each report and they all printed fine. I upgrade to Access 2002 and XP and now these report only only print greyscale logos. Updated my printer driver and got all the latest service pack...

This appears simple enough but I'm going round in circles with it. I have a growing contacts database with the usual contact data , being used to send mail merges via email and mail. I need to categorise each contact record several ways So contact 1 may belong to category 1 , contact 2 could...

Just upgraded from Access 2000 to 2002 , still using Access 2000 file structures ( haven't done the conversion) My database has many reports using a BMP image ( logo) use to print in colour now they print in grey scale. Other office apps print the same logo in colour, if I design a new report...

Thanks for the tip, it worked, I also had to run the linked tables manager . Whew! a small disaster avoided I won't be compacting my backend separately again . Richard

The full error message was ; Reserved error (-1038) Thats it! Richard

In my Access 200 database I have just got an error : Reserved error( -1038) , locks me out of my database. According to Microsoft Knowledge Base Article - 247489 this comes about if you compact a database in Access 97 then run it in Access 2000. Not quite my situation, I have my database...