Recent content by sreyes27

I believe you are correct, I apologize. But I think I found it anyway: ChDir App.Path In my urgent haste for an Access application, I didn't really think about where I was posting my question. Thanks!!!

I am new to VB development so my question is an easy one: How do I set the current working directory for my visual basic application? Let's say my exe resides at d:\dev\vb\folder1 and so when I execute my exe from a DOS prompt at that directory, I want the current working directory to be that...

RE: Undefined function in expression Thanks for your reply. I am really confused. I need to call a stored query that requires 1 parameter. The stored query is 'viewPatient'. Again, it takes 1 parameter, ie. patientId. How can I do this? Thanks t

No, the stored query was created within Access 2003. So I just want or need to invoke it from a Visual Basic program. The stored query (viewPatient) needs 1 parameter (patientId). Thanks!

Any help anyone?

My problem is this: I need to call from VB a stored query (in Access 2003) - called 'viewPatient', which takes in 1 parameter (patientId). I say I need to make it a VB program because the stored query uses custom VB code to process the query - code which is unseen by an outside program (C++ or...

I don't quite see how or where is the database opened. - Sorry Newbie

I am new to the Access and VB world so my question is pretty basic. I need to call an Access stored query (which happens to take 1 parameter) in Visual Basic. Can someone tell me the best method and how to accomplish this? Would ADO be the best mechanism (as opposed to DAO)? Your help and...

I'm sorry for being a newbie, can you tell me how I can do this? Thank you!!!

I apologize for the confusion, I meant to address stored queries within Access and not stored procedures. So the stored query calls or uses VB functions within Access without any issues. But outside Access I am having problems getting to the VB functions. I hope to have clarified this, if...

Thanks for your interest on this issue. Without getting into other issues that do not seem to be relevant, what you can do is just create a Visual Basic function and that is called by your stored procedure. Now call the stored query from a Visual Basic program. You will then see what I...

Reply (Undefined function in expression) There's nothing spectacular about this function, But I'm enclosing it nevertheless. The jist to my e-mail has to do with problem getting to Visual Basic code by a stored query when stored query is called 'outside' of Access. That is by either c++...

I hope someone helps me with this (I've been bugged by this one): My environment consists of an Access 2003 database which contains some stored queries. In particular, the one I'm working with is called 'viewPatient' which contains some Visual Basic functions. The 'viewPatient' query works...