Design Theory...using Web Pages As Forms!
Jul 10, 2006
Here at work we have access 97. My idea is to present to my boss a new way to go about the database. I tell him we need a copy of access 2003 and I use the pages function in it to make html files for people to load on thier machine for the database. This should allow me to have the much needed user friendlyness of access 2003 and all its features without the whole company buying office 2003 for every computer (although they should...)
As far as this working...Whats your opinion about it? Would this way of running a database work well? I am not to bad at html so thats not an issue either.
If you know of any related threads, you can post the link also.
Thanks.
View Replies
ADVERTISEMENT
Oct 22, 2006
Hi,
New here and to access - but I am learning it for a poss new job, 2nd interview tomorrow.....
We already have access databases (currently 97 migrating to 2003 this week)
We also have a web based intranet.
Theory - Here goes
I would like to know if it is poss to embed Access forms in html into pages on our intranet and once completed these route directly inot the access database?
I work in a cust serv industry and we collect customer feedback via 3 or 4 diffent systems - some web based feeding in sql servers and then the data being extraced and also some from a different system. We also collect info from the telephony system.
I maybe a bit wet behind the ears in terms od reporting but I think we could be more efficient if we made better use of the technology -
Anyone any thoughts on this or a push to a helpfull post?
I will be back for loads more posts - later and thanks
View 2 Replies
View Related
Aug 2, 2006
I was hoping to get pointed in the direction of some relationship theory. I am new at this and was wondering when, where and how to implement relationships into a DB. I am sure this has a lot of good uses, but I am failing to understand it completely. Any and all help is appreciated.
thanks
Riley
View 2 Replies
View Related
Aug 2, 2006
As I continue my pursuit of MS access knowledge, I am moving to table relationships and would love if someone could point me to a good source to explain in detail when, where and why to use table relationships as well as how to implement this. Thank you much!
Riley
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
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 3 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
Jul 8, 2013
Is is possible to create a form that is 4 pages in length? After info is entered in first two pages I would like to print out all 4 pages to pass on to another person.
View 10 Replies
View Related
Aug 19, 2014
I have a form in datasheet view, and I am wondering if it's possible to specify "pages" with a set amount of records per page.Think like the search results of Google, you get a huge number of results, but only so many are displayed per page.
View 1 Replies
View Related
May 3, 2013
I have a form with a TAB control and four pages. Each control of each page has his TAB index set correctly (starting from 0 to n), some of controls are not enabled to be tabbed. The form's cycle is set on "Current page".
I have two kind of problems.
First: I am on the last control of the page, pressing TAB key the focus gets invisible. Press TAB key again and the focus moves on the first page's control. For each page happens this behaviour.
Second: clicking randomly on the TAB pages the focus is not always on the control with TAB index 0, but usually on the last.
I have read that clicking on a new page the focus should be automatically on the first control, but this does not happen in my experience.
View 9 Replies
View Related
Sep 25, 2013
I've built a PostgreSQL database for some ecology data and am trying to use MS Access 2010 to make a front-end for it.
I've created a form to display site data; it includes such fields as site ID, site name, county, state, landscape, etc. (There are more, but if I can get the idea down with a couple of these, I should be good to handle the rest). One can click through the form and see 14 pages of site details, which is fine because there are 14 sites.
What I want to do now is make a search form in which one can enter values for site ID, site name, county, etc, and somehow get the pages of the display form that match those values. It's not terribly important to me how that output looks - whether it's a list of matches that allows for clicking on a match and showing just one page of the display form, or whether it's a filtered subset of the display form pages that one still clicks through to view them all.
if there is code to write, where do I type it? Do I start my search form by making a form with the search fields as values, or is there some other way? How do I make those search fields into search boxes rather than display boxes?
View 14 Replies
View Related
Dec 9, 2013
I can no longer alter my forms in design view when I save them nothing happens i have to press no and then access shuts down. I have a feeling this is something to do with the VBA editor that i have been playing with, but don't understand VBA. It is not all forms. I have a split Database.
View 1 Replies
View Related
Oct 6, 2014
I have had to use my first crosstab queries.
I now understand that when opening and saving crosstab queries Access (2010) runs that query to ascertain the column names. Unless you hard-code them. Running the query takes at least 20 minutes.
I have hard-coded where I can, but one report takes arbitrary dates so I can't hard-code them.
I believe that turning off AutoCorrect might make a difference to whether the query runs - but I don't want to turn it off.
View 6 Replies
View Related
Apr 14, 2006
I have some tables that are set up as follows (these are not the actual names of the tables and fields, I'm using generic names so that I don't get a bunch of questions about the setup to begin with; I believe they are set up in the best possible way):
Table1 has a one to many relationship with Table2
Table1 has a one to many relationship with Table3
Table2 has a many to many relationship with Table3
Fields for Table1
Table1_ID
Field1Table1
Fields for Table2
Table2_ID
Table1_ID
Field1Table2
Fields for Table3
Table3_ID
Table1_ID
Field1Table3
Field2Table3
Field3Table3
Fields for Table4
Table2_ID
Table1_ID
Can anyone offer some advice on the best way to set up some forms for data entry with these tables? I think having Table1 be the recordsource for a parent form, having Table2 be the recordsource for one subform, and having Table3 be the recordsource of another subform would work for the one to many relationship between Table1 and Table2 and the one to many relationship between Table 1 and Table3. But I can't figure out how to then include the many to many relationship between Table2 and Table3.
View 7 Replies
View Related
Jun 29, 2015
I have several standard tables and all is well. However the final one I have came to do I'm a bit unsure about.
I have a "Jobs_Type" table as a way to clarify certain information about the "Jobs".
All this needs to be is a few combo boxes and check boxes I believe, neither of which I have used.
Ultimately I want the user to be entering data for that job on one form. Then select the type and enter any other information. Based on the "Jobs_Type" Information, the reports may be different also.
Am I thinking this is more difficult than it actually is? I was wondering if there's anything I should consider at the stage I'm at, or just continue until I get to form design.
- Some things I am unsure about:
*I would like to use sub menus, SO, the user picks a "PROJECT" then under that project they may select "BATCH 1" or batch 2..3.. whatever they wish.
*The choice in "PROJECT" Should determine the sub menu. Some jobs may not be split into batches at all, or it may have a totally new format of delivery. The system needs to be flexible.
*What is the primary key? All my other tables are using auto numbers, BUT here I'm confused.
View 14 Replies
View Related
Aug 14, 2005
Hi
I can do anything(design/edit/add new) to my table & queries but unable to redesign/edit my existing forms & reports, i wonder why?. My Database attributes is not "read only".
pls help.
thank a lot.
:rolleyes:
View 2 Replies
View Related
Aug 28, 2007
(Forms) How do I insert a Page below the Detail Bar?
View 3 Replies
View Related
Jan 9, 2015
I have a form which was locked down (ie Allow additions, allow edit and allow deletions were all set to no) on the Form property. I want to change this to allow edits so in design mode I changed the Allow Edits property to Yes.
I then went to Form view and was able to update fields on the form. When I exited the form it asked me if I wanted to save the changes so I clicked yes.
On going back into the form I can no longer update the fields I could before. Going into design mode I can see that Allow edits on the form property is set to no again.
What is happening here. There is nothing in the on load or other events to set this to no, besides this shouldn't change the form property should it?
I know I can get around it my setting the property in the form itself but why is the property getting reset in the first place.
Access 2010.
View 11 Replies
View Related
May 18, 2007
I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout
Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line
Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)
Thanks
Rahul
View 1 Replies
View Related
Jun 12, 2014
I have a small access 2010 system. The database design was not good (replication of data all over the place) so I have been tidying up the design but have hit a few problems.I am using a form which contains amongst other things a customer name. The customer name used to be part of the enquiry table, and was picked up directly from there. I have replaced this with the key to the customer table.The only way I have managed to pick the customer name up is to change the control from a text box to either a list box or a combo box. I then have to set column count to 2 set the widths to 0 and 3 to hide the 1st one (the ID) and then set the bound column to 2 to show the customer description.
This is fine up to a point BUT the format controls on the list/combo are different from the text box so I can't replicate the back style and back colour (I had transparent and no colour respectively); the back style has disappeared and how to make the back color as "no colour".Also I end up with 2 little up and down arrows (for the list box) or ma bigger arrow for the combo.
View 1 Replies
View Related
Dec 11, 2013
I developed a database for a group and i want to be able to prevent anyone from mucking things up.
View 4 Replies
View Related
Jul 19, 2013
I created a form through the form wizard in access 2007 and based it off fields in a table. the form is done but if I want to move the controls in the design view... I dont have the ability to move just one. I can either move all of them or none of them. Is there a way to change that?
View 3 Replies
View Related
Apr 4, 2014
Is possible to export design ppt to a access form?
View 1 Replies
View Related
Aug 14, 2015
I wish to request if it is possible to design an inventory where multiple shops or branches can be accessed from the same place.
or
multiple shops can use the same program with a centralized database, such that every user can only access his or her report from anywhere they login from.
View 1 Replies
View Related
Oct 1, 2013
I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.
View 1 Replies
View Related
Mar 28, 2014
How to design a form for a table based all records to design in a single form without top to bottom list wise and without scroll bars. Need to form design for all record details are will show on a form as side by side only as horizontal list wise.
For Ex. I have attached the screen shot image as per horizontal wise records continues.
View 4 Replies
View Related
