Recent content by whatever

Check this, which is a cost option but at $99 it seems to do what you want and it may be cheaper than doing it yourself. http://www.ammara.com/support/samples/showsamf3bc.html This is what I have used. HTH Kevin

Just a guess but if your contact number field is a sting then you need to include single quotes to either side of the contactNo field: stLinkCriteria = "[ContractNo]='" & Me![ContractNo] & "'" HTH kevin

Here's how I do it using a combo box under a graph object ("gphArrsNoData2"), The combo box("cboRowSource2") has the chart type (column(7)) and axis minimum and max as columns read from a table, the afterupdate event of the combo box includes this: With Me...

Darrellx, The problem appears to be the recordsource of the subform includes fields from the product table. I would: 1. Change the row source of the subform to be just from the inventory table. 2. Link the subform and main form on product ID. 3. Add a command button to the main form that...

The problem is where you start from for each product and how each of the rows work. You need to decide what the definition of the starting position is, is it: 1. Last stock take + (acqs - invoice) since stock take until start date, or 2. Opening position + (acqs -invoice) until start date...

Nice DB, I think the issue is with what you are calculating on each row. I think for each product group you should have an opening position then you should add each aquisition and remove any disposal as a row an then have a group total which should be your on hand amount.. The starting...

Assuming your data looks like this: ID Date Company Track 1 1/1/2006 "comp 1" Technical 2 2/1/2006 "comp 2" Sales 3 2/1/2006 "comp 3" Technical 4 2/1/2006 "comp 2" Sales 5 1/31/2006 "comp 2" Sales Then...

I would tackle this with a linked subreport. 1. Create and save a new report which lists all your client visits, this will be your subreport, you need to include client ID on this report. 2. Create a new master report which has a page per client again including Client ID. 3. whilst in design...

Rich, thanks for the suggestion but no joy I am afraid, I think the page skip bypasses the detail row format and print events, any idea how i work out if the report is open in print preview? thanks Kevin

Greetings one and all, I have a problem with an Access 2000 report for which I cannot find an answer so any assistance you can provide would be great. The report is a statement of account, similar to a bank statement, which lists all relevant transactions with a running sum balance on each row...

I hope you get this working but I would just add a command button which selects everything in the list then your code can stay the same and you can avoid the "Add All to List" complications... which will involve you changing the SQL criteria depending if 'all' has been selected. Good Luck. kevin

Change This: stSQL = "SELECT * " SELECT qryTECRateListBox.*, * FROM qryTECRateListBox WHERE TEC IN ("& Me!txtCriteria & ") stSQL = stSQL & " IN (" & Me!txtCriteria & ")" to : stSQL = "SELECT qryTECRateListBox.*, * FROM qryTECRateListBox WHERE TEC IN ("& Me!txtCriteria & ") " debug.print...

I have had a quick look and can find these : 1. The too complicated error is due to the field TEC being defined as text so you need to build quotes round your parameter string e.g. stWhat = stWhat & "'" & Me!TEC.ItemData(vItm) & "'" enclosing a single quote in two doubles to build the string...

Make sure you have a reference set to DAO and try this: Private Sub cmdSelectList_Click() On Error GoTo Proc_Err Dim mydb As DAO.Database Dim rstPeriod As DAO.Recordset Dim lst As ListBox Dim intPlaceHolder As Integer Dim strSQL As String Set lst = Me.lstStaff Set mydb = CurrentDb() strSQL...

Nearly there, but you need to open the SQL as a recordset then step through each row in the recordset then compare against all the rows in the list box. If you get stuck PM me.