Search results for query: *

I built a database that keeps track of bank deals transacted by a bank. I am new to access so when I created the database I set no primary key, in order to keep the db flexible as I was building/tweaking it. The current problem is that on occasion we have two deals on the same day for the same...

My wireless network has a WEp password, but whenever I try to log on to the network it reverts to an incorrect password. I have to delete and copy/paste the real one every time. I have tried deleting the network and adding a new one with the correct password, but it still reverts to the old...

I have a form that displays transactions made each day. the Problem is that whenever it is closed and opened again all the records entered in that day dissappear in the form. Is it possible to keep them up despite the from being closed?? If so if it is a shared db, is it possible for both...

I have a sheet that is imported from and access query. This sheet will change depending on the data from access. The fields are: Date Amount 8/18/2004 ($17,020,966.67) 8/19/2004 ($90,789,680.01) 8/20/2004 ($395,559.34) 8/23/2004 ($13,782,879.05) 8/25/2004 ($27,531,708.33)...

Here is a sample of my query: Maturity Date|MaturityDateAmount|Value Date|ValueDateAmount |8/19/2004|($85,260,778.63) |8/12/2004| ($85,260,778.63) |8/16/2004|($27,004,440.00) |8/12/2004| ($27,004,440.00) |8/16/2004|($7,301,192.33) |8/12/2004| ($7,301,192.33) |8/26/2004|($1,000,525.00)...

Here is the type of data my database contains, I am a newbie so I don't really know how to approach this problem Counterparty ValueDate Maturity Date Amount Cashflow BankA 8/9/04 8/10/04 $100 -$110 BankB 8/9/04 8/10/04 -$200 $220 BankC...

I have a query with these particular fields that are of interest to me: CounterParty, Amount, interest, Value Date, Maturity Date, & Cashflow(Amount * Interest) I need to be able to generate a 30 day report outlining the the positive and negative cashflow for each day. On the Value date, I...

I have just spent about a onth creating a very intricate form, and I was trying to possibly put it into a report. I opened up a subform in a new report and told it to use the form in that subreport. I saved it, and now neither the report nor the form will open. Please help, this has taken me...

I have three textboxes that give the balance of 3 different accounts. They are called 'GCI', 'NY', & 'IBF' Their control sources use dlookup to get the value from two queries for each respective account. My problem is the the NY and GCI boxes are working fine but the IBF one keeps coming up...

I have a textbox linked to a query using dlookup =DLookUp(" [Current Position]![Current Position] ","Current Position") which reflects a sum of money. I am using a continuous datasheet and when I enter in a new amount, the textbox does not refresh although the query does. How can I make this...

I have a Query named "Branch Sums" that looks like this: Branch Maturity Date SumOfCashflow GCI 7/22/04 ($5,000,138.89) IBF 7/22/04 ($5,000,138.89) NY 7/22/04 ($5,000,138.89) I would like to create three different text boxes for each branch on my form that displays each respective...

Hi all, I am an Access newbie and I am not too familiar with VBA, but I've been learning a bti as I've delved into this project. I have created an Access table with 7 fields: Transaction Date, Counterparty, Branch, Type, Amount, Interest Rate, Value Date & Maturity Date. These are with...