Search results

  1. 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...
  2. A

    app hangs

    I found my answer...I had to add false at the end of wks.close: wks.close False
  3. 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...
  4. 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?
  5. A

    set order to columns

    Thanks, It gave me an idea and I ran this query in Sql server and got my results I wanted. Select ID, FullImagePath, TabName, xlsFileName, SheetOrder, Row_NUmber() Over(Partition By FullImagePath Order by FullImagePath, ID, SheetOrder ) as ClaimRow, Row_NUmber() Over(Partition By...
  6. A

    set order to columns

    I need to populate 2 columns : 1) Add a sequential record number (ClaimRow) that resets for each xlsfilename. This will contain the row number within the xlsfilename. 2) Add a sequential record number (TabRow) that resets for each xlsfilename, TabName. This will contain the row number within...
  7. A

    Import Excel Files

    Sorry, I did not want to come across that way. I do appreciate your help. thanks, i did learn a different way of doing the same thing.
  8. A

    Import Excel Files

    Found it...setwarnings false. Code is running, but the speed is not anything better with the query instead of linking the excel file.
  9. A

    Import Excel Files

    nevermind...i reran it and it's fine. Only thing now is that it prompts me to create the table..or insert into the table. How can i remove the prompts?
  10. A

    Import Excel Files

    Sorry for late response. I got busy on another project. I tried this below and it is leaving out the first row which has the field names. I want the field names to be part of the data. They are being cut off and I don't see it. strsql = "SELECT * Into TmpLinkXLS FROM " & _...
  11. A

    Import Excel Files

    I am looping thru and linking excel files. Sometimes there is data with the top row having title names. The problem is that when the column names are like "date" and "quatity" then when it links in what shows in the cell is "#Num!". How can I get around this so I see "date" and the other field...
  12. A

    dynamically remove recordsource

    Excellent! just what i needed. thanks!
  13. A

    dynamically remove recordsource

    How can i remove all recordsources from all forms and subforms in my app? I want to do this with vba to loop thru all forms and remove all recordsources. thanks!
  14. A

    save with question mark in name

    The original file has ? in the name. I am only making a copy of the original and need the name to be the same. I can open the file and it has chinese letters in the spreadsheet.
  15. A

    save with question mark in name

    I have a process that runs thru thousands of files and in the end of several steps it saves the file to the z drive. I ran into a problem when it tried to save a file that has a ? in the name. I converted that to chinese letters. ProWkBk = "Vango loveseat ????FR091 20171205.xls"...
  16. A

    conditional formatting

    form has no other code. Not sure why it does not save.:banghead:
  17. A

    conditional formatting

    No Cigar... Tried this below and didn't work: DoCmd.OpenForm FormName:="Form2", view:=acDesign Set frm = Forms!Form2 Call AddFormats(Forms("Form2")!p24_dmg, frm) DoCmd.Close acForm, "Form2", acSaveYes
  18. A

    conditional formatting

    I ran this code and it did run successfully, but did not save the conditional formatting.
  19. A

    conditional formatting

    It will run every time and still not save it. I want it to run once and save so that it doesn't run each time I open the form.
  20. A

    conditional formatting

    I have this code to copy conditional formatting from 1 textbox to all the textboxes (more than 75 textboxes) in a form. It works when I have the form open and i run it, but when i close it and then reopen the form it is not there again. I open it in design mode to check the other textboxes, it...
Back
Top Bottom