Search results for query: *

Hi, Im using Access 2003. I have a list box on a form which pulls data out of another table. There are 5 values, but 1 or 2 more may be added in the future. What I would like to do is have the list box not list the 5 entries downwards, but going from left to right instead. Is this possible...

Hi, This thread can be seen as a follow on from an earlier thread i made, but that thread was how to make the chart in question (thread703-1442834). I have two boston charts in Access 2003, with row source set to a query. What I want is to be able to have some sort of IF statement in the...

Hi, I have two list boxes, one a single select and one a multi select. I have a button which unselects the item in the single select list box, but it wont work for the multi select list box. Here is the code I have for the button: Private Sub cmbUnselect_Click() Me.lstGrouping.value =...

Hi, I have 9 tables (each with 3 columns) that are all similar to each other. Want I want to be able to do is select the data from the 9 tables (the middle column), and have them all put into one list box. So something like this: Listbox Tbl1 MidCol Tbl1 MidCol Tbl2 MidCol Tbl3 MidCol etc...

Hi, I have this code below which is used to show what the highest denomination a value is (meaning the number 45's highest denomination is 10 (the ten figure), 852's is 100 (the hundred figure)). Function denom(lngField As String) As Long Dim intLen As Long Dim lngDenominator As Long...

Hi, I have a table called Risk, and there are 3 columns that I need for the bubble chart. They are RiskID, DateRaised and Criticality. There are also a further 3 fields (Client, PlatformID and ProjectID) which determine which Risk the belongs to which Project/Platform/Client. Client can have...

Hi, I need to be able to delete a lot of records from a table but not log the transactions (to save time). I know theres a Truncate table command, but I need to be able to delete records with a where condition aswell. Does anyone know how to do this? Many thanks in advance, Andrew

Hi, A user selects a project from a combo box on a form, and then clicks a command button to open up a different form which shows all risks for that project. The form is called RiskRegister, and has a subform called Risk (which shows all the risks). In the table Risk, there is a field called...

Hi, I have done some archiving before on a database that i worked on previously, and so know how to do the archive through code, but how would you make the archiving run automatically at the end of the month? The code I used previously was used on the OnClick event of a command button, and so...

Hi, I want to be able to make a custom chart, as none of the charts are what I need. Here is a picture of what im after, and I will explain afterwards: 9| | | 8| O | R | 7| | | R 6|______|______| 5| | | 4| | O |______ 3| Y |______| O 2|...

Hi, I am using Access 2003 project, with SQL Server 2005. I have a form, which has a command button that opens up another form called riskregister (which has a subform in called risk). I have this code that does this: Private Sub cmbOpenRiskRegister_Click() Dim stLinkCriteria As String...

Hi, Im using Access 2003 Project and SQL Server 2005. I have a connection screen which lets the user pick a platform from a combo box and then all projects for that platform are displayed in a list box. The user then chooses that project and presses a command button which opens up a new form...

Hi, Im using Access 2003 Project and SQL Server 2005. I have a connection screen which lets the user pick a platform from a combo box and then all projects for that platform are displayed in a list box. The user then chooses that project and presses a command button which opens up a new form...

Happy New Year!! I want to be able to display a word document in a report. I am using Access 2003, with a SQL Server 2005 backend. The word document consits of text and pictures. Originally, I was going to just copy the whole info out of the word document and paste into a report, and that...

Hi, I seen on the net and on here that you can change the style of writing, which lines it goes on etc etc. But what I can't seem to find, and what I want, is to have a custom name for the buttons on some of my message boxes. So instead of choosing vbYesNo, I would have something like...

Hi, I have a command button called cmbCalculate in a form called RiskEstimate, in an Access 2003 Project. On the Click event of this button, I have some code: If totalWeighting < 15 Then Me.RatingOverall = totalWeighting & " - Low" Me.RatingOverall.BackColor = vbYellow ElseIf...

Hi, I have a subform in a form, in Access 2003. The subform is in datasheet view. I have multiple fields, but only 5 are relevant to this, these are Probability, Consequence, RiskRating, Manageability and Criticality. RiskRating is equal to Probability mulitplied by Consequence, and...

Hi, I have a bit of a puzzler. I have a form called Category (in form view), and a subform called Risk (in datasheet view) in an Access 2003 project called RiskAnalysis. In the subform I have a combo box field called WBS which gets its value from a stored procedure called usp_WBSChange. The...

Hi, I have a form called Category and subform called Risk in an Access 2003 project. I originally wanted the subform to go to the last record when a button called "AddNewRisk" was pressed (which added a new row to the subform), but I have that sorted. What I would like to do is go to the last...

Hi, I have a database called Risk using Access 2003, with Risk linked to SQL Server 2005. I have a form on Access (called Form1 for now), with a subform linked to that form. On the form (not subform) I have a combo box called ProjectCombo and a list box called ProjectList. At the moment...