How do I search for the symbol # in Access? (not as a wildcard)?
92611
Use the following syntaxis:\n\nLike *[#]*
663190
format-->cells-->custom \ntype in ##,##,##,##
578192
answer is here http://www.access-programmers.co.uk/forums/archive/index.php/t-30557.html
385939
A good way to do that kind of thing is to click start - run and type in charmap and click ok. It lets you view and paste any symbol possible.
626282
Here's one way:\n\n#!perl\n\nwhile(<>) {\nif($_ =~ m/abxy$/) {\nchop;\nprintf("$_ -- $.&#92;n");\n}\n}\n\nTurn this into a perl file (say findinline.pl) then run\nPerl findinline.pl somefile\n\nAny qualifying line will print out followed by the line number.
942085
u can do alt + 3 = ♥\nor <3\n\nxox <3 <3 ♥♥♥♥ <3 <3
52040
number = ereg_replace ("^[0]+","",number);\n\nyahoo deletes my dollar signs\n\n^=start at beginning\n[0]+ delete all 0s
150672
Two ways to do it.\n\n1) SQL - in the SQL statement in the OpenRecordSet statement, add a WHERE clause the searches only for records you are looking for.\n\n2) Loop through the returned recordset until you find the record you are looking for.\n\nSub OpenRecordsetX()\n\n   Dim wrkJet As Workspace\n   Dim wrkODBC As Workspace\n   Dim dbsNorthwind As Database\n   Dim conPubs As Connection\n   Dim rstTemp As Recordset\n   Dim rstTemp2 As Recordset\n\n   ' Open Microsoft Jet and ODBCDirect workspaces, Microsoft \n   ' Jet database, and ODBCDirect connection.\n   Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)\n   Set wrkODBC = CreateWorkspace("", "admin", "", dbUseODBC)\n   Set dbsNorthwind = wrkJet.OpenDatabase("Northwind.mdb")\n   Set conPubs = wrkODBC.OpenConnection("", , , _\n      "ODBC;DATABASE=pubs;UID=sa;PWD=;DSN=Publishers")\n\n   ' Open five different Recordset objects and display the \n   ' contents of each.\n\n   Debug.Print "Opening forward-only-type recordset " & _\n      "where the source is a QueryDef object..."\n   Set rstTemp = dbsNorthwind.OpenRecordset( _\n      "Ten Most Expensive Products", dbOpenForwardOnly)\n   OpenRecordsetOutput rstTemp\n\n   Debug.Print "Opening read-only dynaset-type " & _\n      "recordset where the source is an SQL statement..."\n   Set rstTemp = dbsNorthwind.OpenRecordset( _\n      "SELECT * FROM Employees", dbOpenDynaset, dbReadOnly)\n   OpenRecordsetOutput rstTemp\n\n   ' Use the Filter property to retrieve only certain \n   ' records with the next OpenRecordset call.\n   Debug.Print "Opening recordset from existing " & _\n      "Recordset object to filter records..."\n   rstTemp.Filter = "LastName >= 'M'"\n   Set rstTemp2 = rstTemp.OpenRecordset()\n   OpenRecordsetOutput rstTemp2\n\n   Debug.Print "Opening dynamic-type recordset from " & _\n      "an ODBC connection..."\n   Set rstTemp = conPubs.OpenRecordset( _\n      "SELECT * FROM stores", dbOpenDynamic)\n   OpenRecordsetOutput rstTemp\n\n   ' Use the StillExecuting property to determine when the \n   ' Recordset is ready for manipulation.\n   Debug.Print "Opening snapshot-type recordset based " & _\n      "on asynchronous query to ODBC connection..."\n   Set rstTemp = conPubs.OpenRecordset("publishers", _\n      dbOpenSnapshot, dbRunAsync)\n   Do While rstTemp.StillExecuting\n      Debug.Print "  [still executing...]"\n   Loop\n   OpenRecordsetOutput rstTemp\n\n   rstTemp.Close\n   dbsNorthwind.Close\n   conPubs.Close\n   wrkJet.Close\n   wrkODBC.Close\n\nEnd Sub\n\nSub OpenRecordsetOutput(rstOutput As Recordset)\n\n   ' Enumerate the specified Recordset object.\n   With rstOutput\n      Do While Not .EOF\n         Debug.Print , .Fields(0), .Fields(1)\n         .MoveNext\n      Loop\n   End With\n\nEnd Sub
496619
Another way.\n\n=RIGHT(A1,LEN(A1)-SEARCH("source",A1,1)+1)\n\nHover your cursor over the three dots to see it in full.
665780
press the alt key and press 3 on your number keypad. you'll get a ♥, different numbers give you different symbols. Have fun!
484719
Yes symbols go first then numbers and then a - z
150186
Dont declare @i as int, but as varchar(20) and assign it like this\n\nSET @i = '1'
131541
ls -l | more\n\n( '|' is called pipe, to get this use 'shift' and '&#92;' keys)\n\nyou should use space bar to go to the next page of list
1044851
One question: when you type "2" in the field t4f3, what do you want to lookup in table 2? Fields? Records? All fields? All records? I believe you're not designing the right way your database. Please be more specific.\n\nMakiavel
592676
If you mean find as in find something on a page, it's Command + F, not Cntrl + F.  Command is the key with the Apple picture on it.
396944
Access 97 supports only limited SQL queries. Most of these can be generated with the query designer functionality in Access, but if you want to access the database using more advance SQL commands, try writing a VB program to do it and use an OLEDB jet connection. Then you get whatever functionatily you want on it.\nGood luck!
161686
Easy if you restrict to integer types.\n\nCreate the following macro:\n\n#define IS_SIGNED(type) (((type) 0xFFFFFFFF) < 0)\n\nYou can now use it direction in your code as such:\n\nif (IS_SIGNED (char))\n{\n   stuff if it is signed\n}\nelse\n{\n   stuff if it is unsigned\n}\n\nNote that this implementation assumes that you maximum integer type is 32 bits. Pretty easy to change if it is otherwise though.\n\nI have done a LOT of multiple-platform code, char signing and byte ordering are the two biggest headaches.\n\nHope this helps.