Search results

I have converted my 2003 Database to access 2010 og the data base is working fine, but when I wanted to make a macro and use the "before change feature" this is not possible because its greyed in the ribbon. I also tried the import all objects into an empty 2010 database but status is the same...

Thanks a lot Stuart for your assistance. Unfortunately I cannot make it work. I have attached a simplified version of my DB. I want as follows: 1 to M between Projects & Quotes 1 to M between Quotes & Deliveries 1 to M between Quotes & Suppliers I want all the M subforms shown in Datasheet view...

Hi. I have a one to many relation between a main form and a subform. Now I want to make a subform on the subform also in a one to many relation between the 2 subforms. I want to have both subforms shown in datasheet view. I cannot make this work. Appreciate any assistance. Thanks in advance.

Thanks , to both of you . It works fine.

Thanks for your reply. Sorry I do not get what you mean. Please can you show me in attached sample of my database. See former thread. Appreciate very much. Thanks

Please can someone assist me in this ? I need to find the difference between 2 dates.(Planned & Realized) It has to be Realized minus Planned. I would like a querie to write the difference in days when I open it. Attached is a sample database with a table and a Querie. Highly appreciate if...

Sorry but still not reached the goal. [Project No] is text field but once I use below string stLinkCriteria = "[Project No]='" & Me![Main Project Data].Form![Project No] & "'" Then I get the message, cannot find the field "Main Project Data" which is referenced to in the expression. The...

Thanks for quick reply. I cannot make it the way I want. Below is the code I currently use which opens my second form in filter mode. I want it just to open on the same Project No as I make dobbel click on in my primary form. On Error GoTo Err_Kommandoknap32_Click Dim stDocName As String...

Hi. please let me know if anybody can help me a bit on this one. I have a form with several records. Project No is my key. Once I have selected the record that needs to be worked on, I want to be able to open another form which have all the details. I do not want to use the filter mode which I...

Thanks for your answer. That works but can you tell me how I easily can add a new Project no in all tables. Once I import a table which have had a new project no added in the department where it comes from I have to be able to fill in informtation to the other tables from the common form.Before...

I have 5 tables which comes from different departments in our company. All of them have the same key "project no" but hold different information in other colums. As a starting point I have secured that they all have same no. of records meaning all "project no" are in all tables but some table...