I have a client that opens a gazillian screens and expects them all to be there the next day of business ... with updates for Security and MS there is the occasional reboot required ... when this happens the client is very upset that all the windows (mostly web sites) have to be closed/lost ...
I have been using a vbs script for years and today after doing an VFP SP2 and Windows XP updates it is no longer running ... no indication of why ... no event logs ... Any IDEAS?
Dim oShell
Set oShell = WScript.CreateObject ("WSCript.shell")
rem oShell.run "C:\dct\instance 1"
oShell.run...
we have had a hardware failure ... haven't found any old working hardware that is compatible with the old XENIX OS ... the last time I was able to revive an old Harddrive and restore our image files but this time no luck ... kind of hard to run any INFORMIX tools without a machine loaded with...
Sorry if this is the wrong forum but ...
Does anyone either have a link to or know of somewhere where I can get the DBD file specs for INFORMIX 3.3?
I have all the dbd and dat files which were backed up nightly ... I need to recover the data from an old Xenix box circa 86 and move into another...
Sorry having a Grey moment ... Is there somewhere in Access 2K3 where I can set the Units to Metric ... I am attempting to set up a Label report which is all in metric ... I have looked online for setting units, metric and nothing is showing up ... I was expecting to find this in options but...
Just looked at the code ... ttt1 and 2 should have been
If ginPNID <> 0 Then
In this case test2 runs in < 1 second ... however its not the DIM statement that is allocating the memory its the SET statements so PHV's answer is still correct.
Well PHV is king!!!
8 secounds to execute both examples SO NO DIFFERENCE
Thanx for the responses.
Option Compare Database
Option Explicit
Public Function test1()
ginPNID = 0
Dim i As Long
Debug.Print "test1"; Time
For i = 1 To 10000
Call ttt1
Next i
Debug.Print...
I can see the DIM automatically allocating variable space at compile time ... but not so clear on Objects ... given a DAO object, is all the info available at compile time to be able to allocate the appropriate size of the object.
The compiler is most likely making an allocation for a far...
Does anyone know if adding DIM statements inside an IF statement is of any benifit to the speed of an Application?
In other words; Would these 2 examples produce the same compile/token code in ACCESS VBA?
DIM blah As <Object>
IF Foo = TRUE THEN
' do some work
END IF
VS
IF Foo = TRUE THEN...
State Machine Scenario:
Process A: updates a record and commits the data with a release <table> within a local procedure and explicit transaction
Process B: is a status monitor using a DO WHILE TRUE LOOP
issue Process B will read the <table> the first time with the correct value but...
I have a sub form that uses a getval("PTR") function as a parameter ... my test data has 3 records id'd as 1, 2 and 3 ... the getval returns 1 2 or 3 to the sub form.
Select TTID, TTData from test where TTID = getval("PRT");
When I set ginPTR (LONG) to 1, 2 or 3 from the immediate window and...
Thanx for the reply. I guess I am still stuck on why a number of 120dpi is larger then 96dpi ... if all things are relative to the resolution PPI (pixels per inch) then we can probably assume the INCH in DPI is a misleading term (not actually an inch) ... Would this mean that lets say a font...
Can someone Please explain what is going on with the DPI settings in XP?
I have a screen that is supposed to be 1680 x 1050 pixels with a screen that is roughly 13" x 8.25" ... this works out to be about 130 pixels per inch
I read 96dpi as being 96 dots per inch
The advanced screen settings...
ID 1
Clustered: False
DistinctCount: 2
Foreign: False
IgnoreNulls: False
Name: ID
Primary: False
Required: False
Unique: False
Fields:
SAID Ascending
So this is still in the documentor ... the SAID is the field but the documentor thinks it is ID??? Compact and Repair has no...
I just built a simple address book with a dynamic search form and now have a problem with a field that won't clean up. When a table is created it creates an ID autonumber for the primary index ... normally I go and rename this field ... not sure what I did this time but none of my tables have...
Thank you all for your time/help it is appreciated
Please also pardon my confusion ... I am still not getting past my vision of the world :(
The issue in my mind is the 856 type tree assigns one structure HL that can be repeated up to 200000 times ... where as the implementation requires a...
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.