Listing Controls On Open Form
Apr 15, 2006Dear Friends
How do I list al the controls on an open form including mutiple subforms
Please advice
ADVERTISEMENT
Enable Tab Controls On Form Open
Apr 20, 2005I want to disable a tab control page when a form is open, and enable some of the fields if a check box is checked, and some others if another check box is enabled
Can anyone help.
Paul R
General :: List All Open Databases - Referring To Controls On A Form
Jul 17, 2013Any way to list all currently opened Access databases? It feels like this must be possible by referring to the databases collection, but I just don't know how.
Also, is it possible to refer to controls on a form in one open database from code in another database? (and obviously if so, how?)
Modules & VBA :: Main Form On Open Event To Show Tabbed Controls Only If There Is Data
Jul 24, 2013I have a report that tracks scores for our employees. From the report, you can click a button to add a new score in a form or edit an existing score(frmscoretracker). On this form there are two subforms, in a tabbed control to track additional information about the score; what areas were marked down(Trends), and was it a failing score(AutoFail).
When this form opens I have it programmed to only show the subform if there is data in it. The goal being, if I am adding a new score and there is no existing trends or Autofails for this new record, neither subforms will show - I will add an after update even to show either trends or autofail depending on the score recorded. Also, if someone chooses to edit the score, whatever subform with data, will show as well.
When someone clicks to add a new score, opening this main form to a new record, both of the tabs show. However, if the form opens to an existing record, the appropriate tab shows. Here is the code
Code:
Private Sub Form_Open(Cancel As Integer)
'If the subform has a record, the tab is visible, if not, the tab is not visible
If Me.frmtrends.Form.Recordset.RecordCount > 0 Or IsNull(Me.Trends) Then
Me.Trends.Visible = True
Me.TabCtl33.Visible = True
Else
Me.Trends.Visible = False
End If
[code]...
Both tabs are set as not visible in the default settings. Is there something in this code that is triggering then to be visible when there is no record in the main form?
General :: How To Make Form Controls Change Size / Position As Form Is Resized
Jul 24, 2013how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
View 4 Replies View RelatedModules & VBA :: Adding Controls To Form And Saving Modified Form
Dec 3, 2013I am trying to open a form in design mode and add controls, this i have done. I am doing this all in a class, and am having trouble saving the modified form.
I have tried using the following, both produce errors
Code:
DoCmd.Save acForm, "tmpQueryDes"
DoCmd.Close acForm, "tmpQueryDes", acSaveYes
Query Listing
Jan 11, 2006Hello All,
I am have some difficulies in the following query:
The result i need is Summary5 ResultG/001, G/0015 (Room) and soo on
Field Names Are:
Room & Summary5
I realy am not sure as how to do this, if it help the reason why i need to do this is for a report that will show "Asbestos Found In Rooms ...."(Summary5:Asbestos Found In Rooms" "&[Room]) is what i tried but this does not show it right, any ideas.
Alastair
**************************** Resolved With Thanks to raskew (Bob) & Matt Greatorex*****************
Listing By Date
Dec 19, 2005Hello
I have a table with a list of lectures and the dates and times they are running. I then have a related table which lists the feedback marks and comments for each lecture. I want to enter them via a form and have set up a form with the the lectures and then a subform for entering the feedback. This all works fine. However I would like to be able to have the lectures listed by date order and wondered what the best way is to make this work so that the user can simply scroll through each lecture on the form and it automatically goes through the list by date.
I hope this is clear and thanks for any help.
Kay
Importing Directory Listing
Mar 13, 2007Hi,
Having recently correlated the impossible pile of photos that I have on CD, including a lot of re-naming etc... I have now managed to get them down onto DVD.
I there an easy way to import a directory listing into an access database other than inputing the lot by hand? I don't wan't to add thumbnails just the file name and the directory it's in. I can embelish other details later via ASP, just need the bulk of the work done easily.
I have some experience of database design but not huge amounts of programming, other than the ASP side of things so if anyone has a complex answer please go gently with me!!!
Al
IIF In Query Q - Listing All Entries
Jun 20, 2006Hello,
I currently have a DB that has a field in a table that records which shift (A, B, or C) that some data was collected on. I am trying to write a Query in order to filter the results so that either the data from shifts A,B, or C show up, or if "All Shifts" is selected, then all the data shows up. I have another table set up that records the shift selection from a form. I was trying to use an Iif statement but it does not seem to be working for the "All Shifts" option. Selecting "Shift A" or "Shift B" etc. works fine.
IIf([ShiftSelect]="All Shifts","Shift [ABC]",[ShiftSelect])
**[ShiftSelect] containts the users selection for which shift they want to view.
I have also tried this with a wildcard statement (Like "*") instead of "Shift [ABC]", to see if I could get any data to show but I still get nothing when "All Shifts" is selected!
Let me know if you can see the problem, or know another way to go about this query!
Listing Reports In A Listbox
Mar 15, 2006I have a Form named frmClearances that lists the name, age, Club Clearing From, Club Clearing To and the Date of Clearance... this is used for my local sporting Club.
I have created reports that separate names into "Clubs Clearing From" so that each Club is aware of who has gone. The Reports are named...
clrSportingClubName
I have searched this Forum and all over as well, including Tutorials and I cannot understand how I can make a list box that contains the names of the reports so that they can be selected individually when required for each Club.
I copied the SQL for each query and placed it in the RecordSource of each Club Report so that I did not have numerous queries.
I have even copied code from other list boxes to then changed a couple of things but that has been to no avail.
Could somebody please explain to me how I do this? Thank-you very much in advance for any assistance.
Report-Listing Names
Jun 22, 2005I have a report that i am trying to list in the header section, a listing of all the names for a particular field, if it is in my report. I will use these names to send the report to.
View 1 Replies View RelatedListing Words In Report
Feb 23, 2006So I am using 2003. On the report I have created I have this one entry that exists for all my records, it is a Name, and at the bottom of the report I am trying to create a summary that will list each of those names. I already have a count going, so I thought maybe I could tap that, but not every record has a name listed. I am farely inept at coding.
What I want is this:
(Institution 1) Accrediting Institution: ACICS
(Institution 2) Accrediting Institution: ACCST
(The part above is Done, what I need in Below)
(SUMMARY) Accrediting Institutions: ACICS, ACCST
Thanks
ComboBox Not Listing Values
Sep 23, 2011So I have a textbox on a form that contain values. I want to convert it to a ComboBox. Since a lot of these values are the same in a lot of records (for example, "Inventor"), I want the entered values to appear in the ComboBox dropdown so they can just be selected instead of typed in. I converted the textbox to a Combobox by right-clicking on the textbox => Change To => ComboBox. It changed successfully, but I want it to list the values in the dropdown, but it doesn't.
View 1 Replies View RelatedForm Controls
May 28, 2005Hi guys,
please give me some directions.
Recently I designed a form with several controls including both TextBox and Combox. Before I submit data by clicking the button, I use VBA to validate the values of those controls (textbox and combox). If the value is not valid, the system will eject a msgbox and automatically set the focus on that component. In order to tidy the code, I use a GoTo statement, which refers to a group of code to display the message due to the value of parameters
But it seems VBA doesn't recongize the control I set through the parameter.
The code as the following:
private function validation () as boolean
Dim ErrorMessage as string
Dim ErrorComponent as String
......
ErrorMessage="Please select the shop Name"
ErrorComponent="ShopName" // ShopNameis a combox
GoTo ExitFunction
.....
......
ErrorMessage="Please set the start date"
ErrorComponent="StartDate" // StartDate is a Textbox
GoTo ExitFunction
.....
ExitFunction:
msgResult = MsgBox(ErrorMessage, vbOKOnly, "Error Message")
Me(ErrorComponent).SetFocus
validation = False
Exit Function
=============
As I tested for seveal time, I'm sure there is something wrong with
"
msgResult = MsgBox(ErrorMessage, vbOKOnly, "Error Message")
Me(ErrorComponent).SetFocus
"
but how can I fix it?
Many Thanks
Form With Two Tab Controls
Aug 29, 2006I am new to Access and have not used VBA.
I have searched the forum on this, but I can't find an example of this problem.
I have a data entry form with a two-page tab control. One is for company info and the other for contact info. The recordsource is a query based on the two tables. Initially I had the page set up as a rather large form with a subform and decided to convert to the cleaner looking tab control (I used copy and paste to transfer the controls).
This form worked initially, but now I have changed some setting so that it doesn't work anymore: I can enter data properly on the first tab, but not on the second.
I have tried changing the various form properties but I must be missing something obvious. All my tab-less forms work the way I expect them to.
What I don't understand is why one tab works and not the other.
Listing Data Rows As Coulmns
Jun 27, 2005Hello all,
I have a crazy question. Is there a way to write a query that would display data rows with common ID's as if they were columns in a query? It's for visually representing row data as if they were one record in a list. Basically, I would like to take the following data...
fldID fldDetail fldValue
1 Shape Round
1 Color Blue
2 Shape Square
2 Color Red
And display it in a recordsource like each is one record:
ID Shape Color
1 Round Blue
2 Square Red
Is there a way to do this? HTMS.
Listing All Records Not Linked To Another Table
Apr 22, 2006Hi,
Relevant to this query are two tables, tblNames and tblLinks.
I've been trying, with a very limited understanding, to generate a list of every tblName.Name where tblName.NameID IS NOT in tblLinks.NameID.
Is this something I can do in the query design view or do I need to work with raw SQL?
Any tips appreciated:)
Combo Box With Listing Record In List Box
Sep 19, 2006Hi all,
Please refer to the pic 'figure1' to review my question. Thanks.
I need to use a combo box to select the employee name and show the following Ref No. by using the list box. is it possible to do that? If can make it, how bout i need to delete the selected record, any idea for that? Thank you.
Forms :: Combo Box And Listing All Information
Oct 7, 2013Our software was purchased with a volume license, so I want to make a combo box with all of our volume license purchases and when the person selects the volume license number all of the PCs that have software purchased with that volume license are displayed.Below is my code
Private Sub cboVolumeLicensing_AfterUpdate()
'Moves to Volume Licensing field and
'finds records where "Volume Licensing" matches whatever is selected in the combo box
DoCmd.ShowAllRecords
Me!cboVolumeLicensing.SetFocus
DoCmd.FindRecord Me!cboVolumeLicensing
'Set value of combo box equal to an empty string
End Sub
The Query is Volume License Query and it is composed of Main Table and Volume Licensing Table connected by serial number on the main table and volume license on the volume licensing table..The combo box is volumeLicensing .And the form I am trying to do this in is called Volume License Form
Queries :: Listing All Data From Table One And Two
Dec 16, 2013My aim is to chart the career history of many people in my DB and my intention is to achieve this with two "Main" tables with many smaller tables linked to it.
Table 1 will contain the generic data about the individual, employee number, name, DOB, etc etc (there are many more fields) and Table 2 would hold their career history. Where they have worked, when, etc.
When viewing Table 1, I see all data, including a sub table showing career history, which is great. What I would like to do however, is have a query that will return all data from table 1 and Table 2 that refer to the employee number.
Attempts that I have made thus far, mean I have to enter the employee number twice (I would prefer to enter this only once) and then it gives me many pages (in report view) each page has all data from table 1, and one entry from table 2.
I would like to see all data from table 1 and then all data from table two, listed.
Forms :: Listing DB Tables In A List Box
Sep 17, 2014I am after creating a list box that will display some of the tables within my database - there are between 10 and 15 tables and the names all follow the same pattern (They all start "tblD10").
View 1 Replies View RelatedCreating Form Controls In VBA
Dec 18, 2005Hi guys,
I would like to create text boxes using VBA code ....the reason is that I need a number of text boxes to be created that is equal to the number of rows that is generated by an SQL query.
Any suggestions?
Tnx!
Hide Controls On A Form
Feb 27, 2006How do you hide the canned record scrolling keys on the bottom of a Form? I have placed my own controls and do not need them to confuse the Operator, or cause problems.
View 1 Replies View RelatedTrouble With Controls In A Form
May 10, 2006I created lots of controls on my form, and now i cannot create anymore. I do not know what the problem is... I just get an error message that says:
"MS Office Access cannot create any more controls in your form/report. If you have deleted controls from this form/report in the past, try renaming the form/report and then add more controls to it"
I tried renaming the form already. it didnt work :confused:
I tried to create a new database (i copied all the tables, queries and forms into the new database). it didnt work.
I dont know what else to do... Please help
I would dearly appreciate any help. Thank you in advance :)
Form's Controls 'invisible'
Nov 8, 2006I have few forms that look fine when in Design view, but which appear as plain grey screens when opened in Form view. These were working perfectly (i.e. visible in both views) until about half an hour ago.
The only things I have changed are some of the calculations behind certain fields.
Any thoughts?