Search results for query: *

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

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

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

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

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

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

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

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.

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.

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