Search results for query: *

I get a daily file with hundreds of records from an outside vendor...and one of the columns in the file has arrays in each cell. Is there an easy way to break these apart? My final goal is to get them somewhat normalized (meaning a record for each of the values in the array), but I'd settle...

It's been a while since I've posted here...but I'm getting frustrated. I've got a process that dumps a bunch of records for Reps from Access into an Excel file...and in between each Rep does a bunch of formatting (that's the reason for not just dumping the entire recordset). A section of the...

Long time no post... I'm having a problem that I'm sure is an easy fix, but I can't find it. I receive an Excel file daily with many sheets and different data. I have no control over this file at all. I've set up a nice little sheet to pull all of my necessary summaries...but I can't bring...

Hopefully I'm just missing a function I don't know about yet...but here's my problem: I've got a data sheet with Date, Department, Category, and Quantity. Basically if this were an actual database table the primary key would be Date, Department, and Category combined. I need to count how...

I'm missing something, so I thought I'd bring it up here where people know more than I do. I have an Access database that that I'm creating reports in and then printing to the Distiller. Somehow while I'm printing, the Distiller is changing the Job Options from Screen Optimized to Press...

More specifically I'm looking for the technical consultants. I just was hoping to get a dialog going about what it took to start things up and how things are going and what you would do differently or what you did that you are happy you did. I'm an Access, VBA, Web Developer (employee) just...

I've got a sheet with a list of open dates and close dates for stores. Basically I want a count of all stores open as of a certain month...seems easy enough. I set up a countif to give me the number of stores with open dates before the certain month, and then subtracted the stores with close...

Sorry, I know this doesn't quite fit in this forum, but I wasn't quite sure where to put it. I have an Excel file scheduled to open from the task scheduler...basically I just need to know how to tell it to run a certain macro when it opens from the scheduler. For Access it's just /x...

Ok, my 3rd question from the same project. So far I have an Excel sheet that refreshes its data from a table, then after that I have code to copy this data into the body of an email and send it. Now I'm having trouble in between the two steps...basically the data refresh takes about 4 or 5...

I might be reaching here, but I'll tell you my problem just in case I'm not. I've got an Excel file right now that is linked to an Access query. This file is refreshed daily and needs to be emailed out every day...only problem is we don't want it to be an attachment, it needs to be in the body...

Ok, feel a little silly here, but I'm setting up an automatic email for which I've found tons of great code and think I have it all set up...one problem...I need to create a variable and dim it as DataObject, only problem is the libraries that I'm referencing don't have that option, just...

Here's my problem. I've got a sheet with a list of store numbers across the top, a list of every day last year down the first column, and then revenue for each store for each day. I need to get all of this data into basically a vertical list, meaning I need one column for store, revenue, and...

Got a query problem...I have a table with Revenue data for the past year. I need to create a query (that's my first problem, it has to be a query) that basically lists all the stores and revenue, and then I need to calculate what percent of the monthly revenue that day's revenue is (so...

Ok, I've got a problem that is pretty convoluted, I think I'm going about it the wrong way, but it is actually the best way I can think of...with that said, here goes. I have two tables, one with year to date totals for each store, and one with last month totals for each store. I then have a...

I have a report I have created that has store numbers and sales in the details section for about 400 stores...I need the report to omit certain stores from the details section (but I still need that data in the recordsource, so I can't just take it out of there)...I am a decent programmer, but...

Got a quick question that might turn out to be not so quick...I'm trying to create a report off of 2 tables, 1 of these tables is created automatically every week using a create table query, so it therefore has no relationship set up with the 2nd table because in order for the make table query...

I've got a database table that looks like: store month sales x 1 1000 y 1 1000 with data on about 500 stores for each of the last 12 months, and i'm trying to import some data from excel that looks like: store january february march etc x 500 100...