Which Is Easiest To Control?
Jan 25, 2006Hello all,
in your oppinion which would you say was easiest to control through forms, more information per table, or
more tables with less information in each?
Thanks
ADVERTISEMENT
Easiest Way Do Do This??
May 16, 2007Hello folks-
I've tried to search for a solution to my problem, but I'm not sure how to phrase it to get a response. The problem:
I have a listbox that displays columns from a query. I would like to use the listbox to populate textboxes that relate to the same row (record). I’ve done it before, but the problem is that the query is run from a table that has no primary key. I’m not sure how to reference the correct record in the listbox without a key.
Is there a way to add a primary key to a query?
Cheers to anyone who can help. -Tom
Possibly The Easiest Question Ever Asked
Feb 1, 2008This is probably blindingly obvious but I'm unsure about it.
We'll refer to three tables, call them Table X, Table Y and Table Z.
Basically, I have a database with 10 tables. Table X links to Table Y via the Primary Key. Another field in Table X has a relationship with the Primary Key in Table Z (a foreign key).
Now, does the field in Table X that has a relationship with the primary key in Table Z need to be the primary key as well?
Put another way, does Table X need two primary keys?
Easiest Way To Filter Data In A Table?
Feb 5, 2008I am trying to filter information in a table like you can filter information in columns in Excel. For example, if I have a table with data in it like dates and times and I wanted to filter to find all records with the date of 2/5/2008, how could I do that easily? Can it be a drop down box like in Excel. I'm making a program for someone, and I don't want for them to be able to change anything in the program so I have disabled viewing of some toolbars, besides, the filter button in the toolbar never does what I want it to do.
Thanks!
Forms :: Invalid Control Property - Control Source
Sep 24, 2013I added a new field to one of my tables and query, but when I try to add a control for that field into my form it is not recognising it and the field isn't appearing in the sources for the form, even though the table is sourced to the form? Or am I going to have to do the usual and redo the entire form because I made a minor adjustment?
View 1 Replies View RelatedForms :: Web Browser Control Inside A Tab Control Display
Jun 18, 2014I have a form with a tab control, inside the tab control I placed an ActiveX control (Microsoft Web Browser). These are at the bottom of the form.
Everything displays fine if the entire form fit on the screen but if the form is too long and I scroll down the browser control is getting obscured by the tab control and getting chopped off (the contents are covered). It is as if the browser control is staying in space where it was and moving behind the tab control as I scroll.
This problem does not occur if I place the browser control directly on the form. Also I note that the browser control is sitting correctly within the tab control.
I have been through all the settings and properties of both controls and haven't been able to fix it. I searched all over the web but no one has previously stumbled across this one by the look of it.
See the attached image ...
New Field Does Not Show In Control Source For Form Control
May 28, 2015I have table that I had to add a new field to which we update with a form. I tried to add a control for the new field but the field does not show up in the list for the control source. I am trying to add a list box to the form with a blank and 5 options.
I have attached screen shots of the table design and the form. The table has the field in datasheet view and I have manually entered a few entries in it but it still will not show in the control source for the form control. The top section of the form is where we enter and select the data for the new records. The bottom section (circled in red) autofills the matching record, from separate tables, for updating with the new entries.
I have added form controls for modified fields in the past so I am confused about why this is happening.
Reference A Control On A Subform In A Tab Control!
Aug 3, 2006OK. I have searched and searched and every thread dances around similar situations but none seem to address this particular one. I am trying to make a control on a sub form visible/not visible depending on the condition of a control on a main form. The catch is that the control I'm trying to change the state of is on a subform located in a tab control. I've tried a thousand combinations and none seem to work. How do I reference the control on the subform in a tab control?
Main Form: frmMemberMain
Tab Control: TabCtl12
Tab Control Page: 2
Subform: frmChildren
Control on subform: txtRelationship
Can someone please help before my brain explodes!! Thanks! :eek:
Control Validation For 1st Control
May 17, 2006Hi,
I have reviewed the posts for 'Control Validation' and dowloaded the sample database kindly posted by ansentry.
In the PaymentAmount example, a name has to be entered in the first control before an amount is enterered in the second control. If the controls and tab order are reversed, the validation doesn't work.
I have a form where the 1st Control needs validating before moving on. The code below doesn't work.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Me.Employee_No) Then
MsgBox "Employee No Required", vbCritical, "Data required "
Cancel = True
Me.Employee_No.SetFocus
Exit Sub
End If
End Sub
Any help greatly appreciated.
John
Need Help With Tab Control
Aug 3, 2006Hi,
I have used a tab control to create some forms. However, I can't modify or delete any of the information. It's seems like the forms are just read-only.
How can I change it so that I can modify and delete info please?
Thanks in advance.
Tab Control
Dec 11, 2007Hi all,
I am creating a DB using tab controls, I have my information in each tab section. When I come to view in Form View and move my mouse around the tab page it shudders for some reason? anyone know why and how i can fix it?? Thanks:confused:
Tab Control On A Tab Control
Feb 8, 2005I would like to be able to add a tabbed control to one of the pages of a tab control. I have made several attempts and it hasn't worked. There is no reference to it in MS help. I have seen many databases with this facility (not necessarily MS Access). Can anybody offer a suggestion please.
Peter
Tab Control Help
Apr 9, 2005I usually use wizard for creating forms only now I need to have tabs for quite a few forms.
I've recently discovered that you cant simply put your labels and field on a page then select another tab and put other labels and fields on. I've tried looking frmSampl provided by microsoft put cannot figure out hows the single form with tab control on it works.
Can anyone direct me to online help with forms or provide any help with the tab control tool?
Tab To Next Control
Jun 20, 2005I want a Command Button on a form to move to the next Command Button. I basically want to do the same thing as the Tab button on my keyboard. However, I do not want to use the keyboard.
View 5 Replies View Related'03 Tab Control
Jul 15, 2005We have just been upgraded to '03 and while poking around noticed that the tab control changed a little. The main diff was the active tab is slightly easier to pick up because of the highlight line (See attachment). Does anyone know of any other changes in the newer version in the tab control or any other control?
View 6 Replies View RelatedTab Control Within Tab Control
Sep 12, 2005This seems like it would be easy enough, but I can't seem to find an answer. I'd like to put a tab control on one page of a main tab control. I've tried to select the page and create a new tab control and cut and paste existing tab control, but in both cases the tab control pastes into the detail section of the form (where my main tab control is) and thus appears on all pages. Anyone know what I need to do? Thanks for any help.
View 3 Replies View RelatedTab Control
Mar 3, 2006I have added tab controls to my already created form. My original page sits there alone, not on a tab control. How do I put it on a tab control without having to re do everything??? I tried to put it on a tab/page and it lost all the lable names and changed it to numbers.
View 4 Replies View RelatedBar A Control Box
Mar 22, 2006Dear All,
I'd like to bar (make unable to use ) a combo list on my form. The state of the combo list should depend on the true/false state of a checkbox.
I don't know whether it is possible in access.
I'd like to ask for your help.
Thanks in advance.
BR,
Sz.Cs.
Possible Tab Control(s) In Another Tab Control
Oct 21, 2006A simple question. I have tried to add Tab Control(s) in another tab control but those added tab control added in one particular tab control are shows on all tab controls in the same forms. Is it MS Acess limitation or I just don't get it done correctly?
View 3 Replies View RelatedFTP Control?
Jul 15, 2005i have a simple freeware ftp control i use on my machine at work. i need to distribute an app with ftp capabilities, though, and don't want to go to 50+ machines and put this .ocx on them all. my IT department may frown on that also. so....was wondering if anyone knew if there is any ftp support with microsoft .dll's or .ocx's. basically i need something i could reasonably expect any user to have readily available on their machines already.
thanks in advance for any help...
john
Tab Control
Sep 23, 2006If this issue had been addressed before, please direct me to the thread; otherwise please help.
I've created several TABS on a form. Each tab contains several drop down lists.
I've also put a field above the tabs for displaying the choices that I make on the various tabs, BUT I can't get the choices to display in the field above the tabs.
Can anyone help?
Add/change The Name Of A Control...
Apr 7, 2006Just wanted a little help please. I have about 100 option boxes on a form and I want to be able to change the names of the option box and its label. I want to name them from 1 to 100 sequentially. (i.e. option1, option2 ...).
When I create the controls it automatically names them option0, option2 etc. and label3, label5 etc.
I was going to change them via some code but I don’t know how to refer to a control in a form from design view.
Can anyone help please?
Thanks
Red
Tab Control Using Next Button
Apr 17, 2006I would like to use a Next button instead of having users click the tabs. Can this be done eaisly? Please help
Thanks
Control Users.
Jun 23, 2005When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit.
I would appreciate your comments and ideas regarding this part?
Thanks.
Control Arrays?
Jun 23, 2005I am not even totally sure that is what you call it. . but I have most of my experience in VB.NET and this VBA in Access 2002 is killin me. HA. . .
I am trying to dynamically create checkboxes (50 of them) in 10 rows and 5 columns. This is part of a "im bored" project and would like to be able to tackle the dynamic controls area.
I am thinking I want to keep the naming convention as "chkBox01. . .02. . .03" so that I can use the mid() function to determine its "value" and apply the value in the proper place.
I suppose the only thing I need is an example if anyone has one of a checkbox or any control for that matter being made by VBA and not placed on the form manually. 50 check boxes suck when trying to rename them all. sigh
Control Source
Jul 27, 2005Hi all, at the moment all of my field are control sourced. I heard there is a way whereby the field could be unbound and one button it the control source for them all. Im not entirely sure what this means or how to go about it. But i think it would solve the problem of if my users start entering data into a record and then decide to leave it, this record is automatically added to the table, with little or no data. As the data in the table is used for statistics, the table showing records which are not actually there is causing problems. Im not sure if i explained this well, but i would be grateful of any help. Thanx
View 1 Replies View Related