Search results

DoCmd.CopyObject would appear to do what you want http://msdn2.microsoft.com/en-us/library/aa212269(office.11).aspx

Set the Control Source for each of the fields in your report to [Forms]![NameofForm]![NameofTextBox].

Hi, This works for me: Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) If Me.EventDate = Date Then Me.EventDate.ForeColor = vbRed Else Me.EventDate.ForeColor = vbBlack End If End Sub

Try putting it in the On format event of the Detail section (or whatever section of the report the date is in) of your report

Sounds like you need to use SELECT DISTINCT in your row source for the combo. e.g. SELECT DISTINCT [TableName].[Name] From [TableName] Have you referenced the query to the combo box on the form in its criteria i.e. Under the name field in the query used [Forms]![NameofForm]![comboname]? Also...

All you need is [Enter Date] to search for a specific date. You use the Like & * with strings

Thanks Bob

To format the output in the query like that, Format([nameofdatefield],"mmm yyyy")

Hi Maria, See attached (should be in Access 97 ) , in the daysworked field I used the functions Cint and Nz to give the expression: Daysworked: CInt((Nz([mon2],0)))+CInt((Nz([tues2],0))) and that comes up with answer 2 Edit, Just reread the thread again and saw I didnt quite do all you...

Maria, Access 97 version attached for you, hopefully not corrupted (although the other was ok for me) Rural Guy's looks the better solution.

Hi Maria Maria, Take a look at form1 in this mdb and the code in the Before Update event of the second text box, is this what you want to happen? I have used the DateDiff function to work out the difference in days and pop up a message if over 7 days, enter 2 dates and press tab and you...

I'd completely forgot about that, that's fixed it. Cheers! :)

I have a form with subforms that are set as data Entry. In one of the sub forms I want to do a check to ensure that data has been entered on the main form thus creating a new record before data can be entered into the subform. In a combobox before update event I have put code in to see if the...

Add a new text box and set its Control Source to =TotalCost*0.9

Right Click on the Form and select Copy, then right click and paste giving it a new name

Hi, The websites and emails are there, it's just because of all the blanks, to get round it amend the code to SELECT [UK Table].[Website Address] FROM [UK Table] Where [UK Table].[Website Address] Is Not Null ORDER BY [Website Address];

Sorry it's Row Source

Set the Data Source for each combo box to (replacing name with required field name) : SELECT [UK Table].[Name] FROM [UK Table] ORDER BY [Name];

Jo, I know how to will send you it! (Sorry this is not much help to anyone with a similar problem but I have been helping with something else and have a copy of mdb.)

Please see PM