Search results

My main form that has a combobox that searches for records. When I search for one and then leave the combobox, the title I was searching for still remains in the combobox. I would like it to remove the title OnExit but I am not sure what command to use. Why do I want to do this? When I go to do...

In my report footer, I have a field that totals all funding fields in the records on the report. How can I stop the Total from appearing on its own page? This happens when the last record comes close to the bottom of the page and the total gets pushed to the next page. It looks kind of funny...

Instead of having a subform on my main form (which I currently have and it works fine), I would like to use a command button on my main form to open up a form that does the same kind of job as the subform did (Have child records that link to the parent record). I tried to do this by linking the...

I have a subform that has two fields. Both of these fields are comboboxes and the form is plain (doesn't have rows and columns like excel) so if you want to see all of the records you have to use the record advance button on the bottom of the subform. I would like to have a field on the main...

I have a subform that has 1 field. I have found that, for example, I enter in 3 records and then decide I don't need the last record so I erase the data, when I leave the subform (or go back a record), the blank record is left(still shows 3 records). Is it possible to check if the field is blank...

I have a field that must have a response. When the field gains focus but nothing is selected from the combobox and someone tries to change to another field, a generic Access message box pops up and says that the field is required etc, etc. I don't like the message and would like to customize...

On some mailing labels, there is a need for a department name and the Institution name. I changed them slighly so that a comma would not show up if the institution was not entered. This was the expected problem. However, I have now come across a situation where there is an Institution name but...

I have a combo box which searches for the names of an associate (co-worker) and then pulls up the record. The info for the combobox comes from a query of the original associates table because I wanted to concatenate the names which are entered seperately in the table( in other words, there is a...

I have a combobox that gets its info from a query that is based on a table (I am using the query to ensure that the info in the combobox is in alphabetical order) When a user selects a name from the combobox list, the name is stored in the table. I need the combobox to be able to accept having...

I am interested in having Access do a query of two fields in a particular table on start up. One of the fields is Application Date and the other is Status of Application (this has four possible selections from combo box - Funded, Not Funded, Pending and Unknown). I would like to have Access...

I have a form that requires financial information. If no funds have been administered ($0.00), I would like it to skip a bunch of fields and go onto another section. How can I do this? I tried the gotoControl command in the VBA window but I am not very good at this yet and I have failed...

I have a report where we want to see who our project leader have been working with. Presently the report appears like the following: Project Head ------------------Associates John Doe -----------------------Jane Doe -------------------------------Tim Doe -------------------------------Weedle...

I am using the GoToControl and FindRecord action. I suppose the idea is that I want Access to look at a particular field (Name) and search to match the selection from a combobox. The problem is that, as a combobox source, I am using a Query. This Query Takes the person's Last, First, and Middle...

Here's the situation: I have a database for company projects. There are 3 type of people that work on the project. Project Head, Employees associated with the project, and individuals from outside the company that help. We can call them ProjHead, OnsiteHelp, RemoteHelp. At any given time, there...

I have a combo box that allows the data entry operator to select an employee's name from the list on the main form. However, if the name is not on the list I would like them to enter in the new employee info. I could set it up to open up the employee form by pressing a button or something but...

I have one combo box which is being used to represent employees last, first, and middle names (to reduce data entry errors). When I set up the combo box, I designed it to show the last name, then the first name, and then the middle name. However, when the name is selected from the drop down...

For example: The form is for entering project info. The person who heads the project may collaborate with one person. This means I only need the collaborators field to accept one entry. However, if the project leader has 10 collaborators, the collaborators field needs to accept ten entries...