Recent content by choward

Hi guys, i am trying to call an application (Powersim Studio) using vba. BUT i want to be able to call it by calling the file in particular. I have tried: stName = "c:\thisisatest.sip" shell stName, vbNormalFocus but no avail. I am hoping the operating system will determine the appropriate...

Hi Guys, can someone tell me what's wrong with this code? em_name = DLookup("[MODE]", "[SPM Entry Mode Filter]", "[MODE ID] = " & em_no) If IsNull(("source![" & em_name & "]")) Then LOADING = 0 Else LOADING = ("source![" & em_name...

... okay... i think newline is chr(10)... but the pivot table wont actually go to a new line.... hmmm...

... one thought i've just ahd is that in the query i use to cource the data for the pivot table - i can add a field in SQL as something like "Title: [START] + #newline# + [END] + #newline# + [CAPACITY]" but... i do not know how to say 'new line' or even if the pivot table view will accept it.

Hi Guys, firstly - abig thankyou to those who have helped me so far - i am sure the school will love the enhancements you guys have helped me create. Anyway - i have a poblem with pivot tables. Each course has allocated, and loading (number allocated, and the number who turned up) to a...

Hi Guys, Just a brief - i have courses in a table with a start date and end date. Each course has a loading, and a max capacity. I am trying to create 2 seperate graphs and do not know how to do either: Firstly - i am trying to make a graph that on the x axis is each week in the financial...

Thanks Gemma, the combo box doesn't crash anymore - but selecting 'ALL' doesn't bring up the results as if it were unfiltered. In fact, it shows nothing. i cant explain it - and i am 100% certain there is data there. Stupid access 2007.

Hi Guys, this is my sql for the Row Source of a combo box: SELECT [LOCATIONS].[LOCATION ID], [LOCATIONS].[LOCATION NAME] FROM LOCATIONS UNION (SELECT '*' AS [LOCATION ID], 'All' AS [LOCATION NAME] FROM LOCATIONS) ORDER BY [LOCATION NAME] Any ideas why it doesn't work? Location ID is the...

Hi Guys, i was hoping to do something a little more complicated than usual. Basically, on the top of my form is a table of data where each record has a start date, an end date, a unique id, and a quantity (of people in this case). What i want the user to be able to do is to select a number of...

Hi Ken, turns out it was an Access 2007 bug.... GRRRR!!! It works fine once i installed Access 2007 SP1.

Hi Ken, that's what i was hoping to do but i do not know how to specify it properly. The row/source data is the query... but how do i speficy the fields?

Hi guys, i have built a query to find the sums of various fields from various tables. i want to make ONE piechart from all these the sum values... i.e. Cars - 500 Planes - 300 Those digger things i always wanted as a kid - 200 But the stupid MSchart activex thingy in Access 2007 always wants...

Hi Guys, just a quick question. Within Access - building events and so on - can i code them in VB.net instead of VBA? Basically - i would like to take full advantage of Access' interface designer etc but also the power of .net I cant really find any reference material on this so i'm guessing...

Hi People, i want the user to be able to select a working directory by clicking a 'browse' button. Is this possible in VB? Thanks, Chris

Hi, i am trying to do this in VBA: DoCmd.RunSQL "UPDATE [Static Data] SET [Static Data].Result = max([Courses].[COURSE ID]) WHERE ((([Static Data].Criteria)='CMAX'))" it basically stored in a table called STATIC DATA the highest Course ID value. It doesn't work and has this error: "You tried...