|
1d
|
|
awarded | Notable Question |
|
Jun
13 |
|
revised |
"Register" an .exe so you can run it from any command line in Windows deleted 54 characters in body |
|
Jun
11 |
|
revised |
Code to loop through all records in MS Access made some minor edits to clarify and explain, removed broken link |
|
Jun
6 |
|
awarded | Famous Question |
|
May
21 |
|
comment |
Outlook.Application on Access Database Have you checked Outlook when running this code? Outlook has a security prompt that comes up and prevents an outside source from sending emails without accepting something on the security prompt. And yes, it does cause MS Access to hang when that prompt comes up. |
|
May
21 |
|
comment |
"Write Conflict" error appears in single user database Why not use DoCmd.RunCommand acCmdSaveRecord? I'm not saying it will fix your problem but is the standard way to save a record. |
|
May
17 |
|
comment |
"Write Conflict" error appears in single user database While a Form's dirty property is writable, I don't think it should be used that way. Create your own blnDirty variable and use that instead. You can always run a check If Me.Dirty = True Then blnDirty = True.
|
|
May
17 |
|
comment |
DB Overflow in Module You have two For statements and only one Next statement. A For Statement must always have a corresponding Next. |
|
May
17 |
|
comment |
Microsoft Access Drawing Line on Listboxes You want some kind of separator lines inside your list box? Or you want lines drawn on the form, outside of the listboxes? |
|
May
17 |
|
comment |
Difference Between ApplyFilter and SetFilter I've been programming in Access VBA for about 8 years and I have never used either one. I use the Form's Filter and FilterOn properties. The DoCmd object isn't necessarily well thought out. It contains many oddities. It's basically an object built to perform the same actions that are built into the Access GUI. |
|
May
17 |
|
comment |
What is wrong with this query, and how can I make it more efficient? I would try to avoid having to use a query that looks like this. I don't think it's wise to have logic contained inside your ProjectNum that causes you to need these kinds of queries/functions. What if the priority for the project changes, do you change the ProjectNum? Use incrementing numbers for the ProjectNum and then use a Priority column. |
|
May
17 |
|
comment |
Importing emails from exchange server I believe you will have to write code for Outlook. I'm not aware that you can connect directly to Exchange Server and retrieve emails. Take a look at this question: stackoverflow.com/questions/8293651/… |
|
May
17 |
|
comment |
Customization of default Microsoft Access combobox UI For what you want to do you need a query that looks like this: SELECT ContactID, FirstName & " " & LastName, ContactID as ContactID2 FROM tblContacts ORDER BY FirstName, LastName Then you need to set your combobox to have three columns. In the column widths you put 0";2";.5"
|
|
May
17 |
|
awarded | Popular Question |
|
May
16 |
|
comment |
Customization of default Microsoft Access combobox UI Are you having trouble showing which item has been selected? It just shows ID? Or what exactly is the problem? |
|
May
16 |
|
comment |
Insert query for specifies columns in Access VBA gives error "3061" - Too few parameters I don't think you can use a "Group By" on an "Insert Into" statement. I also think it's best to avoid using Joins on an Insert Into statement. Why do you need to create the field on the fly? That's a "code smell". I suspect you are adding columns/fields for years or months which is never a good idea! |
|
May
16 |
|
comment |
How to Delete a record in a subform when you click a button You're trying to delete using a Query name in the From Clause. I don't recommend performing Deletes on a query. Always put table names in the From clause. If there are multiple tables then you should several delete queries or else use "Cascade Deletes" on your relationship. |
|
May
13 |
|
comment |
How to Delete a record in a subform when you click a button I was assuming you were talking about bound forms. When you use SQL statements on bound forms you bypass the many different features and events of the form. Users might end up seeing rows with #DELETED in them. Or read/write errors if they delete a record they were editing. |
|
May
10 |
|
revised |
How to Delete a record in a subform when you click a button Added Edit1 |
|
May
10 |
|
comment |
How to Delete a record in a subform when you click a button Your original question doesn't say what kind of form you're trying to use. My reply has nothing to do with visual studio. |
