How to ResetAutonumber to 1 in Delphi for MS Access Database?
371570
Yes, one way way you can reset an autonumber in Access is to truncate the table -- which destroys all data in the table.\n\nCreate a query in design view, switch to SQL view and enter this text:\n\nTRUNCATE TABLE tablename\n\nExecute the query using the red exclamation point icon; Access will ask if you really want to do it. Again, truncating will destroy all data in the table! Your structure will remain intact, but the data is irretreivably destroyed.\n\nYou could also do it programmatically if you don't have any records in the table, but if that's the case, TRUNCATE makes more sense.
1026870
numbers lock is on!!!!\n\n  press the FN key along with F11 that will take the num lock off, and you're set
987976
you must set the databasename property of your data control to your access database.
718306
try http://support.microsoft.com/kb/888018/en-us
578192
answer is here http://www.access-programmers.co.uk/forums/archive/index.php/t-30557.html
749089
Type Alt+0174 from the keypad
1012192
hold down ALT then 0153\n\n™ tadaaaa.
518146
can't you also do that with alt numbers you know alt plus 3 on the numberpad ♥ -----1,2,3,4,5,6,7,8 in alt numbers ☺ ☻ ♥ ♦ ♣ ♠ • ◘○be sure to press number lock first or alt + 4 is auto-boot. lots of other alt http://www.coloryourprofyle.com/phade/alt.html Thanks :-)
224915
I found the error number on Microsoft's technical database. However, it is a generic message and I couldn't find the exact match to the message. I included a link to the page. I hope it helps.
744599
add and remove ,you will go back to 6 when you delete 7
447356
use an alt +{key} key ¢  \n\nalt + 0162  bam!!! you have ¢
146346
hold down the "ALT" key and at the same time type 130 in the number pad
1015496
Access has the "forms" but I forget how to use it.
279903
1.Click Start | Run. \n2.Type regedit and click OK. \n3.Expand HKEY_CURRENT_USER, then Software, Microsoft, Windows, CurrentVersion. \n4.Click on Internet Settings to view its contents. \n5.Check Regedit's right-hand column for the following two lines (values):\nMaxConnectionsPerServer\nMaxConnectionsPer1_0Server \n6.If these values are present, right-click on the first value (MaxConnectionsPerServer), select Modify from the drop-down menu, click Decimal, and set the Value data field to 6. Repeat this process for the second value (MaxConnectionsPer1_0Server). \n7.If these lines (values) are not listed, right-click on the white region of Regedit's right-hand column, click New, and then click DWORD Value. \n8.Enter MaxConnectionsPerServer for the name of the new DWORD Value and press Enter. The new value should now appear in Regedit's right-hand column. \n9.Right-click the new value and click Modify. \n10.As in step six, click Decimal and set the Value Data field to 6, then click OK. \n11.Repeat steps seven through 10 using MaxConnectionsPer1_0Server as the new DWORD Value name instead of MaxConnectionsPerServer. \n12.You are done. Close Regedit and test Internet Explorer.
347994
dim cn as adodb.connection\ncn.open "..."\n\ncn.execute "update tablename set update='" & now & "' where id='xxx' "\n\ncn.close
864444
♪ALT 13♫\nalt 14\nHold down the ALT button and push 13 or 14 on the numpad
864013
hold alt and press 0169\n\n©