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

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

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

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

I am trying to run a query to join several tables and get am getting an error, "Not enough space on temporary disk". Has anyone seen this before and have a way around it? [flush] DBAMJA It is said that God will give you no more than you can handle. I just wish God didn't have so much faith...

Not enough coffee or something this morning but I just can't wrap my head around this today. I have two recordsets rsTraArt and rsTraArtHdr that are created using: set rsTraArt = db.OpenRecordset("....") Both recordsets have the fields TraSys, TraLvl and TraSeq in common. How do I join...

I can't seem to figure out what is happening with my import. I have a file that uses the | as the delimiter. When I manually import the file it works just fine but as soon as I set up an import specification and use it, it blows up and doesn't recoginze the | as a delimiter. Anyone else have...

I am trying to print a report to a PDF converter and when I send the report using the following: DoCmd.OpenReport "Being Processed " & mnth & da & yea, acViewNormal the save as dialog box opens (which is fine) but the file name that I want to save is not what the report name is. I need...

Not sure if this can be done programatically or not but here goes. I have an excel file that changes from month to month with the number of sheets within the file. Some sheets are added where others are deleted. The people that use this file are looking for a way to summarize a certain cell...

Hi everyone. Thanks in advance for any help that you can give me. What I am trying to accomplish is this, I have a query that I need to export to excel. The problem is that I need to be able to qualify the query by store number (that's not hard) and export the store to the excel file. After...

I run a series of reports every month for 24 different sites. Each site gets the same set of reports that are specific to their location. What I am trying to do is save killing so many trees and send the reports by email. I have no problem sending emails, its saving the reports...

Having a senior moment today and can't wrap my head around this question. I have a list box with the multiselect property set to simple. After the user has selected all of the records and run the update for all of the records selected, I want to reset the list box so none of the records are...

This one is really confusing me. When I am at home and connected to my network, Outlook 2003 works just fine. When I am at work or anywhere else I can receive emails from all of my accounts but I can not send emails from my POP3 account. I doesn't make sense. Works fine at home but no where...