Search results

I have an employees table, and a months lookup table. I am attempting to create a query to run a report according to the month selected. I have set up a parameter box in the critera of the query. It is prompting me for the month I would like, however, it is still returning all records. This is...

I have a db almost done and would like to add an archive table. At the end of the year I need to archive a total field and an ID field. How can I set it up that on December 31 @ approx 11:59 the record values are sent to the "Archive" table? I have the logic of what I need to do, but I'm unsure...

I have a master table that is populated through a form. I have created a subform that is contained in this particular form. When I view the master table I would like to have the box with a + sign available. I would like to be able to implement the drop down row to show the values in my subform...

In a project that already holds 14 letters and 4 reports my partner and I have decided to add a report template should any more be needed later. (Ever heard that before?:) ) The titles are all different. The detail section has 3 repeating fields, however two reports have unique fields as well...

I have a table that I needed to make changes in. I added 3 fields and had to change 4 fields to list boxes. What is the best way to handle the control source on my forms since the table changes have been made. I also changed the field size for a field. These things were requested after the table...

I am building a db for a small fire department. On the "participation" table there are fields for the year, rescues, fires, total calls, and a few more for trainings and meetings. The idea that I need to meet is a list box with all years that the employee has been there and the amount of calls...

I am building a database for a local fire department. I have created the Employees form. The disk that was sent to me of the attempted database by an employee at the fire department hold photographs of all of the employees. I want to extract the OLE object to put into this form. These are part...

I have a form with properties set. The MinMax buttons and the Close button are left visible at this time. I have a Close command button on the form. The buttons in the top right corner are not showing. Does the command button have anything to do with this? There are over 25 fields on the form...

I am searching for syntax to implement the Proper function for names and words that have more than one capital letter. For instance McDonald, or Some City. I have looked in the help files and it only offers a basic syntax. If anyone can help it would be greatly appreciated. Thanks.

I have a master table named Employees. I have a table for Employee Family Information. I want the autonumber for EmpID to auto fill the value of the EmpID field in the Employee Family Information form? When I wrote the Select Query it shows only AutoNumber. (As a list box) I would like for the...

The project that I am working on includes an IntentGrad table and a StudentGrad table. The Intent table holds info for those "intending" to graduate, while the other holds info for those who WILL graduate. The student information on the Intent form is prefilled from the student table. I need...