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

    Creating a macro that FTP's a directory when created

    Ok, I have a server that sits on an autonomous network. When an error creates a log file and a new directory, I'd like a program to take several steps... 1. I'd like to take that directory and zip it to a self-extracting executable with the same name as the directory that was created, with...
  2. AidanEnos

    Need a simple easy script to do an SNMP check on a list

    Ok... logically this is what I want. I want to run a script called "SNMPCHECK_Customer_A" The script will ask for source file of the site list "site_list.txt" Then it will ask for Community string "public123" The script will ping the first entry in the list, if it responds then it will do the...
  3. AidanEnos

    My Query works but returns NOTHING please help

    All this is supposed to do is look at the HS_OrderTable and prompt for date range Between, that works fine. It's going to run from a switchboard command button "Report on users for date range" that opens OrderedUsersSummaryReport whose recordsource is this Query OrderedUsersSummaryQuery. Seems...
  4. AidanEnos

    I have a report that fits on 1/3 page landscape...

    What I am trying to accomplish long winded is this... Main Switchboard Command button On Click Opens Unbound form "CustomerIDSelect" CustomerIDSelect After Upate Opens Query "EndUserInformationQuery" This Query has all of the fields in the EndUserInformationTable - they are to be...
  5. AidanEnos

    Why can't anything I want be easy (query criteria question)

    Ok, I have a report, EndUserReport - recordsource is EndUserQuery If I make the criteria [Enter CustomerIdentifier] then a data entry box will appear so the user can enter the CustomerIdentifier and that will satisfy the query and run the report. Instead of Typing the CustomerIdentifier, I'd...
  6. AidanEnos

    Checkbox quick and easy question

    ok, I have a Customer info form has Customer, Street Address, City, etc. also has Billing Street Address, Billing City, etc.. I have a check box that says "Customer Bill to" same as shipping? with the check... I want to make the code... IF CheckBox is check (not sure of how to syntax this)...
  7. AidanEnos

    DLookUp function in a macro

    Ok, This should work but doesn't and driving me nuts - not even sure where it's failing!!! As I understand it, this code says... I want the CustomerName field from the CustomersTable input to the CustomerName field on the active form and I want the CustomerName from the Entry in the...
  8. AidanEnos

    =If(I knew it exactly"I wouldn't ask", so here is it)

    ok... I am trying something new for me here... I have a drop down list box that is populated by a column in a table - customeridentifier. (I am using customer identifier so we can make names that include abbreviated addresses "ABC_NYC") So here is my literal if statement - some cleaning up so...
  9. AidanEnos

    Open from(s) to current record

    I have 1 table I have 3 forms that update that table The forms are set to data entry (is there a better way to force a new record when the first form is open? - going to try making the other forms sub-forms while I wait ;o) I want to Open form 1 input my data, click a command button that Opens...
  10. AidanEnos

    Every Report I make puts a blank page

    At then end, so when it's designed as a 2 page report - margins all set WELL within guidelines - so much so that I have 1" to spare with the margins moving the Report around on screen horizontally - and 1" extra before the footer vertically. Regardless of my efforts, the report comes out with a...
  11. AidanEnos

    3 forms, 1 table - I want a simple print

    Ok, I have 1 large table... far too many fields to fit on a single page... so I made 3 pages. Each of the forms prints on it's own page call them A, B and C I want my main database page to have a button, that when clicked runs a query [Enter record number], that in turn opens each of the 3...
  12. AidanEnos

    When I try and print my form it has a hidden page break

    Ok, I have a form that has a lot of text boxes for data entry (about 30 or more all with labels) and a memo box 5"x3 1/2") When I print the form it breaks it into 2 pages. There is no obvious page break (I made the form 7"x10" to accomodate single page printing), I've reduced the margins and...
  13. AidanEnos

    Adding a few text boxes together

    Ok - It's been a while and I'm missing something silly - I know it. So, I'm on record 4 in my Customer Order form, there are 5 fields in a row and I want to have the user input the values and total in a text box underneath. Simple? I've tried to set the control source to =Sum([a]+[b]) and it...
  14. AidanEnos

    acer AL2223W monitor driver

    Ever since I got this screen sometimes when exiting full screen mode from an application the desktop is black and I need to do a hard reboot to reset the display. I tried installing the software that came with the monitor, I checked acer.com for the .ini file and nothing. When I check the...
  15. AidanEnos

    My screen keeps 'flashing'

    it looks like there is a background program trying to run - a blank window pops up in the taskbar and the whole screen goes blank then flashes back to what I was doing. If I am using a program that assigns it's own screen size and resolution (i.e. doesn't run in a typical minimizable window)...
  16. AidanEnos

    Old Access95 database won't let me open it

    I created a database many years ago in Access 95, now when I trya nd open it I get a message telling me I don't have permissions and to contact adminstrator. I am the administraor!!! When I go to security, it tells me that Admin is trying to log in and even though I have the password for Admin...
  17. AidanEnos

    Giga-byte GA-5AX F3 boot problem

    Hello, I have a machine here, it's equipped as follows: GA-5AX F3 AMD-K6(tm)-2/500 cpu 524288K ram (one chip in slot 0) BIOS v4.51PG 11/16/1999-ALADDIN5-2A5KKG09C-00 I just put the new ram in it, and a new HDD (old one was dead) - When I boot the computer now it checks the ram - then does...
  18. AidanEnos

    Burned CD that shows no space and no data

    I burned a CD as a backup and left it in "CD-R Only" when my comp was running Win98 (SR1), the disc showed files and I tested them when I did it, but now that I have upgraded to XP Pro, when I put in the disc it shows 0 bytes used, 0 available, data format RAW and NO FILES. Any ideas...
  19. AidanEnos

    Simple mailto: question from within excel

    Okay, I have a worksheet, it is all protected except the user input fields, and I want 2 things to accomplish from here... 1. When someone fills out the form, I want to have Name and Phone Number fields that are requred to be filled before saving. 2. When the user is done, I want to file to...
  20. AidanEnos

    I have a 60GB HD and only formatted to 14GB

    I formatted the drive when I had Win98 installed, now that I have upgraded to XP Pro I want to try and format the rest of my HDD into another drive (say drive P). I assume there is a painless way to do this in XP and am looking for the procedure to format ONLY THE UNALLOCATED SPACE NOT THE...

Part and Inventory Search

Back
Top