Forms :: Form Control Recalculate

Sep 17, 2013

I have two combo boxes on the same form and for some reason one recalculates and updates and the other one doesn't. The control source for each is as follows:

=DLookUp("[03_END_PREP].[END_PREP_DESC]","03_END_PREP","[PDS_PREP] = '" & [PREP_A_subform] & "'")

=DLookUp("[OPT_DESC]","10_OPTION","[PDS_OPT_NUM] = [PDS_OPT_subform]")

Is there any reason why one would recalculate automatically and the other wouldnt? By the way, I've coded the second one EXACTLY like the first one except the proper tables etc were added, and it just doesn't work for some reason....

View Replies


ADVERTISEMENT

Forms :: Recalculate Field On Main Form

Feb 17, 2014

I have a form with a subform. The main(parent) form is called Quotations and the subform is called QUOT_DET. On the subform I have two fields bound to a table. The fields are QTY and Price. On the main form I have a field called QUOT_TOTAL which basically is bound to the Quotations table. Through On Afterupdate on the subform I refresh this total on the main form. The problem I have is that I want this field (QUOT_TOTAL) of the parent form to immediately refresh/requery etc when a user changes the QTY on the subform. The QTY is the first column of the subform. The QUOT_TOTAL only refreshes when I reach the end of the row. I do not want that - I want it to refresh immediately after the user changes the value of the QTY field and the Price field.

View 3 Replies View Related

How Do I Recalculate An Invoice

Sep 25, 2005

Hi There
I Have an Invoice Form Invoice Head And Subform.

Calculation In Invoice_Subform Depend On A Field In Invoice Head. I Need A Code If That Field Changes A Code Will Be Triggred To Check Every Row In The Subform And Change Calculation According To The New Condition

Any Help Please

Thanks In Advance
wkalo

View 4 Replies View Related

Forms :: Default Property / Using A Control Of Main Form Without Using Names Of Forms?

Nov 8, 2013

In the default property of a subform control I want to use a control of the main form without using names of forms, but using me and parent.

I used in default property of cboVATDetail: =Me.Parent!cboVAT, but it is not accepted. My aim is to use cboVAT of parent as default in cboVATDetail of child.

View 3 Replies View Related

Forms :: Access Form With Tab Control Pages Each With Embedded Forms

Apr 13, 2013

I have an access form with tab control pages each with embedded forms.In one page I have a list of records as a datasheet form with the record identifier field configured as a hyperlink. When I click on this it passes its value to a form field in the form in the following tab page (works without the hyperlink but its a useful way of highlighting which field to click) which is a display/edit form of the details of the individual record. The Subroutine which does this sets the focus on this field it is passing the value to on the other form and the 'On Got Focus' event in that triggers the query that fills the editor form.

When I click back on the following tab to select another record to view/edit, the identifier value of the other record is passed to the other form but the data displayed in the rest form doesn't change. I understand this is because the field with the 'On Got Focus' never lost focus and so the query function was not called. To correct this I tried adding the same function call to the 'On Change' event however this does not work (the field is a text box set to 'locked' if that is relevant).I can get the form to do a new query properly if I click on a different field in the form before going back to the list tab or (as this is removing the focus allowing the On Got Focus to work again) if I click on a button to select a different record (which just takes me back to the list form).

Is there any way I can get this to work without having to manually remove the focus from the problem field? I have tried setting its On Got Focus event to move the focus to another field after the query function call however this prevents the Setfocus line in the code in the previous form from working. Here is a snippet of my code below.This code is for the list form and passes a value to the editing form:

Private Sub SalesID_Click()
Forms!Mainform.Requery
Forms!Mainform!Sales_Admin_Form!Sales_Admin_SalesI D.Value = SalesID.Value
Forms!Mainform!Sales_Admin_Form.SetFocus
Forms!Mainform!Sales_Admin_Form!Sales_Admin_SalesI D.SetFocus

[code]....

View 1 Replies View Related

Forms :: One Table / Three Forms - Each Form With Control Tabs

Jul 4, 2013

I'm trying to make a very simple click through data entry screen in Access 2007. For each record I want to have a standard form with three buttons at the bottom. Each button opens a new form (each form has a set of tabbed pages on it as there is lots to enter).How do I make sure that each of the additional forms populate the same record as the main form.

View 1 Replies View Related

Forms :: Navigation Form - Using DB Forms Under Its Subform Control

Jun 19, 2013

I am attempting to create a Navigation Form to allow another computer in my network to be able to utilize necessary forms within a database (through RunTime). I was hoping this would be a clean task by simply loading the forms into the tabs of the Navigation Form, however that is clearly not the case.

For starters, When attempting to use a form that has some VBA behind it (Docmd.ApplyFilter based on a selection from a combo box), I am given the error stating: "The action or method is invalid because the form or report isn't bound to a table or query."

After searching on this error, I believe it's because my Navigation Form does not have a record source. If this is the case, then I am confused as to what record source it should have, as with the 3 forms I need to access through the Navigation Form all pull data between various tables and queries within the database (some not related).

Now I've also come to the conclusion that my VBA references now must change in order to correctly use my forms. A correct reference would look something like:[Forms]![Navigation Form]![NavigationSubform].[Form].[My Form's Control]..Is this necessary in order to write any events, such as an AfterUpdate on a combo box?

View 4 Replies View Related

Forms :: Setting Focus To Control On Single Form Side Of Split Form

Jun 24, 2013

When I right click a row on the data sheet side of a split form an select "New Record" I want the curser to go to the first field on the single record side. I've placed this in the OnCurrent but it did no good.

Code:

If Me.NewRecord Then
Me!Descrfiption.SetFocus.
End If

Any way to set the focus to the single form Side of a split form?

View 4 Replies View Related

Forms :: Tab Control Within A Form

May 21, 2015

I am trying to create a form where there will be information entered. The information being entered needs to be on two different pages, as they belong to two different tables. I would like to use the tab control. The problem I am having is that I want to be able to lock the second tab until all of the information on the first tab is correct and the employee entering the information verifies it. Is this possible and if so how?

View 5 Replies View Related

Forms :: Get Value Of A Control On A Form

Jul 25, 2013

I have a form that has many calculated fields(hidden and shown) based on the data in the source table. The calculated values roll up to a textbox(txtAward) that shows an award(Gold,Silver,Bronze) based on the total calculated points.

There is no inputting in the form. Its just used to display what was input and what the final award is.

txtAward isn't part of the source table but can be added.

How can I get the txtAward value into the table so I can do some reporting?

View 2 Replies View Related

Forms :: Filter List Box On Form By Using A Control On Form

Jan 14, 2015

On a form I have a:

control called "FilterListBox"
list box called "lstCustomer"
option Box called "optCustomerType"

When the user selects an option in the option box, "FilterListBox" is updated to either "1", "2" or "1 or 2"..One of the fields in the query for "lstCustomer" is "CustomerType" and its criteria is set as follows:

[Forms]![frmPrintHowCustomersPaidInvoice]![FilterListBox]

if "FilterListBox" = 1 the query for "lstCustomer" returns the correct records
if "FilterListBox" = 2 the query for "lstCustomer" returns the correct records

But if "FilterListBox" = 1 or 2, no records are returned.

View 9 Replies View Related

Forms :: Tab Control Form With About 5 Tabs

Nov 21, 2013

I have a tab control form with about 5 tabs. However when I move to the tab that has a datasheet form, the page moves down. You have to scroll up to see the above tabs. Is there something I'm missing on this simple tasks? Is it better to have it as a basic form for easier interface.

View 2 Replies View Related

Forms :: Spreadsheet Control In A Form

Aug 24, 2013

I want to have a spreadsheet type control in a form to be use for data entry and also to perform calculation. Is there a way to do that and save the data afterwards?

View 2 Replies View Related

Forms :: How To Control Display Of Fields In Form

Nov 20, 2013

How can I control the display of fields in a form? I see in a given database, that in the design view that some fields exist in a form but in the form-view some of them are not displayed.

I can't find how it was done, i see no difference in the fields' properties. Another question is how can i make a comboBox to display just the text without the ID number...

View 12 Replies View Related

Forms :: Populate Form Control With OpenArgs

Sep 19, 2014

I have this code in a button on my Patient Form:

Code:
DoCmd.OpenForm "frm_Admissions", acNormal, , , acFormAdd, , "NHS Number|" & Me.[NHS Number]

And this in my Admissions form LoadEvent:

Code:
Private Sub Form_Load()
'Use this version if the ID is a number
Dim x As Variant

[Code]....

The expression you entered refers to an object that is closed or doesn't exist

Borrowed code from: [URL]

View 5 Replies View Related

Forms :: Defining Colors On Form Control

Mar 30, 2014

I have to create a control on a form that will be able to change to one of ten colors, some of them are subtle shades. I will be doing this from vba on the control. I know how to do all of this except defining the colors.

I keep seeing the 3 part RGB(xx, xx, xx) etc. but I can't find the values for it that will give me the exact colors that I need!

I also saw a possibility of using a the hex equivalent for the color but I couldn't make that work?

View 2 Replies View Related

Forms :: Display Value Of Control Within Popup Form

Jul 25, 2013

I have a main form bound to a query. Within that form, I have a button which calls up another form (pop up form). I simply want value of the "claim#" field-control to display in the "claim#" field-control of the pop-up form.

View 4 Replies View Related

Forms :: SQL To Run After Data Is Entered Into Form Control

Aug 3, 2015

I have a form that the user enters employees daily duties. I have code to run sql after the BoxNum field has data in it. I want it to look at the BoxNum field and the dropdown box for the task to see if the entered box number has already been completed for the task selected on the form. Here is what my code looks like now. The code runs but gives me the msgbox no matter if it is a made up box number and I also get a syntax error 3075.

Code:

Private Sub Text13_BeforeUpdate(Cancel As Integer)
Dim rs As DAO.Recordset
Dim strSQL As String

[code]....

View 6 Replies View Related

Forms :: Dragging Existing Form Onto Tab Control

May 2, 2013

I have read where you can drag fields onto the tab pages to create a form or you can place a subform onto a tab page, but can you drag an existing form onto a tab page?

I have done it and it is working, but I just wanted to know if this is ok to do or would it lead to problems.

View 2 Replies View Related

Forms :: Examine Image Control On A Form Programmatically

Jan 3, 2015

I have an Image control on a form which I want to examine programatically. It seems there used to be a way of doing it using Point and PSet from info I have seen online. Is this contained in any of the libraries available under References in Access and if so which one...

View 7 Replies View Related

Forms :: Data Entry Form - Set Focus On Tab Control

Sep 10, 2014

On my data entry form I have a tab control with three pages

At the bottom of the first page I have a sub form with 3 fields

Currently, when tabbing, the focus runs through the fields as per the tab order

BUT

Once it gets to the subform (datasheet view) it jumps into the first field of the first record rather than the first 'empty cell' thereby starting a new record in the datasheet.

Once the three fields in the datasheet are completed the focus tabs back to the top of the first page of the form rather than onto the next page of the form

How to correctly reference controls using VBA so I could SetFocus where I want?

The Main form is called frm_Admissions

It has three pages called Patient, Treatment & Service Providers

Patient has a subform called sub_Cluster (which may or may not hold Cluster Information)

I would like the tab order to jump from the last textbox on the form into the first field of a new record in the datasheet (rather than the first field of any existing records)

Once it has finished in the datasheet I need to tab to the first field/textbox in the Treatment's page of the form rather than back to the first field/textbox in the Patient's page.

View 3 Replies View Related

Forms :: Displaying Control From Database To Form Automatically

Jun 24, 2013

I have created and saved a form in access automatically from database table. But when I change Display Control of a field from text box to combo box,it is not reflected in the form automatically after I refresh the form.

View 1 Replies View Related

Forms :: Requery A Control On A Form Pulled From Subform

Feb 6, 2014

how do you requery a control on a form pulled from subform? i've tried but it doesnt work

Private Sub Form_AfterUpdate()
[Forms]![Project_Details]![subform].[Form]![Text119].Requery
End Sub

View 6 Replies View Related

Forms :: Finding Previous Active Control On A Form

Mar 2, 2015

I have a form where the user clicks a button (button 1) to open a modal form, the user then enters data into this form and clicks close.

Then back in the first form I need to find which control had focus before (button 1) was clicked.

Screen.PreviousControl returns a control on the modal form.

I hope its easy like Forms!FirstForm.PreviousControl but I can't seem to find it!

View 2 Replies View Related

Forms :: CBO From Main Form To Reference Control On Subform

Mar 12, 2013

Ok, this is what I have:

I have setup my main form with 2 subforms to mimic a split form; this works fine.

To search for a record, I am using a cbo on the main form which I would like the user to select from. Once selected, then this will populate the first subform.

This is the code I have for the cbo:

Dim intAnswer As Integer
If IsNull(Me!cboCaseNoCFDWit) Then Exit Sub
With Me!sfFocus.Form.RecordsetClone
.FindFirst "Me!sfFocus.Form!CaseNumber = """ & Me!cboCaseNoCFDWit & """"
If Not .NoMatch Then
If Me.Dirty Then Me.Dirty = False

[Code] ....

I get an error at the .findfirst; states that the Microsoft Engine does not recogize Me!sfFocus.Form!CaseNumber

And the reason I am not using a regular split form is because I cannot, get the form to the size that I want. The splitform works great with the code above (a few changes to it of course), but the bottom of the splitform (datasheet) is too long and I cannot shorten it.

View 2 Replies View Related

Forms :: Filtering A Subform On Tab Control From A Separate Form

Sep 11, 2013

I am trying to filter a subform on a tab control based on an input on a second form.

Mainform: frm Index Page 2
Tab Control on Mainform: tabctrlMain
Subform: Customer Details
Tab Name: tabCustomerDetails

The second form is basically a separate Search Form where users can look for a customer ID and returns the ID back to Customer Details form.So far I have managed to redirect focus to the correct tab on the tab control using the following code:

DoCmd.OpenForm "frm Index Page 2"
With Forms("frm Index Page 2")
!tabctrlMain.Value = !tabCustomerDetails.PageIndex
End With

However, I am stuck with the filtering part. Everything was working fine before I began putting the forms together into one big tab control (I tried using Navigation Pane but there were too many referencing problems so I gave up on that one).

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved