Recent content by molsen123

Hi All Any ideas how I get rid of the lines appearing in a report? I've set everything to transparent but the group header and subsequent records in the subreport all have separating lines. Attached is an example Many thanks

Mmmm. That worked fine, and I have done some further modifications to pretty it up for the user. When I'm in the master form in the single field showing the week ending date, if I page down, the relevant records for that date are shown. However if I use the drop down box (I've converted it...

Hi All I have been tasked with converting a spreadsheet to an access database. I thought it would be simple, but after some analysis, its not that easy. I am also self-taught, and after reading the commandments, I thought I would seek some advice! I work for a growing firm of Tree-Surgeons...

“Twas the night before implementation And all through the house, Not a program was working, Not even a browse. The programmers hung by their chips in despair With hope that a miracle soon would be there. And the users were nestled all snug in their beds, While visions of inquiries danced in...

Today, my wife told me she had a head cold. I said, "its probably because you are so fat". "How can being fat cause a cold?", she asked. "Because your heads never out of the fridge"

Yesterday I underwent a painful procedure that required me to have my spine and both testicles removed. Still, I got some great wedding presents!

Many, Many thanks!

Hi All Apologies - been away for a while. Still cant get this working. When I click on an address in the list box, I get the following: Run-time error '3075': Syntax Error (missing operator) in query expression '[Location]' = Sherwell Rise South, Torquay'. Cant figure out how I've...

Thanks again - However this time I have a compile error with the .ItemsSelected highlighted as the problem. I'm wondering if I have the wrong field names selected in the code

Hi All I followed the instructions above to the letter (eventually), and it works a treat. However due to renewed inspiration after finding this website and your gold-plated advice, I wanted the user to be able to select a record in the list box and open a form showing all the information...

Fabulous - Works a treat. Thanks a bunch!

Hi Again Kind People I have tried your method via the link in your response, but I get the following "compile error - method or data not found" when typing in the search data. I have added the code to the On Change event property of the SearchFor box: Private Sub SearchFor_Change() 'Create a...

Thanks Brian & John. The very demanding user is UA testing at the moment so I'll give it a go! Rgds

Hi All What a great site! I am not new to Access, but I am, so far, only a UI developer - not much VBA experience. Using Access 2003. I have created a simple database for a user to input job orders and produce a 'job sheet' and an invoice, as well as various other reports. It all works...