I would like to create a form with a double layered tab format that has the look and feel of the MS Access Options form under Tools.
What code or technique is required to make this work? For example, how do I make sure when the user selects the front row or back row of tabs that only this form is displayed.
I need to know how to set up a form with three tabs, all of which having the same text boxes or method of data input. I want each tab to write the information input into different rows on my table corresponding to the tab (the tabs will correspond the the first column on the table). I have three rows on my table for three companies. I want a form that has a method of gathering the data for each company and writing that data to the corresponding row. I can set up the form with three tabs, all requesting the same info, but I don't know how to connect them to the corresponding rows.
I'm trying to clean up a form a bit and have it only show certain subforms/graphs if the data exists. I already have columns in a combobox query to show an "X" for if certain data appears:
Now, I know I could build another query and have some system go through and identify these things, but the easiest thing would be to reference the "X" in the columns of the combobox. Is there an easy way to reference values in the other (non-primary) columns? Or can you think of an easy way to make these subforms only be visible when the data exists? Maybe have an on load event for the subform?
Not sure if what I want to do is possible, or at least possible the way things are set up.
I have a massive table - c. 6 million rows. It contains data along these lines:
Plan#, Item, Price, Description, Colour, Value, Location, etc.
The primary key would be Plan# + Item. Each Plan# has approximately 1,000 Items, and there is only 1 Item per Plan#. There are only a limited number of Items (c. 1500) and all or only some Items might be assigned to the Plan#. All items under each unique ID# belong together, sort of in a set. So this huge table has approx. 6,000 unique sets (based on Plan#).
To add to the confusion, Item A under Plan#1 may have different information (Price, Description, Colour, etc.) from Item A under Plan#2. I know this isn't a great way to set up data but this is what I have to work with.
Over the years it's possible that the exact same combination of Items with identical values might have been set up for multiple Plan#s. What I need to do is find any Plan#s which have the exact same combination of Item, Price, Description, etc. So if Plan#R has 200 rows and Plan#S has 201 rows, it automatically doesn't match. If Plan#R has 200 rows and so does Plan#T, all information in each record must match between the two Plan#s (with the exception obviously of Plan#).
I don't think this is possible, and if it is I am sure it's not going to be easy. So far the best I can do is to come up with finding duplicates on Item, Price, Description, etc. but that's only one record at a time and doesn't tell me if the two Plan#s match.
Any help or suggestions would be much appreciated.
hi iam new to this forum this is my first post , i'am trying to design a student database and i have designed it just want to know how to add different tabs to the view and how to add button/pull down menus to that certain tab when i try to add buttons the go ontop every tab and i can't figure out how to rectefy this any help is app , if you dont know what i'am on about let me know and i will email the database to you and you can see what i mean , thanks ccbup4it
Hi - Could anyone please help me. I have got a form on which I am using tabs. For some reason, when that form is opened, it is not showing the full number of records from the table. It is only opening in Add mode. If I then start to enter multiple records the navigation buttons at the bottom of the screen will show me how many records I have entered and you can use the navigation buttons to switch between them, however, if I think close the form and re-open it, it goes back to showing no records.
I have tried opening it in Add mode and in Show All mode, but neither is working.
The Cycle property is showing "all records" and the data is definately being stored in teh Source table.
Hi - Could anyone please help me. I have got a form on which I am using tabs. For some reason, when that form is opened, it is not showing the full number of records from the table. It is only opening in Add mode. If I then start to enter multiple records the navigation buttons at the bottom of the screen will show me how many records I have entered and you can use the navigation buttons to switch between them, however, if I think close the form and re-open it, it goes back to showing no records.
I have tried opening it in Add mode and in Show All mode, but neither is working.
The Cycle property is showing "all records" and the data is definately being stored in teh Source table.
Is there a way to make it so when you open a database the forms, tables, etc do not appear in the taskbar and just appear in the bottem right of access.
So basically, like already but without the taskbar tabs.
Let me just start off by saying, I don't have any code to post as it is just an idea I have.
This is a Lease return project for work. We have an excel sheet that is broken up into tabs. Master List, Not Returned and then a tab for every month.
Here is what I would like to do. If someone checks the box that says the leased computer was not returned, can I grab a certain batch of fields to automatically populate another Tab in this Access 2003 Form?
The second part to this would be if a person unchecks "Not Returned" in the Not Returned Tab, can I get that record automatically removed from that list view?
Similar principle for the Monthly shipping by a certain date. If the user enters in a shipped Date by say March 1, is there any way to populate a another tab into a list view?
Thanks for any advice that you gentlemen and ladies can provide.
i have a database that stores contractors/owners & the 4 types of city permits we will be issuing. i have created a form w/the wizard which contains all the info that i need the users to enter, however all info will not always be necessary. i would like to create a main tab with general permit information for users to enter (this is always necessary), and then 4 other tabs for which specifics may be entered dependng on which permit we will be issuing (at least 1, but up to 4 of these will be necessary). I would like 5 tabs...1 for main info, and the other 4 for specifics. i tried doing this manually in design view but for some reason i am unable to enter any data. :confused: does anyone know of a quick way to separate the fields that already exist on the form created by the wizard onto separate tabs??? thanx in advance! :)
Why does my form go to the next record when I reach the end of my tab sequence. And who does one get rid of the controls in the tab list. I had controls on there at one time, but now I dont and the control names are still in the list. But my biggest problem is why its going to the next record!
Here's (http://www.lebans.com/tabcolors.htm) a dynamite site with an A97 dowload with code for "colored tabs" which I stumbled onto. I converted the A97 code to A2K and it ran.
Many of you will be able to put this to good use.:)
I have a tab controled form and when it opens in form view the tabs are to high to be seen on the page and you have to use the scroll bars to have access to them.
What in the world am I doing wrong. I cannot get this to open correctly and my form fits just fine on one screen in design view.
I have on one of my forms a tab control with 5 different tabs on it. Each of the tabs has a different set of fields but all from the same table. I was wondering if it is possible to hide a tab if none of the fields on it have any data in?
So for example tabs 2 and 3 have data on them but tabs 1, 4, and 5 dont. I would want to hide tabs 1, 4 and 5.
I have a long form that has a tab control at the bottom of it. You have to scroll down to get to the tab section. After I scroll down, when I click on one of the tabs the form jumps up. It doesn't jump up to the beginning of the form but somewhere near the beginning. I've checked everything that I could think of but nothing helps this situation.
I made a form with 2 tabs. I created controls on it and I saw that some controls belong to both of the tabs. How can I set the controls to belong only to one tab?
I've been sent a form which retrieves company information divided into 4 tabbed sections. Really need to print all this off but can't even print the tab which is showing - it only prints the part of the firm outside the tabbed area (company name and number)
Would be really grateful for an idiot's guide on how to do this! Reluctant to provide a link as it's confidential information.
I have a database with a couple of tables. All of which have a 1:1 relationship to another table, patient: - patient (id (auto_increment), name, address, etc) - nutrition (patient_id, some, stuff, etc) - sleep (patient_id, foo, bar)
The patient_id in nutrition and sleep is a primary key and corresponds with the id of a patient (my 1:1 relationships)
I have a couple of forms. One for each table actually. In this form the user should be able to add/modify a patient's data. These forms are not to be used by themselves.
I have another form(the main form), which has a tab-control element on it. There are 3 tabs on this and on these tabs the 3 different forms are displayed.
Now for the problem: - when I add a new record to the database using the main form, there is no problem when adding a new patient. Woohoo! When I switch to another tab, , however, the problems start: I can enter new information, but when I leave the tab I get an error: "Index or Primary key cannot contain a null value." Blech.
I want Access to realise that it should use the id that is given to the patient in the first tab, but it seems it cannot get it automatically. (I am not sure, but I think the problem didn't occur at first, so I think I may have done something which is causing this problem.)
Any help here is appreciated.
PS I was unable to find any posts on this forum that can help me with this. The closest I could find was: http://www.access-programmers.co.uk/forums/showthread.php?t=39933
I have a form that is growing with too many controls, so I want to make a tabbed form and select and drag controls onto their own tabs to make things more organized. BUT, as I do the copy and paste thing, it doesn't copy the command behind the buttons?
So far it looks like I'd have to recreate each control button directly on the tab pages themselves?
I have a survey DB with many forms, several of these have tabs. If for some reason there was a cutoff in the survey I save the form name and question name (which is always the first Ques on any form, or the tabctl value) into FormSE and QueS, respectively, so I can return directly to that spot later on. On the forms without tabs I use the following code to open the forms:
However, for those forms with tabs of course the form opens on the first page always. The tabctl0.value was saved into a variable called QueS, similar to the FormSE variable in the above code, which houses the form name.
How can I open the tabbed forms to the correct page (or tab)?
I have a small problem, I have designed a form, and when I pressed tab at the begining it work fine, but then when I started adding text fields and removing them, now when I press tab, it just goes everywhere , in other words the tab goes text field by text field that I have added in chronological order, is there a way to make it jump to the text field beside it.For example I have 3 text fields, StudentId, StudentName, Cource. when I pressed tab it went from StudentId to StudentName then to Cource. Then I desided to change StudentName into StudentFirstName and StudentLastName. When I did that the form starts at StudentId then jumps to cources when I press tab then jumps to StudentFirstName and StudentLastName, but it is not their order. Since their order is StudentId, StudentFirstName , StudentLastName , Cource.
I have a form with two tabs... Its record source is Person and Account. The main tab has a load of fields relating to the person and the other tab is meant to show the bank accounts that the person has in a subform. However if there is no bank account for the person then nothing will show in either the subform or on the person tab.
I have checked throughly to see if there is anything saying SELECT Person.*, Account.* WHERE PersonName = etc which would only get the account and person details if personname was there.
The form is accessed by means of a search form which opens the form like so. DoCmd.openForm "PersonAccount", , , "[PersonName] = '" & personName.Value & "'"
So any ideas why nothing at all shows not even the Person details?