Microsoft Access Hi. I have a form in access were i can take a new call from a client and place their info in the fields on the form. After the clients details have been placed in the fields the form automatically saves the info but i need to restrict other users not to edit these fields. How do i do that? Can i place a button in "Submit" and allow this button to restrict users from editing the fields if so how?

In the Design view for your form element (eg textbox), go to the Data Tab. Look at the options for:
Input Mask, Validation Rule and Validation Text. You can use any combination of these to force a user to enter something in the field. If you just want to check that the contents of the element has a non-zero length, then you can write an event (Events tab) to check the length of the values entered. If 0, then throw a message box and re-focus the cursor on the textbox.

have to follow few steps.
1. new database - give any name
--> design table
e.g id, name and file (the datatype of the file should be hyperlink other wise it wont work)
--> enter some records (in file field write a, b ,c)
--> when you put record in file field then click on hyperlink option on top.. (like first record id=1, name=fahad, file=A) select the A and click on hyperlink option on top and give the hyperlink of the pdf file
--> design the form
--> run the form
--> click on desired file
--> it will open
--> looks complicated but its easy

it will work definitely

this discussion could go on for days (month? a semester at least?) but data is any piece of information you want to capture and save. a name. an address. a phone number. (actually they are examples of pieces of data - and whether you capture and save them or not they are still pieces of data). data "forms" a database when you save it (in the dataabase).

the database usually has tables representing related pieces of infomation.

Example:
the CLIENT table may have the following fields:
Client Number
Client Name
Address
Phone
Contact name
etc., etc.

the ACCOUNTS_RECEIVABLE table may have
Client Number
Invoice Number
Invoice Date
Invoice amount
etc., etc.

Notice how the CLIENTS table is "related" to the ACCOUNTS_RECEIVABLE table by the Client Number - hence the term you may have heard RELATIONAL database.

any more in depth please ask.

se Adodc OR Even better.. ADODB. for this you need to get MDAC fromMicrosoft free download.(check under project_References- Microsoft DataActiveX objects.. the current no is 2.8. if it is not there download invb directory.

next, you can learn about creating a DSN from control panel, ODBC. onceyou learn this, connection becomes a piece of cake. get some free vbtutoriasl from WWW.

then

you need to use DAO or ADO to connect to the database. better study both but since ADO is current, i am showing that code.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string
Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub
and for adding records:
say let us say you have 3 fields. then have 3 textboxes and 1 command button on the form.

private command1_click()
esql1="select * from Yourtablename"
rec.open(esql1),conn,, adOpenDynamic, adLockOptimistic
rec.AddNew
rec.Fields(0) = text1.Text
rec.Fields(1) = Text2.text
rec.Fields(2) = text3.text
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.
rec.update
if not rec.eof then rec.movenext
rec.close
conn.close
set conn to nothing
end sub

this will add new records to access table from VB.
' for picture store the full path of the path and the picture file nameint the text field. and in the picturebox of VB form for viewingrecords again you need ADO or ADODC and here you code:picture1.picture=Loadpicture(rec.fields(3) ' depending on where thepicture field is located. you need to make a few trials.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string

Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub

and for accessing records:

private command1_click()
esql1="select * from Yourtablename where id =" & val(text1) ' for integers

esql1="select * from Yourtablename where name=" & "'" & text1 & "'" ' for string

rec.open(esql1),conn, adOpenstatic, adLockreadonly

label1.caption =rec.Fields(0)
label2.caption= rec.Fields(1)
label3.caption= rec.Fields(2)
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.

rec.close
conn.close
set conn to nothing
end sub


' similarly there are routines to ADD, Delete, Edit, View etc.

If you select the correct table from the drop down, the fields should be shown in the box. or keep the table open and try creating form. or create a blank form and on the right side you will get tables and fields, you can just drag and drop required fields

(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

<HTML>
<BODY>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("sample.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM Friends"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS("Name")%>: <A HREF="<%=RS("Link")%>">Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>
</HTML>

When you create table where you want to store passwords, go to Edit Table, then select a field where the password will be stored, go to Input Mask field in Properties and type Password in that field. That will set up the field needed for storing passwords.

For forms, open a data table in view mode, while there locate the forms setup wizard. For your first try just answer the questions the best you can for the wizard. When there are no more questions to answer wizard will create a form for you. From what you learn doing that you may get enough hints to make a form from scratch. Just keep in mind you always build a form from the fields in a table.
Now for the Query, start out the same way and use the wizard. Query to most folks means ask a question and get an answer. In access query is a way to present sub sets of data or ways to modify data in the fields of your tables.

If, as I suspect, this is for a web form, then it effectively can't be done on a "proper" web server. This is because you cannot install MS Office on an MS server OS (e.g. Server 2003). You need to use MS SQL Server or MySQL instead. If this is for very limited use (i.e. only a few clients at a time), you can use XP running IIS but this is really not a good idea. The sedurity implications don't bear thinking about :) Linking a web page to Access can probably be done using ASP (never even thought of trying it - anyone else here know for sure?) If you are using a Linux web server then it's totally out of the question. Use Webmin or PHPMySQL to set up a MySQL database & PHP to code the linkage between the page and the DB. There are plenty of tools out there that will automate this for you, some of them Open Source and therefore free to acquire.