Recent content by supanoods

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

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!

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

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

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

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

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

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

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!

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

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

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!

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

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!

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