Search results for query: *

I have a piece of string which I need to cut into lengths. I need to determine the the number of cuts per lenght to minimise waste Say the length of the string is 100mm Example 1 I need lengths of 40mm, 20mm I would cut 2 of 40mm & 1 of 20mm Example 2 I need lengths of 30mm I would cut 3 of...

On a subform I have an unbound field, called TotalValue, =[Quantity] * [Price] In the footer of the subform I have another unbound field, called SumTotalValue, = Sum([Quantity] * [Price]) If I change records on the main form the unbound field called SumTotalValue sometimes flashes "#Error" This...

How can I set the size of a "Pop up" form using vba? When it opens, not all the fields are visible and I need to manualy increase the size of the form.\ Thanks in advance Tim

I have an Access 2000 database. The backend (data) resides on a network drive. On the front end I have an append query. Occassionally when I run the query I get the run-time error 3049 - Cannot open database 'query name'. It may not be a database that your application recognizes, or the file...

I am looking for guidelines / recommendations / suggestions about which fields in a database to index. Is it poor design to index too many fields?

I have a parameter query based on fields in a form. If I populate the form and manually open the query, records are correctly returned. If I use the query in a recordset (the form is open and correctly populated) the vba opening the recordset returns a run-time error 3061 - Too few parameters...

To write to a csv file I use: intFile = FreeFile Open "C:\Output.csv" For Output As #intFile If the file already exists, how do I add to it?

I have an Access 2000 database that runs on a peer-to-peer network. If I rebuild it, it is very fast but slowly the speed The problem is the database tends to run slowly over time. If I rebuild it it is very fast but slowly the speed degenerates I want you to look at his network because I want...

I have an Access 2000 database that runs on a peer-to-peer network. If I rebuild it, it is very fast but slowly the speed The problem is the database tends to run slowly over time. If I rebuild it it is very fast but slowly the speed degenerates I want you to look at his network because I want...

I use cdo to create e-mails How can I include a graphic file in the message of an html e-mail?

The following is a section of code that I use to edit a chart in Excel. The code runs perfectly the first time. If I then close Excel and re-run the code, I get a run-time error 1004 - Method 'Active Chart' of object '_global' failed - on the last line of code below. Why is this? Public...

I open a form as a pivot table using: DoCmd.OpenForm "frmDataAnalsysPivotTable", acFormPivotTable How can I get the form header and footer to display? In the header I want to add a check box to turn the ShowPivotTableFieldList on/off. How do I do this?

If I insert an "X" Axis label to a graph, the macro recorder gives me: ActiveChart.ChartArea.Select ActiveChart.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis) ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Text = "X Axis Title"...

If I create a line chart in Excel, using vba, the X axis normally starts at 1 and increments by 1 I want to specify my own axis, e.g: 0.2, 0.4, 0.6..... How do I do this?

In Access 2007 I have a report that contains a chart. I need to be able to change the series of the report, because sometimes it can have one series, other times three. What I have is the following: Dim Rpt As Report Dim grphChart As Graph.Chart Dim recSource As String DoCmd.OpenReport...