I have a data entry subform based on a query. When editing or adding Irish names such as O'Toole, I get an "Error 3075, Syntax error (missing operator) in...

Impossible de trouver l'hôte SMTP. Vérifiez que vous avez entré correctement le nom du serveur. Objet 'Envoi d'un message :...

On My form I am Trying to write a code if the Horse is 3 years old F changes to M (Text) If Year 3 repalce F with M -- Thanks in advance for any help...

Hello, I need a pro who can recommend what steps I should do. I am creating a check writer program using Access 2002 downloading name, address, check...

Hello I have endeavoured to get assistance with this problem in the past, but I think part of the problem was my explanation of what I want to do. As a...

I wrote a bond trading/tracking application whose scope creep has made it a candidate for moving to SQL Server as a back end, and then for a rewrite of the...

my email

On my Form I have a text box and have a combo box to a query that has how can I get my query to filter to the same HorseID on my form Thanks for any...

Several years ago I remember reading it was best to use the Integer Data Type instead of Byte (even if the values where always going to be 256) We're now...

I have a form with a another pivot table form embedded in it. I want to create a button that will export the pivot table into excel. I created a macro to...

Hi Gang, My Access 2007 is doing something very wierd. When I am entering my information into various columns, my primary number automatically changes. In...

Hi! This is "Cesia" LOL!

Hi all, hope somebody can point me in the right direction. I need to display images in a report. At the moment the images are embeded in an excel file. Is it...

I just implemented Access security on a db developed in Access 2003, but in Access 2000 format. By default it seems that the security pop- up fills in the...

I have a field that could be split into 2, one being name and the second being a number. Due to data quality beyond my control and which won't be fixed I...

I have created a query that includes an admission date for patients. I want to create a separate field in the query that flags all admission dates less...

I have a form that users will enter infomation into my tblAttendance. The info they are adding is "EmpID", "DateAbsent", and "AbsentType". How can I set this...

I have an access data record in Access 2003. I now want to update and add information to it. usig 2007. When I open the file, I can't find anyway to bring...

I've had an Access 2003 Database in our office for years, working very well. Our powers to be, decided to upgrade to Office 2007 and asked me to convert my...

I have two tables with almost matching data fields: And I need to compare and match the exacting data to each other. However, one table may have more items...