Search results

omnidragon How to include a bound picture on form HTH Graham

Hi Ian You could also try: http://www.microsoft-accesssolutions.co.uk You may find some useful information their. Graham

There's another working example of using the SendObject here: Sending E-Mails From Microsoft Access HTH Graham

Andy There are a couple fo different examples available at: rogersaccesslibrary HTH Graham

referee Please see the attached image. This shows where to turn on/off the Drop Areas in design view. Unfortunately, if this does not solve the problem I am not sure where to go. HTH Graham

The above solution should work then for this problem. If not you may like to try downloading the service packs available from the Microsoft site as this has solved the problem in the past. Graham

referee Can you not see the drop areas - The places where is says Drop Row Fields here and Drop Column Fields here -OR- Are the actual fields that you want to base the Pivot table (Pivot table field list) not visible? Post back to let us know Graham

With the Pivot table in design view go to View >> Properties >> Behavior. Here you can check the Hide/Show Elements Drop Areas check box and you should then be able to view them. HTH Graham

garbett_d It should be easy enough to create a form then use the form control as the criteria for the query. See the simple attached example to give you an idea. HTH Graham

Steve You can set the format for each combo box on the Format tab of the property for each control in form design. Graham

If the infomation has a One-to-One relationship you could, in fact, store all of this information in the one table. However there maybe reasons that you wish to store this information in only one table. You could use the Open Arguments property of the form to pass the Logbook Number to the...

MadCat From your initial description it sounds as though you have two tables: Personal, which has LogBookNo as your Primary Key -and- TestDetails You appear to say that One Personal can have Many TestDetails associated with it, therefore you should include LogBookNo as the Foreign Key in...

An autonumber is used to provide a unique identifier for a table. There are occasions when a table will have a naturally occurring unique identifier. When there is a naturally occurring key, it should be used. But when it would require too many columns to define a natural key or there...

greasman The following thread from another forum may help towards solving this problem: http://www.accessvba.com/showthread.php?s=&threadid=2508 Graham

Jon You will need to ensure that you have a corresponding field on the tabbed form that you are opening from the List Box. I have attached a quick example of an Access 2K database showing this. HTH Graham

Jon The following example shows one way of doing this, there is probably better ones... Private Sub lstSearchList_DblClick(Cancel As Integer) On Error GoTo Err_lstSearchList_Dblclick Dim stDocName As String Dim stlinkcriteria As String stDocName = "frmBooks"...

Thanks Mile and Kevin Got it working now using: Private Sub cmdExitDatabase_Click() Dim intStore As Integer 'Count of unsent e-mails intStore = DCount("[lngJobOutcome]", "[tblJobOutcomes]", "[ysnSentByMailToStaff]=0") 'If count of unsent e-mails is zero then application will quit 'If count of...

On my switchboard, for the Quit application command button I have the following code If DCount("[tblJobOutcomes]![lngJobOutcome]", "[tblJobOutcomes]", "[tblJobOutcomes]![ysnSentByMailToStaff]=0") = 0 Then Application.Quit ElseIf DCount("[tblJobOutcomes]![lngJobOutcome]", "[tblJobOutcomes]"...

Further Info..... After much testing it appears that the problem relates to a security patch that we had to apply to Outlook XP to allow it to interact with our main "SuperOffice" database. We use this to archive all correspondance from students, however without the patch you only had so long...

Rob/Jon Thanks for the replies. I thought I may have found the solution when I realised that I was using Outlook XP on my machine at work and Outlook 2000 at home (where it works correctly). Tried this morning at work on a machine running Outlook 2K and no joy. Now I feel that I may have...