Recent content by AidanEnos

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...

I haven't tried anything yet so far... I was hoping for a quick simple start then I can modify... I used to be good at this but haven't done a script in 5 years, so starting from scratch is gonna be quite rusty.

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...

yes - it won't let you choose that input mask if you don't have the field type set for date/time

I added the hashes and now it says it has an invalid date format and won't let me save it. Thanks :) P.S. if this is any help I have the date format in the sourcetable is 99/99/0000;0;_

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...

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...

Yes, dynamic that I want the user to select from a list in a table. I don't want to have to statically change the query list each time a new CustomerIdentifier is added - I want that added to the list based on the table.

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...

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)...

My Current Macro Syntax is as below [CustomerName], =DLookUp("CustomerName","CustomersTable","CustomerIdentifier '=" & [cboList] & "'") I have continued to work on this fruitlessly - but, I have encountered an encouraging error :) I select a name from the list and I get: "Syntax Error...

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...

What is your table structure for your two tables? Maybe I'm thinking you want too much into this question - but I don't understand what you are lookign for with it. My table structure is very basic, I have a single primary key and most fields are either Number or Text. A fairly simple design...

Everything I do starts as straight forward and ends up in a twisted way.... Based on your advice I changed what I was designing entirely... I thouhgt I had made that clear.... My new form now looks like... top half of page is Customer info in a seperate table called CustomersTable. This...

YAY - progress!!!! Private Sub RefreshCustomer_Click() If Me.cbolist = "NONE" Then DoCmd.OpenForm "CustomerIdentifierInputForm", , , , acFormAdd Else DoCmd.OpenForm "CustomerIdentifierInputForm", , , "CustomerIdentifier = " & Me.cbolist, acFormEdit End If End...