Recent content by mpnorris

I have two questions. I haven't decided which way to go yet. First, in the DSum expression can you limit the lookup to another value. For example by Region_ID. Currently the way you have it looking up is just by the date. I need date and region. Can this be done with the DSum Function...

I am a little confused. Are you bypassing the query that I created and putting the query into the control source of the text box? Can you explain the expression in a little more detail. Do I put the code exactly as you have it with the new names? More specifically the "" marks?

I have a list box on my form which brings back the results of a query. The list box will only show one number. Is there a way to automatically highlight that number so that it does not have to be clicked on? I am then using that data in another calculation. The only reason I am doing a list...

I am not familiar with the DLookUP() function. I have a form where I am entering information on a daily basis. One of the fields is the # of applications. I also need to calculate the month to date for the # of applications. I have created a query to search the Application table and...

I have figured out the query to get the data that I need. I now have the problem of taking the results from the query and displaying one of the fields in a text box on my form. I need to call the query to run after a certain field on my form is updated. I am not sure how to do that. For...

I have a problem and I hope someonecan help me out. I am trying to calculate Month to Date information in my database. I have created a table that collects application information on a daily basis. I want to be able to calculate the # of applications Month-to-Date. I am not sure how to write...

Thanks for the response. I tried that and it didn't work. Any other suggestions would be appreciated.

I have setup a project plan using Microsoft Project. For some reason when I click any of the views it defaults back to January 1986. My tasks do not start until August 2004. Does anyone know of how to change the default view so that it starts with the first task? Any help would be greatly...

Thanks dzum. That worked. Now I can get something accomplished.

How do you create a file picklist prompt? As I said I am new to Impromtu? I have created the .TXT file with the account #s. Just not sure how to create the prompt to ask for that file. Do you have to put it in a special directory? Any help would be greatly appreciated.

I am a new user to Impromptu and I have a question that I am hoping I can get help with. I need to perform a simple query where I want to retrieve data for a list of account numbers. I don't know how to search one field "Acct Num" for a list of numbers that are in a string format. I don't...

I did not have them check the time zones specifically. I will do that and see if it is OK. Thanks for the response.

I have a problem that hopefully someone can shed some light on. I have a database where the users are entering transactional data. The data entry form has the date automatically populate when the form is opened. When a user enters a transaction and hits the "Add Record" button the date is...

Do you know if closing a form automatically moves the user to the next record? That is the scenerio I am thinking about. Perhaps I can use code on the form close action to prevent the saving of the changes. Also, how would I use an unbound form to make changes. Currently the flow of the...

I have created a form that I want to edit current information. I would like to edit the information and hit a "Save" button before anything is committed to the database. The problem is that as long as the fields are bound, the second you make a change to any of the fields, the...