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 Rhinorhino 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. murad5

    Transfer data from VB Array into Access Table, and vice versa

    Thanks for your help guys - GetRows is very helpful. I'll keep an eye on the other thread to see if anything pops up (need to work on my searching!)
  2. murad5

    Transfer data from VB Array into Access Table, and vice versa

    Hi, Is it possible to transfer data directly from a 2 dimensional array into an Access table, and back again? I've been opening the table as a recordset and adding each row in the array individually, but this takes forever as I have to update the recordset after each record is added... Thanks...
  3. murad5

    Excel formula to allow for variable operator

    Thanks for the feedback. I'm thinking of trying SUBTOTAL - it would limit me to only a few operators, but hopefully it should be enough to get the app working. Thanks!
  4. murad5

    Excel formula to allow for variable operator

    ...some operator is to be applied and C2 is some string which defines the operation. So in the case where the values in the cells are 15, 20 and "*" respectively the result would be 15 * 20 = 300, or where the values are 15, 20 and "=" the result would be FALSE. I guess I could do this by...
  5. murad5

    Limits of the Linest function in Excel

    Hi, I'm trying to use the Linest function to perform linear regression on a set of data. My known ys are in one row, and there are 65 values. I'm trying to fit those values against 27 known xs (ie - an array with 27 rows and 65 columns) however, I'm getting a #ref error. The error seems to go...
  6. murad5

    Changes to Chart Format not Saved

    Hi, I have a problem with one of my Excel workbooks. Basically, I'm trying to change the formatting on one of my charts. On one of the data series, I change the data labels so the font is bold and 8 points, the border has a shadow and they are aligned below the line. This works fine, but when I...
  7. murad5

    Overflow error in summary query

    Thanks Lonnie, there was a division by zero lurking deep down in one of the source queries!
  8. murad5

    Overflow error in summary query

    Hi, I'm trying to create a summary query based on another query, but when I run it I get an Overflow error. The query I am trying to summarise has five fields - Marcom_ID, Call_Date, Calls_1, Calls_2, Calls_3. This query runs fine and returns about 55,000 rows. For the summary query, I link...
  9. murad5

    CreateEventProc causes Excel to crash

    It seems the issue was caused by trying to add an event procedure in a different workbook to the one which contained the code which was running. To get around this, I created a procedure to create the event procedure in the new workbook and called it Auto_Open, therefore the next time it is...
  10. murad5

    CreateEventProc causes Excel to crash

    Hi Skip, Thanks for your help. I tried that method earlier, but it still crashes my system. I have a suspicion that the problem is the reference to the Visual Basic Extensibility library. The workbook with the code in it has this reference, but the workbook I'm trying to add the code to...
  11. murad5

    CreateEventProc causes Excel to crash

    If anyone has any thoughts on this one I'd really appreciate hearing them...
  12. murad5

    CreateEventProc causes Excel to crash

    Hi, I'm trying to add a SheetBeforeDoubleClick event procedure to the ThisWorkbook module programatically, but when I try to call the CreateEventProc method, Excel crashes immediately. I have no idea what is causing this! Here's my code: Set vbCodeMod =...
  13. murad5

    Creating an Excel Named Range programatically

    I'm using Excel 2002. I have to say, I've never had this problem before.
  14. murad5

    Creating an Excel Named Range programatically

    Hi Skip - thanks for your quick response. Unfortunately, I'm still getting the same issue. It seems as if the named ranges are invisible if the sheet where the range they're located is not active. I can't access them either through Excel's Insert - Name - Define... dialog box or through VB. One...
  15. murad5

    Creating an Excel Named Range programatically

    Hi Everyone, I'm writing a procedure to create a workbook on demand. My problem is when I try to name a dynamic range programatically. This is the code I'm using: ThisWorkbook.Names.Add Name:="ProdLines", _...
  16. murad5

    use "Find" methods on Replication ID fields

    The column property is Replication ID...
  17. murad5

    use "Find" methods on Replication ID fields

    I tried that originally, but it came back with an error saying it was a "Malformed GUID"
  18. murad5

    use "Find" methods on Replication ID fields

    Thanks for all your help on this one, guys, I appreciate it! The variable in question is the value of a replication ID held in a text box on the frmPromoMaster. When I try the function changing it to just a normal string (and changing the data) it seems to work fine. I think I'm going to give...
  19. murad5

    use "Find" methods on Replication ID fields

    Hi Daniel, I checked my references again, and I did have ADO turned off. I tried adding the DAO references, as you suggested, but it doesn't seem to be doing any good. Similar code is working for other data types, it seems the be just replication ids which cause issues. Does anyone now if there...
  20. murad5

    use "Find" methods on Replication ID fields

    Hi Tiny, Thanks for the suggestion, but I'm afraid I'm still getting the same error message...

Part and Inventory Search

Back
Top