Search results

Bob, Thanks a lot ! I will try the code tonight! :) Rgds, Atol

Hello, I have a quiery with about 4 to 5 fileds (columns). I would like to export the data to an Excel format (which have about 100+ colimns). The data will fill in just a 4 - 5 columns in Excel (and the rest Excel columns are not changing and no data is feeding to). The question is - can this...

jtff, Try this link and look at the example database; Jon K has a great example on search forms/queries. http://www.access-programmers.co.uk/...d.php?t=103312 Very helpful. Thanks, Atol

Thanks a lot EMP. This will help me a lot.

Hello, I have been searching the forum for this scenario but could not find similar case, which is as follows: I have a Search Form with many Text and Combo boxes, linked to search criteria in a query. There is also a sub-form showing the search results. I am trying to replace one of the combo...

Here is an example....If you select UK, you will see that there is a city Oxford, but same name exists in USA, so in order to destingush I need to put a third combo "continent"... Thanks ! Atol

Hello, I know it has been said a lot on this topic but I could not find exactly this situation in my search. I have a query, which pulls results from many tables. Based on that same query, I have a form with three cascading combos and a list box. The list box however should show results based...

got it. thanks!

Thanks guys. Curtis - I guess form is easier to send via e-mail as a screen shot..., Report is not bad idea; I have also thought about that. Neil - do I use DCount() in a query or as a vba code? never used it before with all honesty...

Thanks Neil. I used "count" since that was what I needed. here is the case actually. I use the same table as an underlying datasouce. I have let's say customers, and they are in two categories (A and B), and also they could be active and inactive. I have separate quieries to do: 1. count all...

Got it. I will try to create such a query; One additional thing - the form will be for ilustration purposes only, meaning no data will be entered. Just if someone is looking for all this data on a regular basis, it will just show up on that form....in the worst case scenario, I will just make...

Hello folks, This is probably no brainer for most of you, but I got stuck. Basically I have created a few queries (some of them just show a number, let's say "total number of active clients, etc). I have a few queries producing similar results; I want to show all those results on one form; so...

Thanks guys. As always I appreciate your help! I actually missed to add in my original post the two important foreign keys to the tblInvestorBond (this is the junction table since one investor can invest in many bond, and one bond can be held by many investors) PK InvestorBondID - this is the...

Hello, I originally put this under "Query" category, but was not sure where actually it belongs... so I aploogize for posting this second time. I need a little bit of guidance with the following. Here is the scenario: two (or many) investors invest in bonds; usually the typical transactions...

Thank you for the fast and valuable response. For sure I will need some time to absorb all those nice hints you provided. I realize that this task is a bit complex since there are too many variables that can change at any point of time - balances, interest rates, picking verious periods, etc...

Hello Folks, I am trying to find a way to calculate a weighted-average interest payment in Access. Here is an example: You have a savings account with changing balance, the balance basically changes every time when you add some cash or withdraw cash. In Excel it would look like this Balance...

fantastic ! Thanks a lot!

That's super ! it did work great....! A BIG help ! another questions, if my column 16 (below) is a percentage, the formula below is bringing in 0.025 instead of 2.5%... Just wandering if there is something to fix this issue. ="LIBOR"&" + "&VLOOKUP(1,Repricing,16,FALSE) Again you helped me a...

Hello, I am trying to use 2 vlookup functions in the same cell (which is fine), but one of the datasource cells is a date; when I run the vlookup, the date gets changed to a number. Is there a way to fix that? I want to see the date, but at the same time I do not want to change the date format...

Well said !..... and all TRUE. .....Thanks again, The Doc Man.... for the wise thoughts and for the encouragement.