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

    Can you force OPENDATASOURCE to user TCP/IP netork protocol?

    Hi all, hopefully a quick and easier answer to this one: I am trying to use OPENDATASOURCE to copy data from one SQL server to another. (I'm aware SSIS is better for this but the scripts are easier for my colleagues to understand and update) I'm falling over at the first hurdle I've written...
  2. WyldeCarde

    Help with inserting data into a remore SQL server table

    Good afternoon I have a need to run a succession of SQL scripts from a client PC to update a series of tables on a SQL server running on a VMware session on the PC in question. The client PC doesn't have SQL server installed, and I need to run the SQL scripts via a VB script or similar, can...
  3. WyldeCarde

    Little help with conditional formatting

    Hi all What I am trying to do is, if a date in a subsection of column is less than the date stored in Cell D2, fill the entire row in light grey. If not, fill it in white. So far I have (a lot if it from this very forum)- Which just colours everything in grey regardless of what values are in...
  4. WyldeCarde

    Removable drive benchmarking

    Hi all I am being tasked with finding us a replacement removable drive set up for our mobile worker people. They are all using Panasonic Toughbooks with PCMCIA based removable storage. These are used to back up the data on the drive continuously. This allows them to move to another unit easily...
  5. WyldeCarde

    File not found error

    In this snippet of my code: Function Filter_Proc2() Dim isFound, TextLine1 Dim rst_read As Recordset Dim rst_write As Recordset Dim dbs As Database Set dbs = CurrentDb Set rstread = dbs.OpenRecordset("Stored_Proc") Set rstwrite = dbs.OpenRecordset("Filter_Proc") rstread.MoveFirst While Not...
  6. WyldeCarde

    Process processor affinity

    Hi all I am shortly going to get a Quad core CPU. I know that you can set the processor affinity to restrict a process to run on certain cores. However when you reboot, these flags are cleared. How can you force a process to always have an affinities to a specific core? Thanks in advance
  7. WyldeCarde

    Help with parsing ASP files

    Hi all I have been tasked with writing an Access database that will search a directory and all sub directories for ASP files, find which SQL stored procedures each fo them runs and output this data. I think in the ASP files the lines I am searching for will be: cmdAdmin.CommandText =...
  8. WyldeCarde

    Predefined filters on a form

    Hi all Let me try and explain this correctly first time! I have a main form which allows you to match members of staff to three source datasets. Some of the staff are in in some or all of the source databases and some are in none. At the bottom of the form are subforms for each data set...
  9. WyldeCarde

    Help running Module (Easy fix I think)

    I wholesale lifted this from another thread on the site, tailored it to do what I needed and if I run it from VBA it does exactly what it should. How do I run it from a macro though? I would have thought using 'runcode' and running 'FixNames' would do it but apparently not. I've only used...
  10. WyldeCarde

    Displaying results of append queries

    Good morning all I am running 2 append queries to update a staffinf table via a macro (I'm fine with converting to VBA if that would help) I'm turning warnings off before I run them, but I would like to be able to give feedback to the user if the table is updated. Basically telling them that x...
  11. WyldeCarde

    Strange issue with visual studio 2005

    I've just installed visual studio 2005, Ive not used any since visual studio 6. Anyway, I started it up, created a project, I want to add a new form so I am clicking project, add new item. When I go to add UI -> windows from type in a name and press add, the screen flashes, no error message...
  12. WyldeCarde

    using robocopy to supplement offline files and folders

    Hi guys I am currently writing (I hope) a robocopy script to use to supplement the offline files and folders functionality on XP. Currently a large number of users cancel the sync process as it takes too long. We are replacing almost 600 of these laptops in the next 3 months and we dont want...
  13. WyldeCarde

    Registry key as a system variable?

    Good morning all I have a strange one here. we are using symantec live state delivery here. One of the nice things about it is that it is "location aware" It can figure out what its closest server is, so when our customers move from site to site, the LSD agent is able to use the closest server...
  14. WyldeCarde

    DCOM/Windows installer issue.

    I have an issue where, after applying a windows security template I have written, windows installer will not run correctly. Unregistering and reregistering the service fixes the issue until the template is reapplied. I searcheed on here, and found a thread similar but not the same...
  15. WyldeCarde

    Add Trusted Sites automatically

    We have run a script (via the login scripts) at my company that runs the Internet Connection Wizard, populates the proxy server settings, and adds a site to the trusted site domain. This all works fine. However we want to add another site to the trsuted sites, and would prefer to do it via a...

Part and Inventory Search

Back
Top