Recent content by psatkar

Hi, I have a continuous form showing 4 different text boxes. Three text boxes are bound to a table. 4th text box is unbound and has datasource as = [txtBox2] - [txtBox3]. I have code Me.Recalc in OnLoad event of the form. This form has been placed as a subform in main form and height for this...

Hi, I have a table with following column headings and data: Trans_Date Expr1 Category_Extended Trans_Type 14/03/2009 -1000 Car:Petrol Payment 14/03/2009 -1500 Car:Repair Payment 27/02/2009 -1000 Car:Petrol Payment 25/02/2009 -800 Food:Grocceries Payment 23/02/2009 -1300 Food : Dining Out Payment...

Hi, I have a requirement in which I need to build the "where" statement of a select query as follows: select * from transactions_details where format(trans_date, "m") = format(date(), "m") I need to make this option from format function to be dynamic so that it can either be M (for months) or...

Hi, I have a report having 8 columns. There is a column called "Remarks" which displays the data with various widths. For example, on an average the remarks are of the length around 30 characters. However, these will be some records in which this data can be over 60 characters as well. Hence...

Hi All, I could fogure out the solution myself after doing some trial and error. I can use DLookup function and get the payee_id. Thanks... Prasad

Hi, I have following 3 tables 1. Payees - Payee_ID (Autonumber), Payee_Name (Text) 2. Transactions - various columns (one of the columns is Payee_id which is linked to table Payees) 3. Security - various columns I have created a form which is bound to table Security. On the form there is a...

Thanks Chergh....Will centainly follow your recommendation....

Hi, I have resolve this issue by adding chr(34) before and after the varTransaction.Date field in the update statement and now it is updating the table properly. Thanks, --Prasad

Hi, I did try definging the variable as "String" type however result is just the same. There is no change. Regards, --Prasad

Hello, I have written VBA code where based on certain infrmation in the current record (in the form), I am manipulating / updating the data available in other corresponding record in the same table. In this table I have a field called Trans_Date which is Date/Time field and the format defined...

Hello Doco, I am not entering any records in Reference_Master table. I only have a combo box on this form which is populated using records om Reference_Master table. I am inserting records only in Trans_Details table. Following is my code....Apologies that I could send it using Code/Codec...

Hello Doco, I am not entering any records in Reference_Master table. I only have a combo box on this form which is populated using records om Reference_Master table. I am inserting records only in Trans_Details table. Following is my code....Apologies that I could send it using Code/Codec...

Hello Dcrake, I guess I did not explin it in the right way. Reference_Master table has two records with values Official, Personal and corresponding Reference_ids as 1 and 2. Reference_Master table has 1:Many relationship with Trans_Details table with key of Reference_Id and Trans_Ref fields...

Hi, I have two tables, Trans_Details and Reference_Master with following fields: Trans_Details table: Trans_Id : Autonumber Trans_Type : String Trans_Ref : Number (This field has a lookup in table design with field Reference_Id field from Reference_Master table) Reference_Master table...

Hello, I am using Access 2007. I have developed a form say "Form1" which also has a sub-form in datasheet view. On form header I have an unbound combo-box (cboxGoToAccount). When I select a particular entry in combo-box, I have written AfterUpdate event so that it will set filter to the form's...