Search results

I repopulated an existing table. I just found that when I used that table and another table and created a relationship, that also should work because they have the two fields in common,ie PlanID, no records are displayed when I run the query. I have no idea what is going on.

I have an application I have been using for a few weeks. Today when I repopulated a table the queries associated with that table remain empty. Any ideas on why this might happen? I have made no structural changes to the table. Thanks. k

Can anyone tell me why this statement is not working? CurrentDb.Execute "UPDATE MainRptDataASD INNER JOIN CHPs ON MainRptDataASD.PlanID = CHPs.PlanID SET MainRptDataASD.PlanName = CHPs.Plan" I want to take the CHPs.Plan name and fill in those fields in the MainRptDataASD.planName At this...

Hello- I have the following sequel statement in a report: TRANSFORM Sum([CHValues]) AS [SumOfCHValues] SELECT (Format([Months],"MMM 'YY")) FROM [Chart Query 1st year Adj] WHERE [pmtyr] = 2004 GROUP BY (Year([Months])*12 + Month([Months])-1),(Format([Months],"MMM 'YY")) PIVOT [IPR]; When the...

You can set the 'filter' on a recordset like this: Set rst3 = db.OpenRecordset("SELECT " & yoursalespersonfield & " from yourdb where parameters") Then do the calcs you want and loop back to this with your new salespersonfield. k

I have four reports that only have footer components. I would like to take the 4 'footer' reports and collect them all as subreports in one report for display. Can that be done? k

thank you so much! k

I have a report that displays a chart. This report is based on a query that has 432 records. So, when I display the chart report I get 432 pages. I only want one. Can I fix this? k

Can someone explain to me the parts of a chart in Access? I need to make charts from data that was formerly in Excel now in Access. What makes up the x axis, the y etc... So I will know how to position the data in tables. Thanks.

Found it! The first subreport didn't have any Link Child and Master set so I changed the 2nd sub to match and that worked. Now everything is displayed. Thanks. k

The main and sub are both linked on PmtYr. That appears to be okay to me. Pmt Yr in both forms runs from 2004 to 2006. In the main form I just have titles and then two subforms the first with totals and the second showing the percent change. The first subform shows all data from 04 to 06...

I opened a third RS so I didn't change the first. Thanks for you help and setting me in the right direction. k

You can insert a field directly into the table into the position you want it to appear.

I have a subreport that lists out all the data when it is run on its own. When I include it in the main report it only displays part of the results.

I thought I was moving the pointer to a record so I could insert the next month's data in the same record as January's was recorded. So I don't know what the 'set rst =' line is doing? It is reseting the db?

I have the following code: Do While rst.EOF <> True myYear = rst.Fields("PmtYr") myIPR = rst.Fields("IPR") myCat = rst.Fields("ASD") myVal = rst.Fields(TotmonVal) rst.MoveNext If rst.EOF <> True Then myNVal =...

I have the following code: Dim rst As DAO.Recordset Dim db As DAO.Database Dim rst2 As DAO.Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("MainRptDataASD Totals") rst.MoveFirst . . . If myVal <> 0 And rst.Fields("PmtYr") < 2005 Then 'Find the next year matching ASD(myCat)...

That worked great! Thank you so much.

I have the following code in an Access module: UPDATE MainRptDataASD SET PlanName = (SELECT Plan FROM CHPs, MainRptDataASD WHERE CHPs.PlanID = MainRptDataASD.PlanID) I'm getting this error: Operation must use an updateable query. This is an updateable query. I perform other updates and it...

Hello- I have a Private sub (code behind a form) that I would like to call to a sub within the same form. The code abbreviated is as follows: Option Compare Database Private Sub Form_Open(cancel As Integer) Dim rst As DAO.Recordset Dim db As DAO.Database Dim rst2 As DAO.Recordset Set db =...