Recent content by Juett

  1. J

    Solved Outlook Appointment Subform records

    Thanks MajP that was just what I needed :)
  2. J

    Solved Outlook Appointment Subform records

    Hi All, I have a main form with a subform and I want to insert all records from the subform into an Outlook appointment/calendar entry. Everything works accept how the subfrom records are copied. I use the following code to grab the subform records: Private Sub Outlook_Click() Dim rs As...
  3. J

    Solved Query with conditional criteria

    It is sage 50 and I think you're right there! I'll import the data! Thanks to all.
  4. J

    Solved Query with conditional criteria

    I've had some limited success with this. The following union query works if I first copy the source data from the Delivery Address table into two local access tables (table1 and table2) using append queries. SELECT * from Table1 where AddressType = 'Delivery' UNION SELECT da1.* from Table2 da1...
  5. J

    SQL Query - WHERE clause

    Yes - I hadn't realised that pass-through queries were read only. I'll need to read up on server side tables I think!
  6. J

    Solved Query with conditional criteria

    Hi everyone, I'm trying to make a query off of two tables that is connected/used with another database I don't directly manage. There is a field called ADDRESS_TYPE in the Delivery Address table that has two values as data options: 'Delivery' and/or 'Contact Address'. The Delivery Address...
  7. J

    SQL Query - WHERE clause

    Is there an example of some of this that I can see? I'm entirely new to server SQL and these types of query, which is why I think I've found the solution to this so evasive.
  8. J

    SQL Query - WHERE clause

    Hi everyone, I have a basic query that references a form's value in the WHERE clause. I'd like to try and turn this query into a pass-through query as I'm looking at moving my tables to an online SQL server. I'm aware that pass-through queries cannot utilise form values in the traditional way...
  9. J

    Solved Auto Population of Form Field

    I've solved this. Idiot moment - the field customer name was also the record source of the combo box, so by concatenating the first two columns and then inserting them into the customer name field, I was also wiping the query result before it could finish updating the other fields. :sleep:
  10. J

    Solved Auto Population of Form Field

    Hi everyone. I've come across a strange issue that I can't seem to figure out.... I have a combo box whose source is a query that runs and stores the results in the combo box drop down list, and it works fine. I have some VBA that stipulates when a user selects a result/row from the combo box...
  11. J

    Form Validation Issue

    They are strings, but, the first one still works as if it was a number range, and the latter doesn't, and I can't see why. Shoudn't either both work or both not work?
  12. J

    Form Validation Issue

    Hi guys, This might be an already-trodden issue...but does anyone know why this form validation works (in the form properties box): >="36.5" And <="37.5" But this doesn't: >="9.5" And <="10.5" What am I missing here?
  13. J

    Solved Display OLE Ink Object in Report

    arnelgp's suggestion to save it as an attachment seems to have worked. Thanks very much!
  14. J

    Solved Display OLE Ink Object in Report

    Hi everyone, I have managed to capture a signature in a form using the Microsoft InkPicture Active X control, and store that signature as an OLE field in a table. I can then also recall that OLE object in the form when cycling through the records. Each form record displays the corresponding...
  15. J

    Solved Copy all query records into Form Datahseet

    Update - I managed to achieve this by running a query from a combo box and storing the results in another combo box, then from this second combo box I copied and inserted the results into the form datasheet using a loop. Dim i As Integer For i = 0 To Me.Combobox2.ListCount - 1...
Top Bottom