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

    open Microsoft Photo Editor using createobject

    Can someone please tell me how I can open an instance of Microsoft Photo Editor using createobject. The Access help files only give an example of how to open an instance of Excel. Thanks in advance
  2. gungfukid

    Excel linked to access, data type problems

    I have linked an Excel sheet to my Access database. Where I need numbers as well as text I have forced Access to make the field Text by using a dummy first row which I then delete. The problem is that in text fields the numbers are not displayed, instead I get #num! This is inconsistent...
  3. gungfukid

    How to specify data types in access table linked to excel she

    I have an Access database that links to an excel sheet (in a table format). When linking from Access, it automatically selects the datatypes for the fields but it has chosen a number datatype where I need a text datatype as the field contains both numbers and text. The rows which have text are...
  4. gungfukid

    Write Reserved gives "your Name" not the users name

    I have used the Write Reserved function (VBA) to find the current user of a file. However, this gives "Your Name" rather than displaying the correct username. I am on a network, running WinNT and assume it is to do with a setting between WInNT and Excel. Does anyone know the cause...
  5. gungfukid

    Write Reserved gives "Your Name" rather than user name

    I have used the Write Reserved function (VBA) to find the current user of a file. However, this gives "Your Name" rather than displaying the correct username. I am on a network, running WinNT and assume it is to do with a setting between WInNT and Excel. Does anyone know the cause...
  6. gungfukid

    find the user of a Excel file using VBA

    Can you find the author or the current user of an excel file using a VBA procedure/function? If so, what is it? Thanks!
  7. gungfukid

    Open password protected Excel linked files, from Access

    I have a passsword protected Excel file (password used to protect hidden sheets) which has some of its sheets linked to an Access database. Access however cannot decrypt the file now it has a password. How do I get Access to specify the password(Excel) when opening the linked tables? Thanks...
  8. gungfukid

    add values together from different tables

    I would like to add together integer values from a number of different tables and display the result in a text box. The problem that I am having is that I would like to add only the values that correspond to the selected record (selected with primary key) not the whole table. How do I write this...

Part and Inventory Search

Back
Top