Search results for query: *

ZmrAbdulla, I am sorry I forgot to say the prevBalance is record 1 and the Debit amount or Cedit amount is on the next record. So I want the next record to take the prevBalance - Debit amount or + the Credit amount.

Hello, Here is what I am trying to do. I have two table one with just a previous balance for one month. The other table has a credit and debit totals by days. I only want to use the previous balance for the first record that starts that month and then I want to subtract the debit amount from it...

markphsd, will this split a query? or just the table and How would I go about that if it is a query. I do not need to do a table because the boss does not want another table in the database. thank you

Hello, I have a table called SPF_2003_2004 it has a field in it called REQ it is a memo field (which are about 20 different names). This data was pulled from another application. I created a query that parse but eceeded resources. So now I am looking for code that will parse it and then...

JoeAtWork, Thank you, sounds good

Hello, Thank you for all your help. The data is dollars done each year. So I name the textbox 2006. This is how this company want it and I am not the one to say "they can't have it" They just get mean. I am just a pee on. I do what I am told. They deal with money by years and months. I...

The nameing is not the problem. The textbox name could be year1, year2, year3 etc... It is doing the if statement to do a search for a textbox to see if it there. I just want it to look at the textbox's name. Is it possible or is not? Why would this be a unnormalized database? If statements...

Hello Everyone, Here is what I am trying to do. Basically the if statement to check to see if there is a textbox called strName(strName = year(now())+1). if it is there end else run the code. The code is behind a button onclick property. Temp_Federal is the name of the form actualy it a...

I am trying to reference a textbox on a form but have trouble with it. Eample strName = Year(now())+1 If IsObject(Me.Temp_Federal.Controls(strName)) = True Then Dim msg As String msg = MsgBox("This year already exists.", vbOKOnly) Else Call UpdateTable end if Help please

TheAceMan1, Thanks

TheAceMan1, That is cool I did not nothing about that and I have been using access for six years now. I will try it and let you how thing go. Thanks

TheAceMan1, That sounds good. What do you mean by seed? Could you give me an example of custom db properties? I think I know what you mean by it but I just want to see my thoughts is the same as what you mean. thanks

What I want it to do is look for the last textbox that was added each time the form is opened and use the left position of that textbox and add this 1680 to it to creat the new position. I hope I am explaing this right. Here is what I am trying to do. I have a button that has code that...

TheAceMan1, The last textbox is left = 8760 and top = 1140

I am looking for code that will find the last textbox on the form and get the left position property number then it is going to add a number to that for a new position of a new textbox. I hope I am explaining this right. Here is example of I mean Say the textbox left proper is 1000 twips...

jebry, Thank you that worked great.

jebry , Yes, the strName is the field name. For example strName = 2007 But the ControlSource = strName does not work It keeps telling me object not found or you have entered an expression that has an invalid reference to the property controlsource.

Does anyone have the answer to this?

jebry, the quotes, here works if you take them out you get a message type mismatch: frm.RecordSource = "qryTemp_Federal" but this does not: .ControlSource = strName

jebry, I sending it the query named qryTemp_Federal and the field name is what ever the strName is. So if the strName is 2007 then that is the field name it should use for the ControlSource.