Search:

Type: Posts; User: Abraxus; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    1,053

    My wife just started a new job (yeah!) and they...

    My wife just started a new job (yeah!) and they have her using an Excel time sheet.

    She asked me if I could help her get it to total the times, but I'm having a bit of trouble.

    The columns she...
  2. Replies
    5
    Views
    3,500

    My code links the table then take each record and...

    My code links the table then take each record and inserts it into other tables based on certain criteria.

    I've tried formatting the Excel sheet column to text and I've tried putting the...
  3. Replies
    5
    Views
    3,500

    I have some code that links an Excel spreadsheet...

    I have some code that links an Excel spreadsheet to an Access database then does some work with the data in that linked table.

    One of the fields has traditionally held numeric values, but recently...
  4. Thanks for the pointer....it helped me figure it...

    Thanks for the pointer....it helped me figure it all out!
  5. I believe all the tabs have data, but I can...

    I believe all the tabs have data, but I can easily check to see if there is data in the cells.
  6. I have a directory full of spreadsheets that have...

    I have a directory full of spreadsheets that have 1 to many tabs in each of them.

    Each tab is identical in format, just the data is different.

    Anyone have any code that can open the...
  7. Replies
    1
    Views
    393

    My brain is failing me this morning... I was...

    My brain is failing me this morning...

    I was given a spreadsheet with rows of data where 1 cell has "Division Name (Division Owner)"

    I need only the Division Name, but am drawing a blank on how...
  8. Replies
    3
    Views
    432

    Ok, I figured out the problem. It only took me,...

    Ok, I figured out the problem. It only took me, however, a day and a half.

    To validate my numbers, I took the results of the query and copy/pasted them to Excel. I would then AutoSum the data to...
  9. Replies
    3
    Views
    432

    I am having trouble with 2 queries from the same...

    I am having trouble with 2 queries from the same data...

    My table has 3 columns (CapOp, Spend, Date). CapOp can have only 2 values, none are null.

    When I do this querySELECT...
  10. Replies
    4
    Views
    414

    Some of us more often than we'd care to admit. ...

    Some of us more often than we'd care to admit. http://windowssecrets.com/forums/images/smilies/blush.gif
  11. Anyone have anything that will take an Access...

    Anyone have anything that will take an Access query and put it to Excel, but place data on different tabs based on a field?

    For example, I have a bunch of data that has a field named BU. That BU...
  12. I have a database that crunches numbers and needs...

    I have a database that crunches numbers and needs to send e-mails to about 200 people.

    My boss's boss decided they should come from an e-mail account I have permission to use, but I can only...
  13. Replies
    2
    Views
    464

    Create two queries. One to calculate the Min...

    Create two queries. One to calculate the Min Start time by date and the other to calculate the Max End time by date. Link the two queries by date. See attached (qryMinMax shows the final results):...
  14. Replies
    2
    Views
    464

    I have an database used in a small bookstore for...

    I have an database used in a small bookstore for sales/inventory. Punctuality was an issue, so I created a table that would time stamp when the database was opened and closed.

    I have a table that...
  15. Replies
    2
    Views
    1,597

    I have a folder full of MP3s that I'd like to get...

    I have a folder full of MP3s that I'd like to get into the proper folders easily.

    Currently they reside in G:\MP3\New\Unfiled

    I'd like them all to reside in this folder structure
    ...
  16. Replies
    2
    Views
    931

    I have a page that has a many-row table with 3...

    I have a page that has a many-row table with 3 columns in it. Each column is set to 33%. but due to some graphics, the 3 columns extend off the right of the page when viewing it at lower...
  17. Is there property setting or alternative way to...

    Is there property setting or alternative way to stop the confirmation for an append?

    I am parsing through thousands of records, building a string for each group, and inserting the info into a...
  18. Replies
    1
    Views
    843

    I am trying to create a passthrough query via...

    I am trying to create a passthrough query via code, and am getting an error with the connection string.


    Sub SQLPassThru()
    Dim dbs As Database, qdf As QueryDef
    Dim strConnect As String, rst...
  19. Replies
    2
    Views
    375

    I received a file from a coworker and the right...

    I received a file from a coworker and the right margin appears to be ignored. I've looked at the margin settings and made sure they were 1.25 inches and applied to the entire document, but the text...
  20. I even tried this Function ExcelCheck2(strFileIn...

    I even tried this
    Function ExcelCheck2(strFileIn As String) As Boolean
    On Error Resume Next
    Set xlApp = GetObject(, "Excel.Application")
    If xlApp Is Nothing Then
    MsgBox "Excel is not running",...
  21. I modified your code to this Function...

    I modified your code to this
    Function ExcelCheck2(strFileIn As String) As Boolean
    Dim xlApp As Object

    On Error Resume Next
    Set xlApp = GetObject(strFileIn)
    If xlApp Is Nothing Then
    ...
  22. Is there a way via VBA to determine 1) if Excel...

    Is there a way via VBA to determine 1) if Excel is open and 2) if a given file is open?

    I have a process that blows up if the user has certain workbooks open.

    Thanks!
  23. Replies
    3
    Views
    471

    That's almost exactly what I did, except I did...

    That's almost exactly what I did, except I did not create a table. Instead I used the WHERE ID NOT IN (SELECT TOP 25....)

    Worked like a charm!



    Hi There

    This is not the most elegant...
  24. Replies
    3
    Views
    471

    I know I can get the top X records in a query...

    I know I can get the top X records in a query using TOP, but is there an easy way to get everything else?

    For example, I need to report the top 25 items and their associated $$ by category. I...
  25. Replies
    2
    Views
    498

    Re: Import all Excel sheets (2003)

    I love it when I can solve my own questions....

    <pre>Sub ImportAllTabs()
    Dim strPath As String
    strPath = "C:PathToFiles"

    Dim objXL As Object
    Set objXL =...
Results 1 to 25 of 248
Page 1 of 10 1 2 3 4