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!

Search results for query: *

  1. Jade3942

    Application Embedding in MsAccess Form

    Is there any way of embedding MsOneNote within a MsAccess form, essentially running the OneNote app within a given control space? Alternatively, is this possible from within Visual Studio using a Windows Form project? Any help appreciated.
  2. Jade3942

    Problem with assigning recordset value to VBA variable

    Thank you.. !'s instead of .'s
  3. Jade3942

    Problem with assigning recordset value to VBA variable

    I am using the following sub and function to extract a value from a chosen table within Access2007. The intention is for the function to return that value as a variable, for the sub to continue and assign it to a different table/record. Things appear to work correctly, except the function does...
  4. Jade3942

    Set a textbox value based on Combobox value

    This code seems to be along the right lines I think... used in the Control Source of the textbox, but I cannot get it to return the right result.. I think my syntax is at issue here.. [Call Form3] is a parent form, [ring around3] is the subform, the [temp id] is a field on the subform which is...
  5. Jade3942

    Set a textbox value based on Combobox value

    What I have is a combobox that has as it's bound value the field [TEMP ID], amongst other things looked up by the box for display purposes in the drop-down list are [Full Name] and [Post Code]. I need to send that post-code value to a textbox after the combobox updates. However as the combobox...
  6. Jade3942

    Start and Finish time broken up into dynamic time bands calculator

    I've got to get my head around the above and see how it relates to the implementation side of things... I appreciate all the help thus far, bear with me a couple of days and I'll let you know my progress.
  7. Jade3942

    Start and Finish time broken up into dynamic time bands calculator

    The business rules we have in place dictate the following: Each day of the week is split into timebands for charge and pay purposes, these timebands apply for a given period...e.g Every Monday the hours between 0600-1800 are say paid at £10 per hour, on Tuesdays those same hours could be paid...
  8. Jade3942

    Start and Finish time broken up into dynamic time bands calculator

    In connection to this problem above, I've looked at a solution excluding the use of dates. The pseudocode below would deliver the hours/mins in each band... however not being a tinkerer rather than a coder and being several steps away from testing this I think I might encounter a problem with...
  9. Jade3942

    Start and Finish time broken up into dynamic time bands calculator

    Times are entered as hhmm a date component is attached to the same record in a seperate field but if needs be we can combine the fields either in the system OR at the time of calculation. We are using the UK time/date formate in case that has any significance i.e. hhmm and dd/mm/yy times do...
  10. Jade3942

    Start and Finish time broken up into dynamic time bands calculator

    I'm trying to find a way to perform a series of calculations that would allow me to apportion the number of minutes existing in a time-band (e.g. 1000hrs to 1800hrs) with a given start time and an end time. Probably best for me to illustrate: JOB A: Start Time - 0800 JOB A: End Time - 1800...
  11. Jade3942

    Concatenate multiple child records, with criteria

    Perfect!!! Thank you for all you help!... lesson learned on date formats and queries. The report is fine now... cheers!.
  12. Jade3942

    Concatenate multiple child records, with criteria

    Okay, I've had a go at seeing if there is some common factor in the data it does concatenate, which it does correctly when it does it. Thats the good news!!..so at least I can see it's a theoretically viable approach. The vast majority out of a sample of 4875 records show missing concatenations...
  13. Jade3942

    Concatenate multiple child records, with criteria

    Ignore the Syntax Error mentioned above.. I copied the code you provided and placed it into the design mode column... (DOH!!) Ok I added the code to the SQL view and it executes but it definitely is not doing what we would expect.. It seems only interested in pulling records from the last 2...
  14. Jade3942

    Concatenate multiple child records, with criteria

    All the fields are available from the query [Copy of CROSS TAB1 pre concat] The added code you suggest throws and "INVALID SYNTAX" error.. it doesn't like the "AS Bookings" part ? Stripping that part off the statement allows the query to run, but most of the data is then lost for some...
  15. Jade3942

    Concatenate multiple child records, with criteria

    Apologies I ommitted the SQL for the concatenate that I have in testing... The test version of the concatenate SQL I am using is as follows...the data sheet view shows the bookings being combined, but sans any consideration to the start date..I think the WHERE clause approach should work...
  16. Jade3942

    Concatenate multiple child records, with criteria

    The SQL for the query that combines data for the crosstab to work on is as follows: SELECT [ISSUE LOG].[ISSUE BRANCH ID], [JOB DETAIL].[START DATE], [RING AROUND].[TEMP ID], [RING AROUND].OUTCOME, CLIENT.[COMPANY NAME], [JOB DETAIL].[START TIME], [JOB DETAIL].[END TIME], TEMPS.[FULL NAME], [job...
  17. Jade3942

    Concatenate multiple child records, with criteria

    I'm trying to produce a crosstab report with some concatenated data... I've successfully implemented Duanes alias style crosstab report, but come a bit unstuck where I now have potential multiple values at each matrix intersection. Rather than produce seperate fields for the extra values it...

Part and Inventory Search

Back
Top