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

    Import Condition list values into Business Objects from CSV/Text file?

    Thanks for the quick response guys. kskid - an example would be where i have a .txt file that had one line of values in it (say Job ref number or something) and looked like this 123456,653467,232323,232325.... and so on. I would manually copy this comma seperated list then paste it into a...
  2. supanoods

    Import Condition list values into Business Objects from CSV/Text file?

    Hi, Is it possible to import an existing .CSV/.TXT file that contains vaules straight into a conditions "in list" list? If so - how the heck do you do it? Thanks in advance for any help/pointers! Cheers, Supanoods B-) "If it aint broke - dont fix it!
  3. supanoods

    Close an Excel workbook that is open by another user

    Hi all! Just to let you know that I came up with kinda work around. I decided to go with using the "OnTime" function. I added this code to the shared workbook Auto_Open macro: Application.OnTime TimeValue("00:30:00"), "Auto_Close" The Auto_Close macro (which includes a close command) closes...
  4. supanoods

    Close an Excel workbook that is open by another user

    Hi Bong, The master data file is maintained by a small team (8 users), but the viewer has the potential to be used by 100+ users throughout the day. Refreashing everytime would be too much, plus there is an very high chance that more than one instance would be open at once. Also: Changes to...
  5. supanoods

    Close an Excel workbook that is open by another user

    Thanks combo - i am going to look into it!! Cheers, Supanoods B-) "If it aint broke - dont fix it!
  6. supanoods

    Close an Excel workbook that is open by another user

    Thanks guys for your input. I have written some code since this post that closes the workbook after 30 secs of idle time. So it could be used to catch the users that leave the file open and go home for the evening etc. But this wont help if the viewer is being used at the time I schedule a...
  7. supanoods

    Close an Excel workbook that is open by another user

    Hi all, I have 2 spreadsheets on a network. One is a master data file, and the other is like a "viewer". The viewer is refreshed every night via VBA code from the master workbook. The code simply opens the viewer, copies data from master to viewer, saves both and closes both. The viewer is...
  8. supanoods

    career advise from EXCEL/VBA developers needed

    My previouse company sent me on a .NET training course for beginners, whrn it first appeared, and I was amazed how much there is to it - so if you can learn it - i imagine you will create a lot of oppotunities for your career! PS - I bought a book that specifically looked at using .NET together...
  9. supanoods

    Drop Down/Combo List qestion

    Thanks for your reply but unfortunately this won't work, because the drop down i'm using is a physical control (like a combo on a form only on the worksheet). apologies if I didnt make it clearer in my first post! Cheers, Supanoods B-) "If it aint broke - dont fix it!
  10. supanoods

    Drop Down/Combo List qestion

    Hi guys, I am currently working on an excel program that looks at personnel details. I have one worksheet that has names, addresses, etc and another that is a nice user-frienly front end type of screen. On the user screen, I have added a drop down list and set the entries to a named range on...
  11. supanoods

    2427 error with subform

    I have decided to alter the way in which I was doing this altogether. The main form was reading one .xls file, where the child form was reading an other. I was getting the error because when the child forms source was reading the .xls file and there was a NULL record entry, I was getting the...
  12. supanoods

    2427 error with subform

    Oh forgot to say, i am thinking about trying an err.number =...then... routine, to IGNORE the error, but I am aware that this is not best practice - or is this the only way??? Cheers, Supanoods B-) "If it aint broke - dont fix it!
  13. supanoods

    2427 error with subform

    Guys, I have a form/subform setup where the main form uses a child subform to check if a 'code number' has already been changed. The subform is based on a query, and if the code selected from the parent is not present on the child form, then I get the 2427 runtime error due to NULL value. I...
  14. supanoods

    Contents of listbox do not show upon opening the Db

    I have in the past used a button to sort, as a default within the forms OnOpen/OnLoad properties had a VB cmd to click the button I want, so it is seemless on the forms opening. Cheers, Supanoods B-) "If it aint broke - dont fix it!
  15. supanoods

    Contents of listbox do not show upon opening the Db

    As far as my understanding of 'Me' goes, it makes reference to the current form/report, where as if you need to refer out of your current form/report you would use a full reference like this (in your case): [Forms]![YourForm]![list2].Requery Personally. I use full commands all time - but...
  16. supanoods

    Remove ListBox Scroll Bar

    FANTASTIC!!!! You learn something new every day!! Nice one!! Cheers, Supanoods B-) "If it aint broke - dont fix it!
  17. supanoods

    Remove ListBox Scroll Bar

    I have a listbox that displays 3 columns, which display 3 characters per column. I want to see the 3 columns, and I have plenty of room to display, without needing a scroll bar. However, Access brings up the bar, and the user can click on it to move along each column individually. NOTE: i...
  18. supanoods

    Contents of listbox do not show upon opening the Db

    I might be mis-reading this, and I apologise if I have, but have you tried a requery command of your listbox, on the forms open and/or load properties. eg: Private Sub Form_Load ListData.Requery ' Where ListBox name is "ListData End Sub hope this helps Cheers, Supanoods B-)...
  19. supanoods

    Disabled SHIFT on startup, but can still access data via ODBC

    Not really help this, but a possible alternative.... I am looking to roll-out a multiuser system in the near future, and i'm looking at using Access Run-Time to package up my mdb. This should run like an install wizard, and make my access system 'tamper-proof', and keep code and tables etc...
  20. supanoods

    Form Sizing and Resizing suggestions

    I always use DoCmd.Maximise on the LOAD property of my forms, unless I want a pop up. Personnally I like working in full screens :) Cheers, Supanoods B-) "If it aint broke - dont fix it!

Part and Inventory Search

Back
Top