frank fazzio! 36-field limit in Access database form.?
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???
992894
Access is fully programmable, and easy to set up for small databases.  You could probably do this yourself.  I'm not sure you will find an actual "Lost and Found" database, but morelikely find an inventory control or the like.
1027306
If you can connect to the database in Dreamweaver, try connecting to it with Access and see if you can modify a table or execute a query.  It's either a permissions issue with your database file, a permissions issue with the webserver that the file is on, or something quirky.  I'd suggest turning off Friendly error messages in IE 6 so it can (hopefully) give you some good feedback.  \n\nI'm a bit confused when you say "seems that all database stuff... are not working properly when viewing". So none of your select statements are returning values either? Seems like a config issue.
884397
you'll want to look for an option that allows forms to be auto filled and uncheck the box/ disable it. i don't know what browser you are using, but it should be in tools or preferences.
47430
thats a good qeustion. i didnt know that there was a limit. just ask yahoo. they let you ask anything and they helped me once.
578192
answer is here http://www.access-programmers.co.uk/forums/archive/index.php/t-30557.html
234098
NO! Not technically.\n\nA database has to have fixed number of named columns. Spreadsheet has a open stucture.
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
924206
to display the records from Sales table and Purchase table, do like Monalisa said, but he/she missing 'WHERE' query.\n\nassume :\nCreate Table Sales (Sales_Date date, total integer);\nCreate Table Purchase (Purchase_Date, total integer);\n\nSelect Sales_Date, Total from SALES where\nSales_Date>='10/03/2006' and Sales_Date<='10/09/2006'\nunion all\nSelect Purchase_Date, Total from PURCHASE where\nPurchase_Date>='10/03/2006' and Purchase_Date<='10/09/2006'\n\nNotes :\n'UNION' will eliminate the same records from PURCHASE table.\nto get all records we must use 'UNION ALL' .\n\nTo sum sales and purchase in 3rd to 9th oct  :\n\nSelect sum(A.Total) as TotalSales, sum(B.Total) as TotalPurchase from SALES as A, PURCHASE as B where A.Sales_Date>='10/03/2006' and A.Sales_Date<='10/09/2006'\nand B.Purchase_Date>='10/03/2006' and B.Purchase_Date<='10/09/2006'\n\nps :\nmy query format maybe have a little different with ms Access query format, so if my query can't run in ms Access, try to change it to ms Access query format.
513723
A field within a table.
214490
I am not sure I completely understand, but from the sounds of it you want to add records to a recordset? If you need to do lots of manipulation to get them try method 1, if it is simply data from two tables use method 2:\n\n1)I like to use a temporary table, insert all your records with an insert into, then do whatever you gotta do to create more records in the table, then select to get the full recordset. This is nice when the new records require a lot of manipulations to figure out.\n\n2)If you just need to add two selects together use a union statement\n\nSELECT * FROM Table1\nUNION\nSELECT * FROM Table2
910105
You forgot the double quotes around POST. Use this:\n<FORM METHOD="POST" ACTION="index.php">\n\nAlso, it's good practice to change this:\n\n<?php\n$d = count($dAta);\n$d = $d + 1;\n$dAta[$d] = $_POST['field1'];\n?>\n\nto this:\n\n<?php\n$dAta[] = $_POST[field1];\n?>
462845
Don't know the exact limit but I have seen using more than 100 forms in one project. I don't know if there is any limit set by VB. But when you have lot of forms, project will take lot of time to load.
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
485900
The MS Access database size limit is 2GB.  You can't change that, but putting your forms, reports, queries, etc. in a separate database and then using linked table will help.  That will let you have a 2GB database for just data.\n\nYou CAN have multiple databases of 2GB all linked in a single application, but you'll run into a brick wall if you need referential integrity, cascading updates and deletes, etc.\n\nIf you haven't already designed your database, it would be eaiser to use MS SQL or MySQL for a database.  The MySQL route is nice because it's FREE, but I'm sure some of my competitors would disagree with the use of MySQL.  \n\nI've developed a large Access/VBA application that has linked ODBC tables to a MySQL database.  The database is around 8GB right now and it runs flawlessly.  And when there IS a problem it's always been an MS Access problem, NOT the database.\n\nMySQL running on Linux is rock solid.  MS-SQL is good, too, but there's a price to pay (licenses).\n\nGood luck!
785158
You cannot specify a minimum number of characters in SQL. You can only specify whether the field allows nulls or a max number of charactes. You would need to enforce character limits in your programming - either on the server-side or by using client-side validation to ensure a username is greater than 1 character. I would recommend doing both.
105474
pass it in the query string\n\nwebform.html?value=27