Search results

I have a dialog form with a date field, formatted as Short Date, that updates a listbox. I set it up so that when the form opens, the date field is populated with the current date, which can then be changed if needed by the user. The code is on the OnOpen Event and is: Me!startdate = Now()...

I want to limit the number of records in my subform to 5. I've tried different codes found on this forum: Form_Current If RecordsetClone.RecordCount >= 5 Then Me.AllowAdditions = False End If End Sub Or: Private sub Form_BeforeInsert (Cancel as...

I have been setting up an audit trail for my database, and I'm having a bit of a problem with dates. I have date fields where the date can either be entered manually or by a pop up calendar. If the date is entered manually, the change is added to my audit table. If the date is added via the...

I'm trying to create a report that takes an activity occuring over a specific period of time and show the individual months it applies to. For example, I have a person who has committed 50% of his time to a project with an effective start date of 1/1/07 and an effective end date of 12/31/07. I...

I have a report in which the rows are alternating shades of gray and white. I'm adding a subreport where the rows of data will line up with the rows of data in the main report. I've made the subreport fields transparent, but because I can't seem to remove the background color of the details...

I have a dialog form used to filter data to a report. I want to be able to use a list box to decide which field columns from a table or query I want on the report. I would guess it would work like the Access form wizard. The listbox choices would be a single column of the the actual field...