Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: psimonnyco
  • Content: Threads
  • Order by date
  1. psimonnyco

    splitting a database - where does front end file go?

    Hello I am splitting my 2007 .mdb by using the Database Splitter. I am following these directions I see that the back end (be) file is created but I'll be damned if I can figure out where the front end file is going. Any ideas? Thanks. How to Split a Microsoft Access Database Splitting a...
  2. psimonnyco

    Compiled Reports in CRX?

    Hello I am running CRX and we use Control M to schedule reports. According to the company's website, you can create a .EXE and run it on the Windows Command prompt. The problem is (as you will see below), there's no REPORT, COMPILED REPORT functionality in CRX. Evidently, this has changed...
  3. psimonnyco

    exporting steps in Macro to temp table in Access

    Hello I'm not a big fan of the Documenter and need a quick way to export the arguments in a macro to a tbl in Access. A while back, a friend of mine showed me how to create a temp table of all objects in a .mdb to a file with object type. I imagine that this can be done as well. Any help...
  4. psimonnyco

    grouping/report formula question

    Hello I have CRX and SQL Server 2000. In the time record table, I have the following: EMPLOYEE, PAY CODE, HOURS, WAGES 123, 01, 40, 1000 456, 01, 20, 500 456, 01, 24, 1000 ETC. On the employee table, I have: EMPLOYEE, RATE 123, 1000 456, 1400 I'd like to be able to write a report that...
  5. psimonnyco

    Windows XP Pro Not recognizing USB 2.0 devices

    Hello Gateway/MPC have been unable to help me. In the device manager, I have multiple USB Root Hubs, something that may well be causing my computer to be confused. As a result, my external hard drive, blackberry, iPod, and the like are often (usually) not recognized. Uninstalling the...
  6. psimonnyco

    maximum based on multiple fields

    Hello I am running CRX. I have easily done a maximum(check_date, employee) calculation to pull an employee's latest check date. I did my group on EMPLOYEE and got one record per employee (although the employee has multiple checks). The following is vexing me, though. EMPLOYEE, PLAN_TYPE...
  7. psimonnyco

    'second pass' error - CrossTab

    Hello I'm running CR X against SQL Server. I have a 'second pass' error and am looking for a simple solution without a custom view. I have a transactional table with transactional data, sampled as follows. EMPLOYEE, HOURS, PAY CODE 1, 40, REG 1, 2, REG 1, 10, OVT 1, 8 VAC 2, 40, REG 2, 10...
  8. psimonnyco

    cross tab rpt: function cannot be used; it must be evaluated later

    sfd Hello I'm running CRX against SQL Server. I have a 'second pass' error and am looking for a simple solution without a custom view. I have a transactional table with transactional data, sampled as follows. EMPLOYEE, HOURS, PAY CODE 1, 40, REG 1, 2, REG 1, 10, OVT 1, 8 VAC 2, 40, REG 2...

Part and Inventory Search

Back
Top