Search results

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

    adodb execution of sql command timeout

    The table is compressed, so TabLock is needed there...so the dba's told me. : )
  16. A

    adodb execution of sql command timeout

    I have this code below and it is hanging on me. It worked fine for several files...but it is now hanging on me and times out with error (-2147217871:Query timeout expired). But When I copy the sql string to SQL Server and run it, it runs in less than 1 second without errors. 'This is what it...
  17. A

    app hangs

    I found my answer...I had to add false at the end of wks.close: wks.close False
  18. A

    app hangs

    My app is hanging when I try to close an excel workbook. I am linking an excel file and when I am done processing and want to close the workbook, the app hangs. What am I not doing right? It hangs on this line: wkb.Close Dim objXL As New Excel.Application Dim wkb As Excel.Workbook...
  19. A

    Import Excel Files

    Now I'm having formatting issues. The date fields are coming up as integers and a column that has long numeric values are coming up as scientific values. How can i get them to insert into ms access table with the values formatted correctly?
Top Bottom