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!

  • Congratulations strongm 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. GlenLynam

    BCM 200 New Number

    Morning, We have a client that has inherited a BCM 200 during a desk move. They are trying to move their new number to this system. We have a mail from BT stating that when we are there to call them and they will make the change. So I guess the question is this, is the process as simple as...
  2. GlenLynam

    Explorer.exe is broken

    I would install XP SP2, should replace the explorer.exe, may help you out
  3. GlenLynam

    Internet Explorer 6 and Access Database Page

    Afternoon, I have a really strange one that is bugging me like crazy!! There is an internal intranet page that when the users click on a link it brings up a web page that launches an MS Access form. This page works fine for everybody except one user. On his PC it loads the title of the index.htm...
  4. GlenLynam

    Can edit query results

    Good Morning, I am trying to edit the results for the following query but all it does is make a noise and wont let me edit the results, no errors or anything. The query is as follows, please can someone tell me how to edit the results?? Thanks SELECT Courses.CourseName, Courses.Description...
  5. GlenLynam

    Delete Query

    It was the unique records setting was set to no for the properties of the query!! :-)
  6. GlenLynam

    Delete Query

    No sorry i get the same error message :-( Thanks for the response any other ideas?? Thanks in advance Glen
  7. GlenLynam

    Delete Query

    Afternoon All, I have the following delete query... DELETE Training.*, Personal.PersonID, Courses.CourseID FROM Courses RIGHT JOIN (Training LEFT JOIN Personal ON Training.PersonID = Personal.PersonID) ON Courses.CourseID = Training.CourseID WHERE (((Personal.PersonID) Is Null)) OR...
  8. GlenLynam

    Variables In A Query

    Sorted it!!!.... SELECT Personal.FirstName, Personal.Surname, Personal.Parent, Courses.CourseName, Courses.CostIncVAT, Training.When FROM Courses INNER JOIN (Training INNER JOIN Personal ON Training.PersonID = Personal.PersonID) ON Courses.CourseID = Training.CourseID WHERE (((Personal.Surname)...
  9. GlenLynam

    Variables In A Query

    Sure...... SELECT Personal.FirstName, Personal.Surname, Personal.Parent, Courses.CourseName, Courses.CostIncVAT, Training.When FROM Courses INNER JOIN (Training INNER JOIN Personal ON Training.PersonID = Personal.PersonID) ON Courses.CourseID = Training.CourseID WHERE...
  10. GlenLynam

    Variables In A Query

    I have set a query to pull in the query parameters from another form that is loaded. Is there a character that i can put into one of these that will show all the results.So say i had 4 fields i could narrow down the name but then put something into the other 3 fields to allow all the answers for...
  11. GlenLynam

    Split Records

    I have an excel spreadsheet that looks like the following... ID Number Docs 1 2 1;2 2 3 1;2;3 3 1 1 4 3 1;2;3 the output in the access table needs to be... ID Docs 1 1 1 2 2 1 2 2 2 3 3 1 4 1 4 2 4 3 How...
  12. GlenLynam

    Word in IE

    hi thanks for the response i cant see this? but i have tried on another pc and got a toolbar, so now the question is how to set the defaults??? Thanks Glen
  13. GlenLynam

    Outlook 2003 Import Contacts to Update Not Replace

    if they are not mapped you will need to re map maybe it isnt picking up the fields, let me know how you get on. G
  14. GlenLynam

    A Windows XP-based computer that was set up by using a Windows XP imag

    did you run sysprep b4 you created the image? Regards Glen
  15. GlenLynam

    Outlook 2003 Import Contacts to Update Not Replace

    Assuming that you have exported to excel then do the replace, when you try and import click map custom fields from here you will be able to ommit the fields that yo dont want to import just highlight and drag to the right as per instructions. Ifi were you i would backup its current state by...
  16. GlenLynam

    Outlook 2003 Import Contacts to Update Not Replace

    so when you are adding the data make sure all is correct and set it to overwrite dupes. I am confused why you dont want to overwrite if all you are doing is changing some data then the original (un-edited data) will still be intact. So just overwrite the old. G
  17. GlenLynam

    Word in IE

    Hi, Does anyone know how to add the toolbars fonts etc into word when you open a document within IE? Thanks Glen
  18. GlenLynam

    Speed Dials

    Please can anyone tell me how to remove the speed dials tab from within phone manager. Regkey or using the manager software anyway at all. Thanks Glen.
  19. GlenLynam

    Replacing characters in excel with VBA

    Hi there, Thanks for the reply but i get the same error as b4. Regards Glen

Part and Inventory Search

Back
Top