Questions tagged [openargs]

21 questions
0
votes
1 answer

The use of OpenArgs or stLinkCriteria

Got a concept question. On opening a form, is it better to use stLinkCriteria or OpenArgs?? If there is a difference, when should one be preferred over the other? Thanx Bill
Bill
  • 1
  • 2
0
votes
2 answers

How can I use OpenArgs to print multiple reports in a loop situation?

I am slimming down my databases, eliminating duplicate reports where I can and creating better code. I have one database that involves our welders and foremen. In this code, I can print a report for an individual foreman, which sends the string…
0
votes
2 answers

RecordSource in Access SQL

I have a form which allows the user to view all records with the LinkRef field equal to a specified value and also either the Clearance Applying For or Clearance Level a certain value. LinkRef is a user ID which is pulled in using OpenArgs from the…
hello123
  • 951
  • 2
  • 15
  • 25
0
votes
1 answer

Passing Parameter to next form starting with parameter input dialog

I'm trying to create a database that is user friendly. So far I've developed two forms. Form 1 shows an overview of orders. Form 2 shows the details of a specific order. Form 2 is build on a query that retrieves information from different tables.…
0
votes
1 answer

passing an element name using a variable

I have a multi page element on a MS Access form and I am trying to use GetArgs to identify which page to open using the below code. Could anyone assist me with how to convert the page name to a format MS Access will accept? Dim WrdArray() As…
Avagut
  • 924
  • 3
  • 18
  • 34
-1
votes
1 answer

How to Pass SQL Parameter to Form Using OpenArgs?

I have a Database (not built by me) that uses 3 separate forms to accomplish 1 thing. I would instead like to pass a SQL string to the OpenArgs in order to utilize 1 form. Original Code for form I'd like to utilize: Private Sub Form_Open(Cancel As…
designspeaks
  • 203
  • 2
  • 11
  • 22
1
2