normalization is a good thing but sometimes there are instances where hibrids of DBMS models is more appropriate... especially when speed has to be considered...
sorry dennis but mike's problem was particular with MSSQLSERVER... so its safe to assume that his workstation is a WINDOWS BASED MACHINE...
but if so
either
char(13) + char(10)
or
char(10) + char(13)
or
char(13)
or
char(10)
:)
>>>> When I add a field to the main client table and relink the table in access it does not let me change information in the client record
pls specify your actual process
show codes if possible...
-AKIRA
sory 4 my preious post...
dim gcancel as boolean
Private Sub cmdCancel_Click()
gcancel = true
End Sub
private sub pProcess
gCancel = false
while not gCancel
' processsssssss
wend
if gCancel then msgbox "PROCESS CANCELLED!"
end sub
WALA
:)
developer,
try to change ur connection's command time out property maybe a little higher or 0
Added information you may consider:
Server Side cursor are faster on execution
Client Side takes longer and sometimes causes timeout
Hope this helps!
[*STAR ME PLEASE]
WAYTECH,
let us make it simpler...
have u tried using NET command
net use \\server\sharedfolder [drive] [password] /USER:[username]
you can put it on ur machines startup
or
you may use shell command on ur VB application...
hope this helps!
here is the rest of the paramenters
NET USE...
imformation that can be shown on the data report will depend on the records coming from it's datasource...
you can do ur filtering on ur recordset b4 you bind it the datareport..
EG
STEP 1
RS.FILTER = [your filter]
or
RS.OPEN "select * from where [your filter]"
STEP 2
set...
try it this way
While Not .EOF
ProgressBar.Max = .RecordCount
ProgressBar.Value = .AbsolutePosition
frmPrintQRPage2.StatusBar1.SimpleText = "Printing QR, Pls wait... | " & .AbsolutePosition & " of " & .RecordCount
DoEvents...
add this
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
'release variables/objects
'most especially connections and recordsets and the like
'set variable = NOTHING
End Sub
this may seem an added burden but i tell this would be very beneficial especially when u...
any file can't be printed w/out opening it...
simple reading of a file is actually opening it on a readonly mode
:)
Pls be specific with ur requirement/need and define also the purpose on why....
this is not actually vb related...
i haven't use 98 machines for a while
i think it's just a matter of configuring ur server with the right account configuration/rights with the account
being used by the win98 machines...
e.g.
SERVER (NT and above)
1. create user
USERID: A
PASSWORD: B...
it simple u...
u create ur combo box
either u bind it with a recordset or fill it with ur code
keep the combobox's style property to dropdowncombo
the trap the change event
the do a a search algoritmm/code
change the index property based on ur search
WALA
the coding part ill leave to u
for...
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.