Search results for query: *

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

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

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

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

Here is what I did I made a button create a textbox not I want it to bound the box to the query field that matches the string here is my code: Dim frm As Form, ctlDefault As Control, ctlNew As Control Dim intLtxt1 As Integer, intLeft, intTop1, intTop2, intNum, intSum, intNewLeft, intName...

I have a form with a subform TempFederal on it and a button on it. On click of the button it creates a textbox and lable on the subform, it creates a table called NewYears and it also creates a new field in NewYears table. I also want the but to rename the table to Years, which is the table...

I have this code and it ran once not it give me the following message that it can not find TempFederal.mdb. Could some on help me I am using access 2002. Public Sub CreatesNewTable() Dim dbsTempFederal As Database Dim tdfNew As TableDef Dim prpLoop As Property Set...

What I am trying to do is, when a you click on each tab it uses a different criteria in the query. for example: the tab is called education and the criteria in the query I want is TxtID Like "pe*" Or Like "su*" Or Like "ta*" Or Like "cu*" Or Like "nh*" the second tab is called support and the...

I am looking for code to convert an access report to a pdf to mail. I will take code for the mail part too. We use Access 2002 and Mozila for mail. If this is possible. Thank you

I can't figure out how to divided a the field's first row by the field's second row and so on. For example: the field name is Millions in the first record it has 100,580. and in the next record it has 500.00 so now I have to divided it form row one by row two. This need to be done until there...