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 Wanet Telecoms Ltd 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: melt333
  • Content: Threads
  • Order by date
  1. melt333

    Check internet file exists

    I am using Excel to retrieve data from excel files on the internet (This I can do). But I need to check whether a file exists before performing anything. Does anyone know how to check for the existence of an excel file on the Web, i.e. does the file...
  2. melt333

    I want my code to finish running

    Hi, I have an event called by a control on a form, which calculates a few things, then runs a macro. This macro opens another form and closes the first form. The problem I am experiencing is that the original event procedure doesn't finish (because the onus is on the user choosing another...
  3. melt333

    Opening a form and entering data from another form

    Hi, I am trying to move from one form to another, bringing the value in a combobox on the first form, to a textbox on the second form. This is probably a simple task, but I have been trying with no success. Any ideas? Your help is much appreciated, Mark
  4. melt333

    Running a Crosstab query with 2 parameters from a form

    Hi, Please help!! I am trying to run a crosstab query, using 2 parameters taken from 2 textboxes on a form. I guess I will have to filter the records first using the parameters and then action the crosstab, but I haven't got the first clue how to!?!!?! Any ideas? Your help is much...
  5. melt333

    Toggle Button & Calendar control to enter a date into a text box

    OK, this has been annoying me for days.... I have created a form with a calendar control on it. I have created a Macro - action(SetValue), Item: Forms![calendar].visible; expression: Not Forms![calendar].visible I have another form with the toggle button, and set the ONClick event to the Macro...
  6. melt333

    Automatically open with a form in Excel

    Hi, I am trying to create an excel workbook to automatically open with a form (without a worksheet behind it). At the moment I have a button on the worksheet which opens the form for me, but I am not happy with that. I've read about the workbookopen event, but where does the procedure go, and...

Part and Inventory Search

Back
Top