Recent content by Slave2TheGrind

Think of the frequency rating as a manufacturer suggested maximum rating. Memory that is rated at DDR500 will work perfectly fine at DDR400 speeds (this is determined by the freq. of your bus) However, if you plan to overclock your system, DDR500 memory can give you much more headroom than...

Ok, I see what you're doing now. The only way I can see to speed this up is: strLine = "If Exists( Select 1 From datetesting Where partnum = " & Me.txtpartnum & ") Then 1 Else 0" I am not sure if the If Exists will work in Access the way that it does in SQL Server, but if it does then...

I'm assuming SQL Server 2000 T-SQL language here as it is what I am used to: If Exists( Select 1 From <MyTable> Where <PartNumber> = <SomeValue> ) Begin <...Processing statements for part number exists...> End [Else Begin] <...Processing statements for part number not existing...> [End] Hope...