Search results

Hi Jemma-The-Husky I've found out what was wrong. The bound column on the list box was set to 1 (I think by default). I set it to 0 and it works fine now. Thank you for your help, your advise has been most helpful and it made me search a little wider for more answers.

Hi JHB I've found out what was wrong. The bound column on the list box was set to 1 (I think by default). I set it to 0 and it works fine now. Thank you for your help, your advise has been most helpful.

Thank you very much for your suggestion gemma-the-husky. I changed the code to the above, but unfortunately that didn't work. I also tried it with cInt just to see if it needed to match the field in the table.

Thank you so much for your reply. It is the first time I've posted so I just cut and pasted. I've used the # this time. I removed the date but still received the above error message. Here is the code again: Search text box - Private Sub txtCustomerSearch_Change() On Error GoTo...

Hi Bladerunner, my apols for the inaccuracy, I meant 6,000,000, and that was sadly just one episode in history. Whole families endured such unimaginable suffering and there was no-one there to help them. And it still continues.....with religious fanaticism driving such atrocities, and not a god...

Hi, I wonder if anyone can help. This worked in Access 2003 but not in Access 2007, 2010 or 2013. I have created a text box for people to enter search criteria, e.g. customer surname. The results appear in a list box underneath. When I select the record it should open up the customer's...

Yes, I am an atheist. I had written quite a lengthy reply on why I was an atheist but unfortunately the system logged me out because I took too long. I lost everything! I started losing my belief in God when I studied Scripture and read the Old Testament with incredulity at this childish...

Hello I have been programming in Access VBA for about a year but still have an awful lot to learn! I live in the UK in the north, in Eaglescliffe, which is about 1 hour’s drive from York. My hobbies include music, playing the piano, singing Barbershop, making clothes, drawing and visiting...