Search results for query: *

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

Hoping someone can help. We are having an issue all of a sudden that our backups are failing. We are using SQL Server 2008 R2. Here is a copy of the backup log: Microsoft(R) Server Maintenance Utility (Unicode) Version 10.50.1600 Report was generated on "RX510001". Maintenance Plan...

Don't know if this is possible but thought I would throw this out there for some help. I have the following query that I am having trouble with. My problem is that the way the table (Inventory_Item_Fact) is laid out there are multiple rows for the same drug based on inventory received from our...

I have a system that sends me an email with an attached file that I need to process through an Access database. I want to automate the process so I don't have to touch it. My problem is getting the attached excel file in the email to automatically save when the email is received. Any ideas if...

Here is the situation: I get an excel file from a web based program that creates several tabs (not always the same number of tabs) in the same Excel file. The columns are all the same from tab to tab. I just can't figure out how to progrmatically import each tab from the spreadsheet. Hope...

Another employee and I share the same set of files on our server. The files are mostly Access databases. The bandwidth on our network is terrible to the point where if running a simple file import while the database is on the server, it takes about 30 minutes where when the database is on the...