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

  • Users: GeorgeDurkee
  • Order by date
  1. GeorgeDurkee

    Function in SQL

    this is great!! thanks for the help.
  2. GeorgeDurkee

    Function in SQL

    What I want to do is select values from a table based on up to six sets of criteria. For each criteria, I want to display an X in a VB datagrid for the records that match the given criteria, so the result looks like this: Identifier criteria1 critereia2 criteria 3 ABC X...
  3. GeorgeDurkee

    Missing Object Library in Access 2000

    Is your client running Office 2000 while you are running Office 2003? If so, then your problem is that you are doing "Early Binding". this menas referencing the object before you know wha the object is. Change your method of opening Outlook. Use the CreateObject metod instead of new object...
  4. GeorgeDurkee

    Filter by form issue

    I have a form that displays a subset of data from the main table. When I try to filter the data using the filter by form functionality, I first must apply a filter that selects all the records (key < 99999), then I can use the apply filter by form functionality. if I don't use the first set of...
  5. GeorgeDurkee

    Identify Escel Worksheet

    I figured it out. thanks for the help. here is the original code: If ActiveSheet.Range("C3").Value = "Preparer (printed)" Then 'Report Sheet Application.CommandBars.ActiveMenuBar.Controls("IB-input").Controls("Build Report").Enabled = False...
  6. GeorgeDurkee

    Identify Escel Worksheet

    I can't do it that way. the calculations and data gathering are too complicated to be handled with a simple query data pull. the output form Access is the result of a large number of calculations from a large number of tables. all i want in Excel is the final result. I can push the data into...
  7. GeorgeDurkee

    Identify Escel Worksheet

    I am creating a series of worksheets using VBA. based on the worksheet, I turn on and off action buttons and menu items. I am using access to populate the first worksheet, then using excel vba to manipulate the remaining sheets. My problem is that as long as Access has control of the...
  8. GeorgeDurkee

    Write confict error

    Just wanted to let eveybody know that I figured it out. I was changing the record in a strange place and it wasn't related to anything the error message was telling me. Thnks for the updates and help.
  9. GeorgeDurkee

    Write confict error

    By the way, a new wrinkle in this....When the write conflict screen comes up and I click SAVE CHANGES, it doesn't save them. I come back to the record and it says it again. As soon as I click DROP CHANGES, then I stop getting the message.
  10. GeorgeDurkee

    Write confict error

    What settngs do I look at to determine what the save settings are? I don't see any in the TOOLS...Options menu. Using the Docmd option doesn't seem to have any effect.
  11. GeorgeDurkee

    Write confict error

    the main form (data correction) is open when the add form is open. the main form is updated form the add form and then the add form is closed. What is strange, even after I say SAVE CHANGES or exit the database, when I come back, to just that record, it gives me the write conflict.
  12. GeorgeDurkee

    Write confict error

    I have a form that is used to edit data. From this form, I open another form to add new data. After adding data, I return to the main form. Everything seems to be fine. I move to the next record on the main form and I get a write conflict error. I am the only user and I haven't changed...
  13. GeorgeDurkee

    Sort cells in Excel

    I want to use VB to sort an Escel spreadsheet I just populated. When I use this command xlSheet.Cells.Sort key1:=Range(&quot;A2&quot;), Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal I get an error 1004, Method...
  14. GeorgeDurkee

    Sorting Excel

    I have created a recordset in Access and exported it to Excel using the Excel CopyRecordset command. Now I want to sort the data. the first time I run the module, it works fine. The second time, with no changes in anything, I get an error - Method sort of global worksheet fails. If I quit...
  15. GeorgeDurkee

    Export sorted recordset to Excel

    It is a new recordset created in memory, using the fields.append method. It is based on the combination of about 8 tables, so using a standard query takes about 30 minutes just to select the data. Add the 30 to 45 minutes to do the record by record export so I can get the data sorted the way I...
  16. GeorgeDurkee

    Export sorted recordset to Excel

    Thanks for the feedback, but OutputTo does not appear to support Recordset procressing. It can output the Access intrinsics (table, form, module, query, etc.) but not recordsets. If there is a way to use it, please let post an example. I'm not seeing it.
  17. GeorgeDurkee

    Export sorted recordset to Excel

    I have a recordset with about 6000 records in it. Each record has 47 columns. I want to export it to Excel sorted on 7 fields. Using the record by record export allows me to sort the data [smile], then export it, but that takes about 15 minutes [evil]. Using the Excel range.copyfromrecordset...
  18. GeorgeDurkee

    Startup w/o exploroer

    When I start my computer, it launches a Windows Explorer window that I didn't tell it to start. [evil] How do I find out where this command is coming from and how do i turn it off? [ponder] I have looked in the registry (I think) and each of the startup folders and can't find the comand to...
  19. GeorgeDurkee

    summing columns on a datagrid

    I have a datagrid that has number of rows. The columns are all numbers and I want to generate a total for each column as well as each row... like this Column1 column 2 column 3 total 1 1 1 3 2 1...
  20. GeorgeDurkee

    Determine if user closed linked object

    This isn't so much a COM issue as a cleanup issue. My app creates and populate an Excel file. The user then wants to view the output and return to my code to do something else that the program does. If he closes Excel, using standard Excel processing before he returns to my code, then I'll...

Part and Inventory Search

Back
Top