Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18

Exporting from Access to a specific table and range in excel mostly done, need a bit of help

  1. #16
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    7,695
    What does "ME" stand for?


    What queries get the values for these cells or where to the values come from?
    A3 - Total Missions Scheduled -??
    A4 - Weather CANX_________________Weather_CM_Query should start at B4
    A5 - Flights minus Weather CANX.......... Need to create query?
    A6 - Total Flights Flown-??
    A7 - Total Flights Effective-??
    A8 - Total On Time _______________OT_CM_Query should start at B8
    A9 - Total Late.................................. Need to create query?
    A10 - Total CANX .............................. Need to create query?

    Query glance should start at B24
    --------------------------------
    A24 - Operations -
    A25 - Avionics
    A26 - Other
    A27 - Documentation
    A28 - Supply
    A29 - Weather
    A30 - Sympathy
    A31 - Quality

    "Other" & "Sympathy" are departments that you cut out, but are really in the table?


    "Deviations_currentMonth_Query" should start at A41


    Where do the "Glance" numbers come form? Are they just typed in the Access form, then copied to the Excel sheet?



    I think I have the structure straightened out. Now starting to work on the code.....



    Comments??
    Attached Files Attached Files
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  2. #17
    archy321 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    9
    Wow, looking at your table and looking at my table shows me that i have a LOT of learning to do. This thing looks AMAZING! It looks so professional!

    The Glance numbers come from the "department" column in the table below it. I figured the users could just type the numbers in. Sometimes we dont use all the departments each month and we would omit those from the charts that excel would make.

    After looking at some of our data i decided against having "lates" queried at this time since some flights can have multiple "lates" on it and i didnt want it skewing the total number of flights.

    Cancellations do need to be made, but i figured that if after i saw your code i could replicate it to save you some work since you're doing so much already!

    Flights minus weather is already built into the excel document. Its total number of flights minus weather department.

    Not all departments are depicted since sometimes we make up new "departments" or how you and i could call a one word reason for a delay.

    Sub Department is a new idea i came up with and is still heavily in work i.e. even though i came up with it i have no idea what to do with it haha.

    Total missions schedule is going to be calculated by hand since i cant figure out a way to calculate it without "lates" being skewing it. The same holds true for total flights flown. Thats going to be hand jammed into excel document manually.

    Total effective missions counts the number of "yes" in "ME".

    Thank you again so much for all the help!

    V/R
    Archy

  3. #18
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    7,695
    OK, I'll back out and you can continue on your programming journey.

    I did make a couple of changes in the VBA code.
    To make it easier to select which month (Prev/Current) the data comes from, I renamed "Private Sub btnPrevMth_Click()" to "Private Sub btnUpdateExcel(TheMonth As String)" and added a few more lines of code.
    I renamed the current month button to "btnCurMth"

    Code:
    Private Sub btnCurMth_Click()
        btnUpdateExcel ("C")
    End Sub
    
    Private Sub btnPrevMth_Click()
        btnUpdateExcel ("P")
    End Sub
    
    Private Sub btnUpdateExcel(TheMonth As String)
    'rest of code
    I'll leave it to you to trace/read through the code......


    Good luck with your project......
    Attached Files Attached Files
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 09-19-2016, 04:02 PM
  2. Replies: 12
    Last Post: 04-15-2014, 11:16 AM
  3. Exporting to specific spots on excel.
    By sonoamore in forum Programming
    Replies: 1
    Last Post: 12-05-2013, 09:55 PM
  4. exporting access report to specific excel cells
    By grgold14 in forum Import/Export Data
    Replies: 1
    Last Post: 02-07-2012, 03:38 PM
  5. Exporting to Specific Excel Sheet
    By unrealtb in forum Access
    Replies: 2
    Last Post: 01-24-2012, 09:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums