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

    Copy Whole Database to Another Server

    If you are converting between two DBMS's, as it sounds like you are with SQL server and Access, then there are several ways to acheive this. Almost all DBMS's have a way to extract data structure to SQL script files. You can then modify the scripts to the new DBMS dialect and load the DB...
  2. natrons

    Select Date that is closest to a date within a range

    I am trying to find a solution to retrieve an individual record by selecting the date that is closest to a certain date but within a given range. The solution I've come up with is rather unwieldy and I wondered if anyone has suggestions on a more elegant solution. For this example, I am trying...
  3. natrons

    Calculating differences between rows

    Thanks, I love an easy solution. Sometimes I think too much. My problem is a little more complicated than this, but this is an elegant approach that I will use. -Nathan
  4. natrons

    Calculating differences between rows

    I am trying to figure out the best way to calculate differences between a value and the value in the previous row. I have come up with several possible ways to do this, but I don't have a lot of SQL experience and would be grateful for help from someone who has done this before. Here is a...
  5. natrons

    alternatve shading

    Yes, The easiest way to do this is to create your detail section, then choose "Format Section" by right clicking on the section title on the left in design view. Click on the "Color" Tab and then click the "Background color" check box. Click on the formula button...
  6. natrons

    CRViewer in MS Access VBA does not work

    Sorry, Forgot to mention I'm using CR8 Developer Edition with MS Access 2000 SR-1. -Nathan
  7. natrons

    CRViewer in MS Access VBA does not work

    Hello, I am trying to use the CRViewer control in MS Access VBA, but something is not working. When I insert the CR Viewer Control onto a form in Access, it appears as just a square, not the usual control. When I try to set custom properties, I get the error, "The operation on the...
  8. natrons

    antivirus recommendations??

    I second the recommendation for Symantec Antivirus Corp. Edition. It is a great product and provides you with quick, easy and consistent control over the entire network.
  9. natrons

    domain/server not accessible?!

    Try changing the number of licenses to 1000 and see if the problem goes away. Then you can 100% eliminate licensing as the source of the problem. I bet it is a licensing issue.
  10. natrons

    no domain server

    There could be several issues here. First, for a w2k domain, you need an internal DNS server. All internal computers (and your external one, actually) should point to this server as their primary DNS. On the internal network DNS Server you should also have secondary (and tertiary, etc) DNS...

Part and Inventory Search

Back
Top