User Profile

Collapse

Profile Sidebar

Collapse
sheikhsab
sheikhsab
Last Activity: Sep 19 '22, 05:21 PM
Joined: Sep 16 '22
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sheikhsab
    started a topic How to use TransferSpreadsheet to transfer query data to Excel Template selected rows
    in Access

    How to use TransferSpreadsheet to transfer query data to Excel Template selected rows

    Hi Team,

    This is the code i am using to transfer data to a excel template, the data is pasted from cell A1. i wanted the data transferred from row 11 and onward.
    Code:
    Private Sub Command18_Click()

Dim filepath As String
Dim sSheetName As String

sSheetName = InputBox("Enter Sheet Name")
filepath = "C:\Users\msheikh\Documents\Fremont Maintenance Support\DB\CSP_Template.xlsx"
    ...
    See more | Go to post
    Last edited by NeoPa; Sep 16 '22, 11:54 PM. Reason: Added mandatory [CODE] tags.
    • sheikhsab
      started a topic how to get the dates from different Dropdown list options
      in Access

      how to get the dates from different Dropdown list options

      Hi,

      I have a drop down list with different status for a process., and the date field on the form for the status.

      how can i save the dates for each status(step) when different option from the dropdown list is selected?

      BR
      See more | Go to post
      No activity results to display
      Show More
      Working...