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 gkittelson 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: Brianus
  • Order by date
  1. Brianus

    CODE TO PRINT REPORT HEADING ON EVERY PAGE

    The report will be generated thru VB (By clicking on a command button on a VB form) Thanks.
  2. Brianus

    CODE TO PRINT REPORT HEADING ON EVERY PAGE

    some of the reports will be coming from MS Access tables and some from excel. Thanks. BM.
  3. Brianus

    CODE TO PRINT REPORT HEADING ON EVERY PAGE

    Hello intellects, Please, what's the appropriate VB code to print my report heading on every papge when printing? Thanks all for your anticipated help. BM.
  4. Brianus

    ACCESS VBA TO INTERFACE WITH A DATABASE IN SEQUEL SERVER.

    I have two prime questions: 1) I am working with access vba, but my input files are located in a database in a sequel server environment. What codes can I use to call or access the database/files in this sequel server? 2) Also, this same Access vba project utilizes input files located in...
  5. Brianus

    HOW TO EXTRACT TIME FROM A DATE STAMP.

    Ladies and gentlemen, please I need your help: Date stamp: 02/13/06 19:45:22 is there a function in VBA/VB to extract the time stamp(19:45:22) from the above date stamp, rather than using the Left$, mid$ and right$ functions. What is the appropriate code? Thans a mil. B.
  6. Brianus

    LOGIC/HOW TO PROCESS A SPECIFIC RECORD IN A TABLE THAT HAS DUPLICATES.

    If I understand it, I wouldn't be asking. Could you please elaborate a little? Thanks.
  7. Brianus

    LOGIC/HOW TO PROCESS A SPECIFIC RECORD IN A TABLE THAT HAS DUPLICATES.

    Re: Response from Remou. Thanks for your valuable input. However my question is: where is "tblog A" coming from? Is that a separate table that I am creating? My confusion: WHERE (((tblLog.[date/timestamp]) In (Select Max([date/timestamp]) From tblLog A Where A.EmpNum=tblLog.empNum))); Thanks...
  8. Brianus

    LOGIC/HOW TO PROCESS A SPECIFIC RECORD IN A TABLE THAT HAS DUPLICATES.

    Table format: Empnum |perendate |date/timestamp -------|----------|---------------- 0500 | 10/2/06 |10/22/06 13:25:52 0500 | 10/2/06 |10/22/06 13:20:50 0200 | 10/7/06 |10/22/06 13:25:42 As you can see from the above table, two of the records are identical - obviousy a duplication. The...
  9. Brianus

    HOW TO SEARCH MULTIPLE FIELDS IN A RECORDSET(TABLE) THEN UPDATE ANOTHE

    Note: The tables was designed by a VB novice, so pardon the sloppiness. inputtbl: projid name hours ==== ==== ==== 5555 John 20 5555 Bill 15 outputtbl: projid name1 name2 hours1 hours2 ==== ==== ==== ==== ==== 5555 John Bill Note: The field “hours1” belongs the person in field “name1” And...
  10. Brianus

    How to do effective Sum function in VBA coding

    I am trying to perform a sum on a field in my table. Table layout: ============= Projid monhrs tueshrs wedhrs thurhrs frihrs totalhrs ------ ------ ------- ------ ------- ------ -------- 05528 5 10 1 2 3 05528 1 2 3 0 5 11547 2 5...
  11. Brianus

    Run-Time error 3122

    In VBA, I tried to execute the code below: SELECT Projid, projstatus, projdescription, Sum(tothrs) FROM Timesheettbl GROUP BY Projid; And I get the following error message: You tried to execute a query without including Projstatus as an aggregage function. How can I solve this problem? Thank...

Part and Inventory Search

Back
Top