Recent content by Hollis

Haha, I better not put that there, might freak some people out. Well that's fairly pain less, thanks for your help Banana :D

Yup sure. Here is the code: Private Sub Command29_Click() On Error GoTo Err_Command29_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_Command29_Click: Exit Sub Err_Command29_Click: MsgBox Err.Description Resume...

This error message comes up when you press a deleate button on the form that I have set up using the wizard. So is there anyway I can change what that error mesage says? Or do I need to write some code to deleate the related records in the other table?

Sorry, I've made an error. It's ment to read: Now on the report I am putting these two feilds in the same text box so that if you have one and not the other it shows up in line, and if you have both the text box will grow and the second number will be put underneath.

Hi All, I have a many to many relationship set up with my tables and as I know when you try to deleate a record that is in anouther table it comes up with this error message: The record can not be deleated or changed becasue the table 'tablename' includes related records. So I was...

I've tried: Format([ContactNumber],'!\09\ 0000\ 0000;;_') But it comes up with: 09 0000 0000

Hi All, I am making a details list with names, address, phone numbers all the usual stuff. For the phone numbers, on the form I have seperate inputs for a mobile and landline. Formatting the input mask for these is easy as the are two seperate objects. Landline mask: !\09\ 0000\ 0000;;_...

You are spot on there pbaldy, I did have a contol named FirstName, after I changed that it worked a treat. Thanks greatly for your help :D

I got this working: ="FirstName" & " " & [FamilyName] while this produces a #Error =[FirstName] & " " & [FamilyName]

Thanks for that, it looks like it should work but it's coming up with an #Error where that text box is, I'm using Access 2000, would that change anything?

Hello everyone, I'm making a list of people attending a program and I have their last and family name in diffrent fields (FirstName, FamilyName). Is there any way to have these two fields in the same text box so that the list looks like this: Aaron Hills Bob Brown Gorden Hollis rather...

I have it going now. Thank's alot!

Hello everyone, I have set up a report so that when it opens it asks for a Program ID. I have set up a form with a list of Programs and a button that when you press it will hopefuly open a report showing the information for the program you have selected in the list. So heres my problem, I...