Recent content by ad2

Thanks in advance: I have a series of SAS programs and data txt files in a series of folders. I want to write a main SAS program that has include statements to run each individual SAS program from its folder location. So here is the set-up of one folder: Folder labs: Labs.sas Labs.txt Here is...

Hi Klaz, Thanks, I will try this. Ad2

Hi, I have a field in an database table that is a text field Values are date ranges separated by a comma, here is an example: 9/10/06-9/12/06, 9/18/06-9/19/06, 9/26/06-9/29/06, 11/9/06-12/6/06 How do I use SAS to pull in the values and calculate the total number of days? That is the sum of...

Hi dhookom, No, the entire pane is invisible, and I've done what you suggested and imported all objects into a new database, so I do have a solution to the problem. I'm just puzzeled as to what may have happened. I've been using Access for over 9 years and this is a new one one me. Thanks...

Hi, I have an Access 2003 database that suddenly the database objects - Tables, Queries, Forms, Reports - are no longer viewable in the left-hand Objects pane. The data entry forms are there in user mode, but even after holding down the shift key when opening the database, and selecting View >...

Too many forms, query give false results. But I'll work on it

Hi, I have an application that has several forms. At the end of the day the manager wants to run a report of all the records entered that day from all froms. I have a field on each table, RecordDate, that captures the date the record was created. I was thinking of creating a temp table, and...

Thanks, works great now

I have an order form on which I want to auto fill the customerID, address, and phone by pulling that data from the customer table. The customerID type is text (value is AlphaNumeric). Type is the text in both the Customer table and Orders table I have a combo box on the order form for the...

THANKS fneily, your Dlookup is just what I needed, works great. And thanks also to Golom for the input. You both rock!

Hi, I have a data entry form for quarterly test results. There are 8 variables. If variable TH2 was ever positive on a previous test, even if it is negitive on the current test, the patient must have an additional set of tests done. So what I need to code somehow, when patient X has a new...

Thanks Bubba100 for the great code and to PHV for the tip on implementation. Works great!

Hi Bubba100, I created the new module. I put this on the onOpen event: =CloseButtonState() but it didn't work, the title bar with the close button is still active.

Hi, I have an Access 2003 application. The manager wants the default Close(x) and min and max buttons disabled or not displayed, so that the data entry persons will be forced to close the application via a button. Well, I've unchecked the boxes under Tools and Startup, and set the Form...

Create a Macro Under Action > Choose SendObject In the Action Arguments: Object Type > Report Object Name > your report Output Format > choose a format the people you are sending to can open and view, such as Excel. Then fill out the To, Cc with the email address of those you are sending...