Recent content by ColinH

Plog, the short answer to your comment is that I have a large database of biological records (>50000) which I need to sort by different fields and combinations of fields to produce reports, and I couldn't think of another way to achieve this. A longer answer is that the UK mapping system is a...

That's exactly right, mailman that character should be $ not &. The VBA works correctly now, thanks for your help. ..and a merry Christmas to you!

Thanks for your reply Minty. I think the double quotes are resolving correctly as you can see from the error report above, the problem might be an extra comma but I can't see where. They also look correct in the Immediate window: IIf(IsNull([Site].[Map_ref_letters])," ",[Site].[Map_ref_letters]...

I have a make-table query based on several other tables together with user input, and it works well. However, I don't think I can't use the query as it is. I think I need to create the same SQL text in VBA and add various WHERE values which the user creates by selecting values on a form. The...

Oh dear! The solution was so simple I really should have found it without bothering the group. I simply had to delete all the linked tables coming from the data file and relink them. Then it all worked perfectly. What misled me was the error message in VBA which was...

I have a large, old application to handle biological recording which I've just moved from an old XP machine to Windows 7. The path on the new machine is different to the path on the old machine. The application is split into data and application parts, so the application contains a variable...

Thanks, vbaInet. Again, I wasn't aware of that subtle detail that I don't need parentheses if there are no parameters. So much to remember!

vbaInet, thanks for responding. I don't understand your use of the term 'Event Box'. I'm using Access2003. The code is run by clicking a button, so I go into design view on the form, highlight the button, display its properties, click the Event tab, then the 'On Click' event and next to [Event...

Got it working at last! Many thanks Bob for pointing out my Private/Public error. I'm so used to Access automatically generating the Subs' framework I didn't think of the Private/Public issue, but like a lot of things, it's obvious when pointed out. The following line finally worked: Call...

I tried that vbaInet, but couldn't get it to work. Both the next two lines fail with syntax error: Forms!frmBookCourses!cmbFindDelegate_AfterUpdate() or Call Forms!frmBookCourses!cmbFindDelegate_AfterUpdate() VBA asks for an "=" either before or after the main text. I guess its treating it...

Many thanks for your reply vbaInet. I did try setting .value to the DelegateID, but this doesn't trigger the combobox AfterUpdate event. In the original app. when the administrator selects a delegate the AfterUpdate event triggers a search for comments about the delegate and his parent...

Well, I've found a solution to my problem of a couple of weeks ago so I thought I'd update this post. The aim is for a value selected in a list box on one form to filter and update a combo box on another form. The filtering worked fine but I couldn't fire the AfterUpdate event on the combo...

strSQL1 and strSQL2 are two text strings that make up an SQL query. strSQL1 is a standard part, strSQL2 is a part that changes according to which entry in the wait list is highlighted. You'll see the code in my database, but it picks up the DelegateID from the first column in the list box. I...

I thought I had uploaded this yesterday, but apparently not. ColinH

I'm not an Access professional, more of a tinkerer. I live near Reigate in Surrey and I started off as a physics teacher but became disillutioned after about ten years and looked for a similar job in industry. I'm now a trainer at a software and hardware manufacturer in the south of England...