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 Rhinorhino 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 DBAMJA

  1. DBAMJA

    Windows 10 and MS Access

    Hoping someone out there has run across this same issue and has some suggestions. A few months back our IT department upgraded (we'll use that term loosely) Windows from 7 to 10. I have an Access database that I run every month to process data files for financial reporting. On the old Windows...
  2. DBAMJA

    Export to text file

    I figured it out, sort of. I redid the export spec and now it's working fine. Very odd but it's working now. Thanks for taking a look. [flush] Michael It is said that God will give you no more than you can handle. I just wish God didn't think I was just a bad ass.
  3. DBAMJA

    Export to text file

    SELECT PD_LAST_NAME AS [Last Name], PD_FIRST_NAME AS [First Name], Null AS [Middle Initial], PATIENT_ID AS [Patient Identifier], GENDER, Format([PD_BIRTH_DATE],"yyyymmdd") AS [Date Of Birth], Null AS Street, Null AS City, Null AS State, Null AS [ZIP Code], Null AS Phone, Null AS [Social Security...
  4. DBAMJA

    Export to text file

    I'm having an issue with formatting when exporting a query to a text file. I have a field in a table that is set to Short Text. Generally there is a number in the field but there is an occasional alpha character in the field. When I export the query that this field is part of to a text file...
  5. DBAMJA

    VBA Creat Oulook Calendar appointment from excel

    You need to make sure that the Microsoft Outlook XX.X Object Library is referenced. [flush] Michael It is said that God will give you no more than you can handle. I just wish God didn't think I was just a bad ass.
  6. DBAMJA

    Date minipulation

    Thanks a ton Skip. [flush] Michael It is said that God will give you no more than you can handle. I just wish God didn't think I was just a bad ass.
  7. DBAMJA

    Date minipulation

    Having trouble figuring this one out. I know it can't be too hard but I don't think I've had enough coffee yet this morning. My problem is, I have a date field [StartDate] in the format "7/31/2016 9:26:12 PM". If that date is a Sunday (which is easy to determine), I need to make that date the...
  8. DBAMJA

    Code at close of form isn't working when user closes database

    I've had similar issues in the past and to get around the user closing the database instead of the form, I set the attributes [highlight #FCE94F]pop up[/highlight] and [highlight #FCE94F]modal[/highlight] to yes and then the only the form has focus. [flush] Michael It is said that God will...
  9. DBAMJA

    Adding Windows 7 registry values for Trust Center from Access 2013 VBA

    I have an application that is distributed to almost 30 sites with some sites having multiple computers. I have a secondary database on a common server that holds objects that need updating at each of the sites. When the site opens the database, it goes out and checks to see if there is a...
  10. DBAMJA

    Calculation in excel pivot table

    Thanks a ton SkipVought. This has put me in the right direction. [flush] DBAMJA It is said that God will give you no more than you can handle. I just wish God didn't think I was just a bad ass.
  11. DBAMJA

    Calculation in excel pivot table

    Below is a snippet of a pivot table that I have in excel. The total column is just that, a total of the three columns for month 01. What I want to do is change it from a total to a calculation such as Internal/(Internal+External). Is there a way to change the total to a calculation? Note...
  12. DBAMJA

    Refreshing Tables Connected to SQL Database

    I have an Access 2010 front end connected to an MS Sql database as the back end. I have had to make some changes to the back end to a couple of the tables and need to programmatically refresh the front end of the database. That's easy enough to do manually on my development database but the...
  13. DBAMJA

    SFTP upload and downloand from Microsoft Access VBA Help Needed!

    I'm not really familiar with putty but just guessing here and you may need to play with it but my guess would be: strCommand = cstrSftp & " -sftp -l " & pUser & " -pw " & pPass & _ " [highlight #FCE94F]PUT[/highlight]" & pFile & " " & pHost & ":" & pRemotePath [flush] DBAMJA It is said that...
  14. DBAMJA

    SFTP upload and downloand from Microsoft Access VBA Help Needed!

    I'm seeing where you are telling putty to use sftp, the user id and password, the file to upload and where to upload it but I don't see anywhere in your code where you are telling putty to "PUT" the file. You need to use PUT and GET commands to send and receive files. Check the putty...
  15. DBAMJA

    Backup Failing

    Sorry it took so long to get back to you. I had to run the check over the weekend when no one was using it. Here is what came out of the application log: DBCC CHECKDB (SendSuiteLive) executed by NT AUTHORITY\SYSTEM found 4204 errors and repaired 0 errors. Elapsed time: 0 hours 30 minutes 49...
See more

Part and Inventory Search

Back
Top