Recent content by Dystonia

  1. D

    Ghost window in Excel 2016 after transfer spreadsheet action

    Just returned from a 3 week vacation and tacked this issue afresh This is more a "work around" rather than a solution After the DoCmd.TransferSpreadsheet action, if the workbook is programmatically closed and then reopened, the ghost window disappears
  2. D

    disable form element if datefield is null

    If Me.cboPartnerId.Column(16)="" OR isnull(me.cboPartnerID.Column(16)) then Me.earlybtn.Enabled = True Else Me.earlybtn.Enabled = False End If
  3. D

    pass parameter dynamicly to query from form

    If I understand your issue correctly, when you use a form you can a) Store the non parameterised SQL as a variable MyVariable = Currentdb.Querydefs("QueryName").SQL b) Add the parameterised SQL string Currentdb.Querydefs("QueryName").SQL = "A Text string containing parameterised SQL" c)...
  4. D

    Ghost window in Excel 2016 after transfer spreadsheet action

    Hi Ranman 256, I agree this is weird I used [Task Manager] to see what was running as I stepped through the code and there were no instances of Excel until the transfer spreadsheet command Equally, when I manually tried to hide the "ghost" the "real" data became hidden leaving two empty...
  5. D

    Ghost window in Excel 2016 after transfer spreadsheet action

    Hi I am in the process of migrating users from Access 2010 to Access 2016 I know that Excel 2016 creates a separate instance of Excel for each individual workbook but after..... DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "_Debug", ExportFileName....when I make Excel and...
  6. D

    VBA to upload files to Sharepoint and set meta tags (if required)

    Hi   I recently had to come up with some code to upload a ZIP file to a sharepoint site and set (existing) document meta tags.   I thought it would be reasonably straightforward use Microsoft Access 2010 to take a ZIP file produced by a Microsoft operating system and upload it to Microsoft...
  7. D

    Counting Inside the field

    Access stores -1 against any check boxes which are ticked and zero against any checkboxes which are unticked When they are ticked your query is basically multiplying -1 by an integer which will produce a minus figure or by zero which will produce zero
  8. D

    Slickest way to covert Date to literal date?

    I think the last option may have to be.... '#' & format([MyDate],'mm/dd/yyyy') & '#' ...or else the calculation will be returned as a string instead of a date ?
  9. D

    Count by area type query

    If you only have a few cities, use could the SWITCH function ? SELECT Switch(City='San Diego','CA',City='Las Vegas','NV') as State ...not recommended though if you have thousands of cities and 50 states
  10. D

    Copy of Excel (OLE Object) and paste as table in word

    You need to post the value of your variable "tabl" so that I can see what it contains
  11. D

    Copy of Excel (OLE Object) and paste as table in word

    You can use the code below to open Excel and copy the contents of a worksheet to the clipboard which you can then paste into word Rem ********************************* Rem Open Excel Workbook Rem ********************************* Dim WB As Object Dim WS As Object Dim XL As...
  12. D

    Copy of Excel (OLE Object) and paste as table in word

    Hi Am I understanding your problem correctly ? a) You want to use Access to open an Excel file b) Then use Dynamic Data Exchange to transfer data in the Excel worksheet into Word
  13. D

    Question remove owner name in title

    You can explore using VBA to hide stuff Rem******************************************* Rem 2015.04.20.01 Set Title Rem******************************************* Dim prp As Property On Error Resume Next CurrentDb.Properties.Delete "AppTitle" On Error...
  14. D

    Selecting all records for TWO tables via an SQL command

    The problem is your criteria You have field names with the same name in more than one table in the same recordset try rst![TableName.ShippingServiceID] =7 or.....
  15. D

    Selecting all records for TWO tables via an SQL command

    Try changing line one to ....... SELECT * .....as per CJ's post and see if you get an error
Top Bottom