Search results

Hi.. I have a text box called Reference. I have data to enter which all start with the letter "M". E.G. M2049, M2050 etc How can I pre-define this text box that the letter "M" always appears. Thank you in advance Ruby

Andy....u are a darling Thankyou very much. I wouldn't have thought of that myself. Your help is very much appreciated Ruby

Andy.. Got it....its all working.. One other problem: I have a button which hides the "Note text box". The Text box and the close note button both appear when I click on the "Note Button". So the text box and the close button appear. I enter in my text. Then I want to hide or close the...

Hi Andy.. it doesnt work. When I click the button, the text box does not appear. The code for the button so far is: Private Sub NoteButton_Click() note.Visible = False End Sub The text box is hiden when I go into the form, but when I click on the command button, it does not appear...

Hi.. I have designed a form to insert users details. I have inserted a text box called Note. I want to hide this text box and i only want it to appear when the user clicks on a command button. How do i do this? Please help.. Ruby

Doug.. It worked, thank you Ruby

hi.. I have a form which has users details in it. I can add new users by clicking on the Add command button. When i click the Add button, a new empty record appears. But I cant see the text cursor anywhere, until i actual click on a field myself. I want the first field to have the text...

D-Fresh.. Thankyou...it worked. ruby

Hi.. I have a combo box which has a drop down menu. I want the combo box not writeable, whereas the users are only allowed to pick from the drop down menu. If i go to it now, I can type anything into the combo box and not have to pick anything from the drop down menu. I don't want it like...

AlanS... I must say a big Thank you to you.....its all working. Your help is most appreciated Thanks Ruby

hi Robert... sorry I actual pasted the wrong VB code above. The correct code is: Private Sub NextRecord_Click() On Error GoTo Err_NextRecord_Click DoCmd.GoToRecord , , acNext If Me.NewRecord Then DoCmd.GoToRecord , , acPrevious Exit_NextRecord_Click: Exit Sub Err_NextRecord_Click...

shacket... thank you for your idea, it works. ruby

hi AlanS.. When it gets to the last record, it now stops at the record with data in it, due to your help. When the users gets to the last record by clicking on the "Next Record" button, I want a message to appear to say "This is the last record" . The VB code so far is as above, but here it...

Thank you AlanS....it worked.. Just another quick question please, I just want to know what that line does.(wat it means and how does it work...the code line). "If Me.NewRecord Then DoCmd.GoToRecord , , acPrevious" Thank you in advance ruby

hi.. I have created a command button using the wizard to go to the next record. It works. But the problem is, if i have 2 records already there, and click on next record, when im on record 2. It goes to a new blank record. I dont want it to do that. I want it to stop at the last record...

hi.. I want to know if i can change the colour of a command button. It always stays grey. I can change the colour of the text on the button, but not the background of it. Thank you in advance ruby

hi i am using Access 2000 and am trying to delete a macro within the database, but it doesnt let me. No error message is coming up and the delete or cut option in Edit menu is not highlighted for me to use. Could you please tell me on how to delete a macro please. thank you in advance ruby

hey...i have it working......thanks alot for your help....just for telling me to use Orders.mdb got it working...thankyou

Hi...thanks for getting back to me. I have looked at the orders.mdb and have tried to work it out, but I still cant get it to work. Please could you advise me of any web page that would explain to me on how to do this. Appreicate your help very much. Thanks Ruby

Hi all, i have 2 tables: 1)DoctorsDetailsTBL 2)PremiseDetailsTBL and I have 2 forms: 1) DocotrsDetailsForm 2) PremiseDetailsForm. DoctorsDetails table and form are working fine and consist of doctors personal details. In PremiseDetailsForm, I have a section in the form called Doctors...