SQL Editor
May 18, 2007Anyone know where I can find an SQL editior to make queries? Also, any additional information would be great.
View Replies
ADVERTISEMENT
VB Editor And Mouse Wheel
Nov 7, 2005Hello to all,
Just something I hate and been frustrated about and would like to know whether it can be solved. I don't know about your PC but my mouse's wheel does not work in the Visual Basic Editor. This applies to all Office apps.
When I scroll the wheel, nothing moves. It works great in other apps, though, such as Explorers, ....
Is it something that was meant at designed or am I missing something here?
Thank you all in advance.
Autocomplete In Code Editor
Aug 22, 2006I'm not sure what you call it but I call it auto-complete; the functionality that gives you a list of methods/commands when you are typing something like Me.Forms. When you type the Me. after the . it will bring up a list for you to see what you can do from there. That works fine for me but when I do the following: "CoCmd." the list will popup for a brief moment (much less than half of a second) which does not let me view the possible methods. Is this normal? If not does anybody have any idea how I might be able to fix it short of reinstalling MS Office (that is NOT an option).
Thanks,
Aaron
I wasn't sure if it should go in this section or the VB section. I apologize if it is in the wrong section.
MsgBox In VBA Editor Not Popping Up
Sep 16, 2011I have a form with a combo box and a button, which when clicked, opens a report based on the option selected in the combo box. For this, in the event procedure of the button click, how do I code it so that if no option is selected in the combo box and the button is clicked, it should display a 'message' as a pop up. I know I should use the MsgBox option but I seem to be going wrong with the If loops. I doubt I am positioning the MsgBox command in the wrong place in the code below, as it does not pop up the msg box as I desire. Heres the code:
Private Sub btnMarket_Click()
If Me.Combo0 <> "" And Not IsNull(Me.Combo0) Then
Dim s As String
s = "1=1"
[code]....
Multiple Sql Statements In Access Sql Editor
Jun 8, 2005I would like to update a lot of fields in my tables; about 120 different fields in 12 different tables. I would however like to keep it simple by using the SQL editor in MS Access by writing all the UPDATE queries and leave them to run while I do smething else. It seems to me however that you can only run one query at a time using the SQL editor. I thought I could separate one SQL editor from the other by using semicolon as in Oracle SQL editor etc., but that does not seem to work. Does anybody know how to do this in Access without writing a VBA code etc.?
View 3 Replies View RelatedGeneral :: HTML Editor To Format VBA Code
May 10, 2014I would like it to be formated the same on the web page as it is in the MS Access code module.For Example:
Code:
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.
' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True
[code]...
Is there a free online HTML code editor that will do this?
How To Link Images With Photo Editor In Access 2003?
Mar 22, 2007I am setting up a database with an image linked to each record. I have installed Photo Editor as required to display jpeg files. However, when I try to insert object in the table field, Photo Editor does not appear as an option under 'Object Type'. How can I use Photo Editor as my OLE server to display jpegs? Or, can someone suggest a better way to display images on forms? I'm a newbie, so although I'll try more advanced programming if required, I will need quite detailed step-by-step instructions :)
Thanks!