Recent content by Hel27n

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...

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...

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...

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

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...

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...

The code is on another pc, hold on and I'll get it

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...

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.

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...

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...

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...

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...

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...

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...