Search results for query: *

#!/bin/bash/perl -w # This is a rename and move script. The goal is to rename files then move them to their # appropriate folders, and then e-mail (hopefully) the files to pre-defined people. use warnings; use strict; use diagnostics; use Time::Local; use File::Copy; my $date = `date`; # Load...

Below is the error I get when I try to run a script I am slowly building. I am in the learning process with Perl and this is my 3 script that I have written. The first two were very simple and short. My goal with this script when I finish is to have a CRON job scan a predefined directory and...

I am doing a search for the high and low of a series of records, from there I will get the standard deviation and then compare a new read against that to see if it is within the realm of reasonable. If it isn't then I can research the problem and correct it before I update any tables. Here is...

I have a text box set up to receive errors found in a variety of records. Okay what does that mean? Simple, I have a set of pre-defined records that I read in every month from a handheld meter reader. During the import phase I run a series of checks against the data and anything that falls...

Hello, I am now working for UCSC! Yes! Anyhow I have an old energy management database called Faser that I need to interface with. What I am doing is linking Access to the Faser tables via ODBC. No problems there. The problem comes from when I am trying to add a record or update records in some...

Not sure where to put this but I have a simple application and all I want to have showing is the form I created. I was wondering if it is possible to "hide" or minimize the main Access application? If so how would I go about doing this? I am using Access 2003 Thanks One by one the penguins...

Below is the code I have at the moment (still in the creating phase...) anyhow what I would like to do is set the code to format the e-mail for me. What I mean is simple. Below this code chunk is test output from the code below as it is formatted and sent. Below that is what I would like it to...

I am trying to figure out how to open TextPad (PATH=C:\Program Files\TextPad 4\TextPad.exe) then take a txtField with modified data and export that to TextPad. So the scenario is this, I have a table that has 8 fields in it. The front form driving the table is set up to allow only a user...

I am trying use a query to build a report. The data comes from two different tables that are joined in the relationship window. Table Definitions: -- tblTempAddSch |-- ID - AutoNumber |-- distName – Text = 28 |-- county – Text = 2 |-- distNum –...

I try to run the debugger so I can step through the code and see where something is bombing out. And I get this error message when it tries to move to a new record: "Microsoft Office Access" "You can't use the GoToRecord action or method on an object in design view." How the heck am I supposed...

I have a simple query set up to pull data from a memo field in one table and append it to a memo field in another table based on a pre-defined set of criteria. The query is used to populate a field on a form, from there when a user selects an item it will then populate the memo field on the...

Working environment: System WinXP Pro 5.1.2600 Service Pack 1 Build 2600 Access 2002 (10.6501.6714) SP3 Oracle 9i I am getting a Data Mismatch error and I have identified where. But searching these forums as well as the MS Access help files has not rendered the answer yet. Below is the SQL I...

Hello all! I have an Access DB that is using several Oracle tables to query against for some in-house reports. The table that I am using as a criteria selector has 3 non-changeable (data content cannot be modified by the user) drop menus that are used to allow the user the ability to select 3...

SELECT CMPS_CDS_SITE_CALL_LOG.TRACKER, CMPS_CDS_SITE_CALL_LOG.CALLDESC, CMPS_CDS_SITE_CALL_LOG.RECVDDATE, CMPS_CPM_ENROLLMENT_SITE.SITE_NAME, CMPS_CPM_ENROLLMENT_SITE.SITE_NBR, CMPS_CDS_SITE_CALL_JOURNAL.ENTRYTEXT, CMPS_CDS_SITE_CALL_LOG.CALLSTATUS...

I don't understand what is going on or why the code is not working. I have tried it two ways that I can think of but the SetFocus command is not working at all. The other portions of the case statement are functioning perfectly it's just the SetFocus command that is not working! I am on XP Pro...

Okay, I can change a Forms Record source till I am blue in the face, simple, easy CAKE WALK!!!! But I cannot for the life of me seem to get a SUB Form Record Source to change... Set up (Key components) Form1 = frmContractInfo - Master Form with all controls Form2 = SUB_frmMasterDistrict - SUB...

Hey all, been a while since I have been here. Anyhow, I have a main form that can be fed from one of two data sources. Within that form are three subform, each of which also have two possible datasources. I am trying to get the main form AND the sub forms to open and based on a value passed...

I have a table set up that will accept new records but once the record is added I can't update certain fields. I have tried through a query, and through directly accessing the table. And the new values will not stay. I get no error message, I get no wierd happenings. I thought it might be...

But the samples I found are for looping through record sets. I have a timer event set for 5 minutes. Every 5 minutes the form is closed then re-opened. Right now it seems to be the only method I have to refresh the data within it. And it works for now, I will make it right in later versions...

Okay here is the deal. I have 2 forms that I am using as a generic Audit trail. The primary form frmAuditTrail has a chkBox that when selected will pre-populate a field as well as open another form for more input frmMissingReports, which is used to allow the user the option to select from a...