I have a main form where the form record property is set to
Allow Deletions: No
I then have a subform, but I do not want it to inherit the permissions of the main form. Basically I can't delete on the subform either???
Hi, I have a DB that is basically a big electronic form. Each table is a section of the form and the main central table stores the ID's from the other tables. Most of the relationships are one to one but without referential integrity because sometimes sections need to be skipped.
It's been growing fairly rapidly lately as bit's keep getting added but now a weird deletion problem has started appearing. Every once in a while when a user goes to complete the form (right at the end) it suddenly dissapears. The records in the related "section" tables are still there but the main table storing all the ID's loses the record.
There are NO cascade update/delete's on any of the relationships, also no-error message appears it just goes. I think there is a problem in actually saving the record because I moved a DoCmd.RunCommand acSaveRec command from the complete button to a slightly earlier process and the point at which the record dissapeared also moved.
Does anyone know what may be causing it? It only happens to about 1 in 30 forms and there is no obvious link between the problem and
a) the machine it happens on
b) the person using it
c) the data entered into the form
If it happens the same user can input exactly the same data in exactly the same way and it saves it fine.
It really is random!
People are starting to get really frustrated. I was tring to "sell" the idea to a new department as well and had 15 people sitting in front of a projector when it happened to me. I was mortified :eek:
Any ideas would be greatly appreciated.
thanks,
Tom
Hello,
I have a general table question. I have a VB programmed user interface logging information to a MS Access Database Table. I want to automate it so when you open up the table to view what was logged -- any table entry older than 2 weeks is removed from the table. Will this be difficult? Any suggestions on how to start? Are there any access functions that will do something similar to this? Thanks in advance.
Zak
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 often move sub forms up and down within a form using something like.
Code:
forms!MyMainForm!MySubform.form.top = 500
However, I am having trouble moving a subform within a subform of a form.
Code:
Forms!MyMainForm!!MySubform!MySubformSubForm.form.top = 500
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:
DoCmd.BrowseTo acBrowseToForm, "frmSales","frmNavigation.NavigationSubform", , ,acFormReadOnly
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.
View 5 Replies View RelatedI tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.
Form 1
subform 1 > button to open pop up form
subform 2
subform 3
I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.
On pop up form close, what's the correct syntax for re-querying subform 1?
How to populate the parent form's PK to multiple records in a child subform set to a default view continuous form?
In other words, how to auto populate the primary key to multiple records displayed the subform?
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.
View 1 Replies View RelatedI 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.
Regards
Jama
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)
the follow is where the debug lands...
Private Sub Form_Load()
OrigHght = Forms!frmPicExample!picsubform![imgPicture].Height
OrigWdth = Forms!frmPicExample!picsubform![imgPicture].Width
End Sub
how do I add the primary form called depot_tracking?
Thank you again
roborro
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.
Hi
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.
Thanks in advance.
B
Is it possible to in a form have some buttons and depending on which button you push a different subform will be displayed?
For the moment I have buttons that opens entire forms that are almost the same but with different subforms. But it feels wrong to do it this way?
-jake
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.
hi,
i am after some help on setting up a form,
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.)
Hi,
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?
Thanks in advance.
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
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.
Justin
Hi,
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
Thank you for your help.
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.
Any ideas?
Hi there,
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 ?
Thanking you in advance
Regards
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.