Hi I am new at Access programing. I have read everything I can find about Access, but nothing wants to work.

[sledgehammer]

This is some simple code I wrote. I run it through debug and get no errors. When I put quick watch in the debug they show <out of context>. I have tried everything I can think of and nothing works.

Public Sub txtGoto_Enter()
Dim MyString As String

Open "C:\Residents\Residentvb.accdb" For Input As #1
Do Until EOF(1)
Input #1, MyString
If gotolot = LotNo Then
End If

Loop

Close #1
End Sub

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[theDBguy]

Hi. Welcome to AWF!

This is the introduction forum. Suggest you start a new thread in a more appropriate forum.

Just in case it helps, maybe take a look at this blog.

How to Read a Text File

Invariably, at one point or another in your journey to write VBA in Access, there will come a time when you will need to read the contents o...

thedbguy.blogspot.com

 

[The_Doc_Man]

I'm going to leave the posts as they are, but it appears that you have double posted. You are new here and don't know our ways, so I'm going to just make a note for others to work with the post at this link

Need Help with Access

This is some simple code I wrote. I run it through debug and get no errors. When I put quick watch in the debug they show . I have tried everything I can think of and nothing works. Public Sub txtGoto_Enter() Dim MyString As String Open "C:\Residents\Residentvb.accdb" For Input As #1 Do Until...

www.access-programmers.co.uk

and leave this introductory post alone.