Recent content by jjonesal

Check out these Oracle links: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=151 http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_042 If you start with 1z0-042, you'll get the OCA cert. Then, focus on the remainder in the...

Have you tried using forms & subforms or is that an option? j

What version of Access? j

In this part you compare site_number to the year: site_number=" & [Site_Program_Year] Those fields will won't be the same. Is that really what you want to do - those are different fields? right? j

What version of Access? j

What version of Access are you running? j

Use a group query such as: SELECT Table2.SiteNumber, Max(Table2.SiteProgramYr) AS MaxOfSiteProgramYr FROM Table2 GROUP BY Table2.SiteNumber; You can paste it into a new query based on the underlying table using SQL View (assuming you change the table/field names) or in Design View, create a...

Are you trying to do this in an actual report or solely using code? IMHO - the easiest way to do this if you are working with a report is to create a query that does the totals, such as: SELECT Table1.ProjectNumber, Table1.Status, Table1.ProjectName, Table1.ProgramName, Table1.PM...

Sure did. Funny, the owner doesn't have Administer privileges to it, but I get the same message. The only acct that has Administer privileges is Admin. I had removed "Admin" from the Admins group. So I tried adding it back. And tried logging on as Admin... still no luck. I'm stuck here.

I have a database that I have enabled for multi-user security. Created users and groups, and set permissions on objects. However, when I'm setting permissions, Access won't allow me to set permissions for the object name <New Tables/Queries>. It gives me this error message: You can't change...

Thanks - thought about that, but got about 3000 databases & some of which will need to be opened by 2003 and 97 users. Just don't want the 2003 users converting the file format (hence locking out the 97 users)

I currently have users that have both 97 and Access 2003 installed on their machines. We have many databases on the network that users access - some in 97 format & some in 2003 format. When a 2003 user opens a 97 format database, they used to get the Open/Convert dialog - and using the KB...

I’ve got a Lotus worksheet that has this formulas in one of the cells: 1/@FV(1,C14,C15) I’m trying to understand how Lotus interprets this…. I would have expected to see the @ symbol as the first character in the cell to denote that a formula was being used. If anyone can point me to a...

Yep...that's right. You are quite welcome! Best of luck on your exam!

It's the same thing. CompTIA used to call it IT Project+, but when that exam retired, they started calling it simply Project+. I've used both the Transcender and Self Test products. Neither is the real exam questions for the test, but great prep nonetheless.