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 the dialog box form, that prompt the user for the query's criteria for Fiscal Year and Month, I was able to make the fiscal year field manditory entry and any entry in the Month field not matching what the user put in the prompt defaulted to a Month = 0 which I used in the query criteria...

The Nz function failed to show me all the records like before. Someone had mentioned the best approach might be to create a recordset and check for EOF. How do you do this? My situation is as follows: Dialog box used as prompt for criteria query...asks user for two things: Example FY: 00...

I tried the Is Null in the criteria for the SupplyMonth and POLMonth so that when the user types: 6 in the dialog box form to see all records for the month of June. Again, if Supply had no entries(costs) for that month, but POL did have entries for that month, the whole record did not show in...

If it matters, the Supply and POL month and cost come from another table/query. The main query pulls this data in order to SUM TOTALS for these Costs. SumSupply and SumPOL. Cannot have a sum if I don't have a matching month in the column. What is the best approach to take for accomplishing...

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

SUCCESS!!! For a simple person like myself here is the steps: 1. In the Data field on the Form, go to the event procedure properties. Do NOT type in [Nameofdatafield] = Now(). You must click on the 3 dots next to the BEFOREUPDATE Property of the FORM (Not the data field}. CLICK CODE and...

I'm sorry, but Alan S's solution does not work and I've even tried different variations. Here's the breakdown: a. Name: DateOfEntry b. Control Source: DateOfEntry c. Format is in date format d. BeforeUpdate: [DateOfEntry]=Now() Tried the following action: 1. Changed an entry to the...

No spaces between characters. Any ideas?

I entered that exactly as you specify on the screen into the Before Update, then I tried it in the After Update, then I tried it in the Change and still nothing happened when the record was updated, changed or added. Nothing displays, just a blank field. Why isn't it working?

In reference to Topic in ACCESS World Forums. Putting the following code into the BEFOREUPDATE event procedure for the form did not produce any results when the record was updated. It stayed blank. I tried combinations of the following code which didn't do anything. DateOfEntry=Now() or...

Putting =Now() into the Default of the data field will not be a running date that changes daily? If it displays the current date that the change was made to the given row then stops, it will be what I am looking for. Otherwise, the whole column will always read todays date which is not...

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

Thanks Andy. I could successfully follow the way you describe. Plus it was the easiest to understand.

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