Search results for query: *

I recently upgraded to Office 2003 pro, and told it to get rid of 2000. Realized too late that some programs (such as FMS Develper Suite) do not yet include the components to work with 2003 version-single compnent ugrades are just too expensive. Speed Ferret has not yet released a new version...

Windows 2000, rplaced pcAnywhere 105. qith 11.0. SLOW, fuzzy painting of screens, scrren too big, even with screen scaling. Could not get drop down arrows to work in MS Access program, nothing on Symantec site about this. Gave up and un-installed 11.0, went back to 10.5 and wokrs like a...

janetlyn, Catching up on tek-tips after being away for a while. Presuming you found this thread doing a search-glad it was helpful! montrose Learn what you can and share what you know.

sailorripley, It doesn't appear that you've got your entities and attributes clearly defined. For example, your tblStudentInfo. You stated "Because we have open enrollment new students are enrolled into courses at any given day or time." Yet you have not allowed for the student's...

Dean, Glad you found it helpful. I think it's a good basic design. Best of luck, Montrose Learn what you can and share what you know.

Dean, You're 'sub-classing entities'. Here's an interesting example that may addrress your needs. http://www.mvps.org/access/tables/tbl0013.htm HTH, Montrose Learn what you can and share what you know.

carmo, Go to http://www.granite.ab.ca/access/autofe.htm Learn what you can and share what you know.

Ben Dalziel, They are, indeed there because of your queries-Access will make these 'indirect relationships'. If you don't want to see them just click on the button "Show Direct Relationships". Montrose Learn what you can and share what you know.

SG, I think you've got corruption in your database. This site http://www.granite.ab.ca/access/corruptmdbs.htm will give you more info. HTH, Montrose Learn what you can and share what you know.

Blue Monkey, Glad you've got it going well. Not sure if I'm following your last question?? A comobo box usually allows the user to see a list of choices and pick what they need. If you've got it bound to a field, then what has been selected is then entered into that bound field. The source...

Blue Monkey, In the combo box properties, Data Tab, set the Bound Column to 1 (one). On the Format Tab, set the Column Widths property to 0; 1.5. The use of the 0 (zero) for the first column width in essence tells Access to 'hide' that column and your actual data in column 2 (I just picked 1...

Blue Monkey, Could be just a one-to-many relationship. tblPictures PictureID (Primary key, Autonumber) (One side of 1:N relationahip) PictureName tblPictureDetails DetailID (Primary key, Autonumber) PictureID (Foreign key from tblPictures) (Many side of 1:N relationship) Category (Comes...

Nathan, Glad you got it to work. Will work anytime you have a one-to-many relationship. Best of luck in your future 'developing'!! Montrose Learn what you can and share what you know.

Nathan, If you have this set up as a one-to-many with cascade updates, you can just base your contractor form on the contractor tbl, and the subform on the job details tbl. Do your contractor form first. Make your job details subform. Then put your job details subform onto the contractors...

H. Jessen, See if this thread, "How to Increase number of menu items in a switchboard?" thread700-174910 helps. Montrose Learn what you can and share what you know.

Dennis, Have not had experience with converting from Peachtree DOS to Peachtree Windows. But I did convert from another DOS acccounting program to Peachtree Complete for Windows. Have you checked the documentation with the Windows version about converting from their DOS version? They used to...

Greggscott47, Calculations, per se, should not be stored in a table. However, the actual 'updating' of your quantity will most likely be done through a query. If you post your table structure, may be able to help more. Or you can re-post your question in the Microsoft: Access Queries and...

mcarey101, DDE gas been supported by Peachtree. Don't know how to do it myself, but see this link for an example: http://www.acctadv.com/accessdde.shtml HTH, Montrose Learn what you can and share what you know.

dallaswoz/Scott, Have you tried to do this using a main form and a subform(s)? If your relationships are set up correctly, you can link the master/child fields between your main form and subform and the user will see just one form for entering data. HTH, montrose Learn what you can and share...

Happy2, "One Agent can have licenses in many states and one state has many loan programs"-you may need to modify your tbl structure. Access cannot resolve many-to-many relationships until you break them down into one-to-many relationships. This is done through the use of a...