Search results

Hi guys, I have a little problem when I try to filter the file by date criteria. Here's what I did: All the data is in text file, so I linked this text file to MS Access 2002, and splited the text file columns. So now I have made a table. The date in this file is like this "2007 05 08", so I...

Hi guys, I'm using update query to update values in table. However it takes about an hour to finish updating. I found that there is possibility to use this code to increase the speed of the query: Sub PMUpdate() Dim dbs As DAO.Database Dim rsWk as DAO.Recordset Dim strSQL,i As String Dim...

Hey, I need to sum values of currencies in one column (Expr2) considering to which currency I choose (Currency is written in column Expr8). I added a text box In Microsoft Access Form. I entered this formula: =DSum("[Expr2]";"Query1";"[Expr8] = 'USD'") However when I go to the 'Form View'...