Recent content by DBAMJA

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

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.

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

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

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.

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.

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

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

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

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.

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

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

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

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

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