Search results

Well actually now that I can reference the GetPhone() function its not really necessary. Before it was used to determine if an employee had an extension and if not grab their "Contract" managers extension.

Never mind Bob figured it out, I referenced a function I had programmed earlier in a module called GetPhone() the exact same way I would in VBA code: SELECT Switch([activeEmployees].[Phone], GetPhone(activeEmployees.[Reports To ID...

Thanks for the help guys but I think I've found a solution by using the switch function: SELECT Switch([activeEmployees].[Phone]="",(SELECT active.[Phone] FROM activeEmployees AS active WHERE active.[Employee ID] = activeEmployees.[Reports To ID...

Does anyone know if its possible to perform a CASE Statement in a SELECT statement in Access and if so what the syntax is? Thanks in advance.

PrnAdmin.dll COM library Issue Hello, I've encountered an issue trying to use the PrintMaster class and Drivers method from the prndamin.dll COM library. When I used the Drivers() method in a W2K3 environment it worked perfectly, allowing me to iterate through the specified servers print...

Yep works great, thanks :)

Alright I think I've stumbled on the problem. I originally created the forms being imported in Access 2003 and its just occurred to me that the project I'm importing them into was created with Access 97. I have since imported the objects of both projects into a new database and everything works...

I've tried and the breakpoints dont break but yet they still execute the code... it makes no sense.

Alright this is very strange. It seems that some of the buttons on my form still work as intended, but three buttons do not. I tried to recreate the link between the three buttons that dont work and their event handlers by going into properties, selecting the Events tab, select [Event Procedure]...

By this do you mean go into the properties of the control, select Event, select On Click then click ... button ?, because according to the property theres still a link between the event for the control and the code.

You dont happen to know of any solution other than replacing all my controls and placing the existing code in the new event handlers?

Hey Everyone, Don't know if this is a common issue or if I've just missed something obvious but when I try to import a form containing custom vba code none of my events seem to fire. I've tried putting breaks on all the event handlers but none of them seem to catch. In its original project the...