Recent content by geraldcor

  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...
Back
Top Bottom