Search results for query: *

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

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

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

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

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

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