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 bkrike 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: *

  • Users: MarkWright
  • Content: Threads
  • Order by date
  1. MarkWright

    Novell /SQL Password log on

    Hello, am not sure if this is the right Forum but, We log into our net using Novell. We are using a SQL 2000 Server to access an Access 2000 ADP DB. The problem I am having is, everytime we change our password in Novell I have to change the given password on the SQL Server otherwise no one has...
  2. MarkWright

    Verweis for OLE connection

    Hello, does anyone know the animadversion for the ole connection`? Thanks Mark
  3. MarkWright

    Delete a Record from a List Field

    Hello, Info: Access 2000, SQL 2000 Server. I am trying to Delete a record from a list field. Is this possible or do I have to call the date direct from the table to delete the entry ? Thanks for your time Mark
  4. MarkWright

    Contex Menu / Search Field

    Hello, I am trying to set a search field in my contex menu. I have a list form and I want to get a search field where with a click on the right mouse tab I get my contex menu with a search field, enter a name and then that searches for given name in all of the entries in the marked field. This...
  5. MarkWright

    query in VBA

    Hello, I have a a table with the fields: ProduktNr, testnr, Ueb. I have to sort the field to show certain information that is filtered into a formular. I have - PNr tnr U 9110 71 z 9026 108 z 9026 167 z 9049 167 z what I need is a way to show only 9110 and 9049. I have made...
  6. MarkWright

    Combo Box in a endless Formular

    Hello, I am using an ADP Databank with msSQL 2000. I have a formular and call another formular from the main formular. I am filling and filtering the second formular with a recordsource. what I need is a way to use a combobox with J,N,O where I can decide in each line/record which letter I want...
  7. MarkWright

    Window pop up

    Hello, I am tryint to find some information on how to get a window that is running in the back ground to pop back up after the action ist done. I have so many different windows opened and I am always jumping back and fourth. I sometimes forget that I have something running and would like to have...
  8. MarkWright

    Set Filter

    Hello, I am using Access 2000 with MS SQL Server 2000. I am having problems setting a filter in a Formular. I do not get the contex field when clicking the right mouse button. I have a field that I have to filter objects from to get certain information but it is not working. In the Dev. mode I...
  9. MarkWright

    ADP with MS SQL Server 2000

    Hello, I have a problem ( ha ha) We have an SQL 7 Server and we are updating to a 2000 server. So my problem is-- I do not have full access to the ADP datenbank from a client computer. I have all rights but somewhere I have missed a check box or something. I can not change any tables in the ADP...
  10. MarkWright

    open form with button click

    Hello, I am trying to enter a number from one formular into another formular. I have a main formular and am opening another formular with the --> DoCmd.OpenForm "frmPBS_TestzyclusSLIN", , , "[testnr] = " & testnr & "", , acDialog When the new formular opens one...
  11. MarkWright

    Order BY for listfield in VBA

    Hello, I have an adp Datenbank and am trying to order my list from A-Z. I am using a query to call my information but the "Order BY :::" does not work in a adp Datenbank. I have also tried to add --> Me.RecordSource = "SELECT * FROM qryTestzycluslist ORDER BY testnr DESC;&quot...
  12. MarkWright

    insert IDkey number into another frm

    Hello, I have a adp Datenbank and am trying to copy a number from 1 textfield in one formular into another formular. I know how it works with a mdb datenbank but am having problems with my adp datenbank. I have a formular and am trying to open a new formular which will have information over the...
  13. MarkWright

    SQL / fill empty fields in a Tabel

    Hello, I am working with a ADP Datenbank and am trying to fill some empty fields in a table. I have five five fields. One field is only partly filled with information. If a field is empty then information from another field is to be entered into the field. I did the same thing in a mdb datenbank...
  14. MarkWright

    Stop an action in Access with VBA

    Hello, I am trying to stop a "by closing" action. I have some Fields that have to be filled out before the formular can be closed. I have been using ( if isnull(field) ) but am not having anyluck stopping the close procedure. What I would like to do is if a Field is empty but should...
  15. MarkWright

    Read Licence number with VBA

    Hello, I am trying to write a program that reads the Licence number from the given System. I have been trying with "Environ" but am having no luck. I can read everything I need , user, system, computer name etc. but I can not get the licence number to show. Just the coded number that...
  16. MarkWright

    link outlook with a SQL Server

    Hello, I have Access 2000 and have linked a table with Outlook so that I could read all my received mail and then add selected mails into a new formular. Everything worked fine . I now have to add the tables and formulars into a SQL Server. and now I have found out that I can not link outlook...
  17. MarkWright

    outlook makro activieren

    Hello, I am trying to add some features to my outlook formular and I am getting a message saying that the makro's are not active or not installed. Does anyone know where I can look to install or activate them ? I have tried with a very small code--docmd.openform "frmTestzyclus" to see...
  18. MarkWright

    Text area name in Outlook

    Hello, I am looking for the name that is given in VBA code to read the Text area in Outlook. I have found all the other names to read information from a leter but am having problems finding this name. Thanks Mark
  19. MarkWright

    read Emails from Outlook and add parts into Access a formular

    Hello I am trying to read emails from MSOutlook and parts of the letter have to be saved in a Access 2000. Our internal letters between our Programmers and Testers have to be saved and have to be able to be seen in a formular. I have tried a couple things but have not had any luck. I have found...

Part and Inventory Search

Back
Top