Link Two Forms Together On One Field In Add Mode
Jan 17, 2006
Hello!
I Have a
project form
test form
sample form
for 1 project there are n tests and for 1 test there are n samples.
The project form is alone and has a button to open the related tests in the test form. The test form incorporates the sample form as a subform.
What works:
For entries already in the database when I click the related tests button on the project form it opens the test form filtered in the correct manner.
For the test form the sample form displays and increments correctly.
What doesn't work:
When I open the project form in add mode I fill in the data and when it is done I click the related tests button and the linked/child field isn't there! No data, I can't get it to work...
Can you suggest something?
PS I cannot find anywhere in the Data properties the Linked field properties... neither child nor parent?
View Replies
ADVERTISEMENT
Sep 22, 2014
I have several subform tabs and one that I have updated no longer shows up when I run the form on Form mode. The tab is there but no content or details of the subform
View 3 Replies
View Related
Oct 7, 2013
I have a form/subform that requires some fields from the Switchboard for its criteria. Last week due to no action on my part, it started asking for those values as Parameters instead (Forms!Data!txtInspDate), etc! The new form loads, but of course it is blank with no data. This happens if I load it from a command button or from the navigation sidebar... UNLESS I first load the switchboard in Design Mode, go to VBA window, then reload the Switchboard in Form Mode and press the button. From then on until I close the database, everything works fine!
View 9 Replies
View Related
Jul 20, 2015
I'm using Access 2007. I have a few problems:
1. I have a switchboard. I want to click a button, that opens a form with a dropdown list, when I make my selection, it opens a subform in add mode, but the linked field in the subform isn't empty, but filled with the mainform's field value that I selected?
OR
2. Is there a way for me to open a form in add mode, add data to it, click the add button (I will add an add button) that allows me to add again, but this time a particular field is not empty, but filled with selected info from previous selection?
Say for instance, I have 2 fields (both combo box fields), I click add, made selections for both fields, I click add again, but this time one of the fields stays constant like it's already been selected. It's filled with what was selected from before.
Either of those 2 - which ever is simpler.
View 4 Replies
View Related
May 10, 2013
Ok so the Data I have holds a hyperlink to a file this field is "basepath".In Form view I want to have a command button that reads the basepath (for that record) then opens said hyper link.
View 3 Replies
View Related
Aug 7, 2014
the forms are not opening in modal/dialog mode when they should be.The forms' pop-up and modal properties are set to "yes"..The code specifies to open Dialog so, for example:
Code:
DoCmd.OpenForm "frmCompanies", , , , , acDialog
Yet, the form opens behind the other form (which, incidentally, is also set to be pop up and modal in the form properties--is that the problem? If so, why wasn't this an issue until now?).
View 14 Replies
View Related
Jul 20, 2006
Hi.
Other than manually moving fields in a table in design mode, can I get the fields alphabetized?
Russ
View 2 Replies
View Related
Jan 9, 2015
I have a form which was locked down (ie Allow additions, allow edit and allow deletions were all set to no) on the Form property. I want to change this to allow edits so in design mode I changed the Allow Edits property to Yes.
I then went to Form view and was able to update fields on the form. When I exited the form it asked me if I wanted to save the changes so I clicked yes.
On going back into the form I can no longer update the fields I could before. Going into design mode I can see that Allow edits on the form property is set to no again.
What is happening here. There is nothing in the on load or other events to set this to no, besides this shouldn't change the form property should it?
I know I can get around it my setting the property in the form itself but why is the property getting reset in the first place.
Access 2010.
View 11 Replies
View Related
Sep 28, 2006
Before I go any further w/this current application, I want to make sure this will work.
I have an access database w/a few forms that will sit on a shared drive on a network. Each user will also have their own username and password because each user will have a certain level of access to what they are allowed to see. The problem I am facing is that if I put the users ID into the global variables module, and two users log on at the same time, then access seems to somehow use both of the IDs when running queries. This makes sense that all uses can see it, since it's Global... but I need a way for simultaneous users to have a persistant unique id so I can query data that's only meant for them. I found this example of code that might remedy the situation by passing variables between the forms.
Call the code below in frmOne to pass the variable.
DoCmd.OpenForm "frmTwo", acNormal, , , , acWindowNormal, "Count=2"
Call the code below in frmTwo to get the variable.
Dim i as Integer
i = CInt(GetTagFromArg(Me.OpenArgs, "Count" ))
Will I end up w/the same result? Will all users be able to see this variable as well?
View 6 Replies
View Related
Oct 10, 2014
I don't know, I have noticed that the SETVALUE argument is not openly available in the lookup tables when setting a macro. (But that aside) I have set my drives c: and d: as trusted, and also thicked the sub folder option.
View 7 Replies
View Related
May 7, 2014
I have a form which uses a listbox to display a given record but when a user without edit rights opens the form in read only mode
Code:
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormreadOnly
The user is unable to use the listbox to select a record to view.
I have also tried opening the form in edit mode (acFormedit) and then setting the allowedits etc. to False
Code:
Me.Form.AllowAdditions = False
Me.Form.AllowDeletions = False
Me.Form.AllowEdits = False
But this didn't work either.
View 3 Replies
View Related
Mar 7, 2013
I have a button using a macro to open a form in Hidden mode. Then I have another button on another form to open this form that was hidden.
When I open the form, the form is virtually blank apart from the form caption name. But when I close this and press the button again the form opens as normal.
I do not understand why?
I was told that once you hide the form and when you open the form again, it should appear normal. Why do I get this blank form??? Only by hitting the button again then the form is normal....
View 13 Replies
View Related
May 28, 2015
I am going into the Form Design mode
Click in the subform
I then set tab order by selecting the box and moving the field up.
Looks correct and then I click okay.
The subform does not change.
I go back into design mode, click in subform and select tab order and it looks correct????
View 2 Replies
View Related
Nov 12, 2013
I just finished a small Access-2013 database (accdb format).
Now I want to make it available to users.
How do I make an 'executable' (meaning that tables, forms, ... cannot be opened in design mode)?
View 9 Replies
View Related
Jun 4, 2013
I would like to take advantage of using combo boxes to search records on a form but do not want user to be able to edit or change any of the data. Setting the form to read only of course, disallows use of any controls on the form.
View 2 Replies
View Related
Feb 25, 2014
I have a form with a duplicate record button.Sometimes when duplicating a record the duplicate is created but the form remains in edit mode (small pencil in the form margin).I also have a manual record counter on the form which does not refresh to the newest record number following the duplication? Both issues happen together and not independently.
I now have the standard MS Access record counter visible on the form to see whats happening and this always jumps correctly to a new record number when duplication is triggered, so when the problem happens the MS Access counter is showing one more than my own record counter.
If I use the standard MS Access record navigation buttons and go back and then forward by one record, the duplicated record is then corrected. The edit mode pencil is gone and both record counters read the same, which I assume has happened this has forced a save to happen
If Me.Dirty
Then Me.Dirty = False
End If
- in the current event of the form, would solve the problem, but it doesnt make any difference at all, its still no better, or no worse than before?Using CTRL + S removes the pencil, but doesn't correct my bespoke record counter?
View 6 Replies
View Related
Apr 16, 2014
I have a single form which becomes either readonly or editable or addnew using a circular toggle switch. The toggle switch is activated by a command button and the caption of the command button is used as the display of the mode.
The SetAddModeBt is a separate command button that initiates the add mode. The problem is that various form or field properties when defined on the fly are not stored and they get lost when you open the form again. Look at the code below:
Code:
Sub tglEditBt_Click()
'-------------------------------------------------------------------------------
' Circular toggle button to change display mode of the form
' ReadOnly - Edit - Add
'-------------------------------------------------------------------------------
' On Error GoTo NotFound
Dim ForName As String
Dim strSQL As String
Dim FMode As String
[Code] ....
Here the first two cases fail when executing the last statement saying it is not supported.
View 5 Replies
View Related
May 25, 2015
I would like to add a cross close command on the tab in tabbed documents mode. Is it possible to accomplish?
View 2 Replies
View Related
Feb 4, 2014
I have several comboboxes in my database from which users select values. However, in most cases, I do want to give them the option to add an item that does not appear while simultaneously updating the underlying table which stores those dropdown values. I have made use of the builtin "allow edit list items" feature of Access 2007 but the form always opens on the first record of the form on which they are to add the new item. Is there a way to specify that it should open in Data Entry view apart from using VBA?
View 4 Replies
View Related
May 13, 2013
I have a couple of fields in Access. To explain I will show here the fields I have and their datatype
ID: Autonummer
Amendment: Text
Basis info: Yes/No
Sex: Yes/No
Period: Yes/No
Salary:Yes/No
Shift:Yes/No
Now, in the amendment field, I've inserted a combo box, with 3 options in it. Let's say option A,B and C...The thing I want access to do, is, when option C is selected, I want fields Period, Salary and Shift to be automatically "Yes".But if option A or B is selected, the the user must choose what the other fields are going to be either Yes or No
View 8 Replies
View Related
Apr 12, 2008
I have a database which works as an information system for the upcomming olympics.
In tblAthletes is...
AthleteID (Primary Key)
FirstName
Surname
And Various other fields not needed in this problem
In tblResults is...
Gold
Silver
Bronze
Also other field in this table
What I am aiming for is to have Gold AND Silver AND Bronze all as foreign keys of the AthleteID field.
Is there a way to do this or can another way be suggested. I am working on the 2000 version of access.
View 5 Replies
View Related
Nov 28, 2005
hi
i have a form just like customer orders in Northwind
with 2 subforms
Subform1 is showing orders number and i want to add something on that
subform 2 is products that ordered !
i want to add something on subform1 that if i Dbl Click on orderID field
it will sho for example another Form "orders"
i'm trying this code but i can't do it
Private Sub OrderID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "orders"
stLinkCriteria = "[OrderID]=" & "'" & Me![OrderID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit Sub
End Sub
would u please help me
View 1 Replies
View Related
Aug 5, 2012
I have a form in which I have four yes/no boxes to indicate in which part of the process is the product.
What I want is that when the last box is checked, automatically the field that I have for Closing Date set the date.
Is this possible? and if it is, how and where can I do it?
View 3 Replies
View Related
May 1, 2013
I'm creating a database for guests at a snowmobile lodge. I would like to create a new Guest in tbGuests but then have the option to create a second new GuestID linked to the first GuestID by a SpouseID. I can't seem to think out how they should be linked. So far I've created a separate table holding the SpouseID as primary key, GuestID and SpouseGuestID. Both the original guest and spouse need their own GuestID's so that I can post charges to each Guest separately if necessary. Then the SpouseID needs to be stored in the tbGuests to reference which guests are linked.
View 5 Replies
View Related
Jul 23, 2014
Can I for instance while my db is open, open it in design mode from my form via code?
View 3 Replies
View Related
Jun 27, 2007
In my table I have Picture (OLE) and Link_String (Text)
On my Form I have the OLE field and the text field.
In the text field I would like to put in a reference to a file on my computer (example: P:PicturesTest.jpg) and the picture OLE field should then show the linked to picture.
Is there a way to code this?
Greetings,
ACF
View 2 Replies
View Related
