Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kev747

    Linking tables across servers

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

    Linking tables across servers

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

    Linking tables across servers

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

    Run an Action Query but bypass the "Are you Sure" message boxes

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

    Run an Action Query but bypass the "Are you Sure" message boxes

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

    Run an Action Query but bypass the "Are you Sure" message boxes

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

    Run an Action Query but bypass the "Are you Sure" message boxes

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

    Linking combo boxes in a form

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

    Searches using multiple values from a form

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

    No duplicates in a subform

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

    No duplicates in a subform

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

    Showing current record in a continous 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...
  13. kev747

    Showing current record in a continous 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...
  14. kev747

    Send a report via Notes

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

    Send a report via Notes

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

    Send a report via Notes

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

    Send a report via Notes

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

    Error when converting from XP to 2000

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

    Opening an Access 2002 Db in Access 2000

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

    Opening an Access 2002 Db in Access 2000

    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.

Part and Inventory Search

Back
Top