Search results for query: *

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?

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...

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

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

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

Hi there I have an access 97 database with a problem. It will not allow me to Compact or repair, coming up withthe above error message. The ldb file closes so it looks as if it is behaving except for the above issue. If I move the database to another folder it works. Other databases i the...

Hi I am not sure if this is the right forum. A customer is getting the following message when they try and compact/repair an MS2000 database: "Table Temp MsysAccess Object already exists" and does not complete the compact. In addition it locks users out when they try and dial in to the...

I have a bit of code creating a an email message with a couple of attachments from an access 97 db. It has been working OK. Now the runtime error mentioned appears at the following line: Set objEmail = objOutlook.CreateItem(olMailItem)line. I have enclosed the code below. Any ideas...

Hi there I have this bit of code which is in an Access 97 database (below), which creates a new version of a word document. However it is not working. It is stopping at the section Marked:"Next bit is Deleting of old issue date and inserting new IssueDate bookmark to allow new issue to accept...

Hi there I have a form with a sub form which is a continuous form. There is a field SalesPersonID, which I would like to format in different colours when the SalesPersonID changes. So at a glance the user can identify the salesperon. I am sure it is a simple bit of code but I am a beginner...

I have 2 text boxes formatted as Date/Time - Short time. The user puts in a start time and a finish time. Using =((([FinishTime]-[StartTime])*14.4)*100)/60 this calculation I can work out the duration between the 2 time input. However if the Start Time is before Midnight and the finish time...

I am working on a db in Access 97. In one of the forms the users enter in data and in order to save time I have made the date field with a default value of =Date(). However recently the default value has started showing the #Name? error. The only change to the set up is that MS Outlook has...

Hi I am working on a database in Access 97 and the client want the words Profit & Loss written on a report. However when I write the text the & becomes an underscore. Any ideas? Jonney

I have created a database in Access 97 for a client which uses the calendar in one of the forms. The database sits in a shared folder. It works on most pcs in their place of work but there are one or two pcs where the calendar will not work. A message pops up saying the object cannot be...

Does anyone know how to total time if the field type is short time. Also is it possible to divide time field by a normal value to get items per minute for example? Hope tha tmakes sense. Thanks Jonney

When I try to enter data into a sub form I keep getting this error message "Not a valid bookmark" Does anybody have any suggestions as to what might be the cause

I have a table which I have been messing around with. I now want to return the autonumber back to 1 so that the client can start adding real data. Does that make sense?