Search results for query: *

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

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

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

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

I have a new database that I could use some guidence in how to create to forms. This database is to house a list of projects that my department is working on. I have created the following tables: Project_Name (Project_Name_ID, Project_Name)-lookup table Team_Leader (Team_Leader_ID...

I have an issue that I am hoping to resolve. I have a database with an entry form. When I open the form, certain data is prepoulated. I have three command buttons, "Add REcord", "Close Form" and "Close App". If any of the fields are populated and I hit...

I hope someone can help me. I have my main data entry form. IT has a bunch of text and dropdown boxes. At the bottom are four command buttons. One of them is add record. When I set up the tab control, indicating which fields should come after the other when you hit the tab key. The problem...

I am having a problem that I hope someone can help me with. I have a database which am still developing and testing. I have set it up as a replicable database. I just found out that my users have Access 97 and I developed in Access 2000. I need to convert my database to Access 97 and when I...

I have a problem where I changed the menu options while setting the "Startup" options under the "Tools" menu. I no longer have the "Tools" option and all of the suggestions in Help? send me to Tools - Startup. Does anyone have any ideas about getting around this...

I am wondering if anyone has ever run into this problem: I just created a replica and a Design Master copy. I have a form that I enter information into and it has an "Add Record" button and a "Close Form" button. Before I made the replica, if I went into the form and hit...

Here is my situation: I have a form which gives the users the ability to enter data. That is all I want them to be able to do. I have a "Add Record" button that will commit the data to the table. The problem I have is that when you run the form, on the bottom of the form, you get...

Here is my situation. I have a series of IF statements. I want to be able to put in code to stop the program from continuing if one of these conditions are met. IF none of the conditions are met the ELSE statement should run. I have the code working except for the Else statement also runs...

I hope someone can help me out. I have a form that enables and disables text boxes based on what is chosen from a dropdown box. How can I change whether a field on the table is required or not based on what is chosen on the form? I tried setting the field to required. When I chose...

I have created a form where I choose a name from a dropdown list. The information on that person is transfered over to the next form when I hit the "Continue" Button. I can see the data on the next screen, but I want to click another button and have the information brought from the...

I have a field where I need to accept letters and numbers. I setup the datafield as text. Is there a way that I can evaluate what was entered in the field as to whether it is letters or numbers? The scenrio is if letters are entered I want to trigger one thing, but if the numbers that are...

I have a form that I would like to limit the number of characters that are allowed to be entered into a text box, based on what is chosen in a dropdown box. Ex. Depending on the type of product chosen from the dropdown, I want to limit a text box to receive only 10 characters or 14. I have...

I am new to using Access with a little VB experience. I have created a form where I am choosing a user from a combobox. The combobox is being populated by a query. After choosing a user name I am trying to carry over two of the data fields (User ID and Department) that appear in the combobox...