I had a problem with ActiveX control calendar to enter dates in a text box so I switched to Allen Browne's Popup Calendar. I have set the control source to...

Originally, when I created the database, I had some queries and I realized that users could update the fields and the table values were getting changed. At...

I have posted questions the past few days about my inability to get the F1 key to call out my help file (CBW5Help.chm). Operating on instructions from...

Most computers I support that have Access also have the latest .NET Framework. Is there a downside to using functions from those DLL's within Access? James...

In Access 2003 I have a Table . I want the Primary Key in field to be auto generated by combining , and of the same Record. I am assuming that I have to...

hey

I created a Validation Text message for a required field, but the default message appears instead. How do I correct this?

I need to take a field that currently has a decimal place in it and change it to remove the decimal, but retain the digits after the decimal (including...

I need one field to be yes when another field is selected no and vice-versa. The fields are populated by check-boxes. Can someone tell me how to make this...

I have created a database which has a macro that merges an enquiry into word. All the merge fields work, however the date has been reversed and I can not...

What is the difference between the text functions that do and don't end in $?

Hi There, We're moving some Access 2003 apps to a new server. The linked tables are running much slower on the Server 2008 x64 than they do on the other...

I'm having a major problem! I cannot open my database and I have a ton of data in it. When I open the database I got the error message: "The Microsoft Jet...

I posted this once but after a long wait, I still don't see it. I apologize if this gets posted twice. In AC07, a sub form (fsubCallDetail) for which the...

I have mutliple (Office XP) Access databases linked to tables in an SQL Server 2005 database. I was searching the newsgroup boards for info on a write...

We recently upgrade our application to Access 2007 from Access 97. We are now getting corruptions about once a month were data just seems to disapear. A...

My query to calculate difference in net_bal of two tables SELECT Sum(.NET_BAL) AS SumOfNET_BAL, Sum(.NET_BAL) AS SumOfNET_BAL1, Sum(.-.) AS Diff FROM INNER...

I am currently using Office 97 and have a database set up in Access; if I upgrade to Office 2007 will I be able to convert my files to the 2007 format?