open the dropdown box on sub form in VBA


HOME ยป Access
Hi,
Wonder if someone can help.
I want to open the
dropdown box on my datasheet view subform from the main datasheet view
form when I run over it with the mouse.
From my main form textbox
[WelderID]
I tried this code but doesn't work. I get the error
invalid reference to the property Form/Report.
Private Sub
WelderID_MouseMove(Button As Integer, Shift As Integer, x As Single, Y
As Single)
Forms![Main]![WorkOrder Form]![DrawingNo fm]![Welds
fm]![WelderStamp Sfm]![WelderStamp].SetFocus />Forms![Main]![WorkOrder Form]![DrawingNo fm]![Welds fm]![WelderStamp
Sfm]![WelderStamp].Dropdown
End Sub
I am automating a Word form and have a few drop-down boxes on the
form. I need to save the value of that box while saving the document.
I also need to copy the value to another document.
We are
using .save and .saveas and are using type = wdAllowOnlyFormFields for
the document.protect and unprotection functions while working with the
document. If all VB code is taken out, the values save ok on the
initial document. If VB code reinserted the value no longer saves.
All other values save ok.
No significant code in the basic
document affects that document and it is the lowest failure point. />Most of the code is checking bookmarks, creating or opening another
document and
Programming Languages
Hello, is it possible to forcibly open a dropdown box (like,
onmouseover)? Just a regular form dropdown. :)
Development
Dear WebDeveloper members and moderators,
A pleasant day to
eveyone.
Im currently making a pet shop site for a friend; I have
this HTML page entitled allpets.html where it displays ALL pets
available in their shop in "unordered" manner. Then I have
this dropdown menu where a visitor can filter the pets according to
their type. Here is the code:
<form action=""
method="get">
Filter our pets by type

<SELECT style="WIDTH: 190spx"
name="ProductCategory">
<OPTION value=0
selected>[Select a Category]</OPTION>
<OPTION
value
Webmasters
Hey all,
Here is my contact Form and Table:
Form
"contacts":
Contact Name ___________
Phone
_______________
Address _______________
Town/City
______________
State _____________
Post Code ____________ />From the form the data is entered into Table
"contacts":
style="margin-bottom:2px">Code:
dir="ltr" style="text-align:left">  id  contact 
phone  address  town    state  pcode />_____________________________________
Access
Hi guys
I have a frontend built in Access 2010 and backend
in Access 2003. Now I am writing the code to populate a drop down box
but it doesn't work
Any suggestions will be much appreciated. />
style="margin-bottom:2px">Code:
dir="ltr" style="text-align:left">Private Sub
RequesteeName_Change()
Dim strText, strFind As String />strText = Me.RequesteeName.Text
If Len(Trim(strText)) > 0
Then
               
   
strsql = "SELECT Name, Dept FROM
tblElevateEmployee where
Access
Hi,
Wonder if someone can help.
I want to open the
dropdown box on my datasheet view subform from the main datasheet view
form when I run over it with the mouse.
From my main form textbox
[WelderID]
I tried this code but doesn't work. I get the error
invalid reference to the property Form/Report.
Private Sub
WelderID_MouseMove(Button As Integer, Shift As Integer, x As Single, Y
As Single)
Forms![Main]![WorkOrder Form]![DrawingNo fm]![Welds
fm]![WelderStamp Sfm]![WelderStamp].SetFocus />Forms![Main]![WorkOrder Form]![DrawingNo fm]![Welds fm]![WelderStamp
Sfm]![WelderStamp].Dropdown
End Sub
Access

- Technology - Languages
+ Webmasters
+ Development
+ Development Tools
+ Internet
+ Mobile Programming
+ Linux
+ Unix
+ Apple
+ Ubuntu
+ Mobile & Tablets
+ Databases
+ Android
+ Network & Servers
+ Operating Systems
+ Coding
+ Design Software
+ Web Development
+ Game Development
+ Access
+ Excel
+ Web Design
+ Web Hosting
+ Web Site Reviews
+ Domain Name
+ Information Security
+ Software
+ Computers
+ Electronics
+ Hardware
+ Windows
+ PHP
+ ASP/ASP.Net
+ C/C++/C#
+ VB/VB.Net
+ JAVA
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow