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 dencom 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 davidmcolaco

  1. davidmcolaco

    Report getting wrong data

    The query is running well so the problem is not on the query. The problem is on the report. The report is based on this query that is running fine and everything is ok, except for one field where it should appear a name and appears the code.
  2. davidmcolaco

    Report getting wrong data

    Sure, here it is: SELECT [RECOR].* FROM [RECOR] WHERE ((([RECOR].Sup)="Sup. H" Or ([RECOR].Sup)="Sup. P" Or ([RECOR].Sup)="Sup. C")) ORDER BY [RECOR].Sup, [RECOR].Departamento; Thanks
  3. davidmcolaco

    Report getting wrong data

    No, it's not. But when I run the query, everything is fine and appears the name I want to see, but in the report, I don't know why it doesn't.
  4. davidmcolaco

    Report getting wrong data

    Hi have a report that gets data from a query. Everything is fine, except for a field where it should appear a name, but appears the autonumber from the table where is that data. Can someone explain me why is that? Thanks
  5. davidmcolaco

    Find AP ip

    I already have access to the router web interface where have an option to show the dhcp clients, but the AP doesn't appear.
  6. davidmcolaco

    Find AP ip

    I use DHCP built into a switch from SMC.
  7. davidmcolaco

    Find AP ip

    And how can I look at dhcp? There is any command for that? THanks
  8. davidmcolaco

    Find AP ip

    Hi, I have a new AP in the network that is configured by a web interface. The problem now is that my router assigned an ip of our range to the AP and I don't know the ip of the AP so I can add new settings. How can I discover the AP ip address? Thanks
  9. davidmcolaco

    Copy changes on one table to another

    The problem is that right now I need to finish up this this week and I don't have time to read now.
  10. davidmcolaco

    Copy changes on one table to another

    Hi, What forces me is that I have a query to select twice values of that table to insert automatically some values, and the only way I could manage to do that was to create 2 tables with same values. Thanks
  11. davidmcolaco

    Format drive with fat32

    Hi, How can I format a hdd with fat32 file system on windows xp? Thanks
  12. davidmcolaco

    File system

    Hi, Just a question: Win NT4 supports FAT32 and NTFS file systems? Thanks in advance.
  13. davidmcolaco

    Copy changes on one table to another

    Hi, I have 2 tables with the same content, but one is linked to a form to change is values. What I need is that when something changes on table1, it copies the changes to table2, so they can always have the same content. Is that possible? Thanks in advance.
  14. davidmcolaco

    Change order in query

    So from what I understand I cannot use if and iif. So how can do it with the if or iff. Thanks.
  15. davidmcolaco

    Change order in query

    No, that was an error of the writing, but with: Sortfield: If([Supervisão]="Sup. Congresso", 1, If([Supervisão]="Sup. Programa", 2, 3)) I got that error I told before. Thanks in advance.

Part and Inventory Search

Back
Top