...any point in the process, the screen saver goes active, all work is lost and he has to start over again. Anyone can understand what a pain in the a** this is for him. Not only does he have to eat lunch at his desk, and never start an update when he has a meeting scheduled, he also can't go...
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...
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...
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...
...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 was taking 3 or 4 times as long just to load. It seemed like everything about the drive was taking eternity. I felt...
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...
...clusters be? The initial load of files will be 515,000 images and will take up about ~125GB. I figure that if I set the cluster size to 32KB, and *if* every file wasted an entire cluster (which they won't), that would only amount to ~17GB, which would be an acceptable amount of waste on this...
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...
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...
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...
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...
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...
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...
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...
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...
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...
...= "Provider=MSDAORA.1;Password=PAULM;User ID=PAULM;Data Source=KARSPROD;Persist Security Info=True"
con.Open strConnect
strsql = "Select count(*) as thecount from accident_summary"
con.Execute strsql
rs.Open strsql
End Sub
Tranman
"Adam was not alone in the Garden of Eden, however,...much...
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...
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...
...Event, say:
intCustCtr = intCustCtr + 1
Then, in the Report Footer Format Event, say:
<myControlName> = intCustCtr
(where <myControlName> is an **unbound** control)
Write back if you continue to have problems.
Tranman
"Adam was not alone in the Garden of Eden, however,...much is due to...
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.