Search results for query: *

Hi, I'm a newbie to using SAS (almost a full week now woo-hoo lol) although used SQL Server for several years. I was curious if anybody knew of a tool similar to "SQL Search", which I love, for SAS? If you're not familiar with SQL Search it allows you to search database-wide on all objects for...

Bought a Seagate Backup Plus 3TB USB 3.0 drive and as soon as I plug it in Windows crashes with PFN_LIST_CORRUPT error. Drive states compatible with XP SP3, which is what I have, so I'm guessing something with my system is causing it, but not sure where to start with troubleshooting. I'm gonna...

I have code to look at every shape in a Word doc and if it's named a certain name then return the page#. I only care if said shape is on an Even page. Currently searching the entire doc is slow so I'd like to only search shapes on Even pages. How do I iterate through shapes on an individual page...

Hi, my team is new to using TFS and we're checking some remaining Access databases we have for source control. I was curious if TFS could be used as a 'backup' in the sense that we have some DBs that run daily and the data (local tables) builds off the prior day so I would like to have copies...

Hi, I'm working on creating a dashboard of all the SSIS packages at my job and I don't have access to (that I'm aware of) all the package information as it 'resides' with a different department (security reasons) and I need to ask them about any information regarding packages. I receive...

Hi, I'm brand new to PHP and installed Apache Tomcat along with PHP and I'm using a book and it states to type in the address 127.0.0.1 (localhost) and I should receive a message stating that everything is setup OK; however I'm receiving an error message stating the browser can't connect/load...

Hello, I'm trying to setup a customer template using field calculations and have been struggling for hours. I am trying to make a field that will add to an existing field elsewhere on the form. I have LetterDate at the top of the letter which the code for is: { DOCPROPERTY LetterDate \@ "MMMM...

Ever since moving to Access 2010 I've notice the 'Run' button constantly disappears from queries for no reason than I can determine. Many times I need to view 'DATASHEET' view first then go back to 'DESIGN' view and then the Run button will be there...anyone else encounter this?? thx

Hi, I'm scripting about 100 tables for a database and had a question on proper index usage. If I have several queries that have three fields in various places (WHERE clause, JOIN clause etc) then is there a difference between setting up the index with the fields in one line or multiple lines...

Say I have the following values in a listbox: ABC BCD CDE Is there a way for me to supply "CDE" and get the return ItemData of 3? I'm not looking to iterate thru the entire value list, was just wondering if there's a way to do it using the built-in listbox parameters. thx

My team develops in-house applications in Access w/Sql Server back-ends. I was wondering if it's possible for us to share SQL functions? Right now we basically copy functions into our database to make them available; what I would like is to have a common area where we can place functions to have...

On W2000 when a scheduled task is created, where does that get written? I've googled around but haven't been able to track down where the data is. In the process of migrating these tasks over to Vista on a different machine and would love a printout of the tasks to rebuild them since there are...

Hi, I'm testing my applications within Vista for the imminent conversion. I noticed "acCmdWindowUnhide" no longer works to unhide the db window under Vista. What I currently have, doesn't work in Vista: DoCmd.RunCommand acCmdWindowUnhide I'm hiding it by setting the property...

Hi, I was wondering if anybody knows of a plugin or whatever to highlight start and end sections of conditions? For example, I'd like to select "If" and have the corresponding "End If" highlight. I'm working from within MSAccess. thanks!

I'm looking to compare two tar files to be able to tell which files aren't in the other. From my research it looks like I can use the 'tar -d' command and write to a file for each tar and then use diff. Just wondering if there's a way to do this in one command? I don't care about differences...

tar tf test.tar | xargs -i cp -r -f {} backup I am trying to copy files that match those in the test.tar file into the backup directory. There are subdirs with files also and these are designated properly within the tar file. The files all get copied to the proper locations in backup, HOWEVER...

Hi, I have a couple questions on using variables in scripts. 1. Can I have a command such as grep within a variable like below, or is the grep being executed as the variable is being set? If it's being executed then I can just pull it out and add it to the second line. 2. I can't figure out...

I have a D-link DCM-202 that is about 2.5 years old and is now dropping the connection at least once a day, started several months ago. Works fine when it works, but loses connection daily. I've unplugged the router to make sure it's the modem and have researched all over for a fix but haven't...

It took me a while to figure out the proper syntax for using the Like operator within code and I couldn't find any related posts, so thought I'd share: If rst!SystemNode Like "*" & nodes![node] & "*" Then (this instance will match nodes![node] to rst!SystemNode if rst!SystemNode contains...

greetings, I'm very green to sed & awk and am working on a project to read each line in a file and if it contains "START" or "END" then I want to capture those lines plus anything in between them. This is a log file so I'm looking to get the beginning and end of a transaction. Also I only want...