Recent content by pikou

Thank you very much for your prompt reply this is exactly what I needed.I wanted to ask a couple of things though if you can spare some time. On this expression (StudyPriceBalance: Nz([ERGO].[STUDY PRICE])-Nz(StudyDeposits)) what does the (Nz) represent ?I checked the MSDN site and the...

Hello all, I have ran into a bit of a problem with a database of mine that is for an architectural firm.I have 3 tables in total.They all have a relationship between them and the main table is ERGO.This table has general info about the work that the company has undertaken on behalf of the client...

The problem is tha the combo box is based on a query from a table let's say Clients and on that query I take the fields (last_name,first_name,id) , concatenate the last_name and first_name so tha the user sees on the two column combo box (last_name & " " & first_name,id).I need the user to see...

Thanks that helped me a lot !!! Now what I also want to do is to be able to insert a button on the form the will open up a form linking combo box.column(2) with a field on the form that will be opened. Any thoughts on that one , let's say that both fields are numbers. Thanks again :)

Hello everyone, I have a combo box on a form tha displays information based on 2 columns from a table.What I want the combo to do is to allow the user to select the row he wants and for the field that is bound to the combo box to store the outcome of collumn1 + collumn2 (string values). Is this...

Hello everyone, I have a combo box on a form tha displays information based on 2 columns from a table.What I want the combo to do is to allow the user to select the row he wants and for the field that is bound to the combo box to store the outcome of collumn1 + collumn2 (string values). Is this...

Hi all, I have a form tha is based on a table and a subfrom on another.The two tables have a valid 1 to many relationship and all is well record viewing wise. Now I have some financial data like the fee that was agreed upon on the main form on a text box .On the subform the user can enter the...

Hello everybody, it's been a while since i wrote on the forums and yet again I am in the need to ask for the help of this wonderful community. I have a form on which is a button that I want when pressed to open a Windows Explorer window displaying the contents of a directory. The exact way that...

That is the problem.The tools -> startup options menu is not there anymore.That is my main problem cause i can enable the db window from a button i have but cant alter tha startup options.Plus all tha right click mouse menus do not work either.

I have actually disabled the menus from the startup options so maybe that has something to do with this ? If so what can i do to re-enable them ?

Well it was all going well until i tried to run the form and got the message to reset my toolbars.I answered OK but it dooe nothing and i noticed that the title of the MsgBox is "The application cannot find the toolbar Visual Basic" and then nothing everything is as it was before. Any thoughts...

Thx a lot very good work. Oh and yeah i kinda screwed my acess up heehe :)

Hello i would like to ask if there is any way for me to enable the menus , the menu bar and the database window if i disable them from the startup options of my Db ?

Well i have tried anything including Rural's thoughts on the matter and still nothing. This cannot be right I mean i should have found something up to now at least what is causing the problem. Is there truly noone that can at least take a look at the problem?

Come on guys someone must have some ideas on this problem of mine. Come on VBA gurus come out , come out whereever you are ....... :)