Replies

right now i’m logged on at 50666
we were getting logons at 24 and sometimes 28 before doing the things listed above. these things may not work for everyone but we saw a big difference
JerryC

try this program TWEAKUI you can down load it free on the internet
HTH
JerryC

have you tried contacting your internet provider some of the setting may need to be changed to increase performace
also in my house the phone wires had to be replaced before we could get a decent logon
hth
JerryC

thanks
worked like a charm
JerryC

in the row source you can set the format
something like this
Format([yourfield],”0.000″)
inside you select statement
hth
JerryC

go to the row source of the chart itself
set the format there
sounds silly but it worked for me
HTH
JerryC

see if this post helps
http://www.wopr.com/cgi-bin/w3t/showthread…&vc=1#Post14685
HTH
JerryC

in your database click on file then click on get external data then click on link tables
then you can browse for the excel spreadsheet you want
HTH
JerryC

IF YOU ARE WORKING ON A NETWORK
YOU SHOULD TRY UNIVERSAL PATHING ON THE LINKED TABLES
SERVERNAMEFOLDERSUBFOLDERDATABASE.MDB
INSTEAD OF A DRIVE LETTER
HTH
JerryC

if you want to close the database from the form you can put this code behind a button
DoCmd.Quit
and it will close the database for you
hth
JerryC

i always place a invisible textbox in my form that shows the path to the picture.
then in the code either behind a button or on the oncurrent event i put
Imagenumber.Picture = Textbox
for more than one picture you could place several textboxes
and then place buttons to change the image
button 1 Imagenumber.Picture = Text1
button 2 Imagenumber.Picture = Text2
and i always place this code on the onclose event of the form to clear the picture
Imagenumber.Picture = “”
HTH
JerryC

Hi Charlotte
I was looking at your database it ran but kept giving me this error
70–Permission denied
unable to copy from c:tempshellbd83.mdb to c:tempshellbd81.mdb
the files updated just as they were suppose to
even after the error message
did i do something wrong
thanks
JerryC

in your query for the form have the Originator
control set for the criteria for the query
then in the afterupdate event of the Originator control
place this code
me!requery
everything should automatically fill in
HTH
JerryC

what are you updating in the records
and why do you need to delete before updating
JerryC

what version of access are you using
i have had about the same problem with access 2000
before i got the sr1 update after the update the problem went away

JerryC