Search results

Hi all, I was wondering if anyone can help me with a problem I am having, namely, I have two tables: Table A with all the names of my accounts (Account01, Account02, ...., Account10) and Table B that records all changes in balance that happens on those accounts and the dates when these...

Hi All I was wondering if someone could help me with a problem I am having with the way one of my reports is printed. I have a report with page and resize events that determine which fields will be displayed/hidden based on their values. If I open the report normally then print everything...

Hi all I was wondering if someone can help me with a problem I am having Is it possible to get a query that combines information from 3 seperate tables (e.g. Table A, Table B, and Table C) and then multiply fields from two of them (i.e. Quantity from Table B and UnitPrice from Table C) and...

I was wondering if it were possible to display multiple records on a form? e.g. records 1, 2, & 3; 4, 5, & 6; etc Thanks

I have the following formula Public Function TotalBalance() Me![intTotal] = DSum("[Total]", "qryMain", "[TransDate] <=#" & TotalDate & "#") End Function : : Private Sub intAmount_AfterUpdate() TotalBalance End Sub Private Sub intAmount_Change() TotalBalance End Sub Private Sub...

Hi All I was wondering if it is possible to use VB to modify/change the SELECT, FROM, and WHERE fields of an existing Query? Thanks

Hi All I was wondering if someone could help me with a problem I am having. I have the following code in one of my queries. SELECT tblMain.Category, * FROM tblMain WHERE (((tblMain.Category)=[Forms]![frmMain]![cboFilter])) ORDER BY Switch(isnull(Forms!frmMain!cboSort),tblMain.Reference...