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 Westi 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. under8d

    Excel VBA error – where do I look for the problem?

    Thanks again Gavin. I was thinking of solving the problem by doing some string manipulation to add the first name to column A, then execute intersect bit and another string manipulation to restore it back to a first name, last name column set up. This does seem like a non programmer’s solution...
  2. under8d

    Excel VBA error – where do I look for the problem?

    Hi Gavin; Thanks for taking the time to help me with my education. Patiently explaining that to me was a huge help, and now I have a much better understanding of how to use the debugging tools. And it is amazing how I can miss the obvious. I wish my mind was wired a bit differently so that I...
  3. under8d

    Excel VBA error – where do I look for the problem?

    Thanks folks; I ditched the With statement, and set up the watch. My lack of understanding of this shines through. I didn’t come up with any clues at all. And it is frustrating that it works in one circumstance and not another. I guess that I just don't know what I should be looking for...
  4. under8d

    Excel VBA error – where do I look for the problem?

    If I managed to capture anyone’s curiosity, here is a link to the spreadsheets. http://ptliving.net/ptl/ Click on the link “2 attachments” and download. File names are: activities spreadsheet Sept 16.xls enters the date at col row intersection Sept 16.xls Cheers, Ray http://ptliving.net/ptl/
  5. under8d

    Excel VBA error – where do I look for the problem?

    Hello all; I’m stuck! I have a bit of code that works just fine in a small developmental spreadsheet that I used to figure out if and how I could do this, but when I cut and paste it into my larger spreadsheet I get the following error. “Object variable or With block variable not set” It...
  6. under8d

    After update problem with a list box

    Thanks AceMan1; I appologize for not responding to your helpful post. I am trying to mop up a number of issues before I leave on a holiday for 10 days. I may not get around to implementing your ideas before I leave, but will certainly explore your suggestions. You will probably hear form me...
  7. under8d

    After update problem with a list box

    I am trying to create a form where the user selects the distinct first letter of the last names from a list box. SELECT DISTINCT [qryMem].[LETTER] FROM qryMem; Then from a list box containing the distinct last names; SELECT DISTINCT [qryMem].[LAST_NAME], [qryMem].[LETTER] FROM qryMem WHERE...

Part and Inventory Search

Back
Top