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 Mike Lewis 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. richardtsa

    Master/Detail Grid Change Detail Heading

    Hi I have master/Detail grid. I am able to change the headings of the colums in the master part of the grid, but if the user clicks on the + to get to the detail part of the grid, how do a person change the headings of the columns in the detail part of the grid by using code Any help would be...
  2. richardtsa

    SQL Server Jobs

    Is there a way to give a user access to start only specific jobs. Because if you give a user targetserverole or sp_start_job permission, the user can start any job on the server and I only want the user to start certain jobs.
  3. richardtsa

    Disable the Excel Window 'X' from VB App.

    have not found a solution that take the x away, but why not keep the WindowState = xlMinimized and then maximize it when the data is loaded
  4. richardtsa

    delete database record after printing report data

    One reason why it will give you an error because the delete statement is wrong SQL = "DELETE * from finalgasbill" should be SQL = "DELETE from finalgasbill" without the *
  5. richardtsa

    list command buttons used in vb application

    Is there a method to list all the command buttons used in an application that was written in vb
  6. richardtsa

    authentication windows 2000 using advapi32.dll

    I used the advapi32.dll to write a vb app to authenticate a user. It works fine on my PC(Windows 2000 operating system), but on my collegue PC(Windows 2000 operating system) it does not want to work. On my PC I can enter anybody's User id and password and it will validate it, but on his pc...
  7. richardtsa

    Calling OEM Job

    Hi I need to call a job from a job using the OEM. If anybody can give me the example of the script it would be much appreciated Thanks
  8. richardtsa

    Fun with combo boxes

    Why not just lock the combo boxes. The user might be able click on the combo box but they can not alter the contents. Just an idee
  9. richardtsa

    Linking 2 seperate forms

    Make sure that the record of the name table is saved before you go to the colour table. First try to go to the next record and then go to the previous record then go to the the colour form. If this works then you know the problem lies with the saving of the record. What you do is do an...
  10. richardtsa

    how do I produce a (variable) qty of labels from any one record

    Why not create a loop for the number of images fro a record and then print it within the loop
  11. richardtsa

    Linking 2 Subforms to a Main form

    A suggestion. Why not put the combobox on your subform. Instead of using the default view of datasheet use the view Continues form on your subform properties and then drag the header or footer to make place for the combobox you want to use. Hope this helps
  12. richardtsa

    Restore table

    How do a person go about restoring a table. I drop a couple of tables by mistake I have arc log, but no luck in restoring anything from them any help would be appreciated
  13. richardtsa

    Increase block Size

    Thanks for the help, I am using 8.1.7
  14. richardtsa

    Oracle Schema to SQL Server

    Firstly do you have the oracle client and the sql server client on your PC. If so you setup your odbc for oracle and then you go to Sql server (I have SQL server 7) and go to the Tools Menu and select Data Transformation Services then select import. Then in source select other(odbc data...
  15. richardtsa

    connecting with excel

    This is if you are using get external data in Excel. First. Do the person that you are logging on have access to the schema. Second. When you are in the display add table screen there is an option button click on it and make sure that the tick tables are selected. Hope this helps if not let me...
  16. richardtsa

    Increase block Size

    Hi Can anybody tell me if it is possible to increase the database block size without recreating the database and if so can please tell me how to do it. Any help will be appreciated Thanks
  17. richardtsa

    Problems with comparing date field with getdate()

    HELLO use the convert function It looks like this convert(char(10),getdate(),112) if you look in the help you will see diff no(112) that show diff date formats
  18. richardtsa

    Can you lose data if you run out of disk space?

    Hello The reason why the your client might not have received the message is that it might have stored the transaction in memory and it might show the transaction in the database if they clear up some disk space so that the info in memory could be written to disk That is just a maybe.
  19. richardtsa

    Capture sql Statement in SQLServer

    One of my programs I've written in VB is capturing junk somewhere and only occasionally into SQL Server. I can capture the info as it is going into SQL Server. But I still do not know what the sql statement is, that is causing it. Is there any way to capture the actual statement in Sql Server...

Part and Inventory Search

Back
Top