Recent content by Chanda

Everyone, This isn't strictly a Access question, but...this group has proven to be very knowledgeable! Does anyone know how to open/view/print a Access report from a Visual Basic 6.0 program? I think its something like this: Dim appAccess As Application Dim msReport As String msReport =...

Try putting this code in Before Update event for the form, or in the Lost Focus event for the actual checkbox frame. If IsNull([yourFrameName]) Then Msgbox "Choose at least one option.", _ vbOkOnly,"Warning!" Me.yourFrameName.SetFocus End If Or if you are storing that value in a table, just...

Hello Everyone, Here is my problem, I need to keep a running total on my form as the user is entering records. I have two fields [TimeIn] and [TimeOut] in my table w\data type "Date/Time". In the query that is the record source for my form I have a calculated field HoursWorked...

You can also write this code using the code builder for the Exit event for each field. If IsNull(FieldName) Then Cancel = True End If

Hi All, I've been working with Access for a while, but am a begginer when it comes to VBA. I have a Contract database, in the ContractDetail Table there is a Contract Start Date and a Contract End Date. In a query based on the table I have two calculated fields: Months (DateDiff between Start...

If you're talking about the "X" in the right corner, go to the properties box for the form, you can set either the Close Button property to No, or the Control Box property to No(that takes away the Min & Max buttons as well). If you have a command button, set the Visible property to NO.

If I'm thinking through your problem correctly... When you set up the macro with the command to open the form, also do the apply filter command. In the "Where" box at the bottom try [client id]=[Forms]![main form name]![client id]. This should automatically filter the records so only the...