Recent content by shapman

thanks for the reply Ive tried this, it doesn't seem to work. Its a secured database (though i don't remember securing it our creating workgroups, all i used was the Startup pain and removed the database window). is there any other tips, it won't even let me open it in other applications as it...

hi, the following error message appears when trying to access my database. I can't seem to get into it at all, not even by trying to import the data tables over into a new database. the following message appears: "The database has been converted from a prior version of Microsoft Access by...

thanks for your reply, I inherited the database at the beginning of the year, old monthly copies of it have been saved in spreadsheets, im going to bring these all back into a new database for a comparison check but at present arnt sure how to do this. I just need to know from the original...

Hi all, Another month, a new database, more questions... a quick thankyou to all those who helped with my last database, much appreciated! I am trying to set up a query run from 12 tables, each table is supposed to be the same but we have had a number of people changing things when they...

Hi I have a query that runs off three tables: These are tbl_contacts, tbl_status, tbl_publications. All contacts have a status but not all will have a publication. The problem is that when i run the query on a status type where none of the contacts for that status have a publication it will...

Hi all I am facing disaster after two months of solid work on this database, the deadline is the morning of the 25th and just when i thought i had got it all working i then put the main bulk of the data into the database and the main search query won't work, it freezes and ends with 'invalid...

hi I was wondering how you would base one query on the result of another through the same form. I need them to all be under the same command button... i.e. on click run 1st query and then run the second on the results of that query. How would i go about this, would it have to be a make...

Thats great! many thanks in advance. Regards Shapman

Hi, thanks for this. i have just noticed my mistake in my last post. I was getting a bit confused, my database is full of clutter as you noted and i think it would be a good idea to clean it up. there arn't any cascading combo boxes in frmemail, they are only in subfrmstatus (which is the...

sorry this should be frmsubstatus

Hi glad to see i understood the relationships issue :-) yes, your descriptions of tables statustype and substatus are correct. The relationship is set up as one status can have many substatus. (in realiaty only two Statuses have any substatus at all). "Statusdesc" in tblstatustype feeds...

Hi glad to see i understood the relationships issue :-) yes, your descriptions of tables statustype and substatus are correct. The relationship is set up as one status can have many substatus. (in realiaty only two Statuses have any substatus at all). "Statusdesc" in tblstatustype feeds...

in terms of linking the generalcontact details table - although i now understand what you mean i am stuggling to design it. I am looking at it in terms of it needs to be done through the tblstatus. the problem is I created tblstatustype and tblsubstatus just to create cascading combo boxes in...

I think now understand the problem with the substatus... without linking these tables the query wont know that some statuses do not have a substatus and read the substatus as null which, therefore, returns no results. If i link them the query will know that some status's don't have substatus...

At first glance i.d. say that SQL 2 requires a Pub whereas SQL 3 does not. I will get cracking with the testing of these, im actually watching mission impossible on TV at the same time...