Wanted: Bughunter!

J

Jaybird

I've got an invoice form that does what I want, but with some inconsistent
problems. Occasionally it will tell me that I can't assign a value to some
record (which one?). Other times it will tell me that I can't save a record
because a setvalue or beforeupdate event or macro prevents it. Don't know
what it's talking about. This is a pretty important form for me and it's
full of bugs... Would anyone be willing to look at it and tell me what I can
do to fix it?
 
J

Jeff Boyce

These newsgroups are great for offering specific suggestions for specific
questions. You seem to be asking folks to debug your application, and
without a lot to go on ...

If this were mine, I'd add in a breakpoint in the code that runs behind the
form and step through, line by line, until I spot what's happening.

You might find someone willing to donate their time to keep hammering at
your form until it breaks, then debug why. Or maybe you need to consider
hiring someone to do that... (the folks who help in these newsgroups are
largely volunteering their time).

Good luck!

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jaybird

I'm just shooting in the dark... I know that occasionally, people will
upload compressed versions of their databases for debugging, and I thought I
would try and appeal to one of these people :) Okay, I admit, I'm
frustrated. I stink at coding and this thing has me all discombobulated. I
don't even know HOW to step through the code. I've faked it for as long as I
can. Now I could really use some help.
--
Why are you asking me? I dont know what Im doing!

Jaybird


Jeff Boyce said:
These newsgroups are great for offering specific suggestions for specific
questions. You seem to be asking folks to debug your application, and
without a lot to go on ...

If this were mine, I'd add in a breakpoint in the code that runs behind the
form and step through, line by line, until I spot what's happening.

You might find someone willing to donate their time to keep hammering at
your form until it breaks, then debug why. Or maybe you need to consider
hiring someone to do that... (the folks who help in these newsgroups are
largely volunteering their time).

Good luck!

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
J

Jeff Boyce

<G!> No time like the present to learn how! Consider how much time it would
take you to explain what you already have put together, before someone would
have any idea where to start looking. You know a lot more than you realize.

Open Access. Click on HELP. Type in "breakpoint".

If HELP isn't enough help, trying searching on-line with "MS Access
breakpoint" as keywords.

And since you described an intermittent problem, spend some more time trying
to nail down what (else) is going on when the problem does happen. That
might provide just the clue you (or we) need.

Maybe you'll get lucky and get an offer from someone with some available
time ...

Best of luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jaybird said:
I'm just shooting in the dark... I know that occasionally, people will
upload compressed versions of their databases for debugging, and I thought
I
would try and appeal to one of these people :) Okay, I admit, I'm
frustrated. I stink at coding and this thing has me all discombobulated.
I
don't even know HOW to step through the code. I've faked it for as long
as I
can. Now I could really use some help.
Click to expand...
 
U

UpRider

Where would one find your uploaded zipped database?
UpRider

Jaybird said:
I'm just shooting in the dark... I know that occasionally, people will
upload compressed versions of their databases for debugging, and I thought
I
would try and appeal to one of these people :) Okay, I admit, I'm
frustrated. I stink at coding and this thing has me all discombobulated.
I
don't even know HOW to step through the code. I've faked it for as long
as I
can. Now I could really use some help.
Click to expand...
 
J

Jaybird

I'd probably have to e-mail it... Unless you have a website to upload it to.
It's not real big. It's a little over 13K uncompressed. I've deleted
everything unassociated with the form (and probably a few other things I
shouldn't have). Anyhow, if you're willing to take a look, I can send it to
you. Meanwhile, I'm going to work on debugging it myself per Jeff's advice.
I had a few good ideas, but none of them seem to solve the problem. I'll
keep looking. Thanks for taking an interest.
 
J

Jaybird

Dave,
Thanks a lot for your earlier help. I'm a lot closer to understanding what
I'm up against. A related question, if you are still feeling charitable...
You may recall that I have code that creates an index if there isn't one. I
have reproduced it below:

If IsNull(Me.INVNUM) Then
Me.INVNUM = Format(DMax("Left([INVNUM],5)", "HDRPLAT") + 1, "00000") & "A"
Response = MsgBox("Is this Invoice Number what you want?", vbOKCancel)
If Response = vbCancel Then
Me.Undo
Exit Sub
End If
Response = acDataErrContinue
Me.Parent.InvoiceNumber = INVNUM 'Uprider added this line 9/7/07
End If

This is currently in the Current event of the subform sbfHDRPLAT. However,
it is causing problems when I use the 'Cancel' option. I'm guessing that it
is generating an empty string where an index is required. Would it not be
better to place this code in the BeforeUpdate event, so that canceling the
operation won't cause this problem?
 
Top