Search results for query: *

Hey PHV. Thanks for the link to that code. Where would I put it exactly? Kev. This is a politically correct signature, due to constant whinging about my previous signature. Long live the fun police.

Thanks for the reply Crowley16. Like I say, Im a bit of a dope when it come to this so I hope I don't sound stupid. Where would I put this code? I'm assuming in the "On Open" event of of my main form. I tried this but to no avail. Below is the code I used - DoCmd.DeleteObject acTable...

Hi All. Im a bit of newbie when it comes to this aspect of Access, so I hope this makes sense. I have a database that is located in a groups directory on my server. However, this database will now need to be accessible to a larger number of users across the country, who are located on...

You guys are the bomb. Works a treat. Thanks to all. This is a politically correct signature, due to constant whinging about my previous signature. Long live the fun police.

Hi all. Thanks for the suggestions and replies. I have successfully managed to stop the warnings and the queries will run but ignore duplicate records. Thanks to all who suggested fixes. One last problem (I hope) is that when I enter data into the fields on my form then click on the command...

Hey guys. Thanks for the replies. The DoCmd.SetWarnings does what I requested, however I have hit a snag. I'm running multiple Apend queries from a single command button on my form. Turning of the warnings works fine provided there are no errors in the data being apended. However, if some of...

Hey all, I'm wanting to run both an apend and a delete action query with a single command button, but I really want them to run without the "Are you sure you want to run this type of query" and the "You are about to apend X rows" message boxes. Is this at all possible? Cheers. This is a...

Hey all. I have a form with three combo boxes on it, and all are linked to their own table - cboBuilding cboDepartment cboArea Specific areas are linked to departments and the departments are linked to buildings. What I would like to see is when the user selects Building A, only those...

Hey all, I'm a bit of a newbie when it comes to creating queries, so any advice is welcome. I have a basic database that holds the majority of records in a single table. Data is entered via a form linked to the table. I have created a form that users can use to search the database. Basically I...

Thanks AvGuy. I've been playing around with it and came up with a similar solution. Hope it continues to work. Cheers. Kev. This is a politically correct signature, due to constant whinging about my previous signature. Long live the fun police.

Hey all, In Access '97, I've created a form with a sub form contained within, and they have a one to many relationship. The subform records staff names, the main form records observations. How can I limit the subform to contain no duplicate staff names for the linked record in the main form...

Hey TheAceMan1, Thanks for the answers. I should have specified that I'm using Access '97. I know what you mean about hiding your work. It's no something I usually do, but it is a request from the database owner. I like the idea of the full validation on the BeforeUpdate event of the form...

I was wondering if someone could answer this simple question for me. I have a fairly basic form that is displayed in a continous format. Each field is disabled pending data being entered into the previous field. When you enter data into the first field, the second field becomes enabled on the...

FP, it's not really a report, just a quick one liner to notify someone that a record has been created. This is a politically correct signature, due to constant whinging about my previous signature. Long live the fun police.

PHV, I tried adding the <b> and </b> as per your suggestion, but it only resulted in <b> and </b> being added to the start and end of the body text. Did I miss something? Kev. This is a politically correct signature, due to constant whinging about my previous signature. Long live the fun police.

Thanks stburkeuk. That code, with a little fiddling, worked a treat. One additional question without notice if I may..... How can I get the text to appear bold in the body of the email? I've tried a few things, but with zero success. In fact, I have absolutely no idea how this would be done...

Hey guys, Wonder if someone could give me a little advice on how to do this. I can get a report I've created to insert itself into a blank e-mail in Notes by way of a commend button, but it is really annoying how the "Select Format" window appears every time I want to email a report. Is there...

When attempting to convert a MS Access XP Db to Access 2000, I receive one of the MS error messages where they ask if you'd like to send a report. The technical content of the report is huge, so I won't bother to reproduce it here. Just wondering if anyone else has encountered this problem when...

Thanks for the reply Ken. My problem is that I have been given a Access 2002 Db, but I'm running Access 97 at work, and Access 2000 at home. Neither are able to open the file. I take it that there is no way I can open this file without a copy of Access 2002. If this is the case, I'll have to...

Is this possible? Do I need to load a patch or something, or am i stuck with having to purchase a later version of Office Suite? Thanks in advance, Kev. Never trust the French. How can you trust a country that has 256 different types of cheese. - Spike Milligan.