Recent content by NthDegree

Amen, Brother.

Buy Monarch? For that little snippet of code? The proverbial "killing a fly with a shotgun" theme. :)

You will not need to add the DAO. though.

dhookom is correct, when you enter the code, you will need to click on tools, references and then add the reference "Microsoft DAO 3.6 Object Library" that will have the definition for the database and recordset keywords so the interpretor knows how to process them. Depending on your version of...

A little bit of code (and if you dont have any forms with VBA code attached where you could run this code from) a simple macro. create a module and add the following code: Option Compare Database Option Explicit Public Function Update_Column() Dim db As Database Dim rs As Recordset Dim...

Open a query in SQL view mode and enter the following: UPDATE Table1 SET Table1.numbercolumn = IIf([textcolumn]="Q",1,2); then just run it.

Open a query and go into SQL mode, enter the following and then run it. select distinct iif((SELECT count(cat1) FROM table1 where cat1=true and date1=#01/01/05#)=0,0,1) as count1, iif((SELECT count(cat2) FROM table1 where cat2=true and date1=#01/01/05# )=0,0,1) as count2 from table1 Repeat...

I'm not sure I know what you mean by enable DHCP on the Ethernet NIC's. We are using static addressing on our LAN.

We are currently running a LAN with a Windows 2003 server and a few Windows XP Pro computers using a Dlink switch. We are using static addressing with the server being 172.16.0.1 and the other computers using 172.16.0.x. To give us internet access we have installed a DSL line/modem and a...

I have laptops that will be connecting (using a NIC) to an internal LAN server (the server will not be connecting to the Internet). The laptops also have a wireless NIC that they use to connect to the internet. Problem is that when I have both adapters enabled I can get to the LAN just fine but...