Recent content by jamierbooth

Aha!! You mentioning that forced me to revisit the queries and I discovered some errors in the field names used. So it wasn't the code, it was the 'like' statement in the queries. (said cboType instead of txtType). Thanks for pointing me in the right direction!

Hi All. Due to my employer giving me Access 2000 to build with, and everyone else Access 2000 Runtime to use the DB with, I'm having trouble building them a dynamic sort and filter option, because Runtime doesn't let you use the normal sort and filter. It seems like my only option is- as...

Sorry, again not working. I tried just adding me.requery as the last line of each little segment of code ie: Private Sub SrtDoB_Click() Me.Refresh Me.OrderByOn = True Me.OrderBy = "[DoB] ASC" Me.Requery End Sub and Private Sub FiltNew_Click() Me.Filter =...

Sorry, that doesn't fix it....

Hi All. I'm using access 2000 to develop and my staff are using Runtime to use the DB. I understand that the right click and menu-type filter and sort options are disabled/not available on Runtime. I recently made some additions to a continuous form for a user to click on a label (ie...

Debug is stopping at this one..... Set outapp = CreateObject("Outlook.application")

Thanks AOB. Have tried that, but I'm getting a Runtime Error 429 'ActiveX component can't create object'. If this isn't something that can be fixed with late binding or anything else you can think of, it might have something to do with the archictecture of our system here. We work on a...

Ah. Things are becoming clear. The DB I'm creating will be shared amongst a number of staff but we all have access to identical applications, as this is the way our ICT dept have set us all up. We all have Windows 7 OS, MS Access 2000 and MS Outlook 2010. (and Word & Excel 2010 - ICT don't...

Hi, Sorry its been a while since my reply, but I've been in demand elsewhere and only just come back to this project. Thanks for the response, however.... I fall down at the first hurdle - and some other issues.... When you say - "So - early-binding first - in the VBA editor, go to Tools >...

Hi All, I'm trying to have a command button send info on the form straight to Outlook as a meeting. So far, the code below works apart from the address bit. I need the code to automatically add the same 2 email addresses as recepients everytime. Error message highlights the red line below with...

Brilliant. OK. Would never have known that in a million years. Code and button work fine now, thanks a lot. And thanks for the various other bits you have taught me on your website!

Hi world, (MS access 2000 user.....) I'm trying to create an "Add" button on a form that will create a new record in a junction table and copy 2 values from the form into new record. There is a clients table, a contacts table and a junction table - a many to many type relationship...

Hi Guys. - Using MS Access 2000 I may be being a bit over-ambitious here. I'm building a customer management database. Part of which is a table to record details of all members of the main customers family or the household compliment. I'm currently using a DCount to work out how many...

Lovely cheers. I took off the msgbox bit, because I didn't any message coming up, but altering that error code slightly to match yours has done the trick. Thanks. Private Sub txtEmail_Click() On Error GoTo ErrHandler DoCmd.SendObject acSendNoObject, To:=Me.Email ExitHandler...

Thanks. That works fine, although I get an error message 2501 (Sendobject action cancelled) if I close the email without actually sending it. Have tried to suppress this with an error handler in the On-Click code to no avail... ErrHandler: If DataErr = 2501 Then Resume ExitHandler...