MS Access Calculation Field Sysytem?
146941
In calculated query field:\n============================\nTotal: [Field1]*[Field2]\n\nIn a form field:\n===============\n=[Field1]*[Field2]
492576
Can u elaborate the problem, The MS-Access has it own built in SQL building routine, if this is not solving your problem, then please explian the kind of connectivity or query u are passing so that i can understand it better..!
1082818
Please note for any of this to work you have to have the project references include the Microsoft ActiveX Data Objects library\n\ndim conn as new ADODB.Connection\ndim rs as new ADODB.Recordset\n\n'Tell your connection what and how to connect\nconn.ConnectionString= "DSN=DSNname;UID=SqlServerUserID;pwd=SqlServerPassword"\n\n'open the connection\nconn.open\n\n'Run your SQL Query\nset rs = conn.Execute("Select * from datatable")\n\n'See if any records were returned we do this\n'by seeing if the recordset is simoultaneously reporting\n'that it is at the beginning and end of the record set\nif not rs.EOF and not rs.BOF then\n\n\n     'Get the field by field name\n      myValue=rs("fieldName")\n\n     'Get the field by position in the return set\n     'This is a zero baed index\n      mySecondValue= rs(3)\n\n     'Now I move to the next record. \n     rs.MoveNext\n\n     if not rs.EOF then\n          'Get another value\n           myValue=rs("FieldName")\n     end if\n\nend if\n\n'now close and clean up\n\nconn.Close\nset rs = nothing\nset conn=nothing
684057
Go to programs, new.  Type in the formula and save it as a program.  When you need the formula just go to program and then edit and you can see the formula
578192
answer is here http://www.access-programmers.co.uk/forums/archive/index.php/t-30557.html
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 &")"
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
852680
Well don't know the version of access you are using...\n\nFor Access 2003\nhttp://office.microsoft.com/en-us/access/HP051874901033.aspx
865202
Dim s as String\n\n'assuming s is not nothing\ns = IIF(s.length() > 30, s.substring(0, 30), s)
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
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
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.
774615
I found this for you : http://www.databasejournal.com/features/mssql/article.php/1756161\n\nHope that helps! Sounds like fun!
254134
I believe Access SQL supports the TOP keyword as below.  This will allow you to easily limit the number of records.\n\nSelect TOP field1, field2, field3\nfrom mytable1 m1 left join mytable2 m2\n on m1.field1 = m2.field4\nwhere field1 = 'value'
637825
MS Access environment\n\nYou must create a field in Table Teachers that uniquely identifies each teacher. It can be an Autonumber field.\nGiven this, each time you add a teacher, the software will give this record a unique number.\n\nIn Students Table, create a field with number Long Integer data type.\n\nGo to Tools>Relationships and set a one-to-many relationship between the 2 tables using these 2 fields.\n\nCreate a query with this 2 tables using the fields in table Students and only the fields in table Teachers you want to show (not the autonumber field)\n\nMakiavel
10408
for this u can do one thing thatu will go database menu and click show sql query and add where\n 'Field name ' = today or now as per as ur requrement.
34052
I do not know a preprogrammed utility to do this, but can point you in the direction that you might need to go.  See the reference below for the math and an on-line converter: