Recent content by DaveBrown

Darn! You are right - my SQL code was in error. This will teach me to test out code before posting :) The correct code is as follows: UPDATE table1 SET Firstname=Left([name],InStr([name]," ")-1), LastName=Mid([name],InStr([name]," ")+1) I tested it this time, so it should work. To answer...

Yes, I can see how this is not obvious to someone new to Access :) To run the update query: 1. select Queries from the menu on the left. 2. click New. 3. leave the selection on design view, and click OK 4. Hit the close button on the Show table dialog. 5. Click the SQL button in the top...

You can do this within access using an update query. First you need to create two new text fields called "Firstname" and "Lastname". I'll assume that your original name field is called "Name" and the the table is "table1". Then run this update query: UPDATE table1 (Firstname, Lastname)...

I think you problem is a more basic one. The data structures you are using are a little unusual and causing you problems as you write queries. Instead, set up your tables like this: Table: users Fields: user_id user_name group_id Table: group Fields: group_id group_desc This is the...

There is a syntax error in your format function. I think your code will work if you change to this: SELECT TableA.Column1 FROM TableA WHERE Format(TableA.Column1,'dd-mmm-yy') = #10-Jun-03#; (note that the code to return the month in three letter format is mmm, not mon) -Dave

Does anyone have any opinions on this monitor? I'm interested in getting a new LCD for my home PC, which is primarily used for gaming. I'm also considering the Dell 2000FP. On paper, the planar seems to compare very well: PL201M: native resolution: 1600x1200 Viewing Angle: 85 Brightness: 250...

Really my only worry with the 2000FP is that at 1600x1200, the dot pitch will be fairly small (.255mm). And I've heard that these LCD monitors don't look as good when not running in native resolution. The 1900FP, however, when run at 1280x1024 resolution would have a dot pitch of .300mm. For...

Ha! Thanks for the advice. My girlfriend already thinks I'm crazy for spending this much on a monitor. But to me, it's worth it. I'll be replacing a 21" CRT, so the size of the 2000FP will probably seem small in comparison.

I'm also considering getting either the 1900FP or 2000FP. I have a 2.53 P4 and 9700 pro. I'm not sure which monitor would be the better choice for gaming though. The price is tempting on the 1900FP.. $640+tax today in Dell small business. Does anyone have an opinion on whether the extra size...

Hi everyone! I am having a problem when my PC powers down. I click shutdown in win xp pro. Everything powers down but then the lights for power HD, and CDROM stay on. Then, if I try to power up using the front power swicth, the PC won't boot. I can get the PC to boot if after I power...