Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mbarkley9872

  1. mbarkley9872

    Append only Selected Records / Update Tables

    If I understand correctly, you're saying to... 1. download 180 days, append to tblMR_Ex180 2. frmMR_Ex filtered to last 24 hours (>= 07:00Z yesterday) 3. sfmMR_ExHist all 180 days, linked to main by Tail and ATA 4. apdMR_ExHist appends PK of frmMR_Ex and PK of selected records on sfmMR_ExHist...
  2. mbarkley9872

    Append only Selected Records / Update Tables

    Since both forms are basically using the same data (both tblMR_Ex and tblMR_Ex180 are built from the same downloaded .txt file), is this the best to set up my tables? 1) tblExDwn linked to txt file containing 180 days history 2) Append from tblExDwn the new events for last 24 hours to...
  3. mbarkley9872

    Select Subform Records to Append

    I've reviewed hundreds of threads looking for some ideas on this. So far all I've seen is using a checkbox as the criteria for the records to be appended. Is this the best method? If so, what would be the best way to clear those boxes after the append? If the user goes to next record (and it...
  4. mbarkley9872

    Append only Selected Records / Update Tables

    [purple]I've got a bunch of stars I'd love to give to somebody![/b] For anybody looking for info on appending only selected records from a subform, I've also posted that question in the Forms forum. Mike
  5. mbarkley9872

    Select Subform Records to Append

    I've posted this question as part of a bigger issue on the Other Topics forum thread 181-1341594. I haven't had any response there so I thought I'd post this sub-question here... If I have... tblMR_Ex: - MR_ExID PK - Tail - Date - ATA tblMR_Ex180: - MR_Ex180ID PK - Tail - Date - ATA...
  6. mbarkley9872

    Append only Selected Records / Update Tables

    Too much info? I'll try to break it down into smaller chunks. If I have... tblMR_Ex: - MR_ExID PK - Tail - Date - ATA tblMR_Ex180: - MR_Ex180ID PK - Tail - Date - ATA tblMR_ExHist: - MR_ExID FK - MR_Ex180ID FK frmMR_Ex – recordsource is tblMR_Ex sfmMR_Ex180 – recordsource is tblMR_Ex180...
  7. mbarkley9872

    Append only Selected Records / Update Tables

    I’ve spent months trying to figure out how to accomplish what seemed like the easiest of objectives, but every time I think I’ve got it figured out I seem to hit another major stumbling block. So, before I throw it all away and forever deem myself as a failure, I’m hoping someone here can take a...
  8. mbarkley9872

    SQL in VBA Filter form

    ZmrAbdulla, Great site, thanks!
  9. mbarkley9872

    Convert Time to Number

    PHV, I'd like to get it as hours... For example 100:45 would be 100.75 I tried CDbl(Val(UTILDWN!FltHrs) but no luck. Thanks for the help! Mike
  10. mbarkley9872

    Convert Time to Number

    Thanks to both of you but I still need to add the minutes. The Val() is only returning the Hours. Mike
  11. mbarkley9872

    Rolling averages chart

    This is close to what you're looking for SELECT DateSerial(Year([COLOR=qry]![date]),Month([COLOR=qry]![date]),1) AS MonthDate, [COLOR=qry].color, Sum(Nz([COLOR=qry]!qty)) AS SumOfQty, FROM [COLOR=qry] GROUP BY DateSerial(Year([COLOR=qry]![date]),Month([COLOR=qry]![date]),1), [COLOR=qry].color...
  12. mbarkley9872

    Convert Time to Number

    I have alot of fields that capture time - flight hours, engine on-wing hours, time since overhaul, etc. They are formatted like hh:mm but the hour part is often 3-5 digits. I.e, 23756:21 I need to use this data to perform many types of calculations - utilization rates, sums, etc. The data is...
See more

Part and Inventory Search

Back
Top