Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    2,188

    Importing Negative Numbers in Access

    I am trying to import a text file into Access. The issue is that i have negative numbers in the following format: (1,200,567.32). I have tried different import types, double, integer, etc. The...
  2. Replies
    11
    Views
    8,528

    Thanks..that worked. I now find that I have...

    Thanks..that worked. I now find that I have another issue with my code. I have the following code:

    ActiveWorkbook.Worksheets("Sheet5").Sort.SortFields.Clear...
  3. Replies
    11
    Views
    8,528

    Excel 2007 Find and Select

    Hi I am trying to write code/macro to look for the word production in column A. Once the word is found, I want to select the cell containing production and all the cells below it and delete it. The...
  4. Replies
    7
    Views
    2,168

    Below is the complete modified code. Sub...

    Below is the complete modified code.


    Sub FixedAssets()
    Application.ScreenUpdating = False
    Dim msg As Variant, TestRange As Range, NaturalCell As Range, BranchCell As Range
    With ActiveSheet
    ...
  5. Replies
    7
    Views
    2,168

    Thanks, but I changed the offset to 1 and i still...

    Thanks, but I changed the offset to 1 and i still received the same error on that line.
  6. Replies
    7
    Views
    2,168

    I have copied the revised code and pasted it over...

    I have copied the revised code and pasted it over my original vba. I did receive a compile error: Argument not optional at the following line: With.Range.Offset(BranchCell, -1,0) . I changed Range...
  7. Replies
    7
    Views
    2,168

    I am trying to modify the current VBA for an...

    I am trying to modify the current VBA for an excel template. What I need the code to do is following:

    (1) I need it to look in a range of cells (Column E) for a range of account numbers, if the...
  8. Replies
    5
    Views
    837

    R, I have no idea. A co-worker asked, so I...

    R,

    I have no idea. A co-worker asked, so I figured I would pose the question on the lounge. Thanks.
  9. Replies
    5
    Views
    837

    There may not be a resolution for this but...

    There may not be a resolution for this but figured I would ask. I am working in excel 2007 and have created a drop down list using data validation. My question is how do you keep the dropdown icon...
  10. Replies
    4
    Views
    503

    I was able to do a work around. I created an...

    I was able to do a work around. I created an update query that combined both the Loc and BU #. I was then able to use my original delete query. Thanks for your response, I appreciate it. ...
  11. Replies
    4
    Views
    503

    I tried your suggestion and recieved the error...

    I tried your suggestion and recieved the error "Could not delete from specified table". Attached is a snapshot of what the select query looks like and the SQL when I changed it to a delete query. I...
  12. Replies
    4
    Views
    503

    I am trying to write a delete query where it...

    I am trying to write a delete query where it looks at the Consignment location table and deletes matching data out of the QOH table based on the Location and BU #. I keep getting a specify with...
  13. Replies
    3
    Views
    1,169

    Hello, I have some code in which I am placing...

    Hello,

    I have some code in which I am placing a formula in certain cells, but if the sheet name is "Corporate Departments", I want to to replace the original formula with something else. I have...
  14. Replies
    3
    Views
    439

    Okay, I think this is a better way of explaining...

    Okay, I think this is a better way of explaining it. I have to export data out of two systems. A production system and a test system (there are four test systems). I am comparing the data to...
  15. Replies
    3
    Views
    439

    I am trying to write a query in which I can...

    I am trying to write a query in which I can compare one table to another one. I want to compare table B to table A. If there is any data in table B that does not match table A, I would want it to...
  16. Replies
    3
    Views
    4,146

    Hello, I have a CSV file that I import into an...

    Hello, I have a CSV file that I import into an access database. The date field in the CSV file is in the format of 20100622 for 06/22/2010. How do I convert this field into a date field so that it...
  17. Replies
    3
    Views
    1,784

    Hello, I have a macro that was written on a...

    Hello,

    I have a macro that was written on a computer with excel 2007 but was saved as an .xls file (2003). When I run the macro on my computer it works fine but if someone that has 2003 on their...
  18. Replies
    7
    Views
    719

    Thank you both so much. This helped. :-)

    Thank you both so much. This helped. :-)
  19. Replies
    7
    Views
    719

    I have attached a portion of the spreadsheet I am...

    I have attached a portion of the spreadsheet I am working on. I can't have it look specifically for SF. This file is to be used by several different "companies". Some may have a prefix of AG, GL,...
  20. Replies
    7
    Views
    719

    I think the preceding zeros are causing the...

    I think the preceding zeros are causing the issue. Without the zeros the formula works but I need to keep the cell value as is. Is there a way to ignore the zeros without getting rid of them? For...
  21. Replies
    7
    Views
    719

    Hello I am trying to write a formula in Excel...

    Hello I am trying to write a formula in Excel 2007. I want to be able to look at a cell and look at several "logic" items.

    If the cell begins with an alpha character (the cell values are...
  22. Replies
    1
    Views
    476

    I am currently using 2007 but am attempting to...

    I am currently using 2007 but am attempting to work in an Access Database that was built in 2003. Before I was upgraded to 2007 I was able to run a macro that would query data based on a set...
  23. Replies
    6
    Views
    485

    I removed enough of the code to make it work, but...

    I removed enough of the code to make it work, but then the chart I looked at was updated immediately, so I can't reproduce the problem.

    What part of the code did you remove? Just your prior...
  24. Replies
    6
    Views
    485

    I have a workbook in which I have several charts...

    I have a workbook in which I have several charts in three worksheets. In a different wooksheet I have all of the data for the charts. I created a macro that would automatically move the data over...
  25. Replies
    1
    Views
    1,076

    Expression builder (Access 2003)

    I am trying to use the expression builder. this is what i have in the field of my query in design view. Paid Month: if([Master table]![frequency] ="qtr",[Master Date]![qtr],0). I must be missing...
Results 1 to 25 of 79
Page 1 of 4 1 2 3 4