Search results

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

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

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

Hi Guys, i have set up a piece of code where after an update of a combo box, it will delete a table which is associated to a subform then rebuild the table based on the value selected on the combo box - then reload the form (basically it's a way of generating a query but in a table). When i do...

Hi Guys, In a table on my form, i want to highligh an entire record if one of the elements of that record is above a certain number. I know how to do conditional formatting for individual parts to a record - but not how to say "If Nuns > 5, make Record ID go RED" any help is appreciated...

Hi, i'll explain my setup. I'm using Access 2007 to build a database of courses run by a collection of schools. It's a favor for my parent's friend because i thought i could do it... i think i've made a mistake! Anyway. There are 3 main tables: Courses (which include: Course ID, Header ID...

Hi Guys (i posted this in the VBA part - but realised it's more appropriate here), quick question - i'm a bit of a noob when it comes to Access so this might be really easy. I am trying to set a default value of a field to be the most common value within the table. Any ideas? I have built a...

Hi Guys, quick question - i'm a bit of a noob when it comes to Access so this might be really easy. I am trying to set a default value of a field to be the most common value within the table. Any ideas? I have built a query to find the most common value but when i set the default value of...

Hi Guys. I have 5 tables: Current Courses Current Course Demands Old Course Header Old Courses Old Course Demands Basically - the Current Courses table lists what courses are on this year. The demands are simply another table linked via a one-many relationship (Current Courses -> Current...

Hi, I think this might be quite common but i cant find anything relevant on google. I have 2 Queries in a form in Table View - one the subform of the other. I want to requery the parent table after updating the child form. i'm using this VBA code (it doesn't work) : DoCmd.Requery ([Parent...

Hi, I think this might be quite common but i cant find anything relevant on google. I have 2 Queries in a form in Table View - one the subform of the other. I want to requery the parent table after updating the child form. i'm using this VBA code (it doesn't work) : DoCmd.Requery ([Parent...

Hi Guys, I was hoping to be able to have a drop down box to filter records in a table without going via a query. The reason being is that when you use a query to filter the records in a table, you cannot add to the dataset in table view. is there a way of using a combo box to invoke the...

Hi guys, i was hoping to control two tables with one scroll bar - meaning that all the rows are in line to one another. Basically one tabl;e view is the stored data, and another is the calculated data. I cant use a query to make one table as i get the "recordset not updatable" error. Cheers...