Search results

DJN, Thanks for the reply. I'm not sure I understand what the underscore preceding the asterisk is for. Like IIf(IsNull(Forms!FormName![ControlName]), _ "*",[Forms]![FormName]![ControlName]) When I pasted in your code exactly as is (replacing FormName and ControlName), I received an error...

I have a query that is the source behind a Search form (frmFindProject). The form contains 5 unbound combo boxes: cboContractNumber, cboCounty, cboRoute, cboEngineer, and cboImprovement Type. The idea is for the user to retrieve records from a project table based on what is entered in the...

Cannot figure out what's going on. Please help. I have 5 tables -- one on the many side of a 1 to many relationship and the other four on the 1 side. My form is based on the main table (many side). The form has 4 combo boxes, each related to a table on the 1 side. When I create a new record...

I knew it had to be a stupid error. Thank you both.

I have a form with 7 unbound combo boxes. Also on the form is a command button called Find Project. The user can use any, all, or none of the combos to find a project. The more that are used, the more the search is narrowed. The command button has code behind it like this: Dim stDocName As...

After rereading this thread, I believe I probably overreacted. I apologize for that and want to thank you for taking the time to spell out what I need to do. I will give it a shot and see what I come up with. Thanks again.

David R, Not sure what I did to warrant that response. I realize there are many articles on this topic in the forum; believe me, I think I've read most of them. However, I am fairly new to Access and very new to VB. I simply don't know or understand where to place the mentioned functions and...

Thanks for the reply, but please note that my original post stated that I had only read about the functions. I am looking for help on where to put them and how to call them.

The database on which I am working allows the user to search for a project using a simple form. The retrieved project is then displayed on a separate form along with a subform that displays any comment(s) associated with the project. The user will be able to enter a new comment via the...

I'm sure this can be done -- not sure how to go about it. It is similar to the form with 2 subforms example in the Solutions database, but a bit more involved. I need to create a form that retrieves a project(s) based on 6 or 7 search parameters. Each parameter is a combo box; one or more can...

I couldn't agree more with Amy35. I don't know which is worse, having an Access expert SOB to turn to (like Amy) or none at all (like myself). This forum has bailed me out numerous times.

If anyone has a database with an example of this, I would like to see it. Or is there an example in the Northwind or Solutions databases?

I have a form call frmPermit. The record source is tblPermit. On the form is a drop-down list for Company. When a company is selected it blows in the Company Name, Address, City, State, and Zip, all information stored in tblCompany. If the user need to enter a new company, not currently stored...

In the Before Update event of my form, I have placed code that asks the user if they are sure they want to save their changes. I have recently added a subform. Now when the user tries to tab from the form to the subform, the message box appears. I am not sure how to get around this. I would like...

I have a form that is used to enter contract information. One of the fields is Employee ID -- the employee who worked on the contract. It is joined to the Employee ID column of the Employee table. Simple enough. However, sometimes 2 or more employees work on a contract, so I need multiple...

I need to run a report by employee. I have created a form that contains an unbound combo box (cboSelectEmployee) that lists all employees from the employee table. In the report query, I have entered [Forms]![frmSelectEmployee]![cboSelectEmployee] in the criteria field of Employee ID. The report...

On my form, I have a check box called Destroyed and 4 text boxes called Storage Area 1, Storage Area 2, Storage Area 3, and Storage Area 4. If the user selects the Destroyed text box, the data in the Storage Area(s) should be cleared. What event and what code would I use to trigger this? Thanks.

I am looking for a very simple method to prompt a user for a date or range of dates when creating a report. If anyone has examples that I could look at, I would be very grateful. Thanks in advance.

Yes cpod, all of the misc. items have a similar ID, so I will give that a shot. Thanks a lot.

I am attempting to convert an inventory database to Access. Most inventory items have a unique ID. However, there are various misc. items that do not. For example, there may be 60 carpenter levels each assigned the ID m00012. My problem is that the user wants an error message when he...