Search results

This code does not work Text39 = Date If (DateDiff(Text39, [EndDate]) >= 12) Then MsgBox "End date near" End If What I am trying to do is: If Endate is within 12 months of the current data , Open MSGBox. Any help Thanks

Please can anyone tell me how to make a update query that updates a fields certan fields on a form. I want to be able to run it off a button Thanks

Hi I have to fields on a form. Start Date End Date These are dates when a student starts and ends their time at uni. After a startdate is entered eg. 01/01/00 the end date automaically adds on 6 years ( the time they have to complete the course) What I need is a field that looks at the...

Re: Seems to work for me... Sorry my fault did not explain very well I am trying to up data all the field with out having to select each one

i am trying at the click of a button to up date the field "Status" on a sub form on the based on what is selected in a combo box. But it only works if you select a the recod manually it might be more clear to show you have a look at the DB Any help would be great Thanks

hi I have a text box on a form which I want to be able to display somethin like this record number 1 out of 250 I know you must have to use Me.Text15 = Form.RecordsetClone.RecordCount but not sure of the rest Any help Thanks in advance

Thanks Thankyou very much for the example. I have a few more questons about it . How do you select values from two tables Open a form based on the results Sorry to keep asking you but I find it much easier to learn by seeing an example I have uploaded a new version of the database with...

Re: Re: Cant any one tell me why this does not work thankyou for your reply and sorry for posting the message twice. But i get an error Number 5 invalid procedure call or argument any ideas I do have Access XP but I though that 97 was the most common format so if you want to send a...

If any one can make this work I will be forever in your dept thanks in advance

this is the database

This is really baffling me if anyone can make it work I will be for ever in you dept Thanks is advance

Any idea why this code will not work Me.RecordSource = "select [StudentNumber] from [Add/ViewStudents] where [Studentnumber] like '*" & Me!txt1 & "*'" Or "select [Postcode] from [Add/ViewStudents] where [Postcode] like '*" & Me!txt2 & "*'" Thanks

I am using this code in a macros where condition to open a form Open Peopleform WHERE Forms![Students]![StudentNumber] = [Student]![StudentNumber] Or Forms![Students]![ProgramNumber] = [Program]![ProgramNumber] Studentnumber is txtbox on the search form ProgramNumber is a txt box on...

Can you put text on a new line in a message box so it appears the record you are about to view is number 1 Any ideas

two questions I want to open a form2 IF Form1= txtbox1 = Password FROM table People AND txtbox2 = ID FROM table People if no record found Msgbox "no record" Also If a user enters text into a field how do you check if the same text has been entered in the same field in a different...

This is what i want do open a from if Textbox1 = ID from Table People AND Textbox2 = Password From Table People If no record is found then a msg box appears with saying "Incorrect" The form is not based on the table Any help would...

Thanks that really works great . You are the Access Authority

I have this code Private Sub Form_Current() On Error GoTo Err_Form_Current If IsNull(Photo) Then Photo = "C:\Documents and Settings\Peter\My Documents\My Pictures\nophoto.bmp" Else Me![ImageFrame].Picture = Me![Photo] End If Err_Form_Current MsgBox "This is not a valid File Name"...

I have a button that updates a field I want a message to appear to the user to allow them to selet Ok to change the field or Cancel to do nothing. I also want to insert a file path from a field on my form called Image Path Any help Thanks in advance

I have a a field ImagePath which Stores a default Image to display in a imageframe. I also have a browse button so I can located a new image and that image is stored in the field ImagePath But i have to close the form and open again before the default image is replaced