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 derfloh 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: *

  1. hyperiest

    SQL 2KSP4, Win 2K3SP1, NT domain no TCP

    Thanx for the advice, mrdenny. I reinstalled SP4 and it is working just fine now. Captain_D "Taking Care of America's Sons and Daughters"
  2. hyperiest

    SQL 2KSP4, Win 2K3SP1, NT domain no TCP

    mrdenny, thanks for the prompt response. When I ran netstat, nothing else was using 1433. I am one of the SysAdmins here and am completely confident that we have no DoD software installed that is preventing listening on 1433 (we have Win2K/SQL2K machines that listen on 1433 just fine). I have...
  3. hyperiest

    SQL 2KSP4, Win 2K3SP1, NT domain no TCP

    Ok, this is my first post on this site in a long time. Please excuse me if I am asking a question that has already been asked and answered a dozen times on this site. I have been beating my head against the keyboard for so long now that I no longer have time to browse the thousands of posts on...
  4. hyperiest

    Font size and mail merge

    AARGH! I have a Word(2000) template for creating certificates with data stored in an Access2K database. I have figured out all the switches for formats, except one: fonot size. The problem I am having is that in one case, the merge field resizes itself to 12 point on its own. I have set the...
  5. hyperiest

    FTP Batch file

    Nope, didn't work. The code you gave still did not check for connectivity prior to beginning the data transfer. Not only that, but since the systems reside on multiple different domains, mapping a drive is not possible. I think I will end up using a custom configurable ftp upload setup...
  6. hyperiest

    FTP Batch file

    Thanks, Airshot. I will take this and see if I can mod it for secure ftp, since all my clients are remote systems on different domain servers on different domains. I think this is do-able, but my chief programmer at work tells me he needs me to buy Microsoft Visual Studio.NET Full version...
  7. hyperiest

    FTP Batch file

    Is there any way to write this to include a connectivity check before ftp transfer? I , too, am pushing files from one system to another, but as it will run as a scheduled task (.bat), I need to ensure that the users who transmit to me have connectivity established before the the batch file...
  8. hyperiest

    Deleting relationships with a macro

    I saw that in your code, you had it set to delete the name of the parent table, so I changed mine to reflect the child table, as it is the child table that I am trying to replace. Then I saved it and put it into my macro after the DoCmd.CopyObject "C:\CORPS-PSB.mdb", "&quot...
  9. hyperiest

    Deleting relationships with a macro

    I have designed and support a data reporting system based on Access2K that allows subordinate organizations to report their data via email. unfortunately, as many of the organizations are not geographically co-located near me, I have to write all of my updates and email them to my subordinate...
  10. hyperiest

    Cross Tab query

    I, too, once had problems writing parameterized crosstab queries. I have it down pat, now, but follow this link to see what it took to figure it out: http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=212272&page=&view=&sb=&o=&vc=1#Post212272 You can read the entire post...
  11. hyperiest

    Totaling Columns in Access Crosstab Queries

    erich13us, yes you can total the columns and calculate percentages, but you will need to run a select query off of your crosstab query. You can create fields in the select query to calculate your percentages, then use column sums in your report to calculate your totals. Don't forget to force...
  12. hyperiest

    Multiple parameter fields and crosstabs

    Well, I just about have this x-tab thing down, but I am still floundering on how to write an SQL statement to include parameters (with wildcards) in more than one field within the query. I have had success creating parameterized crosstab queries with parameterized select queries on them, but...
  13. hyperiest

    TransferText Macro and Specification

    Jim, I understand all this perfectly and thank a mil, but is there any way to view a specification created earlier? It was originally created by the creator of the datasource I am using, but he tailored it for his table; mine is slightly different. I wanted to see if I can view his...
  14. hyperiest

    TransferText Macro and Specification

    I have a database for which I use text delimited text files from another program to update. I have previously designed a class module in VBA to import the text file into Excel, convert only the columns I want and then import the spreadsheet into Access. A friend of mine told me I could do the...
  15. hyperiest

    Select records by most recent effective date

    The table lists records pertaining to personnel authorizations in military organizations. The authorizations change annually, so sometimes the authorizations from a precious year do not carry over into the current or future years. If within an organization, e.g., WATBAA there existed a record...
  16. hyperiest

    Select records by most recent effective date

    This worked to an extent. However, some of the authorizations no longer exist, but they still show up in the query results, as there is no record corresponding to it with a more recent effdate value, but I need to screen out these records as well. Captain_D
  17. hyperiest

    Select records by most recent effective date

    I am attempting to write a query to select records from a table that are identical except for the effective date of the records. The table looks somthing like this: UICDR PARA LIN Auth EffDate WBTAAA 101 02 3 2003/10/17 WBTAAA 101 02 3 2002/09/18 WBTAAA 101...
  18. hyperiest

    Cross Tab Query Criteria

    I have had similar difficulties with criteria and crosstab queries. If you create a base query with criteria prompts upon which to run your crosstab, you will get these errors. What you need to do is create parameters within which to run your crosstab query. You can do this either in the...
  19. hyperiest

    Concatenated values with Autonumbers

    I am trying to create SKU numbers for my wife's inventory database. The idea is to generate numeric strings based on Autonumbers associated with certain items' product ID (bowls, plates, etc.), the items' pattern ID (121a, 164, etc.) and the product number, each in its own table. I then write...
  20. hyperiest

    Parameter crosstab queries and multiple values

    OK, took a week off and re-grouped -- now back in the office for some catch-up work. I have all but conquered the SQL for parameterized queries, but now another twist: how do you write the SQL statement for a parameter query when you want to be able to query records based on a single or...

Part and Inventory Search

Back
Top