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!

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

Recent content by karweng

  1. karweng

    Query returns all columms instead of the select ones.

    Thanks dhookom, that fixes the problem by unticking the option to "output all fields
  2. karweng

    Query returns all columms instead of the select ones.

    Hi, My Microsoft Access 2003 is giving this problem lately. When creating a query in Access 2003 it returns reults from all the columns in the table instead of the selected ones. This is happening on any access database and from any tables. I have tried uninstalling Microsoft Office 2003 and...
  3. karweng

    Border Manager Access Log

    Hello, I'm not sure why this option is greyed out in NWAdmin tool's menu. The snapsin loaded correctly.
  4. karweng

    Border Manager Access Log

    Hello, Can anyone tell me how can I access or retrieve the users access logs from Bordermanager Proxy either from accessing from web browser or from a text file? I'm not sure the version of Bordermanager we are using, but it's running on Netware 6.0
  5. karweng

    BorderManager Proxy Users Access Logs

    Hello all, Can anyone tell me how can I access or retrieve the users access logs from Bordermanager Proxy either from accessing from web browser or from a text file? I'm not sure the version of Bordermanager we are using, but it's running on Netware 6.0.
  6. karweng

    SET TIME ZONE

    Hi HTH, Thanks for that.
  7. karweng

    SET TIME ZONE

    Hi there, Does anyone know the command to change the default date for Daylight saving for netware 4.11 server?
  8. karweng

    Filemaker 6 wont startup on Win XP

    Dear all, I have encounter a very strange problem with filemaker today, one of the XP Pro pc could not get Filemaker 6 to startup initialize, so I tried to disable some of the background services running and see if I have any luck, and it turns out to be if i disabled "workstation" service, my...
  9. karweng

    a report page with 2 columms

    Hello all, I got a crytal report which has a group header based on table.customer, the report only consist of 3 fields and there are plenty of space on the right hand side of the page. Is there ways to create a 2nd columm so that it will fill from up the page from left to right, if start of a...
  10. karweng

    sorting records by minimum of the same value

    Hi Mo, I think I didnt explain myself well enough and confused everyone, what I would like is, from table.A records to be grouped by Catalogue and sorted by the minimum Days, ResultA is how I would like the report to display.
  11. karweng

    sorting records by minimum of the same value

    Hi everyone, I have been asked to help generate a report sort the records by the minimum Days value of the same catalogue from table A to resultA, any advise on how to solve this? Table.A Catalogue Material Days 45478-2 INLAY BACK 1781 45478-2 INLAY FRONT 1781 SIC-0336...
  12. karweng

    run time error 3085. undefined function 'dmax' in expression

    Hi all, while trying execute this program from VB6 code, I got the above error message. Any idea how I can work around the error code or work around my coding? Dim rs_oriTable As Recordset Dim rs_table As Recordset Dim sql_ori As String Set db = DBEngine.Workspaces .OpenDatabase(App.Path &...
  13. karweng

    Sorting

    Ahh that's it, thanks Lespaul and dhookom.
  14. karweng

    Sorting

    Hi dhookom, when I tried the query to sort the by the minimum Days of the same catalogue, I'm not getting the exact result. It looks like it is sorting by the maximum Days of the same group. Catalogue Material Days SortBy SIC-0336 Inlay Front 1788 1777 SIC-0336 Inlay Back 1777 1777 45478-2...
  15. karweng

    Sorting

    Hi dhookom, adding another field is not possible, would it be possible to write a query based on table.A, and get that result? let me try to explain, one catalogue consist of one or more material.....every material with their own 'day', the 'day' can be different for every material of a...

Part and Inventory Search

Back
Top