Recent content by hyperiest

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"

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...