Recent content by jonney

I get this message "This form or report contains changes that are incompatible with the current database format. The form or report was not saved" in access 2010 when working in mdb format. any solutions?

Think I see your point PHV. There is no place for a text field in teh recordset syntax. I took the field out and it seemed to work. Do you agree? Jonney

EMAIL is a text field. Jonney

I'm getting this runtime error every time I run this procedure: Private Sub btnEmailAttendees_Click() Dim oApp As Outlook.Application Dim objNewMail As Outlook.MailItem Dim objOutlookRecip As Outlook.Recipient Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim strCountSQL As...

Thanks for your replay. Will try and out and see. Jonney

Hi there Each time I create a new contact that has a business fax number outlook creates a new contact with the bus fax in the email box. This means I have duplicate records - one with an email address and one with a bus fax number instead of an email. Very confusing Any ideas? Thanks Jonney

Got you!! Thanks again. I'll give a go and see if it sorts the issue. Jonney

Thanks for your help By appearance tab, do you mean Format tab? Jonney

I have a database(ms Access 2003)that on some screens appears normal and on others shows the labels ina cut off format (i.e. not showing all of the label). We have changed the resolution but same issue. The OS is WXP and the version of access is 2003 Anyone got any ideas as to what causes this?

Hi I am trying to automate the process of creating a backup of the back end (datafiles) from the front end to ensure users do not lose data as part of a procedure. Hope someone can help Jonney

Thanks for the prompt replies. That is very helpful Jonney

I have a split database and I would like to be able to add a field to a table using either a query or some code. I hope that makes sense Thanks Jonney

Hi I was hoping someone might be able to help with the creation of Quartiles in access. I have read thread181-54516 but am not sure how the functions should work. Can anyone help? Jonney

Hi I am not sure if this is the right forum...I have created a replica and master. However I am getting an "Out of Memory" error on simple open form commands. The database is XP and is not split. Any ideas? Jonney

Yes, my mistake. I meant the ldb file is deleted and the permissions for the folder seem fine as user can compact other dbs in the same folder. In fact this is a recent issue and until recently the file could be compacted. Any thoughts? Jonney