Recent content by nerdcore

I am getting Active Directory schema mismatch errors after installing Exchange 2003 on a 2003 member server, on a network with 2 existing 2000 server domain controllers. Here is all the relevant information I can think of. Let me know if you need anything else. Thanks!!! - Installed exchange...

A couple quick questions. I am moving email hosting in-house for a client. They have two Windows 2000 Domain Controllers currently. The new server is 2003 with Exchange 2003. Questions: - Should I make this server a Domain Controller? - Does exchange still automatically add a mailbox and...

I am going to be installing Exchange 2003 on a new Windows Server 2003 machine. The existing network has 2 Windows 2000 domain controllers, and the domain name on this network is "domain.local". Email is currently hosted externally through a POP3 service. We are bringing email in-house for...

I have developed an application for a client. It's done using VBA in Reflections, which is a terminal emulator. The client now wants to put this application on a Citrix server. I have never developed anything for a Citrix or Terminal server before. My question is: What things do I need to...

I need to create a Franchisee tracking system for a client. I am working for the world headquarters of a Franchise System and they have 100+ franchise companies (just think McDonald's on a smaller scale). They have a database system in place now but it was not designed to properly accomodate...

thanks for the input guys....i am going to use the checkboxes because i feel it is a bit cleaner and easier to run down a list of 100 items and just check them off rather than drop down/select a yes/no. I am cfparam-ing all my checkboxes on the submit page so i can capture any blank (false)...

I don't know exactly which forum to post this in but since I'm using coldfusion to build this app I'm trying here first. I have an MS SQL Server 2000 backend. I am developing a front end using coldfusion. I am using normal HTML input tags rather than CF tags for the fields. I am BRAND NEW to...

I have a client who has a database with an SQL 2000 backend and a Microsoft Access front end. It's huge :) (like 450 forms, 400 tables, 150 reports, etc.) There is one form (it also has a subform) on which they would like to track any changes made, and NOT write these changes to the live...

I have a report that prints out name badges from a database. This report has always been done by hand in Word, and the names were formatted with the "small caps" effect which will translate all the lowercase characters into uppercase letters, and the uppercase letters into bigger...

I'm creating a "secure" database using the .mdw file and user/group permissions. I have a switchboard form with about 8 buttons that open up the various data entry forms in the database. What I need to do is upon loading the switchboard form, test the permissions that the CurrentUser...

I have a database that has a Front End with all forms/queries/reports, and a Back End with the Tables. When I used the database splitter, it created the relationships in the back end as well as left the original relationships in the front end. I am now adding two new tables to the Back End...

Hi, I would like to apply a custom toolbar to all reports when I open my database. Being that new reports are always being developed and management of these gets difficult, I would like to have a routine that automatically applies the toolbar to ALL reports upon startup. I know you can just...

Thanks HomeAlone! That solved my problem (in 4 different forms/tables) :D

The problem is there is no apparent Error number for the primary key violation. At least it doesn't come up in the MessageBox. The OnError event seems to belong inside a sub however this error is not happening inside a sub. It is happening when moving to the next record. Any help?

I would like to trap the primary key violation error when a user enters a duplicate name on a form. My table is set up with a FranchieNumber field that is the primary key. This field is bound on a Form. If a user enters a duplicate FranchiseNumber they will get a key violation error when...