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 Rhinorhino 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: mans
  • Content: Threads
  • Order by date
  1. mans

    View Word Document in VB Form

    Hello, Can you please let me know how can I open a Word template file using the Word object within a VB form. I do not know how to attach the document to the form, I have not been able to find any documentation in this regard. I use VB6 and MS Office 2000. Thank You
  2. mans

    Displaying dates for a certain day

    Hello, I have a simple table (Access2000), one column with the date (table1.date) and another with a name (table1.name). Can some one please post the SQL statement required to display all of the dates and names that fall on a Thursday. Thank You
  3. mans

    DLL Installation

    Hello, I am using VB6 with Access 2000. The software I have has installed successfully on numerous terminals. I now have a machine running Windows ME that just does'nt want to install about 80% of the dll's required to run the VB application. I have shut down all of the programs running in...
  4. mans

    "Multiple step OLE DB..." error message

    Hello, I am using VB6SP4 with Access 2000. I have this application distributed amongst numerous customers with any issue aside from one. For the first I am getting a customer with the following error message "Multiple step OLE DB operation generated errors. Check each OLE DB status...
  5. mans

    DBGrid Licence Issue

    Hello, I am getting the error message below when I attempt to display a form. I have manually tried to register dbgrid32.ocx without luck. Can someone please let me know what I need to do to overcome this issue. Line 794: Property OleObjectBlob in DBGrid1 could not be set. Line 794: Cannot...
  6. mans

    SQL Statement Expression

    Hello, I am using VB6 with Access2000. Can someone please let me know what code I can use to get information within the last 3 months eg. Select revenue.payment From revenue Where revenue.paydate between Date() and (Date (0 – 3 months)). I understand the 3 months expression above is the wrong...
  7. mans

    Simple SQL Statement (Hopefully)

    Hello, I am attempting to delete a record in a table that contains the minimum numerical value. If the table is called staff and one column contains names and the other the ages, if I wish to delete the youngest person, what statement can I use without creating an additional table. Thank You
  8. mans

    Display Days

    Hello, I would just like to know the code I need to display the name of a day (system day) in a text box, like Monday, Tuesday etc. It cannot be a numerical value, only the actual day name. Thank You
  9. mans

    Assigning current time to a text box

    Hello, I am using VB6 SP5 on XP. I would like to display the current time in a text box at run time, when I attempt to an error message says: "Compile Error, Expected Variable or Procedure, Not Project" and it highlights the following statement, Text1.text = TIME (design time). I...
  10. mans

    Administrator Access

    Hello, I have a new XP home edition, I would like to know how I can check if I am logged on as an adminstrator, if I am not, how do I log on as an administrator. Thank You
  11. mans

    Data Type Check

    Hello, I am using VB6 with Access2000. Can somebody please let me know what code I need to use to check the data type in a text box. I would like a message box to come up and tell the user that he/she has entered: 1/ text instead of a numerical value 2/ a numerical value instead of a...
  12. mans

    Closing Forms

    Hello, I am using VB6 with Access2000. Can someone please supply code that will close all of the forms for a particular application (App1) from within another application (App2). App2 is used to compact, repair and copy the database that is used by App1, App2 needs to shut down all of the...
  13. mans

    Permanently Closing Programs in Memory

    Hello, Can somebody please tell me how I can stop programs/files opening up on start up and running in the memory of XP. In Win ’98 you just go “Start” then “Programs” then Accessories” then “Systems Tools” then “System Information” then “Tools” then “System Config. Utility” then “Tool” then...
  14. mans

    Keyboard Problem

    Hello, I have the Microsoft ME operating system and each time I turn the compter on it constatntly rings and does not allow me to enter the computer. There is a message that says "Keyboard Stuck at FF", none of the keys can then function. I have changed keyboards and that worked for...
  15. mans

    Keyboard Problem

    Hello, I have the Microsoft ME operating system and each time I turn the compter on it constatntly rings and does not allow me to enter the computer. There is a message that says "Keyboard Stuck at FF", none of the keys can then function. I have changed keyboards and that worked...
  16. mans

    DataGrid and Current Record

    Hello, I am using VB6 SP4 with Access2000. I have 3 objects, DataGrid2, Adodc2 and Text2. Each time a user clicks in the above grid with a mouse or by scrolling with the adodc2 object, I would like Text2 to display the record that is highlighted each time (there is only one field). Can...
  17. mans

    Rename Column (Alter Table)

    Hello, I am attempting to change the name of a column from Field1 to Field2 in Access2000 using VB6 SP4. Actually, it would be more useful and simpler (and less time consuming) if I was able to change the datatype of Field1 from Autonumber to Double (it is not a primary key), that would be...
  18. mans

    Add Index (Alter Table)

    Hello, From within VB6 and using Access2000, I am attempting to change a field called field1 so it is indexed, the table name is Table1. I have used the following statement (and some variations) without luck. It says there is an error with the statement and higlights INDEX below. Alter...
  19. mans

    Making a Primary Key

    Hello, I am familiar with creating new fields and tables in Access2000 using VB6, and setting certain features of that field such as data type etc. I would appreciate it if I can see some code that demonstrates how I can make a pre-existing field a primary key (there will be no replication...
  20. mans

    Displaying Image in OLE Object

    Hello, I am attempting to display an OLE object in Access2000 in an ole object (ole1) on a VB6 form. I have been using the code below and it comes up with error messages stating “Item no found in this collection” or “Type Mismatch” when I run it, can somebody please let me know how I need to...

Part and Inventory Search

Back
Top