Search results for query: *

So I have 2 tables: PERSON -> is a table of basic info regarding members in the company (unique key here is PERSON_ID) sample records: PERSON_ID DEPT 123 abc 111 abc 100 bdc 200 cda 140 abc EARN_HIST -> is a table of historical earnings...

Hi, I have a folder from work that contains about 4000 PDF files, each named something different However, in each file name, somebody decided to put the number '4' before the ".pdf" So, my filenames are "myfile4.pdf", "yourfile4.pdf", "testfile4,pdf", etc.... Is there a way that I can write a...

Hello all, I've been doing a certain task at work manually for a long time and it has reach the point where I would like to create a batch script so that I could run it in DOS (yes, i know it doesn't exist anymore.. but i still like to call it by that name). My work runs a WinXP Pro...

Hello, I've searched online left and right... and I can't seem to find the answer that i'm looking for... Its possible that this cannot be done, but I need to ask the people in this community If I'm designing an Access form, can I create a button that opens a Lotus Notes document link? The...

I have briefed both DoCmd.TransferSpreadsheet and DoCmd.OutputTo. Both have their strengths and their purpose. DoCmd.OutputTo Method is great if one is transferring a single Table or Query to a spreadsheet. However, I need to export several Tables to different worksheets in the same Excel file...

Hi, I have a problem which may be a bit too complex for me to handle in Excel. I'm usually pretty good, so for me to ask for help means this should be a challenging question Let's begin.... Current Situation: /*SAMPLE SPREADSHEET*/ DATE: PAYMENT: MonthElapsed 2007/1/1...

Hi, I'm running Access 2002 I have created a form, which allows the end user to select a YEAR value (ie: 2006) The first thing this form does is create a dynamic temp table (let's name it: tblTemp) which will pull in data according to the year selected.... so, it drops tblTemp, then re-creates...

Hi, I have a cell with the following content ="some string 1..." & someVariable & " some string 2...." Normally, that would just concatenate the three parts together into one string However, I need the portion " some string 2..." formatted BOLD in the end-result display Is that possible...

Hi, I'm working on MS Access connected to db2 tables thru ODBC Most of the times, I'm workin on Access tables and I create a query like this: SELECT * FROM tblEarnings WHERE earnEffectiveDate < #5/1/1974# The query works fine in Access with its local data tables. I get a result set of all...

Hi, the subject heading pretty much explains what I need done I created a form which allows the user to select 1 of 6 queries to export to a spreadsheet Let's say the user selects all 6 queries to export and inputs the export filename and path... I would like "DoCmd.OutputTo acOutputQuery" to...

Hi, Not sure if I posted this in the correct forum, but I just wanted to see if anyone can give me some suggestions. I just started using Hijackthis and I just wanted to know if I should fix everything that the scans returns. I have pasted my log and if anyone can tell me which one I should...

Hi all, I've got 2 questions... maybe I should post it separately, but they could be kinda related. Question 1: Now, everyone is probably familiar with Folder sharing in Windows. The blue sharing hand that appears at the bottom of the folder icon... if you don't know what i'm talkin about...

Hi all, I recently put in a new database server at work running Windows 2000 Professional with SQL Server 2005.... I'm a newbie to SQL Server 2005, so please assume I know nothing about it. We also have 2 other Win2k machines running SQL Server 2000 Here's my issue: I've got a database on SQL...

Hi all, I've got an old computer that's only running MS Access and SQL Server. The purpose of this old computer is so that all the other workstations here at work would use Remote Desktop Connection to connect and run the MS Access application. Whether that's the most ideal situation or not...

Hi all, I have my active directory setup in our windows 2000 domain. Now, with visitors coming into our plant, I need to create either a single user or a user group (doesn't really matter) that has very restricted access. I only want them to run a specific application and restrict everything...

Sometimes I really don't understand Microsoft and it pisses me off. I want to do something "supposedly" very simple, but for some reason it isn't letting me. Like the title suggests, I am running a 2000 domain (wweld.com) at work... there's always been 1 computer that has been outside the...

Hi all, There's an old/slow Win2k machine (SERVER1) running as the ONLY Domain Controller in our Windows 2000 Domain. I've recently setup another newer/faster computer (SERVER2) as the second domain controller. Currently, SERVER1 handles DNS, DHCP and has all the FSMO roles.... but I want to...

As the title suggests, I'm looking to add a win2k3 sp1 backup domain control into a win2k domain. Now, I've searched high and low on how to do this... but because everyone's situation is a bit different, I want to make sure that I'm doing the right thing We have a small network here... with...

As the title suggested. hopefully, I asked this question in the right forum I have a network setup at work... it's got only 1 domain controller responsible for Active Directory, DNS, DHCP, etc... The gateway at my work is 192.168.16.254 ... i try to access it from firefox, but nobody...

Hi, Newbie to the world of UPS.... Never needed it before because 1) couldn't afford it 2) didn't need it for my home use But now, because of my work, I need to look for a suitable UPS to purchase. So, here's my requirements that I assume certain UPS can do, so any recommendations/suggestions...