Search results

My table (tblEqtyTrans) is a list of share transactions with records containing equity id and whether it was a Sell or Buy. I want to be able to extract all equity sales for a given date range, and all the transactions for that equity through time. In excel I would have 2 sort levels, the...

On my main form (fmTransactions) there is a tabbed control containing a variety of subforms. One of the subforms (sbfTransactions) is based on a query (qryTransByAmnt) . This query has two criterion referencing fmTransactions. One criteria is "only return transactions within 30 days of the date...

When the database is split between front end and back end where do you create the relationships? In the front or back end?

I wanted to create a database that enable me to characterise bank transactions for tax purposes. The process is, get transactions from my various bank accounts into tblImport and then selectively add them to tblAccountTransactions. I then review each transaction and characterise is as say...

Trying to learn more about Split Forms. Looking at the Northwind DB, Customer List form I notice that not all of the columns are displayed. Can someone explain how this was achieved. Thanks

I have a form based on tblImport. This table is related to tblAccounts. On the form I have a combo box that lists all the possible accounts that are within tblImport. I want to put a text box on the form that references the field "Balance" in tblAccounts that corresponds to the account chosen...

I am using a query to compare 2 tables - lets say tblNewTransactions and tblTransactions where I am looking for records in the former that are not in the latter (because some definitely are). The outputted records have a checkbox field. The idea was to be able select each of the checkboxes of...

I am running a query that compares table A with table B and returns records in A that are not in B. There is a checkbox field in table A which I want to be able to check if it is returned in the unmatched records query. Unfortunately I cannot update the checkbox field in the query because, I...

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 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...

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...

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...

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...

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...

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...

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...

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