Recent content by PhillipsAndrew

Thanks for that... Playing with this Windows Shell Scripting scares me a little! but I'll give it a go if there's no other way of getting carriage breaks in label text.. AP

Does anyone know how to get a new line in a label using code? I've tried using the Carriage return - Chr(13) and Linefeed Chr(10) characters, but these just generate non-printing type characters. My code looks like this:- strMessage = "Eqpt chosen:" & Chr(10) & Chr(13) & EqptName...

ChrisO, Thanks for the clear explanation - it makes sense.. Similar to the extern and structs used in C.. One more question- if you don't mind... If I change the Type definition to include different data types (eg strings) then in the function declaration what should the 'As' be? According to...

ChrisO Thanks for the excellent example above... could you explain a bit more about the scope please? Referring to your example, I’d like to put the AreaOfRectangle function in a standard module so that it can be called from anywhere (declared as Public). I’ve put the Type declaration in a...

I'm sure you're right... and I'll follow you're advice...

Sorry Rich, I'm not being very clear am I? The scenario I'm talking about is for a hospital.... We have a 24 hour equipment store where staff (nurses & porters) can come and borrow equipment. The idea is they scan the equipment and department so that it is tracked and charged for correctly. For...

I would like to!! The trouble is that I'm trying to allow for every eventuality. I know that some users will come into the equipment store in the middle of the night and just scan the equipment and leave (regardless of what the screen says). I want to be able to handle this so that the system...

I’m looking for some advice on Referential Integrity... I’m designing a database to loan Equipment. The system will be barcode based, but at it’s most basic a user will scan the equipment they want to borrow, scan the department they are taking it to and then ‘scan’ Confirm. I’ve got no...

Thanks for the info... I don't generally have a click event to open the form... I bring up this form (A) with a list box displaying relevant records based on a query, using the list box click event a new form(B) is opened where the user can edit the record they've chosen. If they choose to...

This is probably the easiest thing to solve.. I have a form with its recordsource based on a query. However, when the query finds nothing the form opens totally blank. All list boxes, text boxes and most importantly the close button disappear. I'd like it to display an empty list box together...

genius!! Thanks

I'm trying to requery an underlying form using the form name passed by OpenArgs. There's no problem getting the form name, my problem is how can I use this string in the expression to requery the underlying list when I delete records? Example: strCallingForm = [Forms]![MEC Approval].OpenArgs...

Thanks Travis... I'd just stumbled on this in the help... Trouble is, my query actually has another table (I tried to keep it simple earlier) which has a one to one relationship with PersonInfo. This table (tblAdminControl) contains yes/no fields about authorisations etc... When I change this...

I have a form with a sub form based on a many to many junction table, which works fine. If I don't enter any data into the subform no record is created in the junction tables (as you would expect). The main form is base on a table containing Person Info (ID, Name, Address etc..) The junction...

Thanks, That looks like what I wanted...