Search results

I created an app that used the 10.0 library and a field office that recieved the app is using the 9 library. They are having difficuties getting buttons on forms to work. They are getting a 2580 error something about the SELECT statement. Could the library be the problem and if so is there...

So I did some searches and came up with 'perhaps the leading character is not a space, in which case TRIM would not work. I placed this in my code mplan = LTrim(rst.Fields("Service Bureau ID")) Asc (Left(mplan, 1)) -- this was a 48 (in the lookup table a 0) The situation is that the mplan...

I have a MAIN table with autonumbering for the project number. In a table related to the MAIN table I have a project number that I want to be updated when the MAIN table has a new project entered. Can I keep these in sinc automatically?

I did a google search on this but didn't hit on the answer. I want to prevent users from using an old access application form by placing a password on the form load. Thanks.

I wrote an application that has now been sent to a field office for use. It works fine in our office but the field is having problems with some of the reports. Some work fine but some return an runtime error message 2580. The line that is failing is a docmd.openreport "RptName"...

I have the following statement: PIHP_CMHSP_MHP.Value = DLookup("PIHP-CMHSP-MHP", "PIHP", "countycd = " & Combo2.Value & " and PFcd = " & Combo8.Value) The combo2 and combo8 values are both correct but I get an error "Runtime 2001. You canceled the previous operation." when I reach this line...

I have a report that displays fine when displayed on its own. When I include it with two other reports, as a subreport, the top line is repeated twice. I have tried rebuilding the report, and looking at the data in the table which is fine and listed only once. Any thoughts on how I can...

I have a table with data from many months as follows: Jul-06 Aug-06 Sep-06 .32 .55 .64 .44 .75 .52 .56 .33 .48 I want to place the data from just column Sep-06 in another table. Is there an SQL statement I could write to do something...

I have the following line of code: CurrentDb.Execute "INSERT INTO ChartTableC (ordernum, program) SELECT (" & kordernum & ", '" & kprogram & "') from trendanalysis" I'm getting a runtime error - syntax error (comma) in query expression. I just don't see the problem. m

I created a macro (OpenAllrpts) that opens 7 reports. In the argument section I have listed the name of the report and Print preview. In the code behind the form the user will use I have docmd.runmacro OpenAllrpts. I'm getting an error that an argument is needed. What do I do?

I have the following code: Option Compare Database Global theDate As String Public Sub GetDate() theDate = InputBox("Enter Volume Date YYYYMM") mymonth = Right(theDate, 2) then this sub calls another module sub. When that module is opened the global variable theDAte is not recognized...

I have this code in a module in Access: CurrentDb.Execute "UPDATE Matchonyyyymm Set FirstDate = 'Y' WHERE MISSN = '" & fssn & "'" The MISSN is a double data type in the table. The fssn is a varient/double in the code. I get a data type mismatch on this line. Can anyone tell me what I'm doing...

Hello- I have an Insert statement that has a dozen fields that update just fine. One field in the list remains blank after the module has completed. I have checked on the data type, field size etc.. and everything matches. If I change the field size to 2 it fills the field with the one digit...

I have the following lines: Set rst3 = db.OpenRecordset("SELECT * from MainRptDataASD where PlanID = " & MyPlanID & " and PmtYr = " & mypmtyr & " and Ltrim(ASD) = ' " & myASD & " ' and Ltrim(IPR) = ' " & myIPR & " '") If rst3.NoMatch Then CurrentDb.Execute "INSERT into MainRptDataASD(PlanID...

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...

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

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.