I have the following formula in a query: Between NZ(!!,#10/11/2004#) And NZ(!!,Date()) Instead of having #10/11/2004# as default date, I would like it to...

I have an Access 2003 application that I would like to distribute and tried using Package Wizard. I am not happy with this program. It does not allow me to do...

Hi (newbie question) Is there a simple way to fool a field into sorting the way I want, example: 13 13-SE-C 14 341 963 (The 13-SE-C is going to the bottom)

I have turned off all the features in the security center included in WinXP service pack 2. I also unchecked all of the boxes under "Change the way security...

Hello everyone, Can I install an Access 2003 database (defaulted to 2000 format) onto a network server which has Access 2000? Chantel

All, I have a table in Access that it linked to a SharePoint Database. There is a field in that table that is a hyperlink field. The hyperlinks all...

Not long ago I posted a question about splitting a database whose users have either Access 97 or Access 2003 on their PC. I was told (by Douglas J. Steele and...

Hi everybody, I am updating records with a VBA skript. While the script is running access keeps bothering me with confirmation messages. Is it possible to...

my msn homepage is stuck on tuesday nov 8th. i have done all updates what could be the problem

I should know and understand this, but I don't. Could somebody please review the difference between these to values? I have a column that either contains a...

I have three tables: Requests: Stores data about maintenance requests Categories: List of maintenance categories (i.e. mold, plumbing, etc.) AssignedTo: List...

I have an Access 2003 DB that I have been developing that executes normally. When I enter design mode Access will not display objects (Tables,...

Project numbers were previously typed in a colum with either one or two blank spaces (i.e. P - 000-934-042). There should not be any blank spaces. I...

Hi Everyone, I'm thinking of using access for my companies document management system. After a bit of research i'm thinking of using OLE linked objects, to...

I have been working on a database for several weeks. Now when I try to view or change the relationships - the window does not display any information. The...

I just set up my new computer running WinXPMediaCenter with an Athlon 64 3500+ processor running 2048 MB of RAM. I moved over my data before moving over my...

Since our system changed to XP version from NT. I don't have much access to do such changing to the system, e.g access to system32 folder. And I may not have...

I have an ACCESS 2003 database I created at home that I would like to use in my office PC which has ACCESS 97. How do I accomplish this without having...

Hi If someone can help me Im aprecciate so much. When I trying define fields in the wizard create data access page by using wizard. Appear message: The wizard...

I have a form where the user selects a date range for which to run some reports. Currently there is a separate menu option to process the monthly imports to...