Recent content by Dave Titan

I deleted TempMsysAccessObjects and the db is working away just fine. And with a compact and repair it's faster. I've also hidden all the objects again. I would say the DB may have been stopped halfway through something at somestage. It's weighing in at 30mb at the moment 50mb before the...

Ken, Great stuff. Thanks for that, worked a charm. Could you tell me if deleting hidden objects will have any adverse effects on a db? Dave

Hi Folks, I am getting the following error when trying to compact and repair a DB "Table 'TempMsysAccessObjects' already exists" This is using Office XP and it's happening on more than PC. I've searched the tables and am unable to find this one? Any ideas?

Outsiders are needed as they are a table of different (non work) people some of whom have a work common ground with the people in the other two tables. I need to pull off a report that match certain criteria from the people in the related tables tbl Contacts tbl Contact details and the table...

Hi Folks, I have the following: these two are related; tbl Contacts tbl Contact details this one is independant; tbl outsiders I need a query that will display all selected contacts from all tables. However when trying this I can get details from the first two tables, but if I add the third...

Hi Folks, I played around with this a bit before, but with not to much success. I would like the a small wav file to play when a db loads, a form pops up first and I would like it to link to this. The DB is on a server so the wav needs to be associated somewhere rather than on an individual...

cheers, thanks for that I will work on it now and let you know tomorrow the outcome. Thanks again

Thanks. Ok I will give this a go. I don't thinking my coding is up to scratch enough to make this a major success though. Any idea of where a sample may be?

But won't that effect all records?

Hey folks, I've a form containing info based on a couple of tables. There are 250 records. I need to protect records 1 -45 from any changes. or even just the adddress fields in 1-45. But leave 46-250 so others can make changes, or even add new records. Any Ideas???

Apologies but that made no sense to me?!! The lookup column is being accessed through a form, but I want to make the changes in the original table

Hi Folks, On a table I've used the lookup wizard to create a drop down list of 10 "subjects". My question is, if I want to add say another 5 "subjects". How can I do this without having to re-type the whole 10 Subjects and then add the new 5? This can really get painful is you have a list of...

Thanks I will create the query first. Another option I discovered was to cut the fields and then paste them back in again. This way the data is deleted and the field is still saved in masse.

I believe it is thank you. However I a little lost as to where I'm to imput what you suggested?

Do you have a column with nothing in it on you excel sheet? Have you tried to create a new header(field) in excel and place a digit in the column? Once it's imported as a table Access should read it as containing data and then a primary key will have value.