Recent content by BloodshotVandal

Thanks for replying GalaxiomAtHome. Unfortunately, left/right join didn't produce the desired result, while Account01 to Account10 was listed, the changes for Account01 and Account03 was applied to all the accounts rather than just Account01 and Account03.

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 guys thanks for replying. The On Format event (when I finally found it) did the job, it works fine now.

Hi vbaInet, thanks for replying. In my report, in the Resize and Page events I have the following: Public Function SetVisibility() If Me![text09] = 0 Then Me.text09.Visible = False Me.label09.Visible = False Else Me.text09.Visible = True...

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

Thanks again for the reply vbaInet. The problem arose because I had an existing "Price" field in Table A, once I removed it it worked fine.

Thanks for the reply, vbaInet. Tried what you suggested, but the price field on Table A seems to be empty... Edit: Figured out where I went wrong. It works now.

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

Okay, got it to work. Thank you jdraw, SimonB1978, and boblarson your suggestions and advice.

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

I will do that. Thanks

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 Brian Just try out the code you provided, and yes it works. Thanks.

Thanks again Brian. Found a solution, not exactly the one I wanted, but it works... Copied the query, so I had one for Ascending order and the other for Descending order, then on my form I had a combo box where the user will be able to select which order they want.