Recent content by musicmaker

I have Access 2000. The table, in form view is where I am entering a large number of addresses. My first entry field is [ZIP CODE]. I want to be able to view all other enteries within this table/form that has the same Zip Code, when I enter a zip code into a new record. I want to see [Name]...

I have found in Access 2000, when you are in forms and you put a button on your form with the [FIND RECORD] function, it will NOT work on a field that has VB code attached to the [On Exit]. If you reroute the code away from [On Exit] the [Find Record] button will work O. K. Hope this helps...

Another way to set the default date on your calendar in(Access97) is: Go to Form Properties (the form where your calendar is located), Event Tab, On Load... VBA code: SelectDate = Now() Note: for this to work, the name setting of your calendar must be set to [SelectDate].

How to Input a calendar into a form: 1. Make room on your form for the calendar. Approximately 2” X 5”. 2. Press the last item on the toolbar. (It looks like it has a hammer over a wrench, on it.) 3. Choose Calendar. (by clicking on calendar) 4. Place calendar on form. (See below, last line...

The VB Code I posted only works with ACCESS 2000. Any older versions will not work. Below will work in Access97. DLOOKUP FUNCTION INV is a table name: field1 = RecNum, field2 = InvNum, field3 = Description SALES is a table name: field1 = RecNum, field2 = InvNum, field3 = Description Make a...

Put in VB code Private Sub Inv__AfterUpdate() 'NOTICE below field [Inv#] must be shown as [Inv_] 'because the # sign cannot be used in VB code. Me.Description = Me.Inv_.Column(1) Me.Brand = Me.Inv_.Column(2) Me.Model = Me.Inv_.Column(3) End Sub ANOTHER SUBJECT: In lookup, if you have...

Richie, Thank you so much for the above information. Q132017 refers to ACCESS 97. Q210261 is for ACCESS 2000. The web site is: http://search.support.microsoft.com/kb/c.asp Below is how it is done: The field name in this example is: UnitPrice There are five steps: 1.) Insert a text box in...

I need to report the page total at the bottom of each page. =Sum([fieldName]) works great on the Report Footer. (Last page only) Does anyone know a way to calculate a field's total for each page in a report? Thank you in advance for any help!!!

After twenty hours of research, I figured this out. Here is how to do it, if others are interested. There are three steps: 1.) Insert a Text Box in the Page Footer Section, then goto Text Box Properties, then Data (tab), and OnSource, enter: = [Page] next goto Format (tab) and OnVisible...

This is the requirement for the PAGE FOOTER: field name [varJim] On Page 1.... varJim = Summary Index On Page 2.... varJim = Page 1 of Details On Page 3.... varJim = Page 2 of Details On Page 4.... varJim = Page 1 of Misc. etc. Thank you so much in advance for any suggestions!!!

Thank You so much, Mr. Pat Hartman. This solved my problem!!!!

This is the requirement: 1.) First Page: Report Header ON and Page Header OFF. 2.) Balance of report: Page Header(s) ON. I have searched the forum regarding this. I found where Mr. Pat Harman has listed the flow of how reports go. He has stated on more than one occasion that the page header...

I need to remove the zero when the answer comes back ZERO. I need the field to be blank. Nothing in it. Thanks in advance for your help.

For storing calculations when using forms, I have found that if you write your formula in VB code instead of using the expression builder, that it stores the calculations in YOUR Tables! Example: NAME OF FIELDS (in your table) 1stAmt 2ndAmt 3rdAmt TotAmt Next, make a form. Then, Go to design...

Dear Terryb and DML I need to be able to do this also, however, I could not get it to work as outlined above. My expression builder modifies the above to a point where I get error messeges only! Can anybody tell me the correct way to solve this? Thank you in advance. My email address is...