Hello.. Hope someone can help. Here is scenario. I have to adjust a time based on the time zone of a state. So I create a table that gives me the a list of records with original_date, and the number of hours the the time for each record needs to be adjusted. Field name tz_hours. The...
Good day/evening everyone... I'm pretty fluent with basic MS Access (using 2003 here, but have 2007 available if I need some advanced functionality) and I have been fine with doing imports, exports, macros, and have done some custom things underneath buttons and on form loads with some basic VB...
Maybe.. but I just tested it as (cut and paste) and it works! My real issue is how to tie in the "inner join lynx.poshist poshist on poshist.device = mobile_device.device_id where poshist.PosDate = (select max(PosDate) FROM lynx.poshist WHERE device = mobile_device.device_Id" Any idea on...
Hi.. I'm running the select query below without any problems. Issue is it give me all the locations (POSHIST.LATITUDE) table. Positions in this table are reported every 15 minutes, so I need to just get the most recent position. In less complex queries (without this combination of joins) I'm...
Hi.. I'm kind of new to SQL programming. My environment is using Dreamweaver to access a IBM DB2 DB - basically using the recordset builder to create SQL. I have three tables:
Order Table
Order_Number
Truck_Number
Mobile Table
Device_ID
Assigned_Truck
Location Table
Device
Location_Time...
Does anyone know how to stop the "Help Protect Your PC" screen that comes up prior to login after a Windows XP SP2 install? We are trying to automate the SP2 rollout without user intervention, but can't because of this screen. We can't even complete an SP2 install via remote control because...
Hello, I'm not a DB2 expert, but for a software program a client was running DB2 7.2 was required. I installed it no problem and upgraded to fixpack 10. They are working fine. However, a few developers are requesting "DB2 Tools" also be installed. I believe during the initial DB2 install I...
Can anyone one tell me if there is a tool to migrate an existing physical windows 2000 PC to virtual (to run on virtual PC 2004?). I'm familiar with VSMT from Microsoft but according to the documentation only works in the with Server NT, 2000, 2003, not desktop operating systems.
Thanks.
I have an old Compaq Proliant ML350 running Windows 2000 and it is a member server in an NT 4 domain. I need to replace the Proliant with a new Dell Poweredge 1600SC. Same server name, etc. I use Veritas Backup Exec 8.6. Does anyone have a step by step instructions on how to move Win2000 to...
Hello, just took a new 4506 out of the box. I have some experience doing some basic configuration on smaller catalyst switches and routers, but first time with the 4506. After reviewing the documentation, it seemed pretty straight forward - using the "set" command to set an IP...
Getting this message in Event viewer on Dell PowerEdge 1650, Win2000 SP3. This event is generated when trying to run "Setup.exe" off the Veritas Backup 9.0 CD. Setup will stop after a few seconds with message, "Microsoft Visual C++ Runtime Library. Runtime Error...
At 3:30pm every day, the CPU of our Exchange server hits 100% solid for at least 10 minutes. During other times of the day, CPU averages around 25%. Investigating the processes running at that time, it is obvious DSAMAIN.exe is the culprit. This basically started happening after Exchange SP4...
Hello. Have an NT 4.0 SP6a NT server running Exchange 5.5 SP4. Added list of domains using the "@domainname.com" format to turftable registry key. Stopped and restarted Internet Mail Service, but messages from those domains are still being delivered to users. As a test, I removed...
Thanks for the information. I disable spelling and grammer checking, but unfortunately I have the same result when inserting a table. Office XP Service Pack 2 applied.
Thanks
Metaframe XP FR2/Win2000 SP3/Office XP. Publishing out Office XP applications. Most office apps work fine with the exception of Word. Sometimes, when click on menu options, gray boxes will appear instead of the menu and the utilization on the Winterm will shoot up to 100% and the Winterm will...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.