Search results

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

No one any thoughts on this any suggestion at all? I am really stuck on this and i have the feeling that the solution is right in front of me but i cannot grasp it.

I am trying to give the user the ability to select the criteria from the combo's and have the records that fit that description appear on the subform. The thing that i do not get at all is why does this approach work fine up until the 3rd combo where all the selections are made and the records...

Yes i see oyur point but i cannot seem to find a proper way to implement this. Any tips perhaps ?

Hello to all ! I have this db where i wantto include 4 and if possible 5 cascading combos where the user can select records from a table and view them in a subform which is in datasheet view. All is going well until i try to add the 4th combo.Then when i select the 4th combos selection the...

Hello this is my first post in the definetely best Access & VBA forum on the net and i hope i am in the correct forum to ask this. I would like to know if there is any way in access to change the size of the for my users view according to their screen's resolution. E.g. i am creting the form...