Search results

Why not have a seperate form for holidays and sick so she can add data and have this protection password on other forms. Ian Private Sub Form_Load() Dim FormPassWord As String FormPassWord = InputBox("Enter Password", "Password Protected Entry") If...

This is what I have, placed on the on current of the form. Ian Private Sub Form_Current() If Me.NewRecord Then Me.Caption = " NEW RECORD BEING ENTERED " Else Me.Caption = " " & Me.Title & " " & Me.First_Name & " " & Me.Surname & " " End If End Sub

Dave and others......Thank you. I ran a search after posting this and found a few things out amongst you link Dave (thank you). Am now playing around with vbTab VbCr and @@ (fun for a newbie - No way to centre the text I gather) - Also to get more lines do you have to do vbCr & vbCr or can you...

Thanks for that Ian...perfect. When you have text in a message box, how do you get certain parts of it to start on a new line or be in the middle? Ian

I've added to the code but get an error any help? Is it inconnection to using an underscore - it doesn't like the space? Ian Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then MsgBox "No certificates expired prior to "& Forms.Householder_Menu.Text70...

How would I get the date entered into a text box to appear in my msgbox - should no results be showed, the form that this msgbox will open on is not where the date entered field is. Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then MsgBox "No certificates...

I have some code that is repeated in variouys forms etc. From what I believe you can make the code a module and direct the event to it, instead of writing the code for each form that the same code is required. How would I go about doing this, say for the code below. Private Sub Form_Close()...

Why not set the student id number to: Yes (no duplicates), as many students do have the same name. Ian

Glad to see you sorted your differences out......I now have a question. What is the difference between the two codes, apart from one being longer - wouldn't you have to enter the name of the form into each code? Ian

I have two unbound box fields on a menu page and I want to disable the 2nd(End) until data is entered in the 1st(Start) - The second field is set to NO for enabled. My code below doesn't work....Any help Private Sub Start_Change() If Not IsNull(Me.Start) And Me.Start <> "" Then Me.End.Enabled...

Hi Rich (again) I think you must have a satalite receiver to home in on my questions!! (Thank you) What type of add in...? .. I noticed that when I first tried doing a letter in a report the formatting went all over..I did use copy and paste method. Any suggestions are welcome. Ian

For the mailing of letters I currently use Word via merge, I read quite often of people using reports. Would database life be easier using reports, ie for filtering, quicker at opening etc. Any suggestions and ideas welcome Ian

Rich, I have the query run a paramenter value box, with the below data in the criteria section.. <=[Enter in the last date of the GSR] You enter in, in 20/10/01 format, after this it opens up the form (not a report), which lists the people, here you have an option of merging with 3 letters...

Why not just enter macdonalds in the Query section untick the show box and save your query as macdonalds.....and you have the numbers of macdonalds. I know what you want, but this is difficult as I know, Rich or Pat may be able to tell you an answer. HTH Ian

I have a query that users have to enter a date for the records to show, it opens the form, but then on pressing a button to open the word doc that is linked to it, I get the request to enter the date again. Any ideas how to stop the second date request? thanks Ian

Dale What do the users of your d/b enter into the field that you are searching for null values when a call is closed? Ian

From my "not very experienced Access knowledge" I say you can't do what you want. Yet I had a similar situation and changed the options around like below. Eg... You can be 1,2,3,4,5,4&5,2&4 etc... (Make each of these an option in you option box) Now you can just click one option and get the...

I do keep track of all my posts, but don't for one reason and another manage to get round to completing the task.....So...... I need to know where abouts do you right click to convert a macro to code, I've tried all sorts to no avail...I'm running Access97. Ian

Ok, so no responce...........SO........... ...How can I just display one landlord's report from a combo box I put in a form I design...In other words I think I need a filter....I've not worked with these...Help Ian

I have a report that shows all the properties I have registered, what I want to do is have this report just to show the ONE I pick from maybe a combo box list? From this 1 report I will Publish it in MS word, so I can email this as an attachment to anyone I wish too. 1. How do you do the first...