Search results

  1. I

    Access VBA Import from Excel to Azure SQL Server

    Hi all, After a lot of searching, testing and hitting way too many brick walls, I thought I'd see if anyone is able to help - Originally the below was an Access 2016 Front End and and Access 2016 Data Back End setup. Current Setup Access 2016 DB Front End (main tables linked to Azure SQL...
  2. I

    Multiselect dropdown

    Hi, I would like to add a multi-select drop-down to a form that would basically allow me to select the drop-down revealing a populated list (this part isn't the problem) and select checkboxes next to the items in the list that are relevant to me. Basically I'm after something like the Access...
  3. I

    Crosstab Query with latest date/time criteria

    I have a table with data which looks like this - <<Hist_Date>> <Area> <Jobs> 11/10/16 15:53.... AA....... 12 11/10/16 15:53.... AB....... 15 11/10/16 15:53.... AC....... 20 12/10/16 11:22.... AA....... 10 12/10/16 11:22.... AB....... 12 12/10/16 11:22.... AC....... 14 12/10/16 14:32...
  4. I

    SendObject Embed SubForms in message body

    Hi, I would like to be able to send an email using the SendObject method from a form that has 2 sub-forms. Ideally, I want to be able to copy the 2 subforms and embed them in the message body as, say, an image, with text before and after the inserted images. Also, what would be the...
  5. I

    Get current subform control (container) name

    I have a parent form with 2 subform objects, using all the same subform. Parent Form = FRM_Report_Appointments Subform Control 1 = App_Sub_01 (using form: FRM_Appointments_SUB) Subform Control 2 = App_Sub_02 (using form: FRM_Appointments_SUB) How can I find the name of the control...
  6. I

    Sequential Date Field

    Hi all, bit of an odd one... I have 2 tables in a query. One has dates, which aren't always sequential, the other has the default values required where the table with dates doesn't have a matching record... I need to create a field that generates a record for every date between 2...
Top Bottom