]Is it possible to set the format / decimal properties of multiple fields all at once in the SQL Design View--instead of plodding through each field one at a time? I am simply trying to copy the numerical format "Standard" and "0" decimal places to multiple fields in the query--instead of...
I am using the code (see below for a partial listing) from Stephen Lebans that I have modified to synch the horizontal scrollbar movement of two datasheets. However, I need to skip this process when the vertical scrollbar is used to view records--as this interrupts the conditional formatting I...
Help in enhancing ListView example to enable (multi-select) Drag-and-Drop functionality? Listed below is a double click event on the listview that populates a second listbox:
Private Sub ListView1_DblClick()
' User Double Clicked on a Row
' If FieldList = 0 Then
' Move Selected Items from...
I am still having a problem with the code listed below that I got from ZmrAbdulla.
Private Sub listView1_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Long, ByVal y As Long)
If Me.ListView1.ListItems.Count = 0 Then
MsgBox "Right click menu available only if...
I get an error message (2580: The recordsource... does not exist) that the data does not exist (it does) when I try to set a query as the recordsource for a subform in a subform on a main form. Any suggestions? Thx.
'Main form
Set frm = Forms(strFORM)
' Subform1 on Mainform
Set ctl1 =...
Running the Office XP Service Pack 3 (SP3) for Access 2002 Runtime (http://office.microsoft.com/en-us/assistance/HA011525091033.aspx) is what may have saved the day. Also, I read that Adobe files will override the MSO.dll file. I use Adobe to send Logic Process Charts to the PM depicting every...
Hi CautionMP and ZmrAbdulla,
I do not know why... ButI got the procedure to work--after several unsuccessful attempts--when I simply re-keyed "cb.ShowPopup". Go figure.
Thanks, again.
-D.
P.S. I really like the sample work done by ZmrAbdulla. Excellent! A+
Thank you for your help. An error message occurs on the cb.ShowPop line (Compile Error: Method or Data Member not found.) Apparently, I may have a corrupt mso.dll file that supports the CommandBar. Any suggestions?
Regards,
Dave
P.S. On a positive note, I no longer get an error message on the...
Does anyone know how to get the Mouse events (MouseDown, MouseUp, etc...) of the ListView control (MSComctlLib.ListViewCtrl.2) to work in Access 2000/2002? I am trying to use the mouse events to perform a Drag-and-Drop from one listview control to another. I downloaded an excellent sample...
How can I use parameter query as a report recordsource? I tried the following from Dev Ashish with no luck:
Reports: Use a recordset as report's datasource
A recordset has a seldom-used property, Name, that gives you the table, query or SQL string that the recordset was opened with. And this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.