Access 2003 developer extensions (Startup Wizard)

[Patentinv]

Hi,
I've finally opened the Visual studio for MS Office systems tools box and found the access 2003 developer extension CD and loaded it,
I've been reading the overviews on the CD as always it sounds easy to use, how ever through experience on APPs that is not always the case.
Sure enough I was right again, Can any one help?

My problem is when I open the custom startup wizard or the custom package wizard it opens a form that is suppose to have templates to choose from so to get started, How ever there are no templates in the form the form is blank. Which leaves me stuck with no options to get started.
All installed on my PC is the access 2003 developer extensions, did I not install some thing I should of?

Thanks, Any Help will be greatly appreciated.

 

[PHV]

All installed on my PC is the access 2003 developer extensions
You don't have office2003 (at least access 2003) installed ?

 

[Patentinv]

Hi PHV,
Sorry about the late response, Yes I have Access 2003 Installed, but not office 2003.
I think I'm going to spend the money and use SageKey MSI Access 2003 Wizard, I've heard this is the easiest and most stable way.

I have been told I need to convert all my macros to Vb code modules, for error handling.

I have one problem I've also been told that the filter by form is not available in Access Runtime. Is there an alternative way for me to filter to the record I need, which will run in Access Runtime.


Here is my converted macro Code that does not work.

Function Find_Applicant()
On Error GoTo Find_Applicant_Err

DoCmd.Echo False, "Please Stand By"
DoCmd.Hourglass True
DoCmd.RunCommand acCmdFilterByForm
DoCmd.RunCommand acCmdClearGrid


Find_Applicant_Exit:
Exit Function

Find_Applicant_Err:

MsgBox Error$
Resume Find_Applicant_Exit

End Function


Thanks--Any suggestions would really help.

 

[PHV]

my converted macro Code that does not work
Any chance you could post the error message(s), if any ?

 

[Patentinv]

Sorry,

It brings up a little box that says the (runcommand action was cancelled) I click OK and it brings up another small box that says (OK) so i click Ok and it brings up another little box that says (Resume with out error) I click OK and it goes back to the same blank little box again, it does this forever
from (Resume with out error) to Blank Box with OK.

Thanks--I really appreciate your help.

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/166634/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Patentinv]

Hi PHV,
This will not work in my case, I just tried it. It gives error after error, on all forms in my DB.
Maybe because its made for Access 97 and I'm using Access 2003.

Thanks any ways PHV--I really appreciate your help. Do you have any other suggestions, otherwise this will stop me dead in my tracks if I can't figure this out, I've been working on this DB for 3-4 months.

I had no idea Access Runtime was so temperamental.

 

[PHV]

And this ?

http://download.microsoft.com/download/access2000/Sample/1.0/WIN98Me/EN-US/Qbf2k.exe

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Patentinv]

Same results as the 97Qbf.exe I even checked the DAO as readme
instructed in visual basic editor.

Thanks PHV--I really appreciate you trying, I may have to out source this, I'm not real good with SQL or Code. But at least I have a couple of example ways it can be accomplished.

I appoligize about refering to my problems directly, I understand every one who posts here has the same reasons.