Recent content by stardusty

PB, Does =Format(Date(),"Long Date") work? Brent

In your originating table create a numeric field that you will eventually make a primary field. Number from 1-36 in that field for respective first through thirty-sixth animal. Create a query based on your originating table, where the criteria for your newly devised numeric field is ">8". Brent

M, If I'm following, using the extra space is going to exhibit 8 more of your present total of 36 animals. That prints out half (16) of your animals. What will you do with the other half? Brent

You could sum them in a report that groups first by club, then second by their schedule (parttime or fulltime) and then sums the part and full time employees in the schedule groups. Create a text box in the schedule group header; sum with =count(*) as control source.

Here's a fairly milked description: http://support.microsoft.com/default.aspx?scid=kb;EN-US;209769

Have you tried a serial queries? Certainly there is a more elegant answer to your quest, but work must be accomplished and none other have come to your aid. Set up the first query to ask only for the "less than" values of the minimums from the table of chemical data. Set up the second query...

A way to change the row height is to change the font size. With the picture, using a resident graphics program such as Microsoft PhotoShop Editor, change the jpeg to bmp. Hope those help. Brent

Can't explain the how or why, yet copying the database and opening the copy in 2000 allowed for the Preview Report CommandButton to become visible. Then, opening the original version in 2000 made available the Preview Report CommandButton that had not been displayed in 2000 previously.

This is curious George. After developing a database in 97 that includes an Options form that displays a list of OpenReport buttons, I then trained users on 97 and users on 2000. Returning from the trainings, I created another button for the list of OpenReports on the Options form to open a...

Agreement with the many comments on it being more professional. 1. the graphics tend to pull ones attention off to left. if you could displace the white guy segment on the left over to the right with soft transition from keys to guy, it may cause the eye to rest left, hence nearer to list...

Jack, Thanks. Works like it should. Brent

I have a combo box pulling a record from a table other than the one the form is sourced to. Users look for client's in the dropdown to automatically populate a set of the form's text boxes. At times the user will type into the combobox in search of a client, who happens not to be in either...

difference between dates Check this link and see if it helps. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=39034&highlight=difference+between+dates

fk foreign key One or more table fields that refer to the primary key field or fields in another table. A foreign key indicates how the tables are related ¾ the data in the foreign key and primary key fields must match. For example, the Products table in the Northwind sample database contains...

Rich, Thanks for some light in this tunnel. Given that "Some fields in...form, NewReferrals, need to be bound to the corresponding fields in tblClientDataCollection. Other fields on the form are bound to fields in tblDataMartClients," is the...