Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lionelbrown

    Free/Busy Schedule problem

    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...
  2. lionelbrown

    Using .local domain on LAN, .com for public email

    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...
  3. lionelbrown

    Exchange through ISA: internet mail... connectors?

    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...
  4. lionelbrown

    Win98 printers no longer work

    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...
  5. lionelbrown

    Publisher/Office 2000 kills all printers in Win98

    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...
  6. lionelbrown

    shared deskjet - can not print concurrently

    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...
  7. lionelbrown

    Shared Printer - Port in Use Error

    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...
  8. lionelbrown

    syntax error in sql statement

    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...
  9. lionelbrown

    Need to import filenames into a table

    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...
  10. lionelbrown

    Navigation in Subform produces New records

    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...
  11. lionelbrown

    Navigation in Subform produces New records

    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!
  12. lionelbrown

    Columns in SubReports

    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...
  13. lionelbrown

    Write Conflict - Force Drop Changes

    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...
  14. lionelbrown

    Help With Find Next Button

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

    Help With Find Next Button

    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...
  16. lionelbrown

    Database Design - Relationships

    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...
  17. lionelbrown

    Database Design - Relationships

    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...
  18. lionelbrown

    Database Design - Relationships

    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...
  19. lionelbrown

    module clean data

    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...
  20. lionelbrown

    Building a report from search results

    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...

Part and Inventory Search

Back
Top