Search results

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

ooops! my email address is musicmaker@aristotle.net

Dear TERRYB and DML I am having the same problem. I could not get what DML suggested on July 14,2000 posting, to work either. I have researched this whole website trying to find the correct way to do this. No luck so far. If anyone can help resolve this, please let me know how!!!! Thank you in...