Search results

  1. B

    Method 'Cells' of object '_Global' failed

    Hi lagbolt, Well, the other lines you mention, yes they use "Cells" but on the problematic lines, they are nested within the Range method. I have to apologize for the bum code in the first post. I had been doing some editing in the VBE and then tried to clean it up in my post and I missed some...
  2. B

    Method 'Cells' of object '_Global' failed

    Hi All, I'm pretty sure i know why this is happening, but I cannot seem to sort out the solution. I have the below code. It is running from Acccess 2010. It runs fine, the first time through. Then it errors out on the red line on the second loop. Private Sub...
  3. B

    Unable to Rename or Recaption Controls

    wow, I have zero idea what was going on, but after closing and reopening the db at least a half dozen times and observing the same behavior, I closed and went to a few other threads for about 30 minutes. now I reopend it again, and %@#%^@#%^ now the damn things works just fine. oy vey
  4. B

    Access Project - ADP (subform)

    Please provide more specifics on the exact error. There should be an error code with perhaps specific verbiage as well as the steps to repro (are you getting the error in Access or when opening views directly in SQL)? your subforms should be able to be updated in the same way your other forms...
  5. B

    how to show image in ComboBox ?

    One Idea (of MANY possibilities) Use a picture frame placed nexct to the combobox. Use the OnChange event of the combobox to update the picture frame to the desired picture.
  6. B

    Unable to Rename or Recaption Controls

    I created a blank ACCDB in Access 2010 (x64) running on Win 7 (x64) It is saved locally. I created a blank, unbound form. I created a generic button (with no action associated) and then copy/pasted it several times. I clicked into each button and changed the VISIBLE caption. I opened the...
  7. B

    How to force (or re-enable) workgroup login prompt

    Hi RainLover and thanks for your repsonse. I had hoped I was clear, but I guess I was not. The purpose of my question here today is not to seek guidance on breaking or removing ULS. I need to re-establish the credential prompt which somehow stopped firing. Assuming i can get the prompt to...
  8. B

    code error

    I see this has been up for awhile with no replies so I'll take a stab at it, or perhaps give you some new things to ponder. I have done some DAO work but am not a master at it. However, this doesn't look right to me. Has this code ever works and now for some reason is not? or is this new...
  9. B

    Printer used with docmd.printout

    Can you post your code? Are there any saved property settings differences between the one reprot that prints properly and the ones that do not? If you open the report(s) in PrintView and select "Page Setup" and select the "Page" tab, is the report set to "Default Printer" or "Specific Printer"?
  10. B

    How to force (or re-enable) workgroup login prompt

    We are performing migrations of all Office files from the older formats to the newer formats. We have an automated tool which, in addition to converting the format(s), reads the VBE projects and performs remediation of the existing code for deprecated objects, methods, and constants. To perform...
  11. B

    Interesting Excel Problem (ala Access style recordset)

    Roku, Thanks, but the none of this is a recordset. I didn't want to get all distracted by long explanations but the reason I am not copy/pasting is it has to be done dozens of times. I am actually remediating some existing code that was recorded by a novice user. This code eventually bombs out...
  12. B

    My Crappy Code Needs Fixing

    wait a minute, your using Access 2003 but we're talking about Excel? Are you using the Excel 2003 object model? I know there is an option in 2k7 and 2010 to continue the condition evaluation past the first yes, but I can't remember for 2k3. I think some clarity would be helpful here on where...
  13. B

    How to: Connect XLSM file to an XLSX file

    well, thanks for the tips, but, for other reasons too, the ODBC doesn't look like it is going to work for this scenario. the sample code and sheets I've been working with are just samples. the actual workbooks are different and contain many other sheet names, most much longer and other items...
  14. B

    Interesting Excel Problem (ala Access style recordset)

    Connect Excel to an Excel workbook to pull a recordset from the second workbook. http://www.access-programmers.co.uk/forums/showthread.php?t=254444
  15. B

    Excel instance does not close from access vba

    Not a full solution, but some thoughts. I don't think it will be easy to find/match/lookup a date/time combination. Date = yes, date/time = difficult at best. Try capturing the full serial value as for the Excel object, your code does not show how/where it is created
  16. B

    Interesting Excel Problem (ala Access style recordset)

    Hi All, Are any of you Access Gurus handy in Excel? I'm trying to solve a problem described here: http://www.access-programmers.co.uk/forums/showthread.php?p=1298448#post1298448 The code and eventual functionality should/could/would likely end up being very similar to that which would be used...
  17. B

    How to: Connect XLSM file to an XLSX file

    Ok, well, I am growing dubious of the OCDB code shown above. Yes, it works as recorded, however, after I have now parsed it out for modification and adaptation, itturns out there are some pretty problematic restrictions. not the least of which is there apparently is a restriction on the length...
  18. B

    VBA Code to change Cell value depending on Input value

    There is a "SheetChange" event which might be used for this, however you would need to consider if you want to restrict to column(s) and/or rows that would be senstivie to this edit. Also, to be clear, even if you have checks built in, to restrict the column and or row, some code will run on...
  19. B

    Excel 2007 - Linked Files

    samjh, For clarity sake, there is no such thing as "file type - Excel 2003-2007 workbook". There is: Excel 97-2003 (XLS) and then ther are the newer Excel 2007-13 formats (XLSX,XLSM,XLSB) now, you mention that "all the correct buttons are ticked to ensure the links update etc" however, the...
  20. B

    one button that moves to selected sheet

    I'm pretty sure you would have to add a button to the ribbon that calls a sub. I know of no way to create what essentially would be a floating button.
Back
Top Bottom