Search results

I need to evaluate the material components required to manufacture a box. A box has sides, base, lid & ends and each can be constructed using different materials. I need to determine which components have the same material so that I can optimise the use of that material. I need to write a...

Thanks Can you explain a little further?

I use cdo to create e-mails. How can I include a graphic file in the message of an html e-mail? Like a company logo I use Access 2000 I need a solution that is e-mail client independant. It must use cdo only

I think that I need to add each series using vba: .SeriesCollection(i).Add but I can't get it to work!

Last problem and then I am done with this project! It has come out superbly, and I must thank all that have assisted me. I use a table as the row source for my chart. If I add extra fields to the table, how do I get the new fields to automatically display as new series on the chart? I have...

.ChartArea.Fill.ForeColor.SchemeColor = rgb(0, 0, 255)

I have a chart in an Access report. I want to allow users to change the gradient fill of the chart are. So, they can select the fore and back colours and gradient type from combo box's on a form and the vba code will do the rest

Access 2010

Public Function CreateChart(ReportName As String, ChartObjectName As String) Dim Rpt As Report 'Dim grphChart As Object Dim grphChart As Graph.Chart Dim msg As String, lngType As Long, cr As String Dim ctype As String, typ As Integer, j As Integer Dim recSource As String Dim colmCount As...

I have the following code and to resize a chart on a report: Public Function CreateChart(ReportName As String, ChartObjectName As String) Dim Rpt As Report 'Dim grphChart As Object Dim grphChart As Graph.Chart Dim msg As String, lngType As Long, cr As String Dim ctype As String, typ As...

I have the following code: Dim Rpt As Report Dim grphChart As Graph.Chart Dim msg As String, lngType As Long, cr As String Dim ctype As String, typ As Integer, j As Integer Dim recSource As String Dim colmCount As Integer, chartType(1 To 6) As String Const twips As Long = 1440...

Sorry, I should have also asked: If the colour is stored as a long integer, how can I use VBA to get the RGB equivalent or the font colour number eg 65280 = RGB(??, ??, ???) or 65280 = HexNumber and then I can use ChrisO's code to conver to RGB

If a colour is stored in Hex format, how can I use VBA to get the RGB equivalent or the font colour number eg #9999FF = RGB(153, 153, 255) = Color 17 Thanks in advance

I have the following code: Public pubChartAreaBorderLineStyle pubChartAreaBorderLineStyle = "xlContinuous" With grphChart.ChartArea.Border .LineStyle = pubChartAreaBorderLineStyle End With Access throws a syntax error 1004 on .LineStyle = pubChartAreaBorderLineStyle If I change the code...

To change the backround colour of a control using vba I would use: me.ControlName.BackColor = ColourNumber, eg #ED1C24 for red I would like the user to select their own colour. If in design mode, I select: control, properties, format and hit the build "..." button on Back Color, a list of...

Which question? Thanks

I need to import data from csv files into Access. The problem that I have is that the format of the cvs file can change. Some have 5 columns od data, some have 6. Also the contents of the first row change! I can handle the changes in the data if the data is available in an Excel spreadsheet...

I want to report data in a pivot graph Typically the data is the following format: DateTime (x-axis) LoggerSerialNumber (can by multiple - multiple lines) TemeratureReading (data) I also want to be able to: Change title Change X Axis label I thought of having fields a form for the above) I...

did you come right? I have the same issue!

I am new to charts! I am looking for a sample database which includes the vba code to create pivot charts Can anyone assist? I am using Office 2010