Search results

Phew 1 more question I also have a cancel button on the form which I want to use if i do not wish do add a new playername (and contact information). Basically this is a button which a user would press if they had accidently opened up this page and want to return to the switchboard. Is there a...

Hey, Rural Guy I cracked it! Now the unbound image that closes the form, only closes if there is a value in the playername text box, regardless of whether I had entered a name and then deleted it. I think the nz(Me.playername) covered all bases. I added this to the VB code (the red part)...

Yes Yes, Exactly

answer Yes the form is closing and the switchboard is opening as it should do (but only if the playername is not empty). If the playername is empty it should not close.

hey not getting an error message..it's just that when i click on the button (image) it should pop up a message saying the playername box is empty(isnull). if there is a playername entered then the form should close as normal. this is the on click code i am using: Private Sub...

try this is it relavent that the command button on the form is actually an image?

Me again I am using Access 2002. The code you just sent me does not work on its own. I also have to use the code in the on exit property.

Thanks Rural Guy Here is my code on the beforeupdate for the playername control: Private Sub playername_BeforeUpdate(Cancel As Integer) If IsNull(Me.[PlayerName]) = True Or Len(Me.[PlayerName]) < 1 Then Cancel = True End If End Sub I also have this code on the on exit property as the above...

It's sort of working! I have figured out how to make sure that if no name is entered in the playername text box then the user cannot tab into the next box.... Now for the next issue... I have a button on the form with the following on click code: Private Sub OLEUnbound199_Click() If...

Thanks Keith but it still gives me the error message I tried but it still gives the error message. Any other suggestions? Thanks so much for helping me. Rob

Nearly but not quite working Both Keith G and Rural Guy.....both you ways worked but there is one more thing. Let's suppose I enter a name in the client name field and then tab to another field...so far so good......but then if Igo back into the first text box (client name) and delete the name...

It Nearly works I used your cancel=true in the on exit property of the text box. It does disable the user from tabbing to another text box but I have a question. I entered the data into the first text box but after doing so it still prevents me from tabbing to the next text box on my form. Can...

Thank you Rural Guy All I needed was 3 words of code!!!! People like you make building databases look so easy! Thanks so much

Hello all, This forum has been a lifesaver in the past and I hope someone can help me now. I have a Contacts form that is used to input all the client's information. (name, date of birth, address etc). I want to be able to force the person entering the data to not be allowed to tab to the 2nd...

Running Sum Blues!!! Hello, I have a report which is similar to a bank statement. I have a transaction date and then either a credit or debit depending on whether the customer made a payment or if I am invoicing them...

Hello, I have the following code to send a report via outlook. Private Sub OLEUnbound238_Click() DoCmd.SendObject ObjectType:=acSendReport, ObjectName:="Statement One Player", OutputFormat:=acFormatHTML, To:=Me!Email, Subject:="Rob Nickels Tennis", MessageText:="This is a friendly reminder...

I am trying to create a new macro in my database. I selected the Openform action and tried to choose the name of the form but when I try and select the name of the form from the dropdown menu, I receive the following message: THE SEARCH KEY WAS NOT FOUND IN ANY RECORD. I am not able to see any...

Thanks again for responding.. I am trying to find out who is logged on to my database only.

Not quite working Thanks for the response but this does not work...I tried using CurrentUserName="Manager" but to no avail. Basically what I want to do is to check which User is currently logged on and from reference that username. ie. If the CuurentUser="a certain username" then open the...

I have entered the following code to an onclick button. I am sure I have written it incorrectly (it's probably the line I highlighted below to do with username=Manager. By the way Manager is one of my usernames I have created. Thanks for your help. Rob Private Sub Label218_Click() If...