Recent content by JAXDBase

Hmmm.. reassuring that at least in the IT field age does not matter as much. Maybe looks. As for me, I have been able to find a jobs with my skills and specialty in the DB track. 2 years Environmental Chemist overseeing the health of a Geothermal drilling field(for steam used for power...

COBOL Rules!!! but only in the banking and financial world. For what it was created to do, that is, process financial transactions or anything similar NOTHING beats COBOL. Admiral "Amazing" Grace Hopper (the first female US Navy Admiral) started and oversaw the development of COBOL...

XP will die a natural death because they are introducing it way too soon after Win2K. Heck, many biznezez are still using 98 and the smaller ones 95. Plus this added negative publicity and 9/11 will post low sales. MS will have to rethink then repackage the XP into something cheaper / less...

The media seems to de-emphasize the fact that because of the US Computer industry - we pioneered and still are the number 1 in IT technology/production. I believe that it is assinine for the previous administration to disassemble MS. Thank God! the Bush administration is keeping it together. I...

select distinctrow fldSUPPLIER as row source then resize /reconstruct your listbox to 3 columns. it should now do what you want. It will distinct the fldSUPPLIER only and pick the first occurence of all the other columns. if you have the know how to do VBA, create a recordset using the above...

Helo support eh? You fly? I would love to fly them but too expensive. Anyway, try this: Save this query in the query box and when you set the properties of the control source for the textbox, select from the dropdown the queryname you just saved that new query to. Or, you can type it directly...

Folks, Regardless of what arguments are exchanged as to the merits/demerits of MS vs opensource code and breaking up MS, there are still intellectual property rights and work and profit. Judges will usually choose the side of the owner of a property whether it be tangible(car, house, meat) or...

Folks, Regardless of what arguments are exchanged as to the merits/demerits of MS vs opensource code and breaking up MS, there are still intellectual property rights and work and profit. Judges will usually choose the side of the owner of a property whether it be tangible(car, house, meat) or...

This is correct referential integrity. RDBMS does not allow you to link a child table that is related to a parent with duplicate primary keys. The solution would be to normalize the table by either setting key dups = no or to add an additional key that will allow you to make each row distince...

Yes but ohhhh you have to work for it! Access has a utility to save your form as a webpage. Go read up the help or buy a book and follow the examples. To long to write here.

The autonumber feature does not reassign values to rows after deletion of 1 or more. This is designed to maintain referential integrity. By experience, the Jet DB is only able to handle autoincrementing for each row coming. It appears that a multiple row append is treated as a single unit and...

Try: I have expression: DoCmd.OpenTable "PhoneList", acNormal, "", "[PhoneQuery].[State]=[Forms]![Phone3a]![ByLocation3]" This Works! It should work since the OpenTable switches the object from a report to opening the table by running the query.

A shorter way to try and solve your problem would be to use the query builder and run the queries from there. The Access wizards are pretty good with syntax. If it works from there then just copy and paste the code you have developed from the SQL view(while in query builder) into your form.

Ahem, to put my two cents in, I write apps in both FoxPro (considered by many as a middle brother between MSSQL and Access) and Access 2K. I have found that Access allows you to create a nice front end to connect to MSSQL or FoxPro or the native Access tables, and I support the statements of...

You may want to go to the adobe website that describes how to do it. http://access.adobe.com/book5.html I have not done it myself but it has been brought to my attention as a need by my client. Here it is in it's entirety copied from the Acrobat webpage...