I want to inser t tha data in Ms-Access with the HTML page . i create a page that is ... field are ...name and paaword and this information are stored in data base with the help of Submit button.......
You can do this using lower version of Ms Access like 2000 or 2002 version but not in Access 2007.
you can create a page at ms access as your data form to insert data to ms access table and when you save it create an external page file that you can open outside access program.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
To parse a Text field that contains two words separated by a comma, follow
Open any existing database.
Create a table with the following structure:
Table: Parse2Words ------------------ Field Name: Empl Data Type: Text
View the Parse2Words table in Datasheet view and type the following
three records in the Empl field:
Create the following query based on the Parse2Words table:
Query: QueryTest ------------------------------------------------------------------ Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1) Show: True Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1) Show: True
NOTE: You can modify the QueryTest query to account for spaces between
the two parts in the Empl field. For example, if the text in the Empl
field is "Smith,John" without spaces, remove the -1 from the FirstName
Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below:
FirstName LastName -------------------- John Smith Laura Callahan Andrew Fuller
Under the pages tab in the Database window is a wizard that will walk you through creating the page. You can then copy the code or tweak it as you need to. If you do this and want to continue to mange using forms however, you may want to split your database. that means load all the forms in one file and link them to the tables in another. There is a tool to do this automatically under TOOLS > Database Utilities > Database Splitter.
Start, Programs, Microsoft Office, Microsoft Office Access 2007.
Click the Office Icon in the top left corner of the Access 2007 window.
Click New, locate where it says "Blank Database". In the field labeled "File Name", type the name of your new database. To choose a folder on your computer to save the new database, click on the folder icon next to the "File Name" field, and select the folder, then click Ok. Then click "Create".
Please let me know if this helps or if you have any questions.
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.
Display the table in Design view,
create a new field to store the hyperlinks, click the new hyperlink
field's Data Type box, click the list arrow, select Hyperlink, and save
To Insert a Hyperlink:
Select the hyperlink field and then click the Insert Hyperlink button on the toolbar or select Insert ,
Hyperlink from the menu. Either select a file you want (use the Browse
button to help you locate the file) or type a Web address for the
hyperlink's destination and click OK.
To edit a Hyperlink: Right-click the hyperlink and select Hyperlink , Edit Hyperlink from the shortcut menu.
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.