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. vvilan

    How to browse internet

    Hi, For some reason, I want to integrate the net with java. How do I go about do stuff like: 1. open up IE or some other browser 2. go to www.gmail.com 3. input user and password in the correct box 4. click log in 5. check most recent mail I would just like to learn how. Thank you.
  2. vvilan

    Listing Files in a Directory

    Never mind, it works perfectly thank you very much!
  3. vvilan

    Listing Files in a Directory

    ** Posted too quickly, and it still doesn't work
  4. vvilan

    Listing Files in a Directory

    I changed the row source type to value list and added this method to the load event and replaced lstFiles with my listbox's name as well as changed the path to currentProject.path & "\
  5. vvilan

    Listing Files in a Directory

    Hi, how do you list all the files in a directory in MS access using VBA? Preferably in a list or combo box. thanks in advance!
  6. vvilan

    Result of SQL query?

    In php, we could get the result from the query by executing it and then use mysql_fetch_array($queryresult). How can we use something of this nature in access? Thanks! PS. Does access have an API for their vba?
  7. vvilan

    Resizing column to best fit vba

    Okay, let's say I want to execute a query named query1. How would I do that in a subform?
  8. vvilan

    Resizing column to best fit vba

    The user inputs are taken from a form and then the form executes a query based on the input which selects data from the table and the data is displayed with the table's column width.
  9. vvilan

    Resizing column to best fit vba

    Well to view data, I use the form to put the data and the data executes a query from the table. If the table's columns aren't resized, the data will not show completely and the user will have to resize manually. I just wanna get around this problem.
  10. vvilan

    Resizing column to best fit vba

    Thanks for the quick reply but I'm a new user who does not understand the syntax of that code at all. I c/p into my code and it doesn't work.
  11. vvilan

    Resizing column to best fit vba

    Hi, I create the table in access by importing from a text document via this code: DoCmd.TransferText acImportDelim, "Import Specs", fdr, CurrentProject.path & "\" & fdr & ".csv", True How do I auto resize the columns to best fit such that the data from every cell is displayed fully. Thanks!
  12. vvilan

    Alter column hyperlink problem

    Big thanks to that function but my problem is to change the data type of an existing column to hyperlink rather than to instantiate a column with datatype hyperlink.
  13. vvilan

    Alter column hyperlink problem

    EDIT: \\server\computer\folder\file1.txt \\server\computer\folder\file2.txt \\server\computer\folder\file3.txt I meant backslashes
  14. vvilan

    Alter column hyperlink problem

    Thanks for the help but I'm new and I don't understand that syntax. I don't even know what are controls. The best solution for me is to find a working statement that does this: ALTER TABLE [tablename] ALTER COLUMN [columnname] Hyperlink; However, I'm starting to doubt that is possible...
  15. vvilan

    Alter column hyperlink problem

    Well, I am a fairly new user and this thing that i'm making isn't a big database but just a way to organize and search for the massive amount of data that exists. I would like to hyperlink it but how can this be achieved in VBA or some other way such that it can be done automatically?
  16. vvilan

    Alter column hyperlink problem

    Hi, I am very new to access and I have to create this application for work. The application imports information from a text document and transfers it into an access database. One such column is a Link such as \\computer\folder1\file.pdf. Setting this column as hyperlink does not hyperlink the...

Part and Inventory Search

Back
Top