I always come across this question when searching for how to make LEFT JOIN depend on a further INNER JOIN. Here is an example for what I am searching when I am searching for “using LEFT JOIN and INNER JOIN in the same query”: SELECT * FROM foo f1 LEFT JOIN (bar b1 INNER JOIN … Read more
You can use the below query to remove all the rows from the table, also you should keep it in mind that it will reset the Identity too. TRUNCATE TABLE table_name
Use Access’s VBA function Replace(text, find, replacement): Dim result As String result = Replace(“Some sentence containing Avenue in it.”, “Avenue”, “Ave”)
I just tested this and it works in Access 2010. Say you have a SELECT query with parameters: PARAMETERS startID Long, endID Long; SELECT Members.* FROM Members WHERE (((Members.memberID) Between [startID] And [endID])); You run that query interactively and it prompts you for [startID] and [endID]. That works, so you save that query as [MemberSubset]. … Read more
select A, B, ‘c’ as C from MyTable
Maintaining compatibility with Lotus 1-2-3 back in the day, which had a bug in that it thought the year 1900 was a leap year (or pretended?). The explanation is too long to quote, but for the sake of curiosity, here are some snippets. http://blogs.msdn.com/b/ericlippert/archive/2003/09/16/53013.aspx http://www.joelonsoftware.com/items/2006/06/16.html 1900 wasn’t a leap year. “It’s a bug in Excel!” … Read more
1. Write Testable Code First, stop writing business logic into your Form’s code behind. That’s not the place for it. It can’t be properly tested there. In fact, you really shouldn’t have to test your form itself at all. It should be a dead dumb simple view that responds to User Interaction and then delegates … Read more
I am able to use this feature on my machine using MS Access 2007. On the Ribbon, select External Data Select the “Text File” option This displays the Get External Data Wizard Specify the location of the file you wish to import Click OK. This displays the “Import Text Wizard” On the bottom of this … Read more
Possible problems: 1 Concurrent edits A reason might be that the record in question has been opened in a form that you are editing. If you change the record programmatically during your editing session and then try to close the form (and thus try to save the record), access says that the record has been … Read more
Declare Sub Sleep Lib “kernel32” Alias “Sleep” _ (ByVal dwMilliseconds As Long) Use the following syntax to call the Sleep function: Sub Sleep() Sleep 1000 ‘Implements a 1 second delay End Sub