Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Tranman

    prevent screensaver from activating

    Interesting thread. As to why you would want to sidestep a group policy, here's my reason. I have a user who creates and updates layers in Arcview. The updating can take several hours. If, at any point in the process, the screen saver goes active, all work is lost and he has to start over...
  2. Tranman

    Remove/add missing reference from VBA

    You can enumerate the references in a code module by doing something like this: Dim ref As Reference Dim strxxx As String For Each ref In CurrentProject.Application.References strxxx = ref.FullPath Next In your case, you might want to check out the IsBroken property before you try to look at...
  3. Tranman

    Create code module Word 2007

    VB6 Office 2007 I have a VB6 program that builds fairly complex Word documents. The documents contain: Normal text Hyperlinks to documents stored in a Filenet image archive Command buttons that delete rows from an Oracle database, and also update a SQL Server database Various Subs and...
  4. Tranman

    QUERY TO APPEND DATES

    If 'temp' was a generic term, here's a way to put weekday dates into a table... Private Sub AppDates() Dim intCtr As Integer Dim datWork As Date datWork = Now() For intCtr = 0 To 365 Select Case Weekday(datWork) Case 2 To 6 CurrentProject.Connection.Execute "insert into...
  5. Tranman

    Need advice on formatting/files per folder in image archive

    Nelviticus, Thanks for the response. "...if you just plug the drive in, format it and then save files to it - everything will just work..." During the pre-project investigation, as a test, I copied ~400,000 documents to the drive. Up above ~300,000, it got *incredibly* slow--like each file...
  6. Tranman

    HELP!!!! Edge external Harddrive

    Before I gave up, I'd try booting my system on Knoppix (Live Linux) and seeing if you can read the disk. Just download a Knoppix iso and burn yourself a CD and boot from it. It will take a long time to download (big file), but it could save your data. I had a USB drive (Seagate) that Windows...
  7. Tranman

    Need advice on formatting/files per folder in image archive

    Hi All, A am about to create an image archive at work. It will initially contain about 520,000 pdf files, ranging in size from 150KB to 550KB, with the mean size being about 240KB. We will be adding about 70,000 new images to the archive every year. The archive will reside on a 500GB Seagate...
  8. Tranman

    networked scanner for all users?

    I have not tried to initiate a scan from the scanner control panel since the device has been connected directly to the ethernet. Just offhand, it seems like it would be a problem because how would it know who on the network was supposed to get the image? I will be out of town tonight, but when...
  9. Tranman

    Transfering Files from pc to laptop via data cables

    You also want to be sure that you are not using DHCP. Without a DHCP server, neither of your PCs will have IP Addresses, and they won't be able to talk to each other. Just be sure that "obtain IP address automatically" (or whatever it says--I'm on my Linux box), is not marked. Tranman...
  10. Tranman

    networked scanner for all users?

    I have the Brother 7820 N at home, hanging off of my ethernet. All computers have access, and can scan directly into pdf. It's a cheap solution, and the volumes you're talking about would be no problem. Also a pretty good laser printer, and if you've got a phone line handy, a fax, too...
  11. Tranman

    function to check if a string is a number

    Private Function Parser(byVal str as String) as Boolean Try Double.Parse(str) Return True Catch fe as FormatException Return False End Try End Function Works with scientific notation as well as regular numbers. Tranman "Adam was not alone in the Garden of Eden...
  12. Tranman

    Share printer on home network with Win2K pro laptop

    Hi, I have a home peer-to-peer network consisting of: 2x Win98 SE 3x WinXP Home 1x Suse Linux 9.2 (with Samba) Running TCP/IP and DHCP via a DLink 808HV NAT Router/ switch/VPN and a cable modem. One of the XP Home machines is an HTPC (SageTV/3x Avermedia 1500), and so is always on. There is a...
  13. Tranman

    Problem installing VB.NET std on WIN XP Home

    Thanks Guys, I knew about IIS (both that you supposedly can't run it on XP Home, and that you actually can if you jump through some hoops). I do have Office XP Pro, but can't see what that has to do with this. I finally did get it to install--but never got the automated thingy to work. Ended...
  14. Tranman

    Problem installing VB.NET std on WIN XP Home

    Noob to vb.net Trying to install it at home (install worked fine on XP Pro at work). Here at home (Athlon XP 3000+, 512 RAM, 55GB available, XP Home), here's what happens: 1. Inserted VB.Net CD 2. It told me to do prerequisite CD. 3. Installed prerequisites--Framework, J#, Java 4. It told me...
  15. Tranman

    New Computer Hardware-- Won't start no activity

    Some of the dumb things I've done/seen through the years that caused what you're experiencing: Tried to run an Athlon XP with a GeForce 4400 on a 300 watt power supply Tried to run a power supply in USA with switch on 240v Missed one of the plastic standoffs under the mobo, thereby bolting 12v...
  16. Tranman

    summary control on report

    Audrey, 148 queries...[Tranman closes his eyes and imagines your database window] It seems like you could do it with 1 query and plug a where clause into it on the fly. I wrote a reporting app for a customer last fall, and tricked it out so the reports were always launched from a form where...
  17. Tranman

    ActiveX Component Can't Create Object

    Dim oConn as New ADODB.Connection oConn.Open <connection string>,uid,pwd,options You don't need to use the Set command. Here's a snippet. It's nonsense code, but illustrates what you need to do. Connects Access to an Oracle database (It's from my Win98 machine) Private Sub CreateCon() Dim...
  18. Tranman

    summary control on report

    Audrey, Here's another way... Write a query that counts the number of groups in your report. Write a third query that becomes the source for your report. The third query has the original query plus the second query as its data source--without a join between the two (so you get a cartesian...
  19. Tranman

    summary control on report

    Audrey, Are you remembering to reset the count to zero each time you open the report? And being sure not to increment the counter in both the Format and Print events? I have replicated what I suggested in a dummy mdb with the counter being incremented in the Print Event, and it seems to work...
  20. Tranman

    summary control on report

    Hi Audrey, Sorry, I might have been a little more specific about how to accomplish what you're wanting to do. In the General Declarations section of your Report Module (at the very top), where it says: Option Compare Database Option Explicit Add this: Public intCustCtr As Integer Then in the...

Part and Inventory Search

Back
Top