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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Timing out - is this code to cumbersome?
understandable. before I do though, here is a quick question that may solve my problem. My code is basically writing a couple thousand lines of javascript, using the DOM to create <option> for my 3 <select> on the page. I'm thinking this is a little out of hand - but maybe not. I don't do... -
Timing out - is this code to cumbersome?
I thought this was a slick approach but now that I've loaded alot more data into MySQL the same PHP code I was using to render the page is now failing. I'll give a brief description of what I am doing and then put some code in for you to see. The basic approach I'm using is on the load event... -
Setting the selectedIndex of <select> in FireFox
There are none coming up - that is why I'm having so much trouble figuring this out. I've found plenty of codce examples online showing the use of selectedIndex in FireFox - and they are accessing it in the same manner I am. Thanks alot for your input though - if you have any other ideas for...- mpopnoe
- Post #7
- Forum: Javascript
-
Setting the selectedIndex of <select> in FireFox
Thanks but I mentioned in my orig. post that I tried both ways and it still is not working. I tried it again, here are results: function BodyLoad() { var oState = document.getElementById('myState'); oState.options[1] = new Option('Oregon'); oState.options[1].value = 1; oState.selectedIndex...- mpopnoe
- Post #5
- Forum: Javascript
-
Setting the selectedIndex of <select> in FireFox
You got it: function BodyLoad() { var oState = document.getElementById('myState'); oState.options[1] = new Option('Oregon'); oState.options[1].value = '1'; oState.selectedIndex = 1; var oState = document.getElementById('myState'); oState.options[2] = new Option('Washington')...- mpopnoe
- Post #3
- Forum: Javascript
-
Setting the selectedIndex of <select> in FireFox
I have 5 dependent drop-downs (<select> objects) that after I submit the form to complete the search I want to display the drop-down lists to their previous selections. This works flawlessly in IE but fails to fire in FireFox. To keep the code simple to view since there is lots of it, I'll...- mpopnoe
- Thread
- Replies: 7
- Forum: Javascript
-
Advanced <img> src change
I'll take your advice, but I've been testing this site with Mozilla Firefox and IE 6 and onLoad and onError are firing away. Older browsers probably don't support it though so I'll look into doing it in FoxPro - I think I just need to use SOAP or some other component to make HTTP requests via a...- mpopnoe
- Post #9
- Forum: Javascript
-
Advanced <img> src change
If they are supported why are they firing correctly? when the URL fails the onError fires and when it comes thourhg the onLoad fires. The problem at this stage is the 'stack overflow' errors - something to do with the image files but can't seem to pinpoint why. thanks again for your insight!- mpopnoe
- Post #7
- Forum: Javascript
-
Advanced <img> src change
Thanks Jon, I'll look into it - I just thought javascript would be the best route. I almost got this working but I get a stack overflow error @ line 0 and it happens on the last image trying to be swaped and I can't figure out why - any ideas?- mpopnoe
- Post #5
- Forum: Javascript
-
Advanced <img> src change
Sorry for not being more clear - just ignore the URLs, in the code they point to actual photo files but they are MLS listings and I am not authorized to display them outside the designated site.- mpopnoe
- Post #3
- Forum: Javascript
-
Advanced <img> src change
I've found a lot of useful code but just can't seem to get this to work. Ok, the software shows images of real estate that a user searches for in a search results page. now, my databases image fields will always be populated since I auto-generate the photo filenames based on the MLS # of the...- mpopnoe
- Thread
- Replies: 8
- Forum: Javascript
-
select unique records based on multiple columns
Tiglet, Thanks! That worked great, except I did need to add this line to select the valid range of data otherwise "all" visible cells, all the way down to the maximum rows allowed in Excel (65k+) are copied into the clipboard and the virtual money is maxed. Range(Cells(1...- mpopnoe
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
select unique records based on multiple columns
Thanks to both of you. Tony, The reason I move the columns around is because from my limited experience, the only way to create a compound unique key (of sorts) in Excel to filter on is to place them inline, then hide the columns that are not part of the unique key. Is this way off? I...- mpopnoe
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
select unique records based on multiple columns
What I'm trying to do is find unique records based on a compound unique key, that being 5 columns for this example. In order to do the filter, I place the columns in columns 1-5, hide the remaining columns and filter. That part works fine, the only problem is when I try to select just the...- mpopnoe
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Create an XML document from data in a CSV file
Thanks for your quick response. Most of the data I ran into out there for converting data to XML was java and .net classes, so I'll either use the java classes or write something on my own....just wanted to make sure I wasn't missing the easy way of going about this...I have ended up doing... -
Create an XML document from data in a CSV file
I read the first half of "Beginning XML 2nd edition" by wrox, and that was about 6 months ago....so I am not even to the status of newbie yet. Anyway, I believe I understand the concepts of creating xml documents based on dtds, and using DOM, etc. to access/manipulate the data within... -
Excel 2000 error: "Compile Error, Automation Error, Unspecified error
One user of the Excel macros I make is having tyrouble with 1 xls file only, getting the error message thrown by VB stating "Compile Error, Automation Error, Unspecified Error". The code in this workbook is no different then the hundreds of other ones she runs. The VBE opens and has...- mpopnoe
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
References
How do you remove a reference in code? I can't seem to use the remove method properly: Dim objRef As Object, strDesc As String For Each objRef In ThisWorkbook.VBProject.References If InStr(objRef.Name, "EDD_TEMPLATE") <> 0 Then 'objRef.Remove...- mpopnoe
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Retreiving values from other worksheet
xlbo, Thanks, that was what I was getting at. rsk77, Without any more info, I'm assuming (which is never good) that your trying to bring data from the worksheet cells into your form controls. You mentioned that when the user selects a date value this saved data should be displayed. Use one...- mpopnoe
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Sharing code between projects
I referenced workbook "B" from workbook "A" so I could use the code (in standard modules) from "B" in "A". However, I don't know how to call these subs/functions that reside in "B". I also tried placing some code in "B" in a class...- mpopnoe
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
