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!

Search results for query: *

  • Users: GoDawgs
  • Content: Threads
  • Order by date
  1. GoDawgs

    Breaking up Array Cell Value

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

    Populating Excel with Access records VERY slow

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

    Copy a sheet to new file-keep formulas

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

    Count the different data

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

    Distiller Job Options change on their own

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

    To those who work for themselves...

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

    CountIf help

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

    Windows Task Scheduler Help

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

    Must finish Refresh before copying data...

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

    Help with formatting of paste?

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

    What Reference do I need?

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

    Need help transposing basically

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

    Calculate a Dsum only once

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

    Getting 0 where records don't exist

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

    Omitting certain details in report

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

    Creating Relationships in order to run a report

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

    importing from excel

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

Part and Inventory Search

Back
Top