Could anyone explain me the best way to fill external HTML pages automatically with data from an Access dbase?
I have spotted several commercial tools that use macro recording. Surely there must be another way using visual basic for example?
Hi!
I have a table with several fields. I would like to have a lookup in one field (combo list - get data from another table field) and for 2 other related field have the coressponding data appear automatically according to the selection in the lookup field.
eg.
Table1
|Field1...................|Field2...............|F ield3...............|
|LookupField1Table2 |AutoField2Table2|AutoField3Table2|
Table2
Field1...|Field2... |Field3...|
Data1...|Data2...|Data3...|
I am not quite sure if my question is clear... I had trouble in describing it in my post...
I have 3 tables:
Student Info:
Student ID (Primary Key)
Name etc.
Assignment Info:
Assignment ID (Primary Key)
Assignment Number
Criteria Number
Grades:
ID (Primary Key)
Student ID - Linked to [Student ID]
Assignment ID
Criteria Number
Grade
What I would like to do is be able to link the tables in such a way that for each student entered in the Student Info table, entries are automatically entered into the grades table for each assignment criteria.
For example:
Assignment 1 has criteria 1.1, 6.3, 7.2, Assignment 2 has 4.2, 3.3
When John Smith is entered in student info, the grades table is automatically updated with 5 new entries in the form:
John Smith - 1 - 1.1 - Enter Grade
John Smith - 1 - 6.3 - Enter Grade
John Smith - 1 - 7.2 - Enter Grade
John Smith - 2 - 4.2 - Enter Grade
John Smith - 2 - 3.3 - Enter Grade
That way I can have a form that automatically shows the possible criteria for each assignment on the sub form for each available student without having to type it in each time.
Your help would be wonderful
I have 2 fields in access table. In one field i fill numbers eg (1,2,3,4,5) drop down list. In the second field I need to fill another data. When I chose one of the numbers from Field 1, I want automatically fill the second field with appropriate data.
1 = 24857
2 = 24869
3 = 24899
4 = 24944
5 = 24994
6 = 24903
7 = 15480
8 = 15164
9 = 15482
10 = 15479
11 = 15468
12 = 15476
13 = 15489
14 = 15494
15 = 7524
16 = 7537
17 = 7523
18 = 7544
19 = 7533
20 = 7536
21 = 7539
22 = 7534
I am trying to build a database to store product information and also the product page in HTML. I was able to do this in MS Access, however the export process would alter the code....(the field is in long text, and in Rich Text format)
For example, this is the code I store in the table:
<html>
<head>
<title></title>
</head>
<body>
........
</body>
</html>,
however when I exported in Text File or XML File, < got replaced by < and > got replaced by > the code after export becomes:
<div><html xmlns=""></div>
<div><head></div>
<div><title></title></div>
<div></head></div>
<div><body></div>
..................................
<div></tbody></div>
<div></table></div>
<div><!--End Template FreeAuctionDesigns.com Copyright 2008 All Rights Reserved.--></body></div>
<div></html></div>
Good morning! I'm using Access to redesign our company's electronic phonebook. Our intranet uses SharePoint technology and our IT people have cranked our security settings up pretty high, so I can't use data access pages or ASP. Therefore, I'm going to use static HTML, producing a single page which the CEO's secretary will upload once a month, allowing our 800+ employees to view the entire phonebook at once. CTRL-F is their friend.
I've managed to design a data access page that looks very much like we want it to, but I don't know how to export it to static HTML. Can such a thing be done, or am I just being wacky? If so, is there a way to automate it so the secretary can just push a button to generate the page?
Thanks,
Andreas
I am new to microsoft access and i am currently using microsoft access 2010...I have a students table in my access database and i have now append this table with data from a HTMLhow can i do that? using append query
View 10 Replies View RelatedCan i make an html of login form, whose data is saved in access as back end. I am curious to know. but of course simultaneous saving is considered yes in here...
View 1 Replies View Relatedhello all, any help greatly appreciated.....
I have two tables in the same Access 2003 database.
Table1 is called "Clients" and has address type fields, e.g. street_name, postcode, etc. It also has a field called CYPAN_area.
Table 2 is called CYPAN_Postcodes and has two fields; postcodes and the CYPAN area that postcode belongs to.
I want to create a function so that when someone enters the postcode in table1, the database searches Table2 and identifies which CYPAN area that postcode belongs to and automatically populates the "CYPAN_area" field in Table 1.
any tips greatly appreciated
Harry
PS I'm only a novice so I don't know anything about VBA etc, but I understand excel type formula
Hi everybody,
I have a table that has 4 columns as shown below:
(*It really isn't code, I just couldn't figure out how else to keep the columns in place!)
-------------------------------------------------------------------
Store Name Invoice Number Customer Name Customer Address
Store1 1 Bob PO Box 55
Store1 2 Joe PO Box 789
Store2 3 Chris PO Box 1254
-------------------------------------------------------------------
On my input form, for entering a new invoice, when you select the customer name, I want the form to automatically fill in the correct address in the "Customer Address" field.
I think there has to be a way to do this because there is only ever going to be one address for every customer. And the same customers will be comming back very often.
Does anyone have any ideas?
-Chris
I'm kinda new at ACCESS, and I've accepted an assignment that is giving me some trouble. For beginners, I could use some help as follows:
I am constructing a data entry form that is keyed on PID (Personal ID). I would like to be able to have certain fields in my form (Name, Title, Department, etc.) fill in automatically from information already stored in a different table, also containing the PID (which I can set as key). I would like this action to occur either when the PID field has reached 3 characters or when the PID field has LostFocus.
Thanks for any help in advance.
MAE:
Is it possible to have some fields filled in automatically as soon as a certain value has been entered into another field. e.g. if a town is entered in one field, then the postcode is automatically entered into the next field.
View 1 Replies View Relatedwhen you start to type, if there is an item in the column that matches the letters you typed so far, it brings that answer up as a suggestion and you can either keep typing if not what you wanted to enter OR press Enter and it will fill the rest in for you. when i googled it online - it was referred to as auto data fill. when i tried looking this up for access - any search that dealt with autofill was not referring to what i am referring to above.
View 2 Replies View RelatedI have a table with date,item number,quantity,price.and so on...
Im using form to input new record and is there a way to automatically search the table and if I enter the item number, it will fill in the rest of the values with the previous record of the specific item number?
since the only thing that will change would be, most of the time, quantity and price? and also date and invoice number but I have that set up to repeat previous record until updated...
Thanks In Advance.
I am new to Access, but have an urgent need. I want to have certain fields (Yes/No type) to be selected based on a certain field (also a Yes/No) being selected.
It's very straight forward. Select West Coast, and the states CA, OR, and WA are selected. De-Select West Coast and the states CA, OR and WA are deselected.
Any thoughts? thanks in advance.
Warren
I've created a table.
Id= autonumber
tDate=date
Now I need something to fill this table with 365 records where tDate starts at 1-jan-2006 and ends at...you've got it!
I've got a Query that will add a date but I don't want to edit this 365 times.
Probably very stupid simple but please help
I have inherited a database where the structure is that everyone has a People ID which is unique and is stored in a central table. However to create a person you create their People ID in the People table (the ID is generated by autonumber) and to make the rest of the database work you have to manually type the People ID into a separate field in the form to allow you to do anything further. How can I automatically add this new number to the people ID list?
Hope this makes sense
Wendy
Let's say in one table (called Employees) I have two columns, Name (the Primary Key) and Job (Both are text fields). One row contains "Jack" and "Gardener" in each column respectively. If I were to have a form for a different table where I select Jack's name from a drop down menu of all the "Names" in "Employees" and it then automatically fill in the next field with his Job (which would be "Gardener").
I really hope I'm making sense... Is this possible?
I have a form (Project Form) with (Project_ID,Applicant_ID,Project_description, etc). To make it easier for the user who may not know the Applicant _ID when he/she is adding a new project for the applicant, I want to put a combo box with the Applicant Names in it, and once the Applicant Name is chosen, the Applicant ID will be filled out automatically and be saved in the Project Table.
My Approach so far was adding a combo box with two columns(Applicant ID, Applicant Name), and basically adding the following code:
Private Sub Combo36_AfterUpdate()
Me.Applicant_ID = Me.Combo36.Column(0)
End Sub
This approach works well, when I select an applicant, the Applicant ID will pop up correctly. However, This ID is not being saved in the Project Table.
Is there an easy way in Data access pages to do like you do in forms as far as using a dropdown list and when you choose a name/acct#/rec# or whatever, that the rest of the fields are automatically updated to match? Just curious.
If you need an example, I can provide one.... basically, I'm trying to get a data-acess-page to act like a form so someone without access can do a simple search.
I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not even sure how to trigger an event to do it just the one time when the record is created.
View 2 Replies View RelatedI have a table called tbl_post_staff, within this table I have an id number (autonumber), user id (text) and user full name(text). Then I have a form called ec_main with a combobox linked to tbl_post_staff, but stores its value in a field called officer_is in a table called tbl_extensions. also on the ec_main form is a text box that displays current user.
What I am trying to do is; on my form ec_main; default the combobox (Called officeris) to the staff full name based on there userid that is logged in. how can I do this?
I have a mainform with a combobox and a button. What i want is when i click on the combobox and then on the button I want that the textbox in the subform automatically fill in.
The mainform name is FrmTakenInvoerenEnToewijzenAanEenMonteur,
The combobox name is Keuzelijst1,
The subform name is SubTakenInvoeren,
And the textbox name is txtOpdrachtnr.
I tried this code in on button click:
Me.SubTakenInvoeren.txtOpdrachtnr = Me.Keuzelijst1
But that doesn't work.
I prepared students details in access, but when i look the form view students particulars looks automatically (like name, age, weight and address). But what i need is students details has to come after I enter the name.
View 1 Replies View RelatedI have a database in which we are trying to have a field "Headcount" automatically fill with the correct value based on information in multiple fields. The "Headcount" field will be based on about 6 or 7 rules. Most of the rules i can figure out, but im having trouble figuring out what the best way would be to search for a single individual's projects when they are on more than one project at a time. I thought about using a counter of sorts to count how many projects someone was one, but how do I pick them out of the entire table once i have found out the number of projects? Would a for loop work best or just many if statements?
View 5 Replies View RelatedI am Oracle Guy & new to Ms-Access. I want to load the data from Ms-Exell into Table in Ms-Access automatically through Procedure / Macros. How to do this process?. Help me, if anyone knows.
Regards,
GKS:mad: