Recent content by jayme27

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