I got a form name "X-Zone Cyber Cafe by ITE College East"
Inside that form, i got a subform called "PCStatus"
In the main form, i got a image called 'pc01'. I wan to do it something like, when i click the image(pc01), the record of 'pc01' from the PCStatus table will be displayed in the subform.
And when i click on image(pc02), the record of 'pc02' will be display in subform
I have a form that displays a specific set of data depending what you select in a group of list boxes before. See image below:
13516
You select a PIPELINE, a YEAR and then a HAZARD, and this brings up a series of risk assessments depending on what you've selected. The RISK ASSESSMENT is actually a subform thats been set up to look like a list box. (Side Note: The reason I have done this rather than just use a normal list box for the risk assessment is I wanted to have a combo box attached to each record in the list box. Access does not allow you to do that so I had to fudge it). The RISK ASSESSMENT subform is populated by a query. At the bottom of the form is a normal list box displaying the same information thats in the RISK ASSESSMENT - I have done this as a test to ensure that my fudged subform is doing it's job.
From the fist screen capture you can see that the combination of PIPELINE, YEAR and HAZARD produces 3 risk assessments - this is also confirmed in my test list box. Everything is ok so far.
The problem I have is that I can only get my subform to display the data when the PIPELINE selected in the first screen capture is selected. Any other pipeline selection does not display the data in RISK ASSESSMENT. However, I know the data is there as my test list box displays the data. See image below:
13517
Therefore, my question is, why would data be displayed in the subform for some selections but not others, even though the data is there?
I am using Access 2007..I have created a main form and have inserted a subform. When I open the main form, the subform displays correctly. However, when I go to create a Report from the main form, the subform information is not displaying.
This is not a very big issue, but a very annoying one. I'm making a weekly display of tasks preformed (One subform for each day). The functionality is almost like a timesheet. You register the hours worked on spesific tasks/projects.
The problem I got now is that the textbox containing the date (In the subform) is not displayed when there is no records in the subform. The date is set by the motherform - Me.Form!frmday1.Form.VarDate = Me.day1
I have 2 tables setup with a 1 to many relationship, simialr to 1 Customer having 1 or more orders. I created a query to prompt for all orders for a particular customer. I then created a form based on this query - i.e. linked the query to a form.
Now when I open the form I am prompted for the customer id and when I enter this all of the results of the query are displayed in 1 form. However, this is not what I want. I would like the orders for the customer to be displayed within a subform on the actual form. In this way the customer details will static and I can cycle through the customer orders in the subform separately.
Is there any way I can setup my query to display the results in this way? I need the prompt for the customer ID. Or is there any way I can setup the form to display the results in the above way?
I have a subform, which contains only one text box, which works normally, until I set the startup options to hide the menu bars, database window etc...
Can anyone think of any reason why this should be!?
I have a subform that users enter in Dates of the month and how many people attending specific functions. I dont want the users to have enter in all the Dates for each month I just want them to enter in the number of people attended. How can I do that on my subform called TrainingTanfTrainig. the Table is called Training_tbl thats a child table of the SpecialEvents_tbl.
Hi, I'm just wondering if it's possible to display the result of a query on a subform which does not have a relationship with any other table.
What I'm doing is creating a search form where a query is built from the users input (through combo boxes and text boxes) of what table, attribute and condition they want to search from. When they press the search button, I want the result to be displayed in a datasheet below the selection criteria
The first thing I thought of using to display information with was a subform, but I think the purpose of having the subform is so that it can be linked with a form. So, is there another control or way of displaying results. The results can come from any table.
I have a main form which displays data regarding stock takes for a number of locations. The form is bound to a query which is based on a table containing a STOCKTAKE_ID field which is an autonumber field. The STOCKTAKE_ID is present on the main form
I then have a subform which is linked to the mainform via STOCKTAKE_ID.
When I open the form for a particular location the subform displays data, no problem. When I do the same for other locations the form is blank. If I check the table that the subform is based on, there is a record with correct STOCKTAKE_ID but for some reason the form won't display it. There are also no duplicates.
I have two unbound unlinked subforms residing on a 3rd unbound main form. When I enter the current record on Subform1 I would like the matching record(s) on Subform2 to be highlighted or otherwise formatted. I can get this to work for only the first record on subform2 due to the way I have my code setup on Subform1:
Code: Private Sub Accounting_Unit_Enter() 'find where AUs match. only works for first Subform2 record If Me.[Accounting Unit] = Forms!MainForm.[Subform2]!AccountingUnit Then msgbox "Match" End If End Sub
My thought was that I needed to reference the Recordset of Subform2 and search for all AccountingUnits that match the current AccountingUnit of Subform1,
Hello. The problem I am having is related to two tables. I have a table called Void and a table called Panel. A panel can have multiple voids and a void is assigned to only panel (one-to-many). In the Panel table, I set an autoincrementing number(SprayPanelId) for the pK. In the Void table, I set an autoincrementing number (VoidId) for the pk. I place the SprayPanelId into the Void table as a foreign key (same name in the void table). The problem I have is in my forms. I created a Panel form with a button to open a subform for data entry on the voids related to the panel in a new window. Data can be entered and is properly saved in the Void table. I open the Void table in a datasheet view under the table section and see it is properly there. I can run queries where Void.SprayPanelId = Panel.SprayPanelId and it returns the correct void with the correct Panel. The problem becomes when I open my void subform, it no longer displays that record associated with that panel. however, the record is there in my void table. Any thoughts? Do I need a filter perhaps, run any sql commands? Thanks in advance, Kevin
Basically, its a database for an entertainments agency, I've got a form for 'Artists' which shows the performers on the agencies books. I've tabbed the form so one screen shows the artist details and I want the second screen to show the bookings that the specific artist has.
I've linked to the 'bookings' table on the subform successfully, but I can't figure out how to filter it so it just shows the bookings that the specific artist showed has.
i.e.: I want it so that The Deltatones booking tab ONLY shows the deltatones bookings.
I have a problem. In form view, if you use the mouse wheel to scroll down, you switch to the next record. Is there a way I can disable this? Even if I switch the RecordSelectors and NavigationButtons properties in the Form Selector to "No", it still goes to the next record as soon as you scroll down with the mouse wheel. I want the Form to scroll down if you use the mouse wheel, not go to the next record as it does now.
Please help. I don't know what to do. Thank you in advance. kruger101
Err_DblClick_Click: MsgBox Err.Description Resume Exit_DblClick_Click End Sub
When I doubleclick on certain records on the subform it will open the form TRIP NV diplaying me the linked record, on other records it will open the form TRIP NV but a blank form with no records displayed! Why is this happening? Marco
Hi, I am a complete newbie to Access. I want to be able to double click on the field in the table, form or a query and have, as a result, another form pop-up with all the data from that record displayed. I have tried macros, but the doubleclick property only has things like goto first, last, etc. records. and always brings the first record in the table. Any hep in the right direction is greatly appreciated. Thanks.
I have a query which selects certain record. I then use a form to display these records in a tabular format. For each record I would like to dispaly a running total (accumulative). Example
If I have five record with field say Amount and values are 10,20,25,30 and 50
On the first line I would like the TOTAL =10 next line TOTAL=10+20=30 next line TOTAL=30+25=55 and so on.
Can anyone help with this? Your help will be appreciated
I am trying to create a table of help messages and display them help in a form. Using MSAccess.
Each Form used will have a help button, that runs a macro "mcrHelp.xxxxx". This macro should select the relevant record from the table to display in the "Help Form".
I have a form with some tabbed subforms. Master/Child links are set, everything is bound. When I open the form to display records (based on search criteria on the switchboard form), let's say it returns 6 records for someone, they are sorted by date and so the newest would display first.
But when it opens, the main form shows all the appropriate data, but the subforms don't show at all. Just a blank box where the subform control should be. If I click next record (and any thereafter) they all display correctly immediately. Now if I go to the 2nd record, then back to my 1st record, it displays correctly.
I'm guessing it must have something to do with the onLoad event of either the main form or subforms, but I don't have anything in there for OnLoad....no code at all.
I have a report, which opens a dynamic search form (built off of John Big Booty's code from this site). The form opens, and works as expected.During the dynamic search form testing, I created an 'OK' button that opens another form to display the record, but the dynamic search was opened first.
I would like to reprogram the button to display the selected record in the report which opened it.How can I get the selected record to display in the already open report?
I am attempting to display a tickmark (wingdings character 0252) . I have two columns with textbox controls. In each I display a -1 or Null, and the format is ; [Green] (corresponding to the 0252)
For each record, there can be a tickmark in one (and only one) of the columns, or no tickmark in any columns. The tickmark is set by clicking on the control. Unfortunately, the entire square occupied by the tickmark is selected, so it looks weird, so long as the cursor remains there. I want to get rid of that (it goes away by itself if I click on the other record).
I have tried to set the Txtbox.SelSTart=0 or Textbox.SelLength=0 , or change the value from -1 to 1 (that influences which position in the format is affected) ...but a postbox character keeps croppping up in theses instances.
While creating a report , I find that the number of fields are more for a single record, and cannot be accommodated in a single sheet of A4 size paper(Landscape). So what is to be done so that all the fields can be incorporated in the report for a single record on the same page? I don't mind if all the fields for the single record are displayed in two/three lines on the same page.
I have created a navigation form with quick access to the forms and reports I use most often. The Navigation Form (which I named Control Panel) automatically lands on the Tutor_Information Form on a current record. However, I would like for it to open to a blank form instead while retaining the ability to access the current records. Individually, when opening the Tutor_Information Form from the Navigation Panel, it opens to a blank record.
I used a 2 step macro
1. OpenForm 2. GoToRecord - New.
How can I make it do the same thing when landing on the Navigation Form (Control Panel)? I am using Access 2013.
I am having bit of confusion in trying to come up with a code that will assist in completing my database display (for a warehouse rental database).
My aim is to have a form display a layout of the site and overlay an image over a store if its occupied else leave the image off if otherwise.
I have everything in my table plus a checkbox field that states if vacancy is "yes' or "no"; say I have 60 stores to rent and they have specific names (unit = A09) and I already 'drew' the layout on a form (all 60 of them) with renaming the boxes for each unit (Name = A09).
How can I program a code that upon opening the form it will like
If 'Box Name on form' = 'unit name on table' AND 'Vacancy = No' then 'redbox.visible = yes'
