Search results

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.

Looks like the thread never went through! Question was how to delete the contents of a column in a table. Nothing happens when delete is pressed and the contents are highlighted. I need to keep some some columns of information but delete others. And cannot allow records to be deleted. I know...

Thanks for all that, will get to work on it! I'm sure my next question will involve Flash. But not today

Anyone know where this scrolling text tool is??? Can't believe I can't find it at this stage!!

On the splash screen I'd like a .wav to play. This db is used over a server so it needs to be linked in via code. Anyone got some code for this? I've tried some code I got elsewhere but to no avail.

Simple question. I have a report and would like to have my report header(not page header) shown on every page. As at the moment the second page has nothing but the data, and not Report Header. Thanks Again