how can i use records in access table as feilds in another table in the same data base?
611776
In design mode, choose the field you want to have automatically populated (under Data Type column). Then click the "Lookup" tab (in the grey area below), and set the parameters in each field (use row source type Table/Query, and under Row Source, point to your other table).
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
26959
I'd copy the emails from each sheet & do a vlookup to each set. Delete the ones that are matched & then do a vlookup to the original sheets to bring ini the rest of the details.\nI'd take them into Access tho if you can. You could link the sheets to a data base & export the query results back to Excel.
283150
Here's a code snippet that you should be able to paste into a form module and give it a try ... there are obviously many ways to tackle the issue ... this is just one of them.  To use this code you'll need a reference in your VB6 project to a Microsoft ActiveX Data Access Library (like 2.6).  Good luck!\n\nDim rs As Recordset\nDim cn As Connection\n\nDim DBPath As String\nDBPath = App.Path & "&#92;customer.mdb"\nSet cn = New Connection\ncn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath\n\nSet rs = New Recordset\nrs.CursorLocation = adUseClient\nrs.Open "SELECT * FROM tblCustomers WHERE CustomerID=" & 1, _\n    cn, adOpenStatic, adLockOptimistic
187676
Your best bet would probably be a list of checkboxes to match each question.\n\nOnce all the checkboxes have been filled in then submit the form and all the information gets transfered to a database.\n\nDo this as a standalone webpage with a DB backend. Probably something like mySQL or SQL2k, SQL2003 would be your best bet as Access only supports 10 connections at a time and you may overload this if you have multiple people entering data at the same time.
1085254
1. create create a table in MS ACCESS and save it with the extendsion of .mdb\n2. open the control panel and select the ODBC data sources\n3. a window opens in that click Add\n4. another one opens in that select Microsoft Access Driver(*.mdb)\n5.click finish\n6. a window opens enter the data source name\n7. click select and search the database that u have created in the MS ACCESS  and then click ok\n8. then in vb place the adodc control and datagrid\n9. right click the adodc and select adodc properties\n10. in that select use odbc datasource name\n11. it will be displaying various name select the data source name u have entered\n12. then click the recordsource\n13. select the command type as 2-adcmdtable\n14. select u r table name\n15. click ok\n16. click the data grid and in the properties \nset the data source as adodc1(adodc name)\n17. run the program and u can find the information in the datagrid
25554
I guess you wanted to say "how do you use..."\n\nAccess is better do design database interface with windows and buttons. Create a new database using one of templates and study it's setup.\n\nExcel is just a spreadsheet, but if your arrange your data in columns with a header row, you can use some Data menu to filter it, or such functions as VLOOKUP, MATCH, INDEX, COUNTIF, SUMIF to do some database-like things to the data.\n\nNow give me the best answer - you get points for that too.
151888
Sorry, I don't think I can help.  I can use a 50 field table in Access and create a 50 field form using the wizard.\n\nDoes the problem occur running the wizard locally instead of through the thin client?  If it doesn't, you probably need to report the problem to Wyse.\n\nOnly other thing I can suggest (not saying it will make a difference) is see if you have the latest service pack installed for Office - maybe there was a bug???
531740
try using microsoft access.  use the wizard to make a dat base and tjen it is clear sailing.\nthere are also some othere ones but i dont know their names because they arent in microsoft so i highly doubt that you will have them.
143941
1) Oracle has a program call SQL Loader that loads tables from external data.  You can write a module in Access to create a flat fiel from your data and put it in a form where SQL Loader understands.\n\n2) A solution that works with almost any RDBMS is to write a module in Access to create SQL Insert statement for each record in your Access table, and write them to a file.  Then, using the RDBMS's batch execution engine (SQL PLus for Oracle, OSQL for SQL Server, MySQL command prompt, etc, ISQL for Sybase, etc), simply create yout table and run those insert statements.\n\nAn example of 2) would be ...\n\nFunction doIt()\n\nDim rs As Recordset\n\nSet rs = CurrentDb.OpenRecordset("Select f1, f2 from t1;")\nOpen "c:&#92;statements.sql" For Output As #1\nWhile Not rs.EOF\n    Print #1, "Insert into T1 (F1, F2) values ('" & rs("f1") & "', '" & rs("f2") & ")';"\n    rs.MoveNext\nWend\nClose\nrs.Close\n\nEnd Function
139090
If you refer to databases, no, it's not possible.\nA table can have a single primary key, which are used to uniquely identify a record. Aside from that a table may have a number of keys and foreign keys.
591587
Tatzug is quite right that you should link directly to the tables in the database on the server, and then Access will be able to see and use the correct data type for each field.  You do this as follows:\n\n1.  Set up an ODBC link to the SQL Server\n\nYou do this using the "DataSources (ODBC)" control panel, which is found under Administrative Tools.  This is actually a "wizard" which will lead you through the process of creating the ODBC link.\n\n2.  Inside Access, go to the File menu and select Get External Data, then Link Tables.\n\nWhen the file dialog opens, switch the File Type at the bottom to "ODBC Databases ()" and select the ODBC link you created in step 1.\n\nThen you'll get a dialog box which will allow you to select the database tables on the server you want to link to.\n\nGood luck!
560387
Hello\nThere is some software that you can use , but I recommend ORACLE software they have a great database software with a great tutorial. \ngood luck there wonderful.
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
987976
you must set the databasename property of your data control to your access database.
902750
Are you using .NET?\nIf so, I've done it in C#.\nI don't expect there will be all too big of a difference between the two. Also, if you're doing this for a website, I'd highly recommend MySQL over Access. Acess will bomb out on you -- especially if there are multiple concurrent connections. Send me an email if you need more help on it.\n\nusing System.Data.OleDb; //This might be different in C++\n\npublic void ConnectToDatabase()\n{\n  OleDbConnection dbConn;\n  string strConnection;\n\n  strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&#92;somepath&#92;mydb.mdb;User Id=admin;Password=;";\n/*go to www.connectionstrings.com for more info on connection strings*/\n\n  dbConn = new OleDbConnection(strConnection);\n  dbConn.Open();\n\n  //woot, the database is open!\n  OleDbCommand cmdCommand;\n\n  cmdCommand = new OleDbCommand();\n  cmdCommand.Connection = dbConn;\n  cmdCommand.CommandText = "SELECT * FROM tblItem";\n\n  OleDbDataReader rdReader;\n\n  rdReader = cmdCommand.ExecuteQuery();\n\n/*\nThe read function advances to the next row and returns true upon success\n*/\n  while(rdReader.Read())\n  {\n     //This command shows a pop-up of the string\n     //In Row #1 of the results (#0 is the first row)\n     MessageBox.Show(rdReader.GetString(1));\n  }\n\n  rdReader.Close(); //always close your reader or it gets mad\n  dbConn.Close();\n}
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