Search results

Is there a method for bounding a combo box to a list of reports, so the user can choose what report to open? I thought maybe a DOD comand within the underlying table within alookup field. Hummmm. Is it possible?

Can anyone send me a copy of a simple database showing how to maximize a form or forms as soon as they open. Using my switchboard menu, I would like to have it and all other forms maximize automatically regardless if I return to a previous screen(form). Someone said to use the =DoCmd.Maximize...

Goal: To click on a drop-down combo box and see only those relevant CLINS belonging to their respective PURCHASEORDER. Purchaseorder table has a one-to-many rel w/ CLINS in the CLIN table. Up to this point I've already input the CLINS and matched them with their respective Purchaseorders. I...

Using a query that pulls data from multiple sources (tables and other queries), if just one of the columns is null that entire row does not show in the query. How can I have the value "0" display in that field in order for the record to fully display? Example of columns in the query...

I have a field within a row on the form. Call this field [Date of Entry] This date should not be a running (dynamic) date, rather a static date that shows the last time that particular row was updated/changed/etc by a user. Is this possible without the user being able to manipulate the field...

I have many forms in my database, but I don't want the user to have more than the current one open as they navigate through the menus. Example: The user leaves frmMain (by clicking any one of several macros on that form which take the user elsewhere to another form). When the new form opens...

Remaining Funds = Original Fund Amount - Fund Amount Used Simple equation that is the foundation for the one below. The equation works in my form, but not when one subtotal is Null (no entry due to no cost spenditure). The equation must be able to still calculate the Remaining Funds although...

One query is the info source for a report. Each record is unique (fields in the report change per person). a possible of 4 fields for each record contain stored e-mail addresses. I need a macro that sends the unique report to those 4 people in the fields and skips over the fields that are...

I need a form with 4 different macros that will send one of 4 reports based on the person's Type. The TYPES are Base 1-5, Base 6-8, Senior 9-12, and Senior 13-15. If rated person in Onetable has [category]=DAC and [ratingscheme]=Yes then Match rated, rater, intermediate rater, and senior rater...

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

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