Search results for query: *

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.

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

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...

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...

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...

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.

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...