Search results

I am NOT using a Report inside a form. It just looks like that! It is a subform. I don't have issues with referring to a subform but this is out of my expertise. I did resolve my code issue but still no explanation about this. Thanks,

I am having difficulty referring to a couple of subforms. They are both have Other name and All name Code winds up looking like this: If [Forms]![frmEmployees]![ ].[Form]![txtVacHrTotal] > 364 And [Forms]![frmEmployees]![ ].[Form]![txtVacHrTotal] < 730 Then [Forms]![frmEmployees]![...

Philosophical Discussions rarely bring about any true merit since not everyone has an open mind and heart. Fruition is possible, however unlikely. Kind of a spin-off of "Are You an Atheist" Answer: Yes I am a spiritual/religious person. Why? Opens up another can of worms!

I use Access 2010. So this is in Access 2000 mdb format. HTH

I don't know you table or query structure. Example: If you had a form for Jobs and the query for that form had jobdte as a date field in it. Then you could use something like this: Between [Forms]![frmJobs]![StartDate] And [Forms]![frmJobs]![EndDate] Or use a popup form as previously...

Between [Forms]![frmSomeForm]![BegDate] And [Forms]![frmSomeForm]![EndDate] in your query grid. Base your Report on this query. Don't know what other criteria or fields you may have that would need to be addressed! HTH

Have you told that someone(s) that you Love them today? Tomorrow may be too late. :)

Different ways of doing this as has been said and advised. Also as asked, do you have set rules for the syntax? Example: ControlSource=[InvNo] & "-" & [ReferenceID] & "000" Personally I use a Module with a table for my unique generated numbers. HTH

I generally use a Main form for this with date fields that can be edited. Then refer to those fields in your query. Or you could use a popup form and do the same thing. You can format the date fields as needed. HTH

Additionally there are samples in the Sample Database Section.

:o True, but it sucks to get old. Plus with my condition it puts a whooping on my thinking. Poor,Pitiful Me ! Guess I will go off and cry in my Beer !

Was having a Code moment.

This syntax: Results in #Error VacDays: Nz((DateDiff("d",[VacationDteFrom],[VacationDteTo])))

No, the posted code above does not return anything! hence the post!

Here is my syntax,it works but when there is no difference, I need it to show 0 VacDays: (DateDiff("d",[VacationDteFrom],[VacationDteTo]))

No, that's it. Form is simple. No complex code.

Here is my code to try and accomplish it. Private Sub txtstatus_AfterUpdate() 'Filter Form by Status. On Error GoTo txtstatus_AfterUpdate_Error Me.Filter = cStatus = Me.txtstatus Me.FilterOn = True If [Forms]![frmChangeLogs]![Change Log subform].[Form]![txtstatus] = "Active"...

frmChangeLogs is Main Form,Unbound frmChangeLog subform is the subform where the filter needs to run.Bound to qryChangeLog which uses tblChangeLog (Continuous Form) cbofilter is a unbound Combobox Row Source is "Active";"Archived";"All" Row Source Type is Value List tblChangeLog cStatus...

This is a Basic Event Countdown Timer App. Written in Access 2010 32 bit mdb format. Enjoy,

Two women friends had gone out for a Girls Night Out, and had been decidedly over-enthusiastic on the cocktails. Incredibly drunk and walking home they suddenly realized they both needed to pee. They were very near a graveyard and one of them suggested they do their business behind a headstone...