Search results

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?

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

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

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

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

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

Small prob giving me a headache here I have a list of dates in order. However the boss came up with some new dates a while ago, unfortunately they are incomplete dates. ie April, or TBD. My date format is 02/4/2003 or 2nd April 2003. I've tried changing the format on the time date field, but...

I think this should be easy....... I've two fields with multible records. In each field a number is put in. I'd like a third field to add these numbers for a total. Can someone lay this out in laymans? Thanks

Maybe it's the 2 hours sleep I had last night, but I've totally forgotten how to set a field in a form up, that contains an email address, so you can click on it and it'll open up a blank email with the said address in it Any ideas? Thanks

I've the DB set up to have an Icon. It also has a pop up screen and then a Switchboard based on a form. How do I keep the icon on the top of each form that's opened from the options on the switchboard. In other words I open a form from the switchboard now, and the new form shows the Access...

Any Ideas on how to change the color of a command button from the grey, all options in properties seems to greyed out?

I've a drop down menu in a form. I'd like users to select an option from this menu before being alowed to leave the form, or better yet before being allowed to enter data they must select from this. Can some one tell me how? Or perhaps post a link to this question in a previous topic? Thanks

Can some one please tell me the code to close a form that as command button is set in that opens another form?? In other words I click on the command button on a form, that for opens and another form opens. I have everything except how to close the old form that the command button is on...

The easiest way to explain this is to have a look at the Northwind DB form "Customer phone list" You'll see at the bottom theres the alphabet, click on a letter and it filters the Customer list and displays only the customers with that letter in their first name. I've a contact list that this...

I'd like to do something similar to what the Northwind has for displaying labels. Can someone tell me if this is a long way to going about things?? Personally I was thinking of just have a a sub form with a button for each label catagory! The form looks nicer, user friendly etc, but looking...

I've a massive table (I've only just learnt how to break tables up and relate them, but for know I have to stick with this old table) To sum it up: 44 Affiliates 12 sports Each sport costs 75 I've a tick box next to each sport in the affiliate table/form to indicate that they do that sport...

I have a form built on a Query which is built on a relationship between two tables. On the Form is data from both tables. What I'd like to do is prevent users from changing data in certain fields from 1 table, yet still be able to make changes in other fields?? Keeping in mind both tables are...