Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I get Access to append a memo correctly
I now need to update a record (instructions) in a table named will. I am using the following code however it returns a Syntax error. Can anyone tell me what may be wrong? When Debugging it highlights the 'DoCmd.RunSQL strSQL' Private Sub add_instructions_Exit(Cancel As Integer) Dim strSQL...- Hel27n
- Post #15
- Forum: Microsoft: Access Other topics
-
How can I get Access to append a memo correctly
Hello again, I have noticed that I have another problem. When using the code provided by 'dhookom (Programmer)' everything appends ok. However I have noticed that the date format is American. Ideally I would like it to enter the date in the following format dd/mmm/yyyy. On the table I have...- Hel27n
- Post #12
- Forum: Microsoft: Access Other topics
-
How can I get Access to append a memo correctly
Thanks for this. I changed the code to what you have given me above and also included a closing bracket and it now seems to be working fine. Thanks for all you help. can you explain to me why code has to be used for adding appending memos? Also are there any further issues that I should be...- Hel27n
- Post #9
- Forum: Microsoft: Access Other topics
-
How can I get Access to append a memo correctly
Hello, I have added the code above and when I try and run it I get a Run-time error '3134' Syntax error in INSERT INTO statement The fields are set up as follows:- willid numeric refno text will memo date of will date/time instructions memo solicitor text- Hel27n
- Post #7
- Forum: Microsoft: Access Other topics
-
How can I get Access to append a memo correctly
Hello Again, I was looking on this forum and seen that if the field is unbound (on the form) then Access does not know how to handle it correctly. The only problem with this is that I need the field to be unbound as on occasions I need to amend the record (while keeping a copy of the original...- Hel27n
- Post #5
- Forum: Microsoft: Access Other topics
-
How can I get Access to append a memo correctly
The field in CAPS is the memo field INSERT INTO will ( willid, refno, WILL, [date of will], instructions, solicitor ) SELECT Forms!client!willid AS Expr1, Forms!client!refno AS Expr2, Forms!client!WILL AS Expr3, Forms!client![date of will] AS Expr4, Forms!client!instructions AS Expr5...- Hel27n
- Post #4
- Forum: Microsoft: Access Other topics
-
How can I get Access to append a memo correctly
The code is on another pc, hold on and I'll get it- Hel27n
- Post #3
- Forum: Microsoft: Access Other topics
-
How can I get Access to append a memo correctly
Hello, I have designed a table with a field in it which is set up as datatype ‘memo’. I have a form where I want the user to enter details and then I use an append Query to add the details into the table. The trouble is that when I run the query it will not add all the text. I know that memo...- Hel27n
- Thread
- Replies: 15
- Forum: Microsoft: Access Other topics
-
Scrolling through records?
Hello, Can anyone please tell me if there it is possible to stop the mouse scrolling through records in a form in Access 2002? I.e. I want to display 1 record on a form which is to be updated. I do not want the user to be able to view other records by using the scroll button of the mouse.- Hel27n
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Windows Server 2003
Hello, I have several Windows Server 2003 Standard Machines. Two of these are File Servers & the other are used for Proxy Serves, mailservers etc. I have 250 Windows Server CAL 2003 User Cal's. Can someone please tell me how to assign these to the servers? Do I need to split the Cals's...- Hel27n
- Thread
- Replies: 1
- Forum: Microsoft: Windows servers
-
RAID-5 Low Disk Space
Hello, I have basically the same situation as ‘Carpez64’ except that I am running Win 2003 Server. I have virtually no free space on C. I have tried to use Partition Magic v.8 but it isn't compatible with this OS. I also downloaded a copy of 'Partition Expert’ and it would not allow me to... -
RE: Cisco 1841 & Windows Update Error
Hello Andy & Plshlpme, I hope you guys are still around. My Router was working perfectly before the Easter Holidays. When I returned on Monday I found that I can't connect to Windows Update or Hotmail again. No Settings were changed so I am not sure what has happened. Perhaps you could... -
RE: Cisco 1841 & Windows Update Error
Hi Andy & plshlpme, I have great news, I have eventually got the Router working correctly, Windows Update (working perfectly with Win 2k but still some problems with Win XP Pro) and hotmail, fantastic! I haven't tried the above post from 'plshlpme' but if I continue to have trouble I shall... -
RE: Cisco 1841 & Windows Update Error
Hi Andy & 'plshlpme', I have made the changes and still the same error. Can you check this again for me please? Current configuration : 3821 bytes version 12.3 no service pad service tcp-keepalives-in service tcp-keepalives-out service timestamps debug datetime msec localtime show-timezone... -
RE: Cisco 1841 & Windows Update Error
Hi Andy, I shall try this out when I get into work in the morning. I have a few other questions about this config though? ip nat inside source list internal-networks interface Dialer4 overload ip nat inside source static 192.168.255.2 217.46.x.x - What does the 'OVERLOAD' mean on the... -
RE: Cisco 1841 & Windows Update Error
Hi Andy, I have tried what you suggest and I still have an internet connection (thank God) but still have the same problems with Windows Update & Hotmail. However I do feel that we are much closer to solving the problem. Would you mind having a look over the configuration as it stands now... -
RE: Cisco 1841 & Windows Update Error
Hi Andy, I have deleted IP NAT from both Dilar4 & FE0/0, and am still presented with the same error, and when trying to logon to hotmail I get the following message: 'The gateway has lost the connection with the Web site you are trying to access.' I will go through the config of the network... -
RE: Cisco 1841 & Windows Update Error
Thanks for this Andy. I have just one question. Saying all computers on the network access the internet via the proxy will I have to change these settings again or will the ext. IP of 217.46.x.x & the Int. IP of 192.168.10.x(see above)still be ok??? Helen. -
RE: Cisco 1841 & Windows Update Error
Hi, I have tried all of the above and I am still gett in the same error message when runnig windows update and not getting access to hotmail when I enter my logon details. When I had the BT/2Wire Router in place all I had to do was set the Private Network IP Address of the Router 192.168.1.1... -
RE: Cisco 1841 & Windows Update Error
Hi Andy, I am runnig Windows Server 2003 & Windows 2k Pro. I used to have a BT / 2Wire Router in place and the Updates worked fine. I only started having problems when the Cisco Router was installed. Planning on spending a full day on this 2moro evening and I will get back to you then...
