Search results

  1. N

    Show results not using join??

    Cheers, I've used VBA before to do it, but wandered if there was a SQL method. Reason being it is for a piece of work i am to hand over as soon as done, so didnt want to have a "How to Code" lesson before hand. Cheers anyway. Nathan.
  2. N

    Show results not using join??

    A Union query would not do it, that would again put the information underneath. Essentially i want to see the application, then a list of the application numbers, in one column, so Application 1 in column 1, then in column 2, 1234,1235,1236 etc. Thanks. Nathan.
  3. N

    Show results not using join??

    Hi I have 2 tables, one tbl_Application contains details of applications, tbl_A_Numbers contains details of account numbers for that application. I want to run a query which puts all the records from tbl_A_Numbers into one column, rather than the conventional link. So, i have APplication 1...
  4. N

    Event Sink

    Many thanks J Draw it worked beautifully, i have now got a bit carried away with it, and i am sinking everything. One thing that is puzzling me, i want to do this on the detail click of a form, i have done the following and it works on the form click, but not the detail clicking. Dim...
  5. N

    Form Events

    No I know how to get into VBA. I have created an event in my form called datamissing. I want to raise this event based on logic from data retrieval stage, rather than using a sub is this possible as want to have differing events when different data is missing so another event called...
  6. N

    Form Events

    I have created an event within a form in access, but can not find where it is to handle it. Can anyone advise?
  7. N

    Event Sink

    Hi, I am trying to create an event sink, to handle the on_enter event on my form, for each of the (approx 20) text boxes on the form, to have a common event. I have looked at a few examples, but can not get them to work. Can anyone advise. Many thanks.
  8. N

    Creating ODBC connections VIA VBA

    try changing and looking at www.connectionstrings.com for inspiration.
  9. N

    Query Xtab type output

    HI I have a need to create a report, which i will simplify for the purposes of this. I have an orders table, which has 2 fields, cust_ID and Product_ID, both are numbers. I have a products table, which has 3 fields, Product_ID autonumber PK, Product_Name text and Licence Yes/No. The idea...
  10. N

    HTML Email in 2007

    Hi, Apologies, It is my code which retrieves the template for the email. Problem solved. Thanks.
  11. N

    HTML Email in 2007

    Hi, I have recently (today) switched to Office 2007 from Office 2003. I my access DB there is a module which sends an HTML email, using the following code With objMailItem .BodyFormat = olFormatHTML .To = EMAIL@EMAIL.com .HTMLBody = "<HTML>" & strBody & "</HTML>" .Display End...
  12. N

    Import from Excel but have User Browse for the File

    I think it is because you are looping through each sheet in the excel spreadsheet For i = 1 To .Worksheets.Count But still importing the "Testing Tab"
  13. N

    user control properties

    Hi, It was because when adding it, i defined ctl, the new control, as a control, rather than dim ctl as new TreeViewv2.TreeView_Parent at the beginning of my code. Thanks.
  14. N

    user control properties

    Hi, I have added a property to my usercontrol, called NumberOfChildRecords. This property appears when i add the control and view its properties manually. However, i am adding this control by code, and this does not allow me to add this property. ctlParent = New TreeViewv2.TreeView_Parent...
  15. N

    scan each row for a string from other table

    Hi, Not sure which would be easiest to be honest. It has to go back into access, so may as well do it there. Here is the way i'd do it in code, my tables are called _Cities and _Addresses <code> Option Compare Database Private strNewAddress As String Private strCityName As String Sub...
  16. N

    Making tabs visible based on toggle buttons

    Use Private Sub Water_absorbtion_Click() forms("f_test_management").Controls("testManagementTab").Pages("waterAbsor btionTab").visible = forms("f_select_tests").controls("Water_absorbtion") End Sub should work, Me is the form that the code is in. Thanks
  17. N

    Making tabs visible based on toggle buttons

    Private Sub Water_absorbtion_Click() Me.Controls("testManagementTab").Pages("waterAbsorbtionTab").visible = Me.Water_absorbtion End Sub
  18. N

    scan each row for a string from other table

    This is possible, but i would do it in code. Is that something that you are prepared to look at?
  19. N

    Rule for response to a field

    you need another end if before end sub. If 1st IF (current year) END IF if 2nd IF (is null) if 3rd IF 20 years + end if end if
  20. N

    Rule for response to a field

    I would use if not isnull(Me.[Entrance Doors - Flats (Renew Year) 20 LE] ) then If CLng(Me.[Entrance Doors - Flats (Renew Year) 20 LE] >= CLng (Format(Date, "yyyy") + 20)) Then Custom message boxes i have used in the past, just a form with the images on (easy to get hold of on goole)...
Back
Top Bottom