Stack Overflow
Stack Overflow

Questions tagged [openargs]

21 questions
12
votes
7 answers

OpenArgs is Null issue

I am using the OpenArgs parameter to send a value when using DoCmd.OpenForm: DoCmd.OpenForm "frmSetOther", acNormal, , , acFormAdd, acDialog, "value" I then use Me.OpenArgs inside the opened form to grab the value. It sometimes sends a Null value…
lamcro
  • 6,069
  • 18
  • 57
  • 70
3
votes
2 answers

Get List of Queries in Project - MS Access

I've got a very cookie-cutter database (very similar, very repetitive queries) which go into one modular report (ie they all return the same things with different criteria). There will be ~100 of these queries so I'm using a combo box to display the…
StuckAtWork
  • 1,613
  • 7
  • 23
  • 37
2
votes
2 answers

MS Access - Open Argument between sub forms? can I pass a value? do I need to?

So I have a sub form that creates a record (and record it), and then another sub form opens up for data entry...however can I still use an open arg to pass the value (ProjectID) between these sub forms. I know exactly how to do this with forms, but…
Justin
  • 4,461
  • 22
  • 87
  • 152
1
vote
3 answers

MS Access: How to pass OpenArgs into a Subform?

EDIT: nevermind I just created a new form, it looks worse but it's much easier I have a form of orders and there are buttons and a subform on it. The form has a customer name that is given in the OpenArgs property when I open it from the Main…
IdK
  • 31
  • 1
  • 2
  • 5
1
vote
1 answer

MS Access - opening a form with a new record and inserting a value from a previous form

I have a form in an MS Access database which lists Orders with an Order Number with one order per page. At the bottom of the form there is a button which opens another form, to add an item for the order. I am trying to use vb in MS Access to take…
user566577
  • 11
  • 1
  • 2
1
vote
0 answers

Access Public Function for Maintain Combo Lists

I have over 40 combo controls in my application. I am working on developing a public function, to put in the not in list event of every combo. The goal is to have 1 continuous pop up form, which will open, if the user says they want to add a new…
missscripty
  • 529
  • 2
  • 11
  • 30
1
vote
2 answers

Passing Values Between Forms using OpenArgs

*****EDITED So I have a form titled "NewInvoice". This form edits a table "Invoice" which contains the following; Invoice Number, Customer, Order Date. In this form I have a button which opens a subform titled "InvoiceItem". This edits a table with…
jBry562
  • 25
  • 1
  • 8
1
vote
3 answers

OpenArgs Problem in Access

I have a code like this: Dim strResponses As String strResponses = Forms!frmResponses.QstnID.OpenArgs If Len(strResponses) > 0 Then Me![QstnID].DefaultValue = Me.OpenArgs End If When I run it, its gives error 438. Can someone help me to know…
kkbondo
  • 11
  • 1
0
votes
2 answers

MS Access Turn textbox invisible if button clicked

I have two different forms, one has 5 buttons and the other one has 5 textboxes By clicking one of the five buttons from the first form, I want the user to be sent to the 2nd form but only see one textbox, the other 4 are supposed to be invisible.…
Danielthelawd
  • 1
0
votes
0 answers

Open form and set unbound ComboBox to specific value

ISSUE I have two forms: frmForms frmDockRental I have two controls associated with this issue: lstOwners on frmForms (unbound) cboOwner on frmDockRental (unbound) The second form (frmDockRental) is opened using different listboxes located on…
BeardedSith
  • 129
  • 11
0
votes
1 answer

How to programmatically select a value in combo-box?

Good Day all. I have a quick question. I have an openargs value that I'm am trying to use to show up in my combobox (cmbMemberName) on return from another form. The combobox populate the underlining subform. I just can't seem to get the right…
JZeig1
  • 403
  • 1
  • 6
  • 13
0
votes
1 answer

OpenArgs to display record in new form

I'm using a cmd button to open a popup (single) form that has (2) txtboxes that I want to reflect the information from a single record in the previous (continuous) form. The cmd will Code on the cmd button: Private Sub cmdReassign_Click() On Error…
JWC14
  • 1
  • 1
0
votes
2 answers

Me.OpenArgs is always returning null when trying to open a new form in access

Okay, so I have a database in Access, and when I have one form open (for a job application), and click a button it runs this code: Private Sub cmdAddDemo_Click() DoCmd.OpenForm "sfrmAppDemographics", , , , , , txtApplID.Value End Sub Where…
Jacob Jackson
  • 78
  • 10
0
votes
1 answer

MS Access 2007 - OpenArgs not passing the value to next form?

So I pass the ID value from one form to the next using Docmd.OpenForm "SecondForm",,,,,, MainID Docmd.Close AcForm, "FirstForm", acSaveYes and then I check the value on the Second Form's load event: MainID = val(Me.OpenArgs) and when I debug and…
Justin
  • 4,461
  • 22
  • 87
  • 152
0
votes
3 answers

OpenArgs not passing variable to report

I am pretty new to VBA and i'm trying to create a button on a invoice creation form that will print the invoice. The On Click event of the button should open a report and assign the Invoice ID on the form to the openargs property. Private Sub…
JRichardson
  • 1
  • 1
1
2