Search results

Works perfect. Thanks!

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

Thanks everyone for all your help. It turns out, after investigating further, that for some reason my link between the main form and the subform was cancelled or corrupted. So, even though the subform would open, it was opening to a blank record. Now that that is fixed, I am able to...

Thanks Gemma. Yes, I want to limit the items per the main record to 5. I'm sorry, I can't quite figure out how allowadditions = dcount("*"",recordsource)<5 fits it with my current code.

The code was placed in the subform.

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

The code currently in the Onclick event is =CalendarFor([Effective End Date],"Select the Ending Date") The rest of the code for opening the calendar is: Option Compare Database Option Explicit 'Calendar form variable: Public gtxtCalTarget As TextBox 'Text box to return the date from the...

RG: Sorry to be so dense, but I'm still not sure what code I should be writing. The cmdenddate button triggers the calendar form to open, the cmdok button on the calendar form closes the calendar. If I put the code behind the cmdenddate button, my choices seem to be only OnEnter, OnExit...

I use a command button to trigger the Pop Up calendar. A command button on the calender is used to close it. I'm not sure what you mean by "If so then Pop Up the Calendar modal and save the Audit detail when the code gets back." Should I be doing an Onclose event on the calendar form?

RuralGuy: cmdEndDate was actually the command button that triggered the pop-up calendar, which I finally figured out was wrong to have in my audit code, so it's been removed. The code for the audit table is something I picked up from the internet at...

Gemma: I did finally find something on the internet that indicated that changing data by using VB or a macro won't trigger the BeforeUpdate/AfterUpdate events. I've been trying tirelessly today to figure out what code might need to be added to make this work. I was using the AfterUpdate event...

Craig: Below is a sample of the code I'm using. I don't know a lot about developing code, so I generally find what I can on the internet, which is where I found this. What happens is a temp database is created every time a form is opened, and the changes are saved to the temp table. Once the...

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

That's cool. I never knew you could bring in the field list names that way. Now I guess I'm going to have to change the field names in my query to something user friendly. I've previously tried to design a dynamic report, based upon various code I've found on the internet, to no avail, but...

Paul: I already have a report created that includes all the possible fields that could be selected. Would it be possible to write the code so that any fields not selected would be "invisible." My immediate problem is how do I get the column names in the list box? Would I just use a value...

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