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

  • Users: trudye10
  • Content: Threads
  • Order by date
  1. trudye10

    Can't pull Month from date

    I have a date that is stored as numeric in format yyyymmdd. I am trying to extrapolate the month from it and compare it to the current date. Is there a way to do a substring on a numeric field? Here is my code: SELECT DDLOAN, DDprod, DDOFFR, DDBLDT, DDMFEE FROM...
  2. trudye10

    Error Converting Julian date using DateSerial

    Hi Guys, I found this function to convert julian date online but I'm having trouble getting it to work properly. S_Date = DateSerial(1900 + (rs1!PDATE \ 1000), 1, rs1!PDATE Mod 1000) after processing 2007184 S_Date is equal to 7/3/3907. which is bascially correct it s/b 7/3/07? What am I doing...
  3. trudye10

    TimerInterval Problems

    Hi Guys, I am trying to execute a function every minute. It works the first time, the intervalTimer waits a minute before it exec the code the first time, after that it exec it every second. How can I get it exec every 60 seconds? Private Sub Form_Timer() Me![lblclockview].Caption = Time Do...
  4. trudye10

    Assigning File Types

    Hey Guys, how do I assign a file type to a specific software? Thanx much, Trudye
  5. trudye10

    Mail Merge horrors

    It seems that they MS has managed to take a task that has always worked and screw it up. Leave it to MS. You used to be able to place fields in Mail Merge where ever you wanted and that's Exactly where they would print. Now it seems MS supersedes your placement with their own. Here is how my...
  6. trudye10

    Update/Join - Zero Recs Returned

    HI Guys, I checked the Advance Search and fashioned my Update/Join after them. But for some reason it is not working. I created a SELECT query to insure my basic syntax was correct and it ran just fine. I ran a query in Access/SQL to insure my criteria was correct and I got back 2 records just...
  7. trudye10

    Concatenate/Update a record

    Hey Guys, I'm new to SQL Server and I have a question. I am trying to do concatenate 2 fields and 1 value into a new field. Division (nvarchar(2), null) Acct_Number (Nvarchar(11), null) Account_Number (nvarchar(20), null) I tried the following statement: update dbo.MCF set Account_Number...
  8. trudye10

    Restrict processing to a table

    Heey Guys, I have a question. A table in one of our databases is getting updated. We have no idea whose doing it (naturally everyone feigns ignorance), but it's not being updated in the program the table resides in, and the table is not linked to another database. Someone maybe updating it...
  9. trudye10

    Export a Report

    Hey Guys, I have a question. How do I export a report programmatically,(*.rtf). I tried transfertext but I don't have a spec for it. I know how to get a report for a file but not a report. In fact I'm probably taking the long way around to get the spec for the file. Thanx, Trudye
  10. trudye10

    A question about FTP sites

    Heey Guys, I'm not sure this is the right forum. Anywho, does anyone know how I can list the filenames on an FTP site. The actual object of the exercise is to track the time the file completed loading to the site. If this is not the correct site please let me know where I should have posted...
  11. trudye10

    PGP DOS Batch Invalid command

    Hi Everyone; I am not sure if this is the correct forum. I happened on your forum while searching FAQ's. I am having issues with my PGP DOS/Batch command. The msg I am receiving is: PGP is not recognized as an internal or external command. Here is my code: REM Import File "C:\Program...
  12. trudye10

    PGP command Invalid

    The last time I logged into this Forum I had a DOS/Batch command Filename Date problem. This time my DOS/Batch command problem is with the PGP command. The msg I am recieving is: PGP is not recognized as an internal or external command. Here is my code: REM Import File "C:\Program...
  13. trudye10

    3011 - could not find file

    I am receiving error '3011' could not find object. Here is my code. <html> <head> <title>Page</title> </head> <body> Function Export_Output() On Error GoTo WhyMe DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "tblEnroll_Error_Report"...
  14. trudye10

    Read Only Error

    Hi Guys, I'm having a problem with an Export. I read in FAQ that if the path+Filename is too long (> 64 chars.) that this will cause error 3027 (which is what I am getting). I changed the path+filename to 40 bytes and still I'm getting 3027. I checked the database and table properties and...
  15. trudye10

    Compact Dbase Error

    Hey Guys I searched FAQ and found the following code, however, it will not compile. Error Message (Method or member not found and it highlights .CompactRepair . I have included DAO 3.6, what am I missing? Function RepairDatabase() Dim strSource As String Dim strDestination As String Dim...
  16. trudye10

    Batch Command Filename Date

    I am not sure I am in the right forum but here goes. I am trying to get the syntax for adding a date to a filename in a Batch file. I know the command looks like: for /f "tokens=1,2,3 delims=- " %%i in ('echo %DATE%') do (set BACKUP=%%k%%j%%i) but that's gibbrish to me I a little slow, I need...
  17. trudye10

    Batch Filename Date

    I am not sure I am in the right forum but here goes. I am trying to get the syntax for adding a date to a filename in a Batch file. I know the command looks like: for /f "tokens=1,2,3 delims=- " %%i in ('echo %DATE%') do (set BACKUP=%%k%%j%%i) but that's gibbrish to me I a little slow, I need...
  18. trudye10

    Lock Vioations

    Heey Guys, I am having a problem with Lock Violations in a query. I am accessing files that reside on an SQL Server. I ran an Update query that produced the error. Is there anything I can do to get around this error. Thanx, Trudye
  19. trudye10

    IsDate problem

    Heey guys I'm still struggling with this yyyymmdd date format. The pgm will not recognize it as a date. I coded: If Not IsDate(rs1![Effective Date]) Then GoSub write_Exception GoTo KeepGoing End If rs1![Effective Date is yyyymmdd (ie. 20070131). It is writing an exception record...
  20. trudye10

    Reference Libraries Information

    Ok Guys, I found this code that has a file type of FILETIME, I know that it holds values such as Nanosecs. What I do not know is what reference(s) I need allocate for it. Also, the same code requires reference: Microsoft Forms 2.0 Object Library (FM20.dll). Where the Sam Hill is that...

Part and Inventory Search

Back
Top