Passing parameters from vb to access 1

[Giblets]

Sorry, I've already posted this question but need more help, the problem is as follows:I'm having some trouble at the moment trying to pass parameters from vb to access, what I want to do is bring up an access report in vb regarding a particular customer, does anyone know how to pass the parameter from vb to access to allow me to do this? The parameter is coming from a text box. Also do you have to manually open the connection.Thanks again.

 

[johnwm]

You'll do a lot better, and won't offend the original responders if you clarify the question, or explain why the answers didn't help, in your original thread222-483589

Check out faq222-2244 to see why!
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[TIGREBLANCO]

I have the same problem you have, trying to access control's properties on any given Access form, so far the only way I've been able to pass info from Vb to Access and viceversa is writing and reading the info to and from a text file. Still waiting for an positive answer on how to actually get a handle of those properties in Access through COM+.
If not possible with COM+ and txt file is not desirable, then will probably have to use API to achieve this.

on hold....

 

[TIGREBLANCO]

Hi there

I just found out how to access the properties in an MS Access form's control, it can be done through "screen" or "forms" objects (I still can't understand why the object browser won't display the items by its name (like Excel does) rather that "Item 1" name specification, not very happy with this design rule).
So in order to get the value from a text box "Area_Tbx" in Form "Login_frm":
StrTemp = AccessApp.Forms.Login_frm.Area_Tbx.value

or if your form is the the active form (the one with the focus):
StrTemp = AccessApp.ActiveForm.Area_Tbx.value

Good Luck!!