Error in VB code

[Lou_Reed]

I am trying to run this very simple program in MS Access 2010. It fails with an error and I am not sure what it is.

Any help appreciated. Thanks in advance.

The program is posted below.

Respectfully,

Lou Reed

[RuralGuy]

Your program did not post.

[Lou_Reed]

I know that I have done this before and I cannot figure out what I am doing wrong.

I do not need to zip it. It is less that 2 GB.


R,

Lou Reed

[Bulzie]

What is the action you are trying to do and what is the error message?

[Lou_Reed]

I am trying to upload a MS Access 2010 db that is quite small. It does not need zipping. But when I find it (the file) and then I click upload nothing happens.

Any help appreciated. Thanks in advance.

Respectfully,

Lou reed

[RuralGuy]

Zip it up and try again.

[RuralGuy]

The limit on accdb or mdb files it 500.00 KB. I always just zip to save time in the Upload/Download.

[Lou_Reed]

Maybe that is it. it is so small a file that I thought zipping was not needed. I have a zipped version anyway.

[orange]

Post/attach the zip file.

[Lou_Reed]

I think that I may have uploaded it. I am sorry for the delay.

R,

Lou Reed

[RuralGuy]

You have nothing in the Click Event of the button on the Form. What do you want then button to accomplish?

[Lou_Reed]

The zipped code is in the previous post. Ch2CodeExamples.zip. When I run the

VerifyCreditAvail 5.0, 4.93

I get an error: Procedure Undefined. Something like that. It is so simple code that to fail is hard to believe. Then again, I am new MS Access 2010 VBA.

Any help appreciated.


R.

Lou Reed

[RuralGuy]

I downloaded your db and see nothing in the Click event!

[Lou_Reed]

I am currently just going through a tutorial. The click event is in the next part, I am not there yet. This just says put this code in then go to Immediate window
and type

VerifyCreditAvail 5.0, 4.93


That is when I get the error. Undefined Procedure. As I said it is a simple set of code.


Respectfully,


Lou Reed

[RuralGuy]

I don't believe you mentioned that yet in this thread.
Try putting this in the Immediate window:
?VerifyCreditAvail 5.0, 4.93

...note the leading "?".