Search results

  1. G

    AVG anti Virus and Lost Records

    Well, perhaps unfortunately for you, my eventual solution was to switch to MySQL. Haven't looked back since. However, in the interim, one thing we noticed was that our backups might be causing the corruption oddly enough. If you copy the BE, make sure you kick off all connections first. Other...
  2. G

    Memory Problems and Recordsets

    Ok. Thanks a lot everyone. Haven't seen much difference in the new printer, but it has been a slow day. I will go through and close every rst in the report (I didn't do the coding for this one so it will be a long, boring process) according to the allen browne article and see what that does. I...
  3. G

    Memory Problems and Recordsets

    Our office is full of HP LaserJet 1020 printers. I will try setting the default to our sharp network printer and see if that helps. In the allen browne article, it puts the rst = Nothing in an error handler. This confuses me as I wouldn't think this would be called unless there was an error...
  4. G

    Memory Problems and Recordsets

    Well, the upgraded driver seemed to be worse. I can't find any drivers older than the one that is already installed. It is from 2001 (the updated version is from 2003). I'll keep experimenting. Greg
  5. G

    Memory Problems and Recordsets

    There was an updated driver for USB printing support under the USB Devices in the computer manager. I will let you know if it works or not. Greg
  6. G

    Memory Problems and Recordsets

    Hm. Very interesting. I will explore this more. Any other ideas in case this doesn't work?
  7. G

    Memory Problems and Recordsets

    I'm pretty sure I do, but I can check. That's a good suggestion. Would that be giving me the "you have run out of Memory" error?
  8. G

    Memory Problems and Recordsets

    Hello all, I have a report that consists of a parent, 5 children and those children have anywhere from 2 to 7 children. This was done so that all of our different reports could be printed on one page for PDF convenience reasons. The problem. Ever since this report's conception, it has been...
  9. G

    Report Page Breaks with VBA

    I too am VERY interested in any help with this same question. I have searched all around and have found plenty of questions, but no answers. Thank you all for any help.
  10. G

    Parse a feed url

    Does anyone know if it is possible to parse a feed url? Any feed type will do (RSS Atom, JSON) I just need to know if I can do it in Access. Thanks for any help. Greg
  11. G

    Force New Page based on Subreport Position

    Hello All, Been a while since I've posted here which is a good thing. I have searched and searched for this answer but have not found anything. So I have a Parent Report that has a bunch of child reports. These children have a bunch of children. It is a huge, slow, but unavoidable report. I...
  12. G

    Dynamic Search Box using 'Like'

    Sorry it took me a while to reply, I got caught up doing things at work and forgot about this. Here is all of the code that I need to make things work as needed. I added all of the keydown code to handle using the arrow keys for navigation and still be able to use the mouse clicks. I added...
  13. G

    Dynamic Search Box using 'Like'

    Notice my previous post. The reason mine wasn't working was because I was using the wrong delimiters/escape characters. I think the others have answered your question otherwise, but if you want, I can post my exact code and you can tweak it to suit. I have it so that the list displays everything...
  14. G

    Dynamic Search Box using 'Like'

    That would have worked, but some contacts have a ' in their name so I did the double quotes. Thanks a million Greg
  15. G

    Dynamic Search Box using 'Like'

    Alright. Enough is enough. I needed to add "" i.e. ""* & Me.PreContactSearch.Text & *"" It all works wonderfully now. I did some cosmetics so that there is one text box and when the user types in that text box the list box becomes visible. Then oncurrent, the listbox disappears. Thanks pbaldy...
  16. G

    Dynamic Search Box using 'Like'

    Got the onChange to work, but I can't get anything to populate in the list box. My SQL: SQLStatement = "SELECT Customers.IDFLCustomerNum, tblContacts.ContactName FROM Customers INNER JOIN tblContacts ON Customers.IDFLCustomerNum=tblContacts.ClientID" _ & "WHERE tblContacts.ContactName LIKE...
  17. G

    Dynamic Search Box using 'Like'

    Furthering the problem: On change doesn't do anything until I exit the field. And, even after that, the listbox isn't updating based on that rowsource. I am doing a msgbox to tell me the rowsource after the text is changed and it seems ok. The listbox just won't update. Do I have to force it?
  18. G

    Dynamic Search Box using 'Like'

    Not sure I understand the .Text reference. On the OnChange event, I have AdvancedSearchText.Text doing what? Oh. Wait. To reference the control itself I have to use the .Text. Silly me. Takes a little more time for things to set in.
  19. G

    Dynamic Search Box using 'Like'

    Oooooh! That's pretty good. When would be the best way to dynamically change the rowsource? i.e. onDirty, onEnter etc. How do I keep the listbox 'listening' to the TextBox?
  20. G

    Dynamic Search Box using 'Like'

    No Problem. It seems you may be right. I may have to do a two step search of some sort, which is done in other places so perhaps they will not murmur too much :) Thanks.
Top Bottom