Search results

I have a table on another project so I just have a example to post here...

Here is what I did and for some reason it is not working.. I made a module named mpl_CNT and then created my txtbox and named it Players and put =fpl_cnt into before update event.

lol.. I think I'm lost now.. sorry..

Thanks for the help... One question.. I would need to post the code you provided in the text box where I want the count displayed.. in the event procedure?

Can anyone help? Here is what I have already, Please see attached. Here is what I am trying to do. I enter the players names in the text box then they appear in a large txt box. What I would like to do is to have another txt box that counts the number of players that are in the text box...

I have a couple of questions.. 1. What does the "on got focus" do? I did my own and I couldn't get it to work until I put the code into "on got focus". That code is Private Sub Command4_GotFocus() Me.txtPlayer.SetFocus End Sub 2. How do you get the form to pop up when you click on team...

Works like a charm! I am going to dive into it and learn from it.. hope u don't mind if I ask why you did what you did so that I can understand..

I like it... works great!! Thanks a ton.. I was actually wondering sort of the opposite though.. So in the box you have team name... I would enter the team name in the form view such as eagles or whatever i wanted... Next I would enter in the players name in the text box (text box 1)beside...

Can Any one help with the attachment... I am trying to have the user input a team name and under that team name enter the players to that team. Once they enter the player name... there is a txt box to the right that the name appears in.. I want the user to be able to enter more then one name in...

Ok... I created a two tables.. one named Team and one named player I also set the primary keys to the Team ID and Player ID How do I set the field named Team ID in the Players table to a long interger? This is probable very simple.. i'm just not that experienced with access

Thanks so much.. I'm gonna give it a try.. you mind if I have questions to send you a reply back? Thanks again

I am to type in lets say a football team... called eagles and I also want to put all the team members that belong to the eagles. Is there away to do this? An example of this would be that I select the team eagles from a form that is linked to a separte table via a drop down menu. Then I...

Not sure boblarson why using just "date" would give me 12/29/1899 but it did.. so I used MSAccess option and it worked... I also used another code that someone suggested.. Here I just used the text box called currentdate2. This stamped the date as 12/29/2009 either way it worked! Private Sub...

Sweet! that worked... I also got this to work too.. I made the control source the text box.. Private Sub Toggle2_AfterUpdate() If Me.Toggle2 Then Me.Toggle2 = Format(Now(), "Short Date") Else Me.Toggle2 = Null End If End Sub

Your the man MSAccessRookie! Thanks to you too boblarson!!

I did what you said and I still get a date of 12/29/1899

I'm not sure what you mean... If I set the toggle to a text box how will it know what to put in there? can you give me an example?

I am wondering how to get the current date 12/29/2009 without the time in a text box using a toggle button. I had someone else, Thanks boblarson, who helped me to get this code. When I use this code I get 12/29/1899. Private Sub Toggle2_AfterUpdate() If Me.Toggle2 Then Me.Toggle2 = date Else...

I've tried using the now function but I don't want the time with it..

any idea how I could get 2009 instead?