0

I need to create a data file called students.dat and insert a few records into it.

I need (3) fields: 1) student id no. 2) last name 3) first name

I thought it would be pretty straight forward, but I get a compile error: Invalid Outside Procedure and "students.dat" is highlighted. Can anyone help me out on this? Thanks in advance.

Here is my code thus far.

Option Compare Database
Option Explicit

' Create Students Data file

Open "students.dat" For Output As #1

Write #1, "123-00", "Joan", "Blake"
Write #2, "560-05", "Mary", "Smith"

Close 2
1
Contributor
2
Replies
3
Views
9 Years
Discussion Span
Last Post by clueless101
0

After some persistence, I was able to create/insert records to the data file.

But, I'm not having any luck with the 2nd part of my assignment, which is to create a form permitting a user to view all records in the data file via populating records to a list box. I also have to use error handling when opening the data file.

Can anyone get me started in the right direction for this added task? I've added a button and list box to a form, but can't get the records to load...

Any assistance is greatly appreciated.

0

Solved this one on my own. Thanks anyway. It took me all night, but it's worth it when it works!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.