Search results

PERFECT... Worked like a charm. Thanks

I have a table that has a field for month represented by a number. I would like to report by month but group by year. The report would group months 1-12 into year 1, months 13-24 into year 2, months 25-36 into year3, etc..... up to possible 20 years. Is there an easy way to identify and group...

Hey Paul. I thought of that but didn't know what criteria to use. I filter the table down to the records related to the ProposalID only. There should only be a few records associated with each ProposalID maybe 5-6 max. Usually 2-3

I have a table tblExtInc that has multiple records with fields StartYear EndYear Amount Inflation Freq Source 2 8 1000.00 .02 12 SS 6 10 2000.00 .00 12 Pension Here is the code I have to Update a table tblExternalIncomeSchedule It works fine and...

I am the first to admit I struggle with looping through records.:banghead: I am trying to loop through a table and collect external income data and write it to a new table. My issue may be the way the table is laid out. ??? The attached pictures show the tables. The tblExtInc is where the data...

No problem I have 2010 as well

If your want to post your db or just the a sample db with that table and form. I'll get it working. I'm retired and am looking for something to do.

Do you get a value if you "force" the lookup using ex.1 or 2 or some value that is in the table? Try using Me.Refresh after the code

Verify that txtAssetNumber is a number. Then try Me.txtDetectorNumber = DLookup("DetectorNumber", "AmmoniaDetectorT", "AssetNumber =" & 1) or Put a value you know is correct (where the 1 is) and will lookup in the syntax to verify it is working. I have also found in the past sometime if I...

Or try Me.txtDetectorNumber = DLookup("DetectorNumber", "AmmoniaDetectorT", "AssetNumber = " & Me.txtAssetNumber)

Try this Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec Me.txtAssetNumber = Forms!DetectorManagementF!txtAssetNumber Me.txtDetectorNumber = DLookup("DetectorNumber", "AmmoniaDetectorT", "AssetNumber = Me.txtAssetNumber") End Sub

I have a tabbed control form that I an using as a survey form. It has Next and Back buttons to navigate the survey. Is it possible to disable the navigation feature of the tabs and allow the user to ONLY use the Next and Back buttons? Right now I have a label plastered over the tabs - It works...

Thanks. That moves the box to the right. How do I "reset it" to the original position? How do I move it to the left? I have an on openevent Box1.Left = Box1.Left + (Me.RiskIndex * 10 + 500) If RiskIndex is 40 then it moves it to 400+500=9000 If the next time I open the form and RiskIndex = 10...

Is it possible to move a rectangle control using code? I am trying to create a visual representation of a number on a linear scale. I have a control named RiskIndex which will have a value of 0 - 100. I would to "Slide" a rectangle named Box1 along a line from 0 = Far left to 100 = Far Right...

Error 2501 OpenReport action canceled. Also I do not have any error handling code that is trapping it.

I tried that and yes the report name is correct. Still have the issue.

I get the OpenReport action canceled when trying to open a report using Private Sub Command21_Click() DoCmd.OpenReport "rptNet Worth", acViewPreview End Sub The report opens fine directly from the database.:banghead:

Yep. I missed that. I was thinking I was looking for an integer when you are correct I was using x as a string. Thanks.

Thanks for your help. I ended up changing the field column names ( I think it was confused with the column name as an integer) and using Me.rdt = DLookup("age" & Me.spouseage, "TblJoint", "[OldestAge]=" & Me.clientage) IT works as needed.

That returns value of x (me.spouseage) This works Me.rdt = DLookup("[55]", "TblJoint", "[OldestAge]=" & Me.clientage) so the issue lies with x. x or [55] is a field column name. Could that be a problem? Should I rename the columns to age55 or age56 or age57 etc?