Recent content by abenitez77

  1. A

    search for value in excel worksheet

    This is close ...but I need the address of where the Thanks! close and got me where I needed to be. this is what works for me below. I am putting the values in cells E12 thru E15. I now need to copy those values to columns F thru P. But I need to change the Letters accordingly...ie in...
  2. A

    search for value in excel worksheet

    My search below only finds 1 value. It does not stop at the other value it should be finding. The value in the cell is identical to the one it does find. What am I doing wrong? for vrow = 12 to 15 fDesc = loWorkSheet.Range("A" & cstr(vrow()).value) If fDesc = "" then goto NextvRow...
  3. A

    Recordset with selected records

    Ok, so let's say I just wanted to export all the records that are filtered on the form? not the selected rows....
  4. A

    Recordset with selected records

    My guess is, the user thinks he's selecting all rows by selecting the column, instead of going down and selecting the record selector where it selects the entire row. But I see your point...that does not select the actual record. I just need to educate the user on the correct way.
  5. A

    Recordset with selected records

    The user may select the records how you are showing it as well. If he wants to select all, he may select the column, but I can require them to select it the way you are doing it, if it helps. I expect it will be contiguous 95% of the time, but there may be an occasion where it won't be.
  6. A

    Recordset with selected records

    I agree with you on the approach, but the "SelectedField" is basically just the user highlighting the rows or the column which then hightlights the rows (in this case only the filtered records on the form). So there's no way for me to identify them and add it to the query.
  7. A

    Recordset with selected records

    You can see the column is selected on a filtered set of records:
  8. A

    Recordset with selected records

    I have a form that has a grid and in that grid, rows are being selected.
  9. A

    Recordset with selected records

    I have a table with a column named VendType and it has 3 values ("FS", "EXP, "DSD"). I want to export the records into 3 separate spreadsheets by VendType. I also only want to export the rows that I select from a grid on the form I am on. The form could be filtered and possibly have rows...
  10. A

    formatting numbers

    This worked! I just had to add a missing comma and parens: Format(Abs([CreditMemoAmount]), "- $#,###.00") Thanks!
  11. A

    formatting numbers

    I have a report that is using a query where I have a column being formatted in the query like this: CreditMemoAmt: "- " & CStr(Abs([CreditMemoAmount])) In the report, numbers like 1,500.00 are coming across like 1500. And 1623,60 are 1623.6 How can i fix this? I want the numbers to appear...
  12. A

    Looping thru all forms

    I was using system tables first, but I heard it wasn't good to use them because it is not always reliable...if i delete a form or create one , it doesn't always update the system tables right away? is that true?
  13. A

    Looping thru all forms

    I am looping thru all forms...and i have more than 1,000. looking for the forms that start with the prefix "DYN_" & MyReportListID. Then when I find one, I am copying those forms and resetting properties on them. Looping thru all forms will take a little less than a minute. Is there a way to...
  14. A

    adodb execution of sql command timeout

    I found my answer...I had a window in sql studio where i did a select statement on that table...and it had a hold on the table...so that is why it hung and didn't allow me to insert with tablock. Sonic8, Thanks for pointing that out...it led me to finding the issue.
Top Bottom