Forms And Subforms On Access Pages
Jun 25, 2007
:confused: Hi everybody. I have started trying to be a little more creative and making my systems a little more what the big boss where I work would like to see. I have set up an Access Data Page, with one form on it where the user would enter some required information, which is saved into a table for me to monitor (date, time, unit, spec reviewed, name etc). What I was hoping to do, was have on teh same Page, a subform or another form, where the user would reference that other form, when doing their entry. Basically, they are entering that they looked at a certain spec so if they produce the wrong item, or use the wrong materials, we can say well, you looked at this spec, or so you say.....Does anybody have any suggestions on how this can work? Or even if it is at all a possibility. Thanks!
View Replies
ADVERTISEMENT
Jul 14, 2005
I have created a form which has a main section (Client demographics (bound to tblClient) and then five tabbed pages with subforms.(Data associated with the Client- all forms derived from tblAssociatedDetails). The subforms on the tabbed pages are all linked via a ClientID number.
In the form header I have put a a combo box and with the wizard said that I want it to select data from my form (in the case search via Surname). This works but only for the top part of the form (ie it will load the demographics) but will not load any of the data from the tabbed pages (subforms).
Any idea where the missing link could be?
View 1 Replies
View Related
Oct 11, 2005
Hey ladies and gents,
Just so you know, I am new at this. You probably guessed.
I am trying to learn how to make a specific type of form here and I feel like I am wading through an ocean of instuction books and help files, I was just hoping someone could point me in the right direction.
Just for a stupid example, lets say the form has three combo buttons when you open it; state, county, and city. If I want to make it so that when I select a specific state it changes the options available in the county box, and again when I select that box, what concept is this? I've heard of subforms and forms with multiple pages and I just want to know what I should be researching to find out how to do this.
Thanks for the help.
View 3 Replies
View Related
Apr 13, 2013
I have an access form with tab control pages each with embedded forms.In one page I have a list of records as a datasheet form with the record identifier field configured as a hyperlink. When I click on this it passes its value to a form field in the form in the following tab page (works without the hyperlink but its a useful way of highlighting which field to click) which is a display/edit form of the details of the individual record. The Subroutine which does this sets the focus on this field it is passing the value to on the other form and the 'On Got Focus' event in that triggers the query that fills the editor form.
When I click back on the following tab to select another record to view/edit, the identifier value of the other record is passed to the other form but the data displayed in the rest form doesn't change. I understand this is because the field with the 'On Got Focus' never lost focus and so the query function was not called. To correct this I tried adding the same function call to the 'On Change' event however this does not work (the field is a text box set to 'locked' if that is relevant).I can get the form to do a new query properly if I click on a different field in the form before going back to the list tab or (as this is removing the focus allowing the On Got Focus to work again) if I click on a button to select a different record (which just takes me back to the list form).
Is there any way I can get this to work without having to manually remove the focus from the problem field? I have tried setting its On Got Focus event to move the focus to another field after the query function call however this prevents the Setfocus line in the code in the previous form from working. Here is a snippet of my code below.This code is for the list form and passes a value to the editing form:
Private Sub SalesID_Click()
Forms!Mainform.Requery
Forms!Mainform!Sales_Admin_Form!Sales_Admin_SalesI D.Value = SalesID.Value
Forms!Mainform!Sales_Admin_Form.SetFocus
Forms!Mainform!Sales_Admin_Form!Sales_Admin_SalesI D.SetFocus
[code]....
View 1 Replies
View Related
Oct 11, 2005
I would like to change my Forms to Access Pages, Therefore they can be used like webpages. I converted them in access, however the command buttons dont work. Anyone have any ideas? Also I have been looking everywhere for any information on adding the ability to use a writing tablet with my access program. any ideas here? Thanks for your help :)
View 2 Replies
View Related
Oct 10, 2005
I've made an adp (access project ) file. I want to permit some users to look in the data but i'm not certain they have access installed, can i give them read-only rights by placing a data-access page in a network map? Can they use the functionality of a data-access page without having access installed?
View 1 Replies
View Related
May 13, 2005
Hello Experts..
I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.
'The wizard is unable to create your data access page'
When I click on Database and select Refresh, I get the other msg
"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..
I am very badly stuck here..Please help.
Thanks in advance...
Arun.
View 1 Replies
View Related
May 13, 2005
I am getting very frustrated(and surprised) to see there was no answers to my question regarding Data Access Pages yet. I searched the web and manuals and help in Access, but no luck yet...
Can anyone tell me if Data Access Pages really works? I just came to know about it while developing MS Access application...I just thot it will be cool to go web with less effort...
Thanks very much...
------------------------------------------------------------------------
Hello Experts..
I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.
'The wizard is unable to create your data access page'
When I click on Database and select Refresh, I get the other msg
"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..
I am very badly stuck here..Please help.
Thanks in advance...
Arun.
View 7 Replies
View Related
Aug 9, 2005
I'm setting up data access pages that will be accessed over the internet. Because of this I want to make sure that everything is secure. I am using IIS 5.0 (Windows XP) as the web server. I used the three-tier authentication approach discussed in the microsoft article here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp) So I'm pretty sure that the authentication is secure. But what about the communication between the browser and MSDE during databinding? Is that secure?
Wanting to make sure I set up a SSL certificate which secures the page and set the Remote Server in the connection settings in the data access pages to "https://domain.com". Does this secure the comminication between browser and the server?
Thanks in advance
View 1 Replies
View Related
Dec 6, 2005
If I build an access database that uses data access pages, are all users required to have a copy of the MS Access software, or does the database run strictly off of the browser?
View 1 Replies
View Related
Nov 19, 2007
Novice user here. I have created a database with tables,queries,forms and reports. I'm now trying to create a webpage that will run the reports i have created. At the moment i'm the only user that will run these reports (via webpage) so the database is on my computer.
I have created a data access page using a query but the records are displayed 1 by 1. I need it to display like my reports.
Sorry if you're confused. Thanks for any feedback.
View 1 Replies
View Related
Sep 9, 2006
I have generated a data access page from a table. I want this page to be used on the Internet where users can enter their data and the info is automatically sent to the access database.
But when I accessed the page in the browser, I can not edit the fields and do any inputs. Have I missed something?
tks
View 1 Replies
View Related
Sep 30, 2007
Hi,
When I create the Data Access Pages, I put the table values fields on the page, but it does not allow the user to edit the data. If I just create Textbox there, we can type it. So, Does the Data Access pages only view data? It doesn't allow the user to edit data. And also, I create a few button over there, and I want to create a few different function of each button, such as Update, Add, Delete. But, The properties of the buttons do not have the click event. Actually, I know that the forms can do it.
Actually, what is advantage of using Data Access Pages? I feel that Data Access Pages can give me a lot of help. It has many limits. It just created by HTML format, and save it external (I mean that it will not save inside the db file, but it just link the file to db file)
I thought it is just simple webpage, only view data, and search data. That's it. It doesn't allow us to edit data on Data Access Pages, create button.
View 1 Replies
View Related
Aug 3, 2005
Hello all
I have fell into Data Access Pages (yes, it hurt :p ), and have absolutely no knowledge of HTML or Javascript (though fairly competent with vb), so please bear with me!
When you are using normal forms in Access, you can launch a separate form from a command button, and bring up a record based on a value in a combo box - for example, Form A has a combobox1, and when cmdbutton1 is pressed it launches Form B and displays the appropriate record, using the criteria of combobox1.
My question is, is there a way to duplicate this functionality when using DAP?
Cheers for any insight..................
View 2 Replies
View Related
Feb 2, 2006
I have a table with three fields:
AutoID : AutoNumber
Name: Text
RecordID: Number "Long Integer"
I have created a form that aytomatically starts a new record and I have also
placed the following Code in the form's module:
Private Sub Form_Current()
' Comments: If this is the first entry then set the RequestID to 1,
' else find the maximum RequestID and add 1 to it.
If Not IsNull(DMax("[RequestID]", "tblMain")) Then
Me.RequestID = DMax("[RequestID]", "tblMain") + 1
Else
Me.RequestID = 1
End If
End Sub
I have saved the form as a Data Access page but the code doesn't work and
I couldn't find a code simialr to that which I can use in my html page?!
Maybe I can use ADO to open a recordset ans search for the maximum value
but I don't know the exact code and how to write the result back to the
recordID field in the html page?
Thank you.
View 2 Replies
View Related
Dec 26, 2006
Sir,
In MS Access there is a separate option to create "data access pages". Can we publish these pages on web.. Please help me
From
somashekhar
View 1 Replies
View Related
Jan 30, 2007
Hey there,
I have created a tabular style DAP using the page wizard before. I used to have the option, but now I only seem to have columnar style. Is there an option I have to select somewhere?
View 2 Replies
View Related
Dec 18, 2007
G'day,
Putting together some data access pages to display data from tables.
All is good except a property that I do not like, when there are multiple records in the returned recordset from the query to the page, I have grouped these by ID (for example).
Each time you move to next record the display contracts back to just the top level of display, that is with the the ID number displayed in a text box and a "+" to expand it out to see the details of the record under that group.
I would like have it always expanded to show the details of the records as I scroll though the ID numbers (the top level of grouping), rather than having to expand for each ID number to see the details.
Not sure that is clear, but any ideas..........
View 1 Replies
View Related
Oct 11, 2005
Hi all,
I am a new user to Data Access Pages, I have no idea what I am doing. I have been reading some things through this form and have not found anything really of any use. So I am asking myself if anyone can help me. I have a database all ready created and I would like to change that into Data Access Pages. I have file save as my Form to Data Access Page, however when I look at it in webpage view the command buttons dont work. I have no idea what is going on with the code. could anyone help me please, thanks in advance.
View 1 Replies
View Related
Jan 1, 2006
HI Sir....
I want TO Attach my ASP PAGES WITH ACCESS DATA BASE THROUGH DSN...WHAT WILL BE MY CONNECTION STRING IN ASP PAGE???
RIGHT NOW..I HAVE MENTION DATA SOURCE NAME IN MY ASP PAGE...AND MY CONNCTION STRING IS.....
conn.connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Mydb.mdb"
..........
Now..i want to connect through dsn...plz tell me what altration i have to do in my Connection string..and secondly what will be the location of my Access Data Base
waiting for ur Quick Reply
Thx
View 2 Replies
View Related
Mar 18, 2007
I have a database that I want to share with everyone on the company intranet.
Many people upgraded to IE7 (because they have auto update on). I can access
the DAP on every computer using IE6 without a problem. However, on every
computer that has IE7, upon attempting to open a DAP, IE7 crashes. Only one
computer with IE7 has no problems opening it.
I am not a hard core tech geek, but can muddle my way through. Can someone
please help me? Is there any settings in IE7 that needs to be changed etc? I tried running IE7 with add-ons disabled. Then the DAP loads but the fields have no links to any data and I get a message saying, OWC is needed (which is predictable as I have the add-ons disabled). I compared the add-ons running on two different machines running IE7 (where the DAP loads on one machine and causes IE7 to crash on the other), however could not see any difference. I would appreciate any input.
View 1 Replies
View Related
Jul 24, 2007
Is there a way in data access pages to have where the user tabs to a numeric field in an existing record, that it highlights the data? Or....... is there a way to have currency values null instead of $0.00 in an existing record on a data access page?
The problem I'm having is: For my data access page, the user queries to pull up an appointment. The user then enters various amounts in different fields. I have the tab order set up ok, but when they tab to a field to add an amount collected, it tabs to the end of the $0.00 which makes the user have to backspace 3 times to enter data, or highlight and delete and then enter data....... All of this, of course, is time consuming.
These values are null, but show as 0 in my data access pages.
How can I get these to remain blank, or how can I get it to highlight the data in each field on tab?
Thanks in advance.
View 1 Replies
View Related
Aug 11, 2005
Im creating a data access page overtop of a relational database. the database is simple... it has customers and workorders. there may be more than one workorder for a customer.
When I create a new customer record through my data access page, I want it to automaticly create a new workorder (filled with 0's)
Does anyone know how to do that?
Thanks
--Ben
PS: I understand SQL... I just need to know where to enter it (if necessary)
View 1 Replies
View Related
Jan 29, 2006
Hi,
I'm currently putting together a database for a medical NGO in Cambodia (http://www.medicorps.com/updates/cambodia.html) and am looking for some advice. The simple database is for logging client referral cases by Cambodian doctors to a team of international doctors. I haven't used access in 10 months and despite programming in access for 5 years progress is very slow. At the moment I'm designing the input and search forms. I was thinking that a more logical approach would be to convert the forms to access data pages and put the database online. I haven't used data access pages but from what i know their fairly limited?
The goal would be the ability to log/search the data with auto updated pull downlist based on the actual data. Ultimately I want the data compiled and emailed to a email list from withing the website. The trouble is I have no idea how to do it.
Thanks in advance for your help.
View 5 Replies
View Related
Mar 20, 2006
Hello
At our firm we have a mix of Microsoft Office (2000) Standard licenses and Microsoft Office(2000) Professional liceneses.
After reading through a lot of literature from Microsofts own site it is possible to create Data access pages to enable users to view and have basic inputting into an access back end database.It also states that you need a qualifying License to use microsofts 'web components' to be able to do this.
Now another of our offices has decided to 'check' with microsofts helpdesk about wether or not you need a seperate access license for each user and suprise suprise Microsoft state you do.
Their own site states that Office standard IS a qualifying license see here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp
but microsoft are saying otherwise....
Anyone know if i am commitiing an offense or am i just being bullied by microsoft.I have asked them to produce the legislation that states i am doing wrong but they have not yet responded
cheers
View 1 Replies
View Related
Oct 2, 2006
I am building a database for users to input escalations in. The users that are actually keying the information in, do not have MS office. When they try to access the DAP html file, a message appears at the top of the page that states "The page requires the Microsoft Office Web Components.
See the Microsoft Office Web site for more information."
Can data access pages be used without office being installed? I have heard that it could also be the users internet explorer security settings.
Any help would be greatly appreciated.
View 3 Replies
View Related