Search results

Mike, Let's see what you have. Thank you.

I wish to click a macro on a form that will automatically e-mail the report(s) to those people specific to that report. For example, each report must be sent to three people: rated person, rater, and senior rater. Each person may have different raters & senior raters which make it more...

Let's say my table has a primary key (yes it is text field called NAME, not a number field). Then what would I use instead of using the current record's ID in my code? Please be specific. Here is what I have so far to transfer record to different table before deleting it from main table...

Trying to control the choices displayed in my combo box within a form. Three separate tables linked at Many-to-Many relationship. Table 1: Field1: Categories (many of the same) Field2: Available Awards (many of the same) Table 2: Field1: Category (only one of each) Relationships: 1-to-many...

I would like to output/transfer MS Access data fields to corresponding data fields in Delrina FormFlow. Ideally the user inputs all or some data into an MS Access form. When the user wants, they push a button that will take certain data fields from that record and output them into FormFlow's...

I have someone elses table in MSACCESS that they want me to create a form for. The first column is a list of numbers inputted by the user that identify an ACTION. Call it Action# field. Problem is even though this action# is unique to each ACTION, the same action# can be in that column maybe...

More info. I can get the fields from the combo box into the table where they are stored, but I need the combo box in the form to only display the appropriate list of choices for that record. In other words, sometimes not all people stored in the database will show every choice listed in the...

I want to create a combo box within my form that is record specific. In other words, not everyone has the same list of choices to choose from in the combo box. It is based on each person's category. The combo box draws its data from the [Categories] table which is linked to the [Main...

Familiar with FORM FLOW? It is an application of all military DA Forms allowing you to choose a form, type your data into each field within the form, & save the data or print it thereafter. I know it is possible, but how do I go about writing program that takes the data fields (MSACCESS) and...

Issue still unresolved. I have a date field called [calldate]. I need a pie chart that shows % of null entries compared to % of entries not null. In other words, comparing blank to none blank entries in the [calldate] field. I think because the datatype is a date and not a number data type...

Ok, easy question for you since I've tried about 5 different times/ways of doing this, but it doesn't display the way I want. I need a % pie chart that displays % [ATFP completed] versus [ATFP not completed] out of [total persons]. [ATFP] field is a list of dates or is null; however, I made a...

I created a database that keeps track of personnel information; however, I need to save complete record information of those personnel once they leave the organization too. Such historical info regarding these people and their information should be referenced through a form but not confused...

When you create any report, it prompts you to use the fields stored in a Table/Query. What if you created fields you want to use in your Forms? For example, in one of my Forms, I created a field that keeps a running date and one that uses an equation to tabulate another field. If I cannot store...

When you create any report, it prompts you to use the fields stored in a Table/Query. What if you created fields you want to use in your Forms? For example, in one of my Forms, I created a field that keeps a running date and one that uses an equation to tabulate another field. If I cannot store...