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 Chriss Miller 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. stephenmbell

    VBA - Create Pass Thru Query without ODBC DSN??

    Is it possible to programatically create a pass thru query that connects to SQL server without having a DSN on that machine? I can't seem to get it to work. Thanks sb
  2. stephenmbell

    IIS 5.1 on XP - Modify with vbscript?

    Hello all, I have roughly 650 windows xp machines running IIS 5.1 that I need to modify the home directory (among other things). I am wondering if there is a way to automate this process with a vbscript?? I have been searching all of my scripting resources web sites and I cannot seem to find...
  3. stephenmbell

    Can I push out Local Security Policy Settings Remotely?

    Hello, I have a network that I manage - it has 700 windows XP based PC's (SP2) in a total of 350 different locations. These machines are accessible over a WAN connection from my desk - and they are not joined to any domain. I am looking for a way to configure certain settings...
  4. stephenmbell

    problem with tr.nextSibling - not getting expected results

    I am trying to implement expand collapse functionality in an html table. I am using aptana and firebug to debug this. I think the problem is coming on this line, but I cannot figure out why.. var tr = img.parentNode.parentNode; var next_tr = tr.nextSibling; // this is the problem line...
  5. stephenmbell

    Problems Setting up IIS on server - Authentication??

    I am looking to setup both a dev server and a production server for our company's intranet - intended to run some asp.net 2.0 applications & possible SQL 2005 I just setup a fresh installation of Windows 2003 server (standard edition), ran all of the windows updates, and installed IIS on it -...
  6. stephenmbell

    Limit the characters in a multiline textbox

    I am writing an application that has a multiline textbox on a form. I am looking to make this textbox not be able to have any lines of text in it that are longer than 22 characters. The number of lines does not really matter. I turned off wordwrap and do now show any scroll bars - how would...
  7. stephenmbell

    CFMAIL Not Sending - Please Help

    I have a page that submits a form to an email address. The CF Version is 8.0 enterprise, and the site is not hosted in site, so there is no way for me to access the smtp server settings on the CF Administrator. That being said, here is my code: (I have tried both from attributes individually...
  8. stephenmbell

    help with div tags and *rounded corners*

    It isnt really rounded corners.... I have an image - basiaclly just a white box with a drop shadow, that will eventually hold some text and images. I know how to do this with tables, but cannot seem to get it right with div tags. What I have done already is, slice the image up into 1 image...
  9. stephenmbell

    Windows Security Center - Disable After SP2 Install!??

    Here is my situation - because of some new regulations, I have to upgrade 600 PCs on a segment of my network to XP SP2 from Windows XP Pro SP1. These machines are on a different subnet, and not part of a domain. These machines are also behind a firewall and do not have internet access. I will...
  10. stephenmbell

    Confused by Timer.Interval Property...

    I am writing an application that will shell out to c:\windows\system32\shutdown.exe This application will start by scheduled task - 15 minutes before I actually want the machine to reboot. I have a timer on my form, with an interval of 90000 (which I believe is 15 minutes) The event does...
  11. stephenmbell

    Refreshing Imported Tables - VBA

    I am looking for a way to click a button on a form and have it refresh some imported tables - what would be the best way to do this? I have done some similiar work with ADOX - would this be the way to go? thanks in advance HTH sb
  12. stephenmbell

    Schtasks /Create - Can I set Run Until?

    I have a handful of scheduled tasks running on every windows xp machine in this segment of my network. From time to time we have to re-image these machines and re-set them up. One of the things we have to do when we re-image is run a bat file to create all of these scheduled tasks. Out of the...
  13. stephenmbell

    Copying a worksheet and pasting into new workbook

    I have 25 excel sheets that I dynamically create by exporting data from Access. Each of the 25 files consist of 1 sheet each (sheet 2 and 3 exists, but contain no data and do not concern me) Using VBA I would like to: - Create a new workbook (AllData.xls) (I have this part done) For Each of...
  14. stephenmbell

    Access Backend Performance Issues

    I am not even sure if this is the place to post this, but I will give it a shot. I have an application that runs in msaccess. There is a backend db that resides on the server and a front end db that resides on the clients machine (has all of the forms / reports as well as linked tables from...
  15. stephenmbell

    putting a formula in a cell - VBA??

    I am using access to export to an excel sheet sales for items. each item has 10 rows on the excel sheet, and they are populated by row, sequentially. there are 3 rows that I would like to display... for this example we will say rows 4,5,6 (out of the 10 per item). I want rows 4,5, & 6 to...
  16. stephenmbell

    Looping through a range

    I am automating the creation of an excel spreadsheet from a microsoft access database. I have googled and failed to find a good example of looping through a range (atleast, the way I want to do it). the spreadsheet is showing product sales over a 9 day period. At the beginning of displaying...
  17. stephenmbell

    Is there a way to seed the sort order of a query??

    I have a relationship in my database setting up "buddy items" so if you select viewing item 100 (it may have buddies of items 234(rating 1), 512(rating 2), 311(rating 3)) - each item -> buddy relationship has an associated rating field. I want to display the item selected at the top, then...
  18. stephenmbell

    Passing Values w/ OpenArgs and getting an AfterUpdate Event To Execute

    I have 2 forms with toggle buttons. They toggle back and forth between the two forms. Form1 is a continuous form of items and Form2 is the form containing all of the detail for each individual item in my db When I am on Form1 and click the toggle button to go to Form2, I pass the item# in...
  19. stephenmbell

    OnKeyUp event on Text box... Autosuggest possible??

    I am trying to do something similar to an autosuggest box. Basically, it is a text box used to search the database. as the user enters the search term, i want to update the rowsource property of a corresponding listbox... in the keyup event of the text box i am creating a dynamic sql string...
  20. stephenmbell

    ANY IDEAS?? Feeling Limited By Access....

    I have been given the task of creating an application in Access to track sales and competitor pricing to better make business decisions. I pretty much have the data layed out the way that I need it, but I am having trouble deciding how to best display the data on the form. Hopefully this is...

Part and Inventory Search

Back
Top