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 Chriss Miller 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: *

  1. end922

    Seems rather advance SQL queries

    Greetings, I am trying to reconcile two tables in Access. Each table contains AccountNames, Trade Prices, Amounts, and Reconciled. What I would like to do is be able to identify in both tables if there is a match, multi, single or no match. I have the single done with no problems however, The...
  2. end922

    Remove "=" from cell with VBA in Excel

    Thanks Everyone appreciate your help. kiwidancer,cmithwick,and DougAJ4. I ended up using this Thank you for your help TotalNoOfRows = .Cells(65536, col_FacID).End(xlUp).Row Set TextRange = .Range("D2:D" & TotalNoOfRows) For Each TextCell In...
  3. end922

    Remove "=" from cell with VBA in Excel

    Skip. edit replace in the column will not work as the = can be anywhere in the cell. Edit replace I can't get to work in a single cell as the error prevents anything from happening. I've tried many scenarios but the only one can find to work is simulating F2 and enter after I change the field to...
  4. end922

    Remove "=" from cell with VBA in Excel

    Skip, edit replace wont due. The whole story. The file is received from our loans department. It is a daily record of all loan transactions processed the previous day from all over the world. There are literally thousands of them. The id field as I believe I mentioned in my first and second...
  5. end922

    Remove "=" from cell with VBA in Excel

    Hello, agree there is error in the field but not realy. The field is an ID field and just about any character or symbol is a valid id for that record. These cells do not contain formulas. When I change the field or column to text the field displays #Name?. Now I need to edit the field using VBA...
  6. end922

    Remove "=" from cell with VBA in Excel

    Greetings, I received a file that has a column formatted as general. I first format the column as text. The contents of the cells in this column contain alph numeric and symbols. I need in my code to be able to scan through each row and if a cell in that column begins with = then simulate F2...
  7. end922

    PowerPoint Excel Chart Update links issue

    Greetings, I have a PP slide with Excel charts in them. When I was using 2003 version of PP I could open PP and click update links and all was well. The charts udpated... Now with 2007 when I click update links my chart in PP blows up to like 2000% in size. I have recreated the charts using 2007...
  8. end922

    Excel CopyPasteSpecial from MS Access

    Yes he is correct. I added his code to the one I posted. That is what I was looking at.
  9. end922

    Excel CopyPasteSpecial from MS Access

    I went ahead and added in .select before the with. Thanks for your help Anotherhiggins!!
  10. end922

    Excel CopyPasteSpecial from MS Access

    Cool I like it. Only one issue. It does not select sheet Aging. It runs the code on whatever sheet is seleted on time of open. When I add .select or .activate behind .worksheets("Aging") it errors out.
  11. end922

    Excel CopyPasteSpecial from MS Access

    Greetings, I am importing a spreadsheet into Access. Prior to importing I have to clean up the data a little. There are some formulas that I want copy pastespecial so I can keep the value of the cell. When I run the code I get error PasteSpecial method of Range class failed. Any suggestions...
  12. end922

    Dlookup with Like

    join expression not supported. SELECT * FROM Range INNER JOIN ImportBD2 ON Range.ID = left([ImportBD2]![F6],3); select * FROM ImportBD2 I INNER JOIN Range R ON R.ID=Left([F6],3);
  13. end922

    Dlookup with Like

    I will try. table name is ImportBD2 field F6 What is the I after ImportedTable mean?
  14. end922

    Dlookup with Like

    Thank you PHV. 2nd works great. You the man! Skip. Would have used yours if the RANGE table was in the query. There is no way to join it so a lookup seemed my only option. Thanks Guys for your immediate response and solution. E
  15. end922

    Dlookup with Like

    Greetings, I am trying to do a Dlookup in a query with Like. I import a table that has acct #s like ###-#####-## (field name [F6]) I want to flag accounts that are on my list. So I created a table called range with a field called ID and added in the first ### (the other digits are NA to me) to...
  16. end922

    Query count day over day

    Thank you sir. It is a good starting point. Appreciate your assistance. E
  17. end922

    Query count day over day

    I knew you were going to ask that question. query1 SELECT Master.ID, Master.General, Master.DateReqRec, Master.DateReqEntered, IIf([DateReqRec]=[DateReqEntered],[DateReqRec],[DateReqEntered]) AS 1, IIf([ADPIssued] Is Null,0,1) AS [Comp], IIf([ADPIssued] Is Null,1,0) AS Pending...
  18. end922

    Query count day over day

    Current Query Results Date Carry New Comp Canned Pending 16-Mar-09 0 19 17 0 2 17-Mar-09 0 47 45 0 2 18-Mar-09 0 19 17 0 2 19-Mar-09 0 25 18 1 6 20-Mar-09 0 33 23 0 10 Currently Pending column will only show the number of items pending for that day. Carry column is null. Desired Query...
  19. end922

    Query count day over day

    Gotcha bad example. Can I send you an example of what I am trying to do? May I e-mail it to you?
  20. end922

    Query count day over day

    Greetings, I am not sure how to even pose this question. I have a query that does a group by on a date then sums each category. Each day they have. carried over from previous day, New, Complete, Cancelled, Pending for next day. like so Date.....carry .... new .... comp ... can .... pending...

Part and Inventory Search

Back
Top