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

    Use Google spreadsheet to populate ASP.net web page

    A couple of friends and I share a Google spreadsheet to keep a list of events. I want to use this spreadsheet to populate a web page. I want it to the web page to automatically update when the spreadsheet is updated. So I'm guessing I should use an ASP.net repeater and pull in the spreadsheet...
  2. may1hem

    How to show or hide controls using checkbox click, client-side?

    I have separate snippets of text which I want joined together to form an email message. My ASP.net page has a radiobuttonlist where the user can select the email circumstance, and based on the selection I want some checkboxes to show or hide. Then, as certain checkboxes are clicked, I want an...
  3. may1hem

    How to keep label and input together in horizontal CheckBoxList

    I have a CheckBoxList, with RepeatDirection set as "Horizontal" and RepeatLayout set as "Flow". I'm finding that the label and input (checkbox) don't stay together at the end of a line. So I end up with the checkbox on the previous line and the label on the next line, which isn't good. I'm...
  4. may1hem

    How to pass dropdownlist as parameter

    I want to create a sub which accepts a dropdownlist and a comma separated string as a parameter and populates the dropdownlist. The code does do the job when I enter the name of the dropdownlist directly, but it doesn't work when I create a separate sub for general use. I think it's because it's...
  5. may1hem

    How to add class attribute to list item in master page

    I have a menu list in my master page and in each page on my web site I want the current page to be highlighted in the menu. Here is the relevant snippet of the MasterPage file: <body id="master_body" runat="server"> <div id="header"> <div class="container"> <div id="top-menu"> <ul...
  6. may1hem

    How to make multiple Adrotators show unique images from same XML file?

    I have 5 Adrotators on a web page, and they all select images to display from the same XML file. At the moment it's working, but sometimes when I refresh the page a few of the Adrotators display the same image which I don't want. Is there a way to make them display 5 unique images from the same...
  7. may1hem

    How to pass listbox or string as a parameter to a function?

    Hi, I want to create a general function which accepts either a string or a listbox. I've tried to use a variant but this doesn't work. Public Sub FnDoStuff(IdStringOrListbox As Variant) 'Do stuff here.. End Sub How can I get the function to accept either a string or a listbox?
  8. may1hem

    How to switch from calendar to mail in Outlook?

    I want to be able to switch from calendar to mail in Outlook 2007 using VBA, how can I do this? On the Outlook toolbar I can click on Go --> Mail , but I don't see how to do this using VBA. Any ideas? Thanks
  9. may1hem

    Open new url from textbox value - doesn't work 1st time but does 2nd

    I want people visiting my web site to have directions to my office using Google Maps, which uses a simple querystring for directions. So on my web site, I want a textbox where a customer can enter where they're coming from, then they either press enter or click a submit button, and then Google...
  10. may1hem

    Reading JPEG images gives Out Of Memory error

    I've written some code so that I can select images from the server to display on my web site. It works fine in folders with around 100 images but in one folder which has 400 images I get an Out Of Memory Error. It only reads 144 images then gives the error. Can someone help me find out how I can...
  11. may1hem

    How to create monthly calendar on spreadsheet

    I'm using Excel 2007 and need to create a monthly calendar in separate worksheets. So sheet 1 should show Jan 2010, sheet 2 should show Feb 2010, etc. ------------------------ January 2010 Mon 4 11 18 25 Tue 5 12 19 26 Wed 6 13 20 27 Thu 7 14 21 28 Fri 1 8 15 22 29...
  12. may1hem

    Renaming file causes error &quot;Object reference not set to an instance&quot;

    I have an ASP.net (VB.net) web page which uses an include file and an xml file. I called the page "default_.aspx" whilst I was making changes, and the xml file "products_.xml". The include file is called "rightcol.ascx". I amended the code as I needed, and it all works fine. Then to make the...
  13. may1hem

    How to change URL of frame2 from frame1 ?

    I've created a local web page which uses frames, and I want to be able to change the URL of frame2 from frame1. Frame1 contains a button which when clicked should change the URL of frame2 to Google's home page. Frame1 also contains a textbox which I was using to check if the OnClick event was...
  14. may1hem

    Use repeater with child nodes of XML document

    I'm currently using a repeater to display my business service fees from an XML file. I want to be able to offer 3 pricing options for each service. I want to create child sub-nodes in the XML file, but this doesn't seem to work. The XML file looks like this now: ----------------------- <?xml...
  15. may1hem

    Populate dropdownlist from multiple fields in xml file

    I have an xml file which lists events: the event name, the weekday, the start time, and the end time. I want to populate a dropdownlist on my web page with these events. E.g. it should display events as: Monday 7pm to 8pm dance group Tuesday 6:30pm to 9pm circuits class Obviously this requires...
  16. may1hem

    Modified date of Outlook notes folder

    My application loads over a thousand notes (from an Outlook notes folder) into memory each time it runs, which is slow. What I want to do is load the notes into memory once and then each time I use the application it should check the last modified date/time of the folder to see if anything has...
  17. may1hem

    How to lookup VBA Dictionary key

    I'm familiar with defining a Dictionary object and storing pairs of values, e.g. ProductCode234, Bread ProductCode546, Milk ProductCode812, Tea I know that if I want the value of product code 234 I use dictionary.item("ProductCode234") to retrieve the value "Bread". But how can I lookup...
  18. may1hem

    Error handler only works once in loop

    I'm looping through a collection of items and I'm deliberately creating an error, just to test the error handler. The error trap works correctly for the first item in the FOR..NEXT loop, but on the second item it doesn't work and instead Outlook brings up an error message "type mismatch". Of...
  19. may1hem

    Find messages using VBA

    How can I perform a search using VBA code? I want to find all emails sent to and from a particular person, and I want to display these emails in a listbox on a Userform. By the way I'm using Outlook 2007. Is there a simple search method, or do I need to read through all of the emails using a...
  20. may1hem

    Excel workbook named formula problem

    I've written a formula which is named using the Name Manager. I chose it to be a Workbook Function. The worksheet is called W1. When I make a copy of the worksheet (called W2), the formula doesn't work. When I checked the formula in W2 it is referring to worksheet W1. But the formula is a...

Part and Inventory Search

Back
Top