Recent content by thatguy

This problem may have worked itself out, oddly enough.. A maintenance guy accidentally shut off a circuit breaker to the server room, which, eventually (when the UPS died), shut down the Win2k server. When it came back up, there were 84 leases with the IP address listed as the device name...

Hey all -- This has got me stumped. First off, I'm walking into this very poorly structured/maintained network, so I have no idea where it's come from. So the Win2k DHCP is reporting 100% of its addresses are taken, but looking thru the leases, there are gaps of addresses available - about 50...

Well that wasn't so tough.. SQLEXEC(cxnhandle,sql,tempcursor) CREATE CURSOR realcursor (; field1 b,; field2 c(254),; field3 c(254)...) INSERT INTO realcursor ; SELECT field1,allt(field2),allt(field3)... ; FROM tempcursor This is my solution. Thanks again AndyKR.

Thanks AndyKR. SQLColumns() showed what you described.. The fields were defined as simply "text" with no precision/length specified, but they come across to VFP as being 8190 chars wide. So you're saying that there's no way to limit the chars that come thru? My only option is to 1) read the...

Hello-- I wrote an app in VFP8 that reads data from another app's database (Advantage). Recently, tho, that app has changed its backend to PostgreSQL, so I need to update my VFP app to read from PostgreSQL. I've installed the psqlODBC (8.2.4) driver and can connect and read from the database...

Sorry bout that.. here's the code.. Set oWord = CreateObject("Word.Application") Set oDoc = oWord.Documents.Open(cfile) oDoc.Bookmarks("bkImage").Select oWord.Selection.InlineShapes.AddPicture _ "C:\Photos\Test.jpg", True, False And the error that pops up is...

I'm wondering if it's possible to insert an image into a placeholder in a Word template (from Access). I have several fields (using custom document properties) such as name, employee title, dept, etc, that I insert with no problems, but I also need to add in a link to an employee picture...

I actually move the record pointer in a sub (refHist) and the AfterUpdate calls that sub. Originally, I was running the ListBox.Requery; Selected(0) = True; refHist; ... but then the AfterUpdate was getting called automatically and refHist was getting called twice, which threw up an error...

Weird.. it was firing for awhile.. then just stopped suddenly.. *shrug* I guess I'll have to add a hidden checkbox flag to the form -- unless there's some other way...? Thanks

I have a bound form with a bunch of textboxes and a listbox. After I requery the listbox, I set Listbox.Selected(0) = True, which, up until recently, caused the Listbox.AfterUpdate event to fire (which positions the record pointer and, voila, the selected record from the listbox is shown on...

Sorry I forgot to mention the detail that they still need to be able to log on during off-hours.. but I don't want Idle sessions during off-hours.. What most of these users do is log on during the day and just stay on for 24hrs straight.. That makes maintenance and rebooting times a pain.. --...

So uhh.. no thoughts on this at all?

Hey there folks-- I'm wondering if there's any way to enforce the End Idle Sessions setting only during certain hours. I don't mind if there are idle sessions throughout the business day, but if people are idle during non-business hours, then I want those sessions ended. Any thoughts? thanks...

Hey there folks-- I've been playing around with DFS and FRS to replicate data files over to a secondary server as a disaster recovery kinda thing. I've got everything working with a test folder.. shared it, set up the one-way replication, etc.. but once the FRS is running, windows explorer...

Hey there-- I have a new Win2k SBS installed and I setup a backup schedule as normal - one job for each day or the week, scheduled for 11:30p each night, backing up to an external hard drive. For some reason, the backup didn't run last night, tho I can run it manually from Scheduled Tasks just...