Toggling Linked Subform Shows Parameter Entry Window Twice?

Mar 9, 2014

I have two subforms in a main form. book_sub and book order subform. there are various subforms which i toggle in book order subform window by changing their properties with command button on main form. here is the code -

Code:
private sub billq_click()
Me.BOOK_SUB.SourceObject = "BILLQ"
Me.BOOK_SUB.LinkMasterFields = "[BOOK ORDER SUBFORM].FORM![ORDER ID]"
Me.BOOK_SUB.LinkChildFields = "[order ID]"
private sub stock_click()
Me.BOOK_SUB.SourceObject = "stock"
Me.BOOK_SUB.LinkMasterFields = "[BOOK ORDER SUBFORM].FORM![BOOKCD]"
Me.BOOK_SUB.LinkChildFields = "[BOOKCODE]"

Now the problem is when i change billq to stock it shows parameter entry window with caption [order id] twice. after clicking ok it does toggle the form to stock. then when i click button for billq again it shows the same thing.

the code works fine except showing parameter entry window twice with every toggle.

View Replies


ADVERTISEMENT

Database Window Shows After Printing Form

Feb 16, 2005

Hello team,

My database window is hidden.

I have a form with data about an article. When I click a button, another form opens showing a sales graph of that article.

On the form with the graph, I have put another button to print it. The code behind that button is:

Private Sub printpriceevolution_Click()
On Error GoTo Err_printpriceevolution_Click

Dim stDocName As String
Dim MyForm As Form

stDocName = "frm_priceevolution"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.Name, False

Exit_printpriceevolution_Click:
Exit Sub

Err_printpriceevolution_Click:
MsgBox Err.Description
Resume Exit_printpriceevolution_Click

End Sub

The funny thing is that after the printing (which works fine) my database window is shown, where it is supposed to be hidden.

Any idea what could trigger this? Does it have to do with pop-up dialog box settings?

Thanks

View 1 Replies View Related

Button Shows Verify Window Before Update?

May 17, 2006

I would like to have a button on my form that would update a record to a closed status, but I want to have an "Are You Sure?" window pop up first. I did a search on "verify," "verification," "sure," and several others but haven't found what I need. I looked through my Access bible, with no luck.

Any help is GREATLY appreciated. Thanks!

View 3 Replies View Related

Modules & VBA :: Way To Grab Text From The Window That Shows Location Of File

Jun 18, 2015

I want to find a way to grab the text from the window that shows the location of the file using vba in Access.

View 3 Replies View Related

Forms :: Totals Query That Shows Results In A Chart - No Parameter Selected

Dec 12, 2014

I have a totals query that shows results in a chart. It takes a parameter to limit results, by a combobox in a form.

Parameter in the query includes the OR "*" expression, in case someone wants to get the results unfiltered.

The Combobox in the form, has an AfteUpdate event that opens the chart (form) every time its value changes, by the [DoCmd.OpenForm "ChartForm" , acNormal] expression.

I don't know how to make it open the ChartForm when no parameter is selected in the combobox.

View 13 Replies View Related

Parameter Window Help

Sep 8, 2005

Is there a way to have unlimited parameter boxes to pop up when a query is ran?

Thanks

View 1 Replies View Related

Subform Shows Up SOMETIMES...what Is Up?

Jan 18, 2006

I have 2 cascading combo boxes which control what appears in my subform (AuditYear,Company).

Once I select both, sometimes the subform info shows up and a while later I try again, and it doesn't. Then I try some other AuditYear + Company, then THAT shows up...then I try again, it doesn't.

Any ideas?

View 2 Replies View Related

Subform Shows #DELETED

Jun 14, 2005

I have a textbox on a Subform which is updated when a record is double clicked in another Subform. This works fine until i move the mouse over the updated subform. Then the updated entry is replaced with #Deleted. The data is still in the table that gives the subform its value.
Also another form running has the same subform and it and the updated value is shown perfectly in this one.
Anyone know why this may be happening?

View 2 Replies View Related

Subform Shows A Number, Not Text...

Dec 8, 2006

It's my understanding of general database practice that an Autonumber field should be used as a primary key in normalisation tables. I realise my understanding could be wrong, and I'm quite happy to change that practice if need be.

I have my normalisation tables. For the most part these consist of an Autonumber field ([UID]) as the primary key, then an indexed, no duplicates text field with the normalisation data. For this case, we'll say it's a list of departments ([DepartmentID]).

I have a form for entering users. Again, the PK is an autonumber field. I used a wizard to create a combo box. I selected the fact that I want to store the value in [DepartmentID], NOT [UID].

This works fine, I can add my users and the combo boxes work, although I had to change the bound column to 2, as 1 is selected by default although it is [UID].

I then created a subform based on a query of all users. This subform is not bound to the main form in any way, it simply shows the result of the query.

When entering users, upon saving a record, the form is updated and the new user shown in the subform. Great, apart from "txtDepartment" in the subform showing [UID], and not [DepartmentID] as stipulated.

I have a horrible feeling this is to do with [UID] being my PK, but I'd like someone to tell me I'm wrong. I can quite happily remove the autonumber field [UID] and make the unique [DepartmentID] field the PK, but this just doesn't seem "correct" to me.

Should I do this? Should I have an autonumber field as the PK?

I realise this is more a design theory question than a form problem as such, but anything that clarifies my understanding of correct design practice will help.

EDIT:- I'd also like to say that I did it this way to get away from using the "LOOKUP" field type at table design time, specifically to avoid this very problem of numbers showing up when I want the text there!

View 3 Replies View Related

Forms :: Subform Only Shows First Match

Nov 30, 2013

It's been a while since I last used Access but now I need to be reminded how to populate a sub-form with all rows for a query (Access 2013).

- Do I need to establish a relationship between Table A (main form) and Table B (sub-form)?
- What sub-form properties need to be set to display all retrieived rows from the main form query (select where Table A PK = Table B PK)?

View 1 Replies View Related

Forms :: Subform Always Shows First Record Based On Date

Jul 14, 2013

So, let's say I have a table named FLOWER_SHIPPING that has field:

Date [Date]
Flower_name [Short Text]
Amount [Long Integer]
Sender [Short Text]
Address [Long Text]

Then I created a form named MAINF with FLOWER_SHIPPING as its RecordSource. The form only has one TextBox: Date.

Then in MAINF, I created a subform named SUBF with FLOWER_SHIPPING as its RecordSource, in Datasheet View. It shows all fields in FLoWER_SHIPPING as it is.

The link between MAINF and SUBF is Date.

I want SUBF to only show record based on the Date chosen in Date TextBox in MAINF. So far, yes it did what I want. But with problems:

1) [SOLVED] SUBF does show record based on the Date I've chosen in MAINF's TextBox Date, but it ALWAYS ALSO shows the first record on the FLOWER_SHIPPING table. And the date in the first record always changed into the Date I just input in the TextBox Date in the MAINF. Automatically.

Example: I chose 6/22/2013, and there are 2 records with that date. the SUBF will show 3 records: those 2 records + the first row of FLOWER_SHIPPING with its Date automatically set to 6/22/2013.

2) When I chose a date in MAINF, I have to click everywhere in the SUBF so that it will refresh its content. Can I have it refresh automatically everytime after a date chosen?

View 9 Replies View Related

Subform Shows Actual Record, No List Of 3 Last Added Records

Mar 13, 2006

Hi There,

I have got this form, consisting of 1 form (that needs to add a new record to a table everytime) and 1 subform, that needs to show the last three records of the table.

My problem is that I cannot get it right, now both forms (form and subform) are showing the details on just one record. If I open my subform it shows me all the records of a table, but in as soon as I view the form as a subform I shows me only one record.

Any help is welcome, I attached my db, just in case....

View 6 Replies View Related

Modules & VBA :: Subform Date Filter That Shows All Values If Left Blank

Mar 2, 2015

I am a bit of a novice when it comes to Access, but have managed to create a form with a subform embedded and various filters to show different data within the subform, including a date range filter. The code I have used for these filters is as follows:

Private Sub Command40_Click()
Dim strCriteria As String

strCriteria = createCriteria("[Introductions].Town", "List78")
strCriteria = strCriteria & " and " & createCriteria("[Introductions].Ownership", "List52")
strCriteria = strCriteria & " and " & createCriteria("[Introductions].Company", "List54")

[Code] ....

This all works fine, but I'm wondering what I need to add to this code to make it so that if the date boxes are left blank, records from all dates are displayed. At the moment I have to enter dates in order for it to work properly.

View 5 Replies View Related

Forms :: When Subform Have No Records Then Total Field On Main Form Shows Error

Sep 1, 2013

In my database main form with subform. subform have query as recordsource.total of one of field in subform shown on main form. all is ok and show total correctly but when subform have no records then total field on main form shows #error. How to convert this value either into null string or zero(0).

View 2 Replies View Related

Linked Forms And Parameter Transfer

Dec 4, 2006

Hello,

I have a form "article" with a button "place an order". Click on the button opens another form ("order") where I should fill the order for the current article.

The problem : how can I tell to "order" form that I want to order the article I was on in my "article" form, and not another one ?

Thanks

View 3 Replies View Related

Forms :: Filter Statement Asks For Parameter Entry

Aug 22, 2014

I have a bound form, in its heading I have a combo box which lists three choices. Basically I want to filter all my purchase records by checking a field PUOrderNb (Example: PO200100025) against the choice made in the combo box, namely DE (for demand), PO (for Purchase order) etc. On the after update event of the combo box, I have the following code:

Dim strfilter As String
strfilter = " left ([PuOrderNb],2) like " & cboFilter.Column(1)
Me.Filter = strfilter
Me.FilterOn = True

When I make a choice in the combo box, I get a window asking me to enter a parameter value and it lists the value of the combo box choice as a sort of a title just above the white input fame.When I type in PO for instance, the program does correctly filter all order numbers starting with PO, but the whole point of having a combo box is not to have to type anything.The other odd thing is, when I change the choice in the combo box, after my first choice, I do not get this parameter question but nothing happens as to filtering. The first choice remains active.

View 3 Replies View Related

Subform Blues - Data Entry Setting Itself To 'No' & Requerying 1 Subform From Another

Dec 5, 2006

2 Subform problems

I have a data entry subform that is only supposed to show an empty record ready to be populated, and a display records subform that is supposed to show all the records. The subforms are both on the same tab of a tab control on my main form.

Problem 1:
The data entry subform shows all the records rather than a blank record. Something on my main form is causing it to show the records when it should not. Any ideas? The Data Entry is set to Yes.

To try to isolate the problem, I created a new form and added the subform to it where it behaves properly:confused:

I then added Me.DataEntry = True to the form open to see if that would solve my problem but it still sets the data entry to no.

If I have the properties box open when in form view of my main form, I can set the data entry to Yes and it works fine until I move to the next record of the main form when it resets to no. Teraing my hair out here.:mad:

My final attempt was to search the entire project to see if there is a "DataEntry = False" somewhere but there isn't. What is setting this property? Any ideas where I should look?


Problem 2:

After entering data in the first subform (data entry form), I want to re-query the second subform but I just can't get the syntax right. I have wrestled with the "Syntax for subs" document downloaded from http://www.mvps.org/access/forms/frm0031.htm (Microsoft MVP site) but to no avail.

My main form is called fdlgPrjDetails, the data entry is via fsubPrjCommentsUsersDataEntry and the subform I wish to requery is fsubPrjCommentsUsers.

None of the attempts below worked giving a cannot find control error.


Private Sub Form_AfterUpdate()
On Error GoTo ErrHandler

Me.Requery

'Me!fsubPrjCommentsUsers.Requery
'Me!fsubPrjCommentsUsers.Form.RecordSource.Requery
'DoCmd.Requery ([fsubPrjCommentsUsers])
'DoCmd.Requery [fsubPrjCommentsUsers]

ExitHere:
Exit Sub

ErrHandler:
MsgBox Err.Number & " - " & Err.Description & Chr(13) _
& Chr(13) & "Error in fsubPrjCommentsUsersDataEntry: Err 003"
Resume ExitHere
End Sub


Any Ideas?

Both problems have me stumped so I'll be grateful to anybody with a scoobie on this.:)

View 10 Replies View Related

Passing A Parameter In A Query To Update Linked Table?

Oct 8, 2015

I have a linked table tblHome which is stored in a Sql Server DB and I want to create a form with 3 fields in it i.e. fieldA, fieldB, and FieldC in it and a button.

I want to add values to fields fieldA and fieldB and fieldC and when I click the button I want the value in fieldA to update any records in the linked table tblHome which contains the values in fields fieldB and FieldC.

how to do this?

View 5 Replies View Related

Forms :: Move Subform To Tab Window

Dec 21, 2014

I have a main form that has 2 sub forms on it - one below the other.

Because I did not like this layout I created a tabbed form on the bottom of the main form (2 tabs) and would now like to move each sub form onto each of the tabbed forms.

View 1 Replies View Related

Toggling Design Mode On / Off

Sep 1, 2015

I have an old db. I would like to see the forms and tables so I can select them and make changes. I know there is a way to access those items on startup but I have forgotten how. When I bring up the db I see a form and I can get into VB for that form but I cannot see any embedded table, forms reports, etc.

View 3 Replies View Related

Toggling Multiple Yes / No Fields In A Table?

Apr 30, 2013

I'm trying to use Access to create a simple list of the TV-Shows I'm watching, with each episode and a Yes/No field to cross out if I've seen the episode or not. It's taking up unnecessary time to cross of each field individually, but I can't seem to find a way to toggle several in one action, is this possible? It seems likely that it would be.

View 8 Replies View Related

Forms :: Subform Shows In Design Mode But Not In Form Mode?

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

Forms :: Toggling Visibility Of Picture For Each Row In Form Detail Section

May 31, 2013

" Is it possible to toggle the visibility of a picture on a form's detail section for each row based on a query whether a certain condition is met? "

I have a form, which fetches data from a database and populates the content as a number of rows in the detail section.

For each row I want to test if a certain 'yes/no' condition is met on each query and the toggle the visibility on a picture that I have placed in the detail section.

I've tried seveal possible solutions now, like macros and VBA but haven't got it working.

Btw I'm using Access 2010

View 4 Replies View Related

Forms :: Toggling Combo Box Language (value List) Using A Command Button

Dec 21, 2014

Now I have "tbl_organs" with three columns "organNameLatin" and "organNameArabic" as body organs names in latin and its arabic translation,and "bodySystem" which contains body sestems "digestive, respiratory..." in Latin only, and "frm_visit" as a form for recording visit data, I added unbound combo box "cbo_organ" with raw source "tbl_organs", I addedd two command buttons "cmd_En" and "cmd_Ar" to convert the combo box value from english to arabic, I mean cmd_En for showing combo box with two columns "organNameLatin" and "bodySystem",for cmd_Ar will show "bodySystem" and "organNameArabic" , the value of "cbo_organ" then used with another field for populating a txt box, i used this code for onClick event for "cmd_En" :

Me. cbo_Organ = "select distinct bodySystem, organLatinName" & _
"from tbl_organs " & _
" order by bodySystem;"

And for cmd_Ar :

Me. cbo_Organ = "select distinct bodySystem, organArabicName" & _
"from tbl_organs " & _
" order by bodySystem;"

By pressing cmd_En nothing changes and combo box still showing three columns, also the final result is populating bodySystem in final txt box instead of organ name, I dont know if properties of combo box "cbo_organs" like column count and row source have effect on this or not, and if I should determine row source of combo box from the beginning or not ? NB: bodySystem is in one language only which is Latin, the form is unbound, combo and final txt box are unbound.

View 6 Replies View Related

Help: Pass Argument From Child Window To Parent Window?

Feb 15, 2005

Hi,

I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.

How does one pass argument back from child window to parent window?

From parent window to child window, I used
docmd.openform ,,,,,,[argument] and me.openargs in the child window

thanks in advance.

View 4 Replies View Related

Subform Data Entry

Apr 27, 2006

Hello all,

I'm looking for a little help on something that I'm sure is an easy problem. I'm building a form for patients (data from Table: Patients) that contains a subform containing lab values (Table: Lab Values). I'm new at using subforms so I'm in a little over my head.

Both Tables contain the patients name to link them together. When I create the subform, I don't want it to display the patient name, because it is already displayed in the header. But if I don't include that field, I can't link the two tables together. I'm using one of Microsoft's templates off their website (called Contact Manager Database) as a guide, and it has exactly what I want - a sub form that only displays the relevant data for each patient, but when you add a record the data in the table automatically includes the name of the person.

I just can't seem to figure out how to do this. I'm sure I've been very unclear describing this, and I'm sure this is an easy task, but if someone can give me a little direction I would greatly appreciate it.

Cavy

View 3 Replies View Related







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