Search results

My workflow is to open database Return to internet and download csv data for particular account number Refresh linked table by opening and closing Perform queries on linked table Return to internet and download csv file but this time for another account number Open, refresh and close linked...

Using a web interface I export bank transactions into a csv file - the name of this file is always the same. I have an access table that is linked to this csv file. I then query this table and do things. Can the linked table be refreshed without opening it? Or do I just run some code that...

Thanks to you both. arnelgp, you nailed it.

My subform is based on a query and lists transactions. In this query I have a field called txtTransDate whose criteria is; Between [Forms]![fmAllocation]![txtTransactionDate]+5 And [Forms]![fmAllocation]![txtTransactionDate]-5 The subform child field is TransactionDate as is the master...

SELECT DISTINCTROW did allow me to edit, SELECT DISTINCT did not. Thanks a lot

Thanks, just saw that. The query is a Find Unmatched Records query. Here is the SQL; SELECT tblImport.Import, tblImport.TransactionDate, tblImport.Amount, tblImport.TransactionDescription, tblImport.AccountNo FROM tblImport LEFT JOIN tblAccountTransactions ON (tblImport.Amount =...

I have a query that returns records from a table. One of the fields in the table that is outputed in the query is a check box field. I would like to select the checkbox filed in the query output and have the same checkbox field in the table checked.But I find I cannot select the checkbox field...

access I need to identify the transactions not in the db. Comparing the totals and noting the variance means I search for the latest transactions that total to equal the variance. The checkbox selects the transactions to be added to the db.

My database is an attempt at mirroring the transactions that occur in my bank account. My challenge is to identify the transactions in the bank not yet in the db and somehow bring them in. The bank only provides a text export of the transactions which I link to an access table...

Pat, I think your approach is the better way - I am going to start developing it. thanks a lot

Thanks People, Doc_Man, I should have mentioned that the intention is to render the amount (which comes as text) as numeric by deftly handling the plus sign. Thanks Pat, you gave me some ideas. Unfortunately, linking won't work because the source file always changes. The easiest solution is...

I am trying to import a CSV file listing transactions in my bank account. An example of a record is; dd/mm/yyyy, "+##.##", "transaction description" The number field could be preceded by a + or a -. The import works perfectly with the values preceded by a negative, however, the values...

My intention is to pass data from one form to another. I have a form (fmTransactions) based on a table (tblTransactions) with an index located in the field TransID. I have another form (fmRental) based on a query that is filtered by the value in TransID from fmTransactions. Note the index...

And how would I use this statement?

Is there any way I can configure a text box so that I can enter a formula in it and the result can be displayed/written? For example say I want to put in the text box 179+11 and want the result to display as well as being written to the db. Sort of like an excel cell. thanks

I am trying to add the value of two text boxes, whose default value is set to 0, by putting this statement in the record source of a third text box; =-[txtTtlRent]+[txtBodyCorp] However nothing displays in the third text box. What is the problem? Note that the data types are correct. Thanks

Do I just call this code with the statement Me.txtMyField = fnProperAndUpper(s)

I know this is a minor thing but as I am a newbie at coding and trying to get it clear in my head... would it be correct to declare s more clearly? Say Public function fnProperAndUpper(strNameSay As String) As String Is that the way this can be done? Also why is it declared a string twice?

I have a field (FullName) which might contain either John Doe or John Doe(6). Also the case might be mixed. The objective is to apply PROPER case to the first name, UPPER case to the second name and still display the value in parenthesis immediately after the second name. I was going to use...

Have found the source of the problem. In another procedure the following code runs in relation to strCloneGuest; fName = StrConv(Left(Me.txtGuestName, InStr(1, Me.txtGuestName, " ") - 1), vbProperCase) lName = StrConv(Right(Trim(Me.txtGuestName), Len(Trim(Me.txtGuestName)) -...