Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Error:Unable to open first record!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error:Unable to open first record!

 Post Reply Post Reply
Author
vinaylak View Drop Down
Newbie
Newbie
Avatar

Joined: 01 June 2004
Location: United Arab Emirates
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote vinaylak Quote  Post ReplyReply Direct Link To This Post Topic: Error:Unable to open first record!
    Posted: 01 June 2004 at 10:12am

I have been working on this s/w project which is supposed to accept data from the user and print it out onto ptre-printed forms.I have used VB frontend,CR7 for printing report,Access back end to temporarily store the data before transferring to CR.

Everything worked fine on the project.After compiling it and making it into a package I installed it in  my own PC and when I ran it I got this error:

"UNABLE TO OPEN FIRST RECORD!"

I went back and tried to run the original VB project file.IT ran just fine and gave the correct output too.

What could have gone wrong here?

Can anyone help me please?I am desperate for an answer.

Back to Top
vinaylak View Drop Down
Newbie
Newbie
Avatar

Joined: 01 June 2004
Location: United Arab Emirates
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote vinaylak Quote  Post ReplyReply Direct Link To This Post Posted: 01 June 2004 at 11:19am

Someone please help.I have tried all sorts of things on the  code.The data is being entered into the db correctly before it is transferred to the CR.

I don't know where the error is coming up from.

 

Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post Posted: 01 June 2004 at 4:03pm
yo, take it easy.. an hour isn't enough time for us to give an answer.. we're not here 24/7 you know!

we need more specific details on how the script look slike where the error comes from and maybe some more
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 01 June 2004 at 4:44pm

If you created a .mde file, did you recreate the links to the db when you moved the executeable?

Do you have the access runtime and cr7 installed on the pc you moved it to?


Lead me not into temptation... I know the short cut, follow me.
Back to Top
vinaylak View Drop Down
Newbie
Newbie
Avatar

Joined: 01 June 2004
Location: United Arab Emirates
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote vinaylak Quote  Post ReplyReply Direct Link To This Post Posted: 02 June 2004 at 3:50am

I have included the DB in the package as well.And it has been correctly installed into the same folder containing the Project CAB file.I had just given this code on the Form_Load() to set the path:

Set datastore = OpenDatabase("delidata.mdb")

The thing works fine on the project file.Only when I make it into a EXE does the error come up.

Sorry about the post earlier post.I was getting so depressed, more so since I didn't think I was going to come up against something like this with something so easy.

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.