Search results for query: *

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.

I think the amount of prep time will depend on your PM expertise. I took about 2 weeks off and on of prep. Also check out Self Test Software's practice test - that will give you something good to go with too. www.selftestsoftware.com

I received my Project+ cert in 2003 and then took the upgrade exam in December 2003. IMHO: I have found that it says volumes about the fact that you have IT skills, but also business skills that make you more valuable to an organization. FYI: The newest exam has less IT-specific topics on it...

Which test are you going to take first? Are you experienced with VB or C#? That will definitely affect which prep materials you select. Also, you'll want to get a good practice test such as Transcender or Self Test.

Duh...Nevermind...I didn't check the Data Entry property... Thanks anyway!

I have a form frmAnalysisDetails. My switchboard has two entries. One that opens the form in Add mode and another that opens the form in Edit mode. The option to open the form in Add mode seems to work fine, but the option to open the form in Edit mode, comes up in Add mode. I only see one...