Search results for query: *

My LAN domain is company.local and we have a public domain of company.com. I set the primary email address as company.com and everything seems to be working as far as sending/receiving email. However, when I schedule an appointment in Outlook 2003 and type in an attendee, the free busy info...

I setup my exchange server on a local network (company.local). Everything worked fine, but I needed to receive our external email sent to @company.com. I changed the default exchange policy to use @company.com and updated to all AD users. This worked fine (all users now have 2 smtp addresses...

I just installed Exchange 2003 Standard on a Win 2003 Standard box. We are behind an ISA 2000 firewall. My internal domain is company.local and my public domain is company.com. I had no problems when I tested internal email using user@company.local. I changed the policy for all users for SMTP...

My printers suddenly no longer work. I can install printers, but I can't even print a test page. I suspect the problem is somehow related to Office 2000 with publish (installing disk 2 of Office 2000), since the problem seemed to appear not long after installing it. Office programs show up as...

After installing Office 2000 disk 2 (with publisher), I can no longer print to many of my printers. I can install printers, but I can't even print a test page. Office programs show up as having no default printer installed. I've tried changing the default printer to fix any registry issues...

I have 4 PCs running win98, one of them is sharing an HP deskjet 810c printer. I can print from each of them without problems. However, when I try to print concurrently (for example print a Word document from 2 PCs at the same time) I get "Error ... lpt1, port already in use... another...

I have 4 PCs running Win98 connected by a switch (and then on to the lan from there). They all belong to the same workgroup and share a printer connected to 1 of the PCs. I have no problem printing individually, but when I try to print from 2 at the same time, I get something like "Port...

Hey you might have gotten lucky! The problem with the query is that "parameters" is a reserved keyword. If you put brackets around the field name your query should run. Here's the section of code modified with the brackets to let access know parameters is a field name instead of a...

Here's a quick and dirty way to do it. Probably not the best way (since I'm relying on an error to prevent duplicate records), but it works. This is using ADO in Access 2000. You could also use DAO to do it with a little code tweaking. It looks like this post will wrap the text, so you'll...

I misunderstood your question. I thought you wanted to move to a new record, but prevent the error when you click the next button on a new record. Here's a way to prevent moving to a new record (there may be a better way, but this seems to work): DoCmd.GoToRecord , , acNext If Me.NewRecord...

Replace the section of code that moves to the next record with this: If Not Me.NewRecord Then DoCmd.GoToRecord , , acNext End If Hope this helps!

The problem can be corrected by changing the subreports Column Layout to "Across, then down" (this is found in page setup). Of course this won't do you much good if you absolutely have to layout "Down, then across". For an explaination of the cause of the problem see...

Hello! I have a bound form in a multiuser Access 2000 db that is set to "no locks" (optimistic locking). Pessimistic Locking ("Edited Record") is not viable because I'm using sql queries as the recordsource for the form, which will only use Page Locking (which locks several...

Oops, sorry about that. I missed the .findnext in your code. I apologize if my previous post was not of much help.

I think you need to use bookmarks and .findnext Here's an example from Access 2000 help files that should provide you with the info you need: ------------------------- FindFirst, FindLast, FindNext, FindPrevious Methods Example This example uses the FindFirst, FindLast, FindNext, and...

svanels, thanks for the reply! I agree with each of the reasons you've listed. So if you have a chance I would like your opinion on this design (let me know if this is what you had in mind): A Person table (super-class) with all the attributes relating to an abstact person (name, phone...

Hello! I'm designing a database that contains a Homesite table (stores info about a new home) which will have RealitorID, InspectorID, ServiceRepID, etc. as attributes. These are all foreign keys to a contact person. I have a table (Contacts) which contains info about a contact (name, phone...

Hello! I'm designing a database that contains a Homesite table (stores info about a new home) which will have RealitorID, InspectorID, ServiceRepID, etc. as attributes. These are all foreign keys to a contact person. I have a table (Contacts) which contains info about a contact (name, phone...

OK... here's some working code (I added the DAO. to Database and Recordset because I'm using Access 2000). I left your code the way it was and only modified what I needed to get it to work. I took out the rs.movenext from the initial if test (rs!add2 = Null) because you would move to the next...

Here's a quick and dirty example: *Create a report (you can probably use the report wizard) to display all the Assets/Primary Users. Make sure you include the AssetLocation field in the datasource for the report (you can remove it from the report so it won't display if you want). *Create a...