Access:  If DLookup gives you one field, how do you get 2 or more fields?
828970
dim db as database\ndim rs as recordset\ndim strSQL as string\ndim strA as string\ndim strB as string\ndim strC as string\n\nset db = currentDB\n\nstrSQL = "Select fieldA, fieldB, fieldC from Table1 where FieldD = fieldvalue"\n\nset rs = db.openrecordset(strSQL, dbOpenDynaSet)\n\nif not rs.EOF then\nstrA = rs!fieldA\nstrB = rs!fieldB\nstrC = rs!fieldC\n\nend if
61405
Convert the parameters in your "where" clause to the same case, upper or lower.\n\nselect * from tbl \nwhere upper(fielda) = upper(searchparameter)\n\nI've not worked with Access (.mdb) dbs much, but there may also be an Access configuration to disregard Case.  (At least that is an option in MS Sql Server.)
883282
It would depend on your table structures, but it should look something like this:\n\nSelect <student info>\nFrom <table name>\nWhere <table name>.<birthdate field name> = <date of feb>
112245
Microsoft - Its called Access (Database)
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
431188
when u create table in design view,and select field. there is look up option ear general TAB.click on that tab if u have text field then u r able to change it and make combo. then u have to give reference combo to perticular table field by using query
1007349
add a hidden field\n<input type="hidden" name="num_inputs" value="how_many_inputs_you_have">\n\nthen when submitted\n$i = 1;\n$sSql = "INSERT INTO table (name, age) VALUES";\nwhile ($i < $num_inputs) {\nif ($_POST[$name.$i] != "" && $_POST[$age.$i] != "") {\n$sSql .= "('".$_POST[$name.$i]."' , '".$_POST[$age.$i]."')";\n$i++;\n}\n}\nexecute query here\n\n$name.$i would get evaluated to name1, name2 etc, and if statement checks if both of them are empty. operation .= means "stick whats on the right to whatever was in left variable"
462677
You can use Tables from MS Access or MS SQL Server Already loaded with Data
567687
u can use the SELECT command\n\nSELECT fname, lastname FROM biodata\n\nbiodata is the table name and fname and lastname are the fields u want 2 be displayed
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.
1124819
Create a new field in the property table called Address:\n\nalter table property add Address char(50);\n\nThe above assumes the data type is char(50).\n\nUpdate that new field equal to street number and street name:\n\nupdate property set Address = concat (Street_Num, ' ', Street_Name);\n\nAssumes that Street_Num and Street_Name represents street number and street name, respectively.\n\nThis assumes MySQL syntax.  The exact concatenate syntax is database-dependent.
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!
1333
Sorry in advance if Yahoo eats my indentation, but I think you are looking for something like this (tested under Access 2000):\n\n\nPublic Sub FiddlingWithQueryObjectsViaVBA()\n\n    Dim dbs As DAO.Database\n    Set dbs = CurrentDb\n    Dim qrydef As QueryDef\n    \n    Dim sSQLstring As String\n    Dim sQueryNames As String\n    \n    For Each qrydef In dbs.QueryDefs    ' iterate through all the Access query objects\n    \n        sSQLstring = UCase$(qrydef.SQL) ' Get the SQL for the current query\n        \n        If InStr(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR") > 0 Then   ' I found what I'm looking for?\n        \n            sSQLstring = Replace$(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR", "REPLACEMENT_TEXT") ' replace the text\n            qrydef.SQL = sSQLstring     ' update the query object with the new SQL\n        \n            sQueryNames = sQueryNames & qrydef.Name & vbCrLf    ' Maybe make a list of queries modified?\n        End If\n    \n    Next\n    \n    MsgBox "Modified the following queries:" & vbCrLf & sQueryNames\n    \nEnd Sub
513723
A field within a table.
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
870873
Well the easiest way is to use a straight out SQL method in access. Its not that a SQL method is hard but is just how you access the information in a table. Below is a link to a page which shows you a great straight forward example of using a few nested select statements or if you want to create an intermediate table to hold the results, that example is there too.\n\nHope this doesn't confuse you too much, but really if you take a look at it, you will find it makes sense. Just read it out loud.\n\nGood luck!
780343
If you are in VBA in MS Access? Than you can cut the string and used the variable directly and then finish the string.\n\nstudTbl.Open "SELECT * FROM [studlst] where ([no]=" & i &")"