Search results for query: *

Thanks Lupins.

I have two backend database MDB's on a network being accessed by multiple MDE frontend applications. The data in the two backend MDB's relate to each other. So I have had to setup the relationships in the frontend app. But of course the tables linked from the two different databases wont...

Legendary! Your too kind, thanks.

Its true, this is a little unstable. I suppose the other solution would be to store an array of values taken from the database, and only populate the fields I want displayed in columns on the listview. Thereby interacting with the array instead of the control for getting at record IDs etc...

Thanks Zameer. That works, though will need some tweaking to make it usable on multiple listboxes where the hidden/locked columns are more than first two. I guess I could use the Tag property for this. Will

Does anyone have a clever idea on how to easily lock a listview column? Obviously setting its width to 0 will hide it, but still allow the user to resize and see its contents. Any help most appreciated. Will

Hi Crowley. I couldnt say. Im just interested in getting the maximum performance out of my database. As such I always run my select queries in 'snapshot' mode wherever I dont need to update the returned records, and set locking to 'no locks' if possible. And for action queries, Im thinking...

Afternoon all... Does anyone have any 'best practices' they would like to share in terms of using action queries? In other words, when should you, and should you not wrap your query in a transaction by setting this property? Will

Thats great, thank you for your insight, it really is appreciated. Will

I see. Thats enlightening, thanks Jim. Thanks Lupins. So I guess you could say that if using a shared access backend its best to connect to it via DAO rather than ADO, and if connecting to any other database (eg MSSQL or MySQL) then ADO connections would be better suited. You see I always...

Sorry for the delay in replying, I was away over the weekend. I come to this from a web background and have used action and parameterised queries stored in the backend for some time, all accessed via ADO execute commands (and snapshot, read-only recordsets where necessary). Now Im new to...

Firstly thanks for all your comments everyone - much appreciated. Ok Im just playing devil's avocate here, but there may be merits to having the queries shared backend. 1. Security By not storing queries (or tables) in the frontend, and encrypting all the other objects into an MDE there is no...

In a multi-user file-server split access database, is it better to store the queries on the frontend or the shared backend, and why? WM

Why on earth have I not used the ListView control before... Dim l As MSComctlLib.ListView Set l = Me.lvwTest.Object With l .View = lvwReport 'Add Headings .ColumnHeaders.Add , , "Name" .ColumnHeaders.Add , , "Surname" .ColumnHeaders.Add , , "Address" '...

Good point. What I should have said is that I am populating the data manually (call me crazy) via an ado connection from a remote database. For control of data flow, and more importantly near bullet-proof security I dont want any link to the data in the client application except for what is...

Thanks for your input chaps. Eupher: Long story... The native ListBox is limited to 2048 characters when in ValueList mode. Gol: Im in Access 2000 using MS Forms 2.0 Object Library. AceMan: I dont want to bind to a recordsource (I guess thats the long story, and I've probably programmed...

Store the ID of the record in the Key (or Tag) property of each node when populating the tree. Then on the NodeClick event of the TreeView control interrogate the Node.Key or Node.Tag properties of the selected node and there you put your record open code.

Please please help me, Im banging my head against the wall on this... I want to use the MSForms (version 2) ListBox control, on a form, but I cant set the headings via code. I can only populate the rows. I add a row thus: Me.lstTest.AddItem "Hello" And turn on headings...

Ok Ive answered my own question... To get MS Chart and Graph controls you need to add the tool to the toolbox... In design view goto: Tools->Customize->Toolbox ...and drag the "Office Chart" icon to your toolbox. The Chart Wizard should open when you add the control to your form. Select data...

I have added an explicit reference to "Microsoft Office Chart 9.0", although the control doesnt appear in the toolbox in design view, I can browse the ActiveX controls and add one to the page. However I cant access its properties via code its just coming up as an active x object woth generic...