Search results

Hi, Is this probably a wrong way to do the tree ctrl view - please give suggestions. Thanks, Priya

Hi, I am trying modify my forms so that I can display data like a tree view. I have a mainform and a subform. The source of the subform is a datasheet view of a query which has children linked to it. I have attached a snapshot view to this post. How do I access a field in the child in the...

Hi Dave, Thanks for the sample. The sample only allows for 2 levels on the tree. I have a situation that could have upto 8 levels and the data is contained oly in one table as given in the employee table. Am I missing something from your example - can it also be used for multi levels...

Hi Dave, Thanks for the sample. The sample only allows for 2 levels on the tree. I have a situation that could have upto 8 levels and the data is contained oly in one table as given in the employee table. Am I missing something from your example - can it also be used for multi levels? Thanks:o

Can any body help please? Thanks

Hi, I am having trouble in implementing the TreeCtrl structure. I have a simple database for testing purpose and I am not able to make it work. There appears to be a problem with the bookmark property and I get an error message: "can't Add child:Arguments are of wrong Type, are out of...

Thanks...I will change all my front end queries. Priya

Hi, I am really sad that all my previous posts have gone..didn't ever think this could happen. Anyway, I did get my Access to SQL server conversion done. All "Yes/No" fields have been converted to a byte. This has got rid of the "-" in the "-1" field which corresponds to "Yes" in Access. My DB...

You need to set up a query to supply the required details to the report. In the query, accept a parameter either from a form or from the user directly. If the user is going to run the report directly, you can code in the criteria in the query. Use between [Enter start Class No] and [Enter...

Thanks a lot...that's a brillliant idea. :D

Hi, I think the question has been misunderstood. There are 2-3 users to the system and each of them have their own front end. I want the first user to load the tables when he or she logs on. The code for loading the table is in the Form Open event. Subsequent users who logon should not repeat...

Hi, May be a silly question...I need to be able to run some initial processes (table load etc) when the user first opens the database. Subsequent users need not do this processing. How do I accomplish this within the form open module in Access :confused: ? Thanks, Priya

Should it be IIF([....])?

Any one able to answer this...help needed please. :confused:

I am in the process of upgrading Access b/e to SQL b/e using .mdb and linked table as the front end ( as given as the best solution in many of the posts). I remember reading in this forum ( Comment made by Pat Hartman) that forms should be based on queries rather than using a filter criteria...

Thanks Pat...I'll have a look. Priya

Does it mean that this is a limitation of a continuos form??- :confused:

Hi, I have scanned through the forum but have not found an answer for the above.. How do I do a requery only for the combo box of a particular record in a continuous form? To be brief...the user has to select the pimary sector for a project . After, this, I want the next field to show up all...

Thanks Pat...It worked well. Cheers, :D Priya

Hi Dean, The code is giving you a compile error. The structure of the IsLoaded statement is incorrect. See eg: If CurrentProject.AllDataAccessPages(strPageName).IsLoaded = False Then ... You may have to say If forms.frmusers.Isloaded = true then... Thanks, PH