hello,
I am using the following code to update a field in access. My aim is to actually overwrite the existing data and not append.Could somebody help me with this?
rs1.AddNew
rs1!year7 = Text3.Text
rs1.Update
thanks in advance
jono
A good fortune may forbode a...
Hello,
i am very new to access and hope somebody can help me with the following:
I have a form with several fields on and the record source is a query i made up. all the data is displayed how i want it. Now I have two text boxes that does not take information from the database; this info will...
Hello,
I picked two well known websites to ping and just wondered if anybody could explain what the data is after the IP. why is one 55 and the other 245?
thanks
jono
reply from 212.4.208.123: bytes=32 time=18ms ttl=55
reply from 217.12.3.11: bytes=32 time=25ms ttl=245
A good fortune may...
Hello,
I have w2k server, 15 xp pro boxes and 5 nt 4.0 boxes. I have set up a DHCP scope from 192.168.1.10 -192.168.1.30. I have twenty leases as one would expect.
The other day I installed a port monitor and noticed that there is an established connection between 192.168.1.2 (w2k srv) and...
Hello,
I have wired my house with cat5E cable and have also put a data outlet in the bedroom. My aim is to be able to play a movie on my computer (which is in the study) and view it on my conventional TV in the bedroom. Has anybody tried this?
If so could you recommned a good cheap piece of...
Hello,
I have recently set up win2k srv AD and DNS. I have been experiencing some strange events. For example one computer keeps on losing its dynamic IP + DNS and replaces them with another IP and our ISPs DNS. Although the IP is still in our subnet this drastically slows the machine down.
I...
Hi,
I have recently set up win 2k AD and DNS. Everything is working fine, email, Internet and the network in general.
However, it has come to light that we cannot view our website this side of the firewall/router. We get a "bad ip address" error message. I can access our website from...
Hi,
can anybody recommend a good sniffer ;O)
I want to analyse traffic on my network of 360 workstations and 6 servers. in particular there are four activity lights constantly on one of our 3com switches. The switch connects one of our main IT rooms and I am just wondering why they are always...
I have a list box populated with over a 1000 names. Is there a way to search this list for a particular name. I thought about using a for next loop which would compare the contents of a text box against the list box. Would this be slow and is there a better way.
Thanks in advance.
Jono
A...
Hi,
I was hoping somebody could help me convert the following in to code:
I have two fields in access that I want to manipulate:
"date purchased" field in date format, for example 09/02/2001
"warranty" field in number format, for example 3
So, I am thinking if I add 3...
Hi,
is it possible to clear an access table before I add to it?
I am using the DAO "rs1.addnew" command to add data to the current fields. I would like to empty the table each time I call the routine that adds the data.
hope this makes sense!
thaks in advance.
jono
A good...
Hi,
A user on our network wants to be able to install things like the google toolbar for instance. I don't want to give this person admin rights - is there a way around this; and do they need to have a local account on the machine?
Workstations are win xp and the server is win 2k AD.
cheers...
Hello,
I have written a small program to keep track of our static ip addresses. The only problem is that you can enter the same address twice. How can I tell VB to check the MS Access field for duplicates before it writes to the db.
cheers,
jono
A good fortune may forbode a bad luck...
Hi,
I have recently set up win 2k AD and DNS. Everything is working fine, email, Internet and the network in general.
However, it has come to light that we cannot view our website this side of the firewall/router. We get a "bad ip address" error message. I can access our website from...
Hi,
I have just bought a 2.4gh zeon raid 5 server and installed windows 2000 server. I have approx 20 workstations 15 of which are new and have XP pro installed.
The other 5 are nt workstation and connected to the server fine. The major problem is that the XP Pro machines take about 2.5 mins...
Hi,
Can anyone tell me how to stop the following message from appearing in the event log. I have just set up a win 2000 dc.
"this machine is a pdc of the domain at the root of the forest. configure to sync from external time source using net command."
Who or what address will the...
hello,
I have gone from win98 to win xp pro and would appreciate some help. I have a program on floppy disk that i use to create an image of the HD - as it takes forever to load i used to copy the files onto c and call the .exe from autoexec.bat
I notice xp does not have an autoexec.bat file -...
Hi,
I want to install XP on my computer, however the installation will not boot from cd-rom.I cannot get any CD-ROM to boot and I have changed the settings in the BIOS.
I have started the computer via FD and copied the entire XP disk to my D drive - I then ran the set-up file within the I386...
hello,
I have recently purchased a Linksys BEFSX41 router. I have managed to set up my test-website using the DMZ port. I would now like to connect to my computer remotely using the VPN.
However I am a little confused about the configuration and would be grateful if somebody can assist me.
I...
every time I try and set up our printer on an NT 4.0 workstation I get the following error at the end of the installation:
cannot set default printer
If I right-click the printer and print a test page it works. It works in MS word but will not work in MS Excel. It doesn't appear in the...
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.