I need to share in computer club

[Guest]

Is there any online chat discussion regarding msaccess? If yes please let me
know the web address etc.....

Thanks in advance.

 

[Guest]

This is addressed to Jeff Conrad. When I try to reply, I get redirected to
another page of Microsoft. However, here is the info you requested:

Private Sub Form_Current()
If Me.NewRecord = True Then
Me.FirstName.SetFocus
End If

End Sub

I also am interested in the answer to Kutty's question. Thanks.

 

[Jeff Conrad]

in message:

This is addressed to Jeff Conrad. When I try to reply, I get redirected to
another page of Microsoft. However, here is the info you requested:

Private Sub Form_Current()
If Me.NewRecord = True Then
Me.FirstName.SetFocus
End If

End Sub

Ok, it looks like you have most of the work already finished now.
Now we must be absolutely certain that the first control on the form
you wish to have the cursor in is actually called "FirstName." To
do this, find the control on the form (in Design View) and right
click on it. On the Properties box that will pop up for this control
look on the "Other" or "All" tabs for an option called "Name."
What does it say for the name of this control?

Access may have named it something weird like Text25 for example.
If that is the actual name (using this example) of the control your
code would need to look like this:

Private Sub Form_Current()
If Me.NewRecord = True Then
Me.Text25.SetFocus
End If
End Sub

Follow me?

 

[Jeff Conrad]

in message:

Is there any online chat discussion regarding msaccess? If yes please let me
know the web address etc.....

I *think* these Access Chats are still going on each week. but I am not positive:

Live Access chats every Tuesday and Thursday:
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

 

[Guest]

Jeff Conrad:

An interesting thing happened after my last message to you. I pasted your
code in again and selected (highlighted) the whole thing. Then I clicked
Debug. Compile was available to be clicked that time and everything worked.
The cursor is now on the first name field after I click the Add New Record
button and also when I press enter continuously to get to a new record. Your
help was great. Thank you very much.

Now, please find out why I cannot answer you directly from my own postings.
I seem to be directed to another Microsoft page saying sorry they can't help
me. This page has a list of support options on it.

 

[Jeff Conrad]

in message:

Hi faxylady,

Jeff Conrad:

An interesting thing happened after my last message to you. I pasted your
code in again and selected (highlighted) the whole thing. Then I clicked
Debug. Compile was available to be clicked that time and everything worked.
The cursor is now on the first name field after I click the Add New Record
button and also when I press enter continuously to get to a new record. Your
help was great. Thank you very much.

Sweeeet!
That is very good to hear!
I'm glad we have the issue resolved now.

To continue your studies in Access I would save this link as it will help
lead you to many Access web resources. There are a lot of tutorial links
you may find very helpful:

http://www.ltcomputerdesigns.com/JCReferences.html

Now, please find out why I cannot answer you directly from my own postings.
I seem to be directed to another Microsoft page saying sorry they can't help
me. This page has a list of support options on it.

I'm not sure if you are aware of this, but I do not actually work for Microsoft.
I would, however, absolutely love to work there and we'd move up there in a
heartbeat if we had the opportunity. I digress.....

It sounds like you are accessing these newsgroups from Microsoft's Web portal
from one of the following locations:

http://communities2.microsoft.com/communities/newsgroups/en-us/default.aspx

http://support.microsoft.com/newsgroups/default.aspx

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

http://communities.microsoft.com/newsgroups/default.asp?icp=Prod_officebeta&slcid=us

The web portal is only one possible way to access the newsgroups.
Microsoft is continuing to refine and change the web portal so
from time to time it will experience some "hiccups."

I access these newsgroups using Outlook Express from three different
computers in three different cities and experience none of the problems
you are having. You may want to look into using Outlook Express (or
another type of Newsreader like Agent) to make your newsgroup travels
a bit easier.

Good luck with your project,