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...
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...
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...
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...
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...
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
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 =...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.