Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wm2005

    Location of relationships

    Thanks Lupins.
  2. wm2005

    Location of relationships

    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...
  3. wm2005

    Locking hidden listview columns

    Legendary! Your too kind, thanks.
  4. wm2005

    Locking hidden listview columns

    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...
  5. wm2005

    Locking hidden listview columns

    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
  6. wm2005

    Locking hidden listview columns

    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
  7. wm2005

    Use Transaction Property

    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...
  8. wm2005

    Use Transaction Property

    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
  9. wm2005

    A hypothetical question...

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

    A hypothetical question...

    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...
  11. wm2005

    A hypothetical question...

    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...
  12. wm2005

    A hypothetical question...

    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...
  13. wm2005

    A hypothetical question...

    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
  14. wm2005

    ListBox Headings Nightmare!

    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" '...
  15. wm2005

    ListBox Headings Nightmare!

    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...
  16. wm2005

    ListBox Headings Nightmare!

    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...
  17. wm2005

    Help with a TreeView

    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.
  18. wm2005

    ListBox Headings Nightmare!

    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...
  19. wm2005

    How do I use MS Chart?

    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...
  20. wm2005

    How do I use MS Chart?

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

Part and Inventory Search

Back
Top