Hello everyone. I have a quick question. I am creating a staffing database for a nursing staffing agency. At present I have 3 tables: Enter/New nurses, Facilites, and Schedule a nurse. The schedule a nurse table is linked to Enter/new nurse by Nurse's name feild and to the facility feild by facility name feild. My primary index in each table is Nurse's Name (enter/new nurse) Facility (facility) and Nurse's Name (Shceudle a nurse).
I need to be able to enter schedules for each nurse. I created a form based on the schedule a nurse table using on feild Nurse's Name which is a pull down. I then created a subform based on the schedule a nurse table with all feilds excluding Nurse's Name. When I enter feilds in after I pull down the nurse's name it tells me the index is null and i can't enter any data.
I did this because I need to see (when I pull down a nurse's name) exactly each entry for that nurse under the schedule nurse's table. Can anyone tell me what I'm doing wrong or offer an suggestions as to what to do if this process can not be preformed. Thanks in advance.
I have a main form that has two subforms, subform1 and subform2, both connected to the main form. When I enter data into a field in subform1 I want subform2 to requery and update to show the calculated results from the new or changed data in subform1.
I found that if I do a refresh it works when changing the data but not when entering a new line of data in subform1. I tried some code in the after update field of on subform1, but cannot seem to get anything to work.
Me.[subform2].Form.Requery
Does not work. It errors and says it cannot recognize subform2 as a field. I have tried a field name on subform2 but I still got the same error.
I'm working on the Navigation Form template in Access 2010, which is new to me. It appears that one needs to use the BrowseTo command to open up a form in the built-in subform module. I'm trying to create a couple of buttons where each button opens a form in a different data mode; one in read-only and one in add mode. Here is the syntax I used for read-only:
frmSales is the Sales form I want both of the buttons to open and frmNavigation is the Navigation form. It seems to be ignoring the data mode part at the end however. It only will open in Edit mode. Is there something I'm doing wrong with this command?
Basically I need to design form that looks very similar to either Split Form or Subform. I have attached a print screen of what I roughly need. The form is split into two parts. In the first/top part there are some List Box/Date fields that act as filters to the bottom form, so the bottom form displays only records that match values in red. The second part of the top form has some field that require input from user and then these records are added to the bottom form. I was trying to use both Split Form and Subform and none of it is working,I have attached an example of database and this form would be based on data from Query1.
I have created a master form, which is a tab style. I have five additional forms that I want to use as sub-forms within each tab. I also want to include master navigation buttons that will work for each sub-form in unison. In other words if I navigate to record 10 on tab 1 and switch to tab 2, I want the new tab to show the information related to record 10. It would appear that I need to link them together in some fashion.
I currently have a couple of problems with an input form set-up.
I have a main form (frmWebSites). On this form I have a TabBar and one of the Tab pages holds a subform (frmSiteDetails). Within this subform I have a simple option group to select between 2 further subforms that are themselves subforms on frmSiteDetails (these are frmWebSites_pgeSiteDetails_Features and frmWebSites_pgeSiteDetails_Membership). I have coded the option group to make one sub-subform visible and the other invisible and vice versa depending on what option is selected.
This procedure I call from the Click event of the option group, both the Current and Load events of the frmSiteDetails.
The controls that exist on each of the sub-subforms are bound to the same table tblWebSites as the controls on the main form (frmWebSites).
The selection between the sub-subforms works perfectly well between the 2 forms when I am on an existing record and am just viewing the data.
1. The first problem arises if I want to change the data on one of the forms.
If I change a value in any of the check boxes or combo boxes etc and then try and select the other sub-subform I get the Error message 'The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record.'
I can OK this and select the option button again and the page changes as it should and the data has been updated.
2. The second problem arises with new records. If I try to enter a new record by entering details into controls on the main form everything is OK. I then try to enter further data on the currently visible sub-subform, but as soon as I then try and select the option to make this form invisible and the opposite sub-subform visible I get the following error.
'The field 'tblWebSites.SiteName' cannot contain a null value because the Required property for this field is set to true. Enter a value in this field.'
I don't understand why this is saying it is a null value as this is the first piece of data that is entered into the form. Furthermore I don't understand why it is looking at the value of this field at the time it does.
This locks me up. I can still enter data in the remaining fields of the currently visible sub-subform but not change to the other.
Any ideas where my problem lies??
Please be gentle with me, I am a complete new boy at this and this is my first Database.
I do not know if this is possible but I am trying to use a subform in a subform. Meaning I have a picture(picsubform) which is in a subfrom(frmPicExample) both of these are in a form(depot tracking). The goal of this little experiment is for every record of an item it will have the ability to add, delete, next, previous etc. to allow more then one picture to be linked to one record. My problem is that I am get the following error:
(Microsoft Office Access can't find the form 'FrmPicExample' referred to in a macro expression or Visual Basic Code)
I'm trying to open a form with a subform from a separate form. I've never had any issue before, but all of the sudden, the subform doesn't seem to open immediately. I get the error
Code: Method 'Form' of object '_SubForm' failed.
After that, it opens (subform and all), but some calculated text fields just say "#Name?#" The only thing I did today was add a command button to that subform.
When I try opening the form (or subform) from the navigation pane, I get
Code: The expression On Current you entered as the event property setting produced the following error:
A problem occurred while Contracts was communicating with the OLE server or ActiveX Control
When I step through the code, it doesn't reach the On Current event.
I'm working on a project that has two tables. "Calls" and "Customers". The Customers form has a subform, "Calls Subform" in it. When you click on the (New) Hyperlink a new form opens, "Call Details". I would like to pull information off of the "Customers" Form and insert it into the newly opened "Call Details" form.
Problem #1) Home Phone (named "Phone" and Text223 (named "CID"): are both bound controls so I have to do this in an OpenArgs type process.
Further details:
On "Customers" the following is true: "25" is the "ID" for that customer on the "customers" table "Home Phone" is the home phone number on the "Customers" table
On Call Details the following is true:
Home Phone is Bound to a table "Calls" and needs to pull it's data from Customers Form..Text223 is CID and bound to the table "Calls" and needs to pull it's data from "Customers" form.
I have used the wizard in Access to make a form and created a subform for it. I have noticed that the subform was pulled from a query; however, I think the form is pulled from the table directly.
I am not sure about the last point I mentioned above and wonder if any one knows if it's correct.
I have been asked at work to take a personnel database done in File Maker and convert it to Access. For the most part its not a difficult process except for the forms.
There is a main form with all of the relevant information (date hired etc.) but I require 3 subforms that contain personal information. These are labelled “Personal” home address, home phone, home email “Emergency” Emergency contacts in case of accident etc. and “Training” requests the individual has made for training and courses they have been sent on
In File Maker the subforms have tabs which you click to open or close. The “Personal” sub form (for example) opens with all of the relevant info while the main form still stays on the screen. You then click the tab again and it closes. They would like something similar to this in the Access form. Problem is, I don’t even know where to start looking.
Would some kind person point me in the right direction.
let's say you hold a car event every year. (car event 2004, car event 2005, car event 2006)
your entrants could come to each of these events. I have an entrant form and would like to add a event subform with a combobox that you can select each year that the entrant is there.
is this the best way to do it, and how would i go about it.
(i have included a pic of my current entrant's form with the event sub-form but it won't allow me to use a combo box.)
I have main form with subform. Is it possible to open form on specific record, like main form ID = 2, and then add records to subform? I keep getting error (Changes were not succesful... error 3022).
For example: I would like to open form Invoce and I want it to open on Invoce number "2". Record number "2" was entered before this opening. That also mean that I get data on subform that are connected with Invoce number "2". Now the question is: Is it possible to add a new line in subform?
on my form u find a record by inputing 1 of 3 product numbers. if a user inputs a product number for BRAND A how can a record on my subform automatical display BRAND A company name
Hi I have 2 forms both have a field called date, what I need is when I open a form in the sub form it will appear all the records wich have the same date of the opened main form, I don't have a clue about relating the forms, can you give me detailed instructions!! Thanx
I have a database that keeps track of schedules. A user will select a week and will have his/her schedule for the week. I am thinking of having a tab control and having 1 tab for every day of the week. I have created a subform which has time,location,city, person, etc. I have used a subform because on any given day there may be multiple entries of events.
If I were to do it this way I would have to have the same subform on each tab control and then try and add 1 to the date on everytab. I am unfamiliar with incremented recordsources so can someone steer me in the right direction?
Does anyone have any suggestions on if this would work? or suggestions on how I can do it differently?
My tables are as follows:
User PK UserID Username
Report PK Date PK Time PK User ID Location City blah blah
I created a form that has a dlookup statement in an after update event procedure that populates a field based on what is entered in another field. It works great until I dragged the form onto another form to create a subform. When I change the data (using the form/subform) in the field that executes the event procedure I get an error, running the same form by itself works perfectly.
Private Sub cboservicetype_Change() Forms!frm_Accounts!txtpayment = DLookup("[monthly_payment]", "[tbl_Support_Service_Types]", "[service_type]='" & Forms!frm_Accounts!cboservicetype & "'") End Sub
The error I get says: Microsoft can't find the form frm_Accounts referred to in an expression or visual basic code.
I have a form which is also build up with a subform. The form has four fields student_ID, Surname, Forename, and Numhus. The subform is build up of module and mark fields.
The problem is when I update any field on the subform (i.e., module or mark) the information is updated perfectly to the respective table, however, the Student_ID is added to the form table with empty fields in Surname, Forename, and Numhus. This in return creates a new record with Student_ID field only.
What I really want it to do is when I update the fields in the subform, it doesn't affect any other field in the main form.
N/B I have a time and date which is always updated when a field is updated in any of the subform and form. The Datemodified and Timemodified fields are in the main Form, as (hide column). This might be contributing but how to rectify it ?
I have a subform which makes a change to a field on the main form. When focus is returned to the main form, the BeforeUpdate and AfterUpdate events fire. Why? I thought from the form's perspective, the subform is just another control.
BTW, I get the same behavior if I modify the field from within the Exit event of the subform control.
In either case, the main form's Dirty event is NOT triggered.
I have a main form (stud_details) also I have a subform called (pay_det_sub).The subform is displayed on the main form. I want to create a relationship between the stud_details and pay_det_sub, with the aid of a field on the stud_details called numhus (which is the primary key).
So that when a student with a specific numhus value is displayed it brings about the payers details on the subform.
What's the best way of doing it??? Is it necessary to have numhus value stored also in the subform table to create a relationship....
Obviously "SupplierOrderCreateNewSubForm" is a sub forms on "SupplierOrderCreateNew".
There is a text box on "SuppierOrderCreateNew" called "supplierOrderNumber".
There is a text box on "SuppierOrderCreateNewSubForm" called "productNumber".
I then have a second form: "ProductSuppliers". I want to return a value from "ProductSuppliers" when a button is clicked on. When the button is clicked on, I want to put the value into "productNumber". However, I dont know how to refer to the text box.
I can put the value into "supplierOrderNumber" but not into "productNumber".
I'm having a bit of a problem figuring out how to do this...
I have a form (single form) and a subform (datasheet which is based on a query which includes the data elements [via outer join] in the single form). What I'm trying to do is have the data sheet form include (view only) all records from the query and have the single form display selected fields for edit/entry (will update a table that is the outer join in the query).
Example:
Table A has "Policy Number", "Line of Coverage", and "Insured ID". Table B has "Policy Number", "Insured ID", and "Insured Name".
Query 1: SELECT A."Policy Number", A."Line of Coverage", A."Insured ID", B."Insured Name" FROM "Table A" A, "Table B" B WHERE A."Policy Number" = B."Policy Number" (+) AND A."Insured ID" = B."Insured ID" (+)
(+) means outer join (sorry i'm used to using oracle).
So in the form I have a single form (FORM X) bound to Table B and a datasheet subform (FORM Y) bound to Query 1. I would like the user to be able to edit (or add if it doesn't exist) the "Insured Name" in FORM X based on the record currently selected in FORM Y.
Other things that may monkey with the process are the fact that even though Table B will have a unique key based on "Policy Number" and "Insured ID" Query 1 (and Table A) may have multiple "Line of Coverage" based on a single "Policy Number" and "Insured ID" combination.
Alternatively not relating the two forms, but simply populating the FORM X based on the record selected in FORM Y would be sufficient. Would this involve populating FORM X using the "on focus" function and how do I use vb to reference to a specific record in my subform?
Please let me know if I am not making any sense and thank you for your help.
