Search results

Hi! Thanks for your responses. Fornation: that is one possibility but when I was messing around last night I came up with the following: =Trim(IIf(IsNull([Department]),[Institution],([Department] & IIf(IsNull([Institution]),"",", " & [Institution])))) This seems to do the trick so that if...

Thanks for the info. I am already working on something like that so hopefully it will work.

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

Found an answer in another forum. All I had to do is add an If IsNull statement. I'll leave this post here in case others need help with this problem. Private Sub FindRecord_AfterUpdate() If IsNull(Me.ActiveControl) Then Exit Sub ' Exit code if Null ' Find the record that matches the...

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

Thanks for the link.

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 had an issue similar to yours come up while dealing with an unrelated problem. I too have notice that the field will be highlighted (typically because it is first in the tab order). Instead of changing the tab order, I fixed the problem (and my original problem) by going to Options in the...

Thanks!

Thanks!

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

Thanks. I'll give that a try.

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

Thanks Abby N. I'll give that a try. =+}

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