Search results

Sorted and thanks for asking.:)

tblImport is created from a text file import and holds superfluous transactions that need to be weeded out - the balance of the transactions are appended to the tblAccountTransactions. Thanks for the pointer re memo fields. Fortunately it isn't.

Yes have used the unmatched query wizard without success. My mistake, the field Date is really TransactionDate. This is asking me for Parameter values for tblAccountTransactions.Description and tblAccountTransactions.Amount.

I would like to find all records in tblImport that does not have matching records in tblAccountTransactions. In both tables I have Amount, Date and Description. I need to use an AND statement in the criteria. That is, using all 3 fields (Amount AND Date AND Description) from tblImport find non...

I tried to implement this on a text box that is formatted for Currency but the code only selects the numbers to the left of the decimal point. Can anyone please advise the fix? thanks gavin

I have a form containing a subform. The subform contains checkboxes and corresponding amounts and bank account numbers. In the footer section of the subform is a DSUM formula saying add up all amounts of a particular account whose checkbox is true :=DSum("[Amount]","tblImport","[Import]=True...

Fixed it - I was missing the rabbit ears.

I have a table called tblAccountTransactions. In this table are the fields BankedAmnt and AccntNo. In the query grid window in the first column is AccntNo. In the second column is the formula total: DSum(BankedAmount,[tblAccountTransactions]). However when I run the query it is asking for a...

I am running this code but am receiving the error in the subject; Private Sub cmdUpdate_Click() Dim dbsCur As Database Set dbsCur = OpenDatabase("C:\Users\Gavin\Front End\MyFile.accdb") Dim tdf As TableDef Set tdf = CurrentDb.TableDefs("tblCSVData") If Len(tdf.Connect) > 0 Then...

tblCSVData is a table of MyDB.accdb

So I did as you suggested but still receive the same outcome Here is the code;

If I comment out Dim dbsCur As Database Set dbsCur = OpenDatabase("MyDB.accdb") I am now getting the error I reported on post #8

I have got this code to work before but now I can't, giving me a runtime error 3024, Could not find MyDB.accdb Here is the code; Private Sub cmdUpdate_Click() Dim dbsCur As Database Set dbsCur = OpenDatabase("MyDB.accdb") Dim tdf As TableDef Set tdf = CurrentDb.TableDefs("tblCSVData")...

Thanks Gasman, I cannot specify the name of the file unless I change it after the download. The bank does not allow any interaction other than request the download. I have eliminated the manual refreshing of the linked table (point 3 and 6).

Thanks everyone, unfortunately I am limited by the nature of the external source therefore can only process one file at a time, initiated by a manual process. But that doesn't mean I can't make it more efficient, which I have as a result of this thread. thanks again

Thanks Pat, in fact one of your earlier posts set me on my current path.

Well what do you know. Once I reopened the db it worked. thanks for your help

Yes, replaced table1 with my name. Yes it compiles. The enabled references are Visual Basic, Object Library, OLE Automation and the database engine object library.

The line If Len(tdf.Connect)>0 Then is throwing a "object invalid no longer set" error. How should I fix this?

With each iteration a different run time parameter is specified... I can only create a csv for one account at a time, and I have multiple accounts.