Viewing 15 posts - 16 through 30 (of 77 total)
Sean Lange (5/9/2014)
May 9, 2014 at 11:03 am
jdasilva (5/9/2014)
SQL is delicious (5/9/2014)
Sean Lange (5/9/2014)
jdasilva (5/9/2014)
J Livingston SQL (5/9/2014)
is/can your form be based on a single table/sql query?but then how does the report see this filtered data?
The resulting...
May 9, 2014 at 10:28 am
SQL is delicious (5/9/2014)
jdasilva (5/9/2014)
May 9, 2014 at 10:08 am
SQL is delicious (5/9/2014)
May 9, 2014 at 8:01 am
If you want to keep a query in Access, use a pass-through query:
Sub RefreshQuery(Byval Value As String)
' Name of the query in the Access database.
' Replace QueryName by the actual...
May 7, 2014 at 3:00 am
Definitely a vocation and a passion for me. In 1968 (I was 12) I saw the motion picture "2001 A Space Odyssey" (S. Kubrick) then read the book (A. C....
May 6, 2014 at 5:55 pm
The solution I provided does work, I've been using it for several years. However, you need to take certain precautions in the way the procedures are written:
1. Always begin each...
May 6, 2014 at 2:25 pm
Here's what I use:
1. In the folder where the SQL scripts as stored, create a file named mergescript.cmd.
2. Open this file and paste this into it:
@IF EXIST scriptdb.sql DEL scriptdb.sql
FOR...
May 6, 2014 at 3:16 am
Thinking of it, it could be faster:
For Each clave In tdf.indexes
If clave.Primary = True Then
Campo_Actual = clave.Fields(0).Name
...
April 30, 2014 at 12:58 am
Try switching to the DAO library, it's usually faster than ADODB/ADOX.
April 29, 2014 at 12:47 am
m_booReady is what's usually called a member variable, meaning that:
1. It is declared outside any procedure in the module.
2. It is declared as Private.
The consequence is that such a variable...
April 10, 2014 at 7:31 am
grovelli-262555 (4/10/2014)
Thanks 🙂"This event can only occurs when both subforms have been initialized" and that's for the Open event but what triggers the main form's Ready property?
Private Sub Form_Open(Cancel As...
April 10, 2014 at 6:38 am
grovelli-262555 (4/9/2014)
so in the main form Open event you have
m_booReady = True
but then what triggers the...
April 10, 2014 at 12:15 am
Viewing 15 posts - 16 through 30 (of 77 total)