Search results for query: *

Hi YA Had exactly the same problem but managed to fix it by starting a new DB and importing all the objects and compiling the code. having done this I was able to create an MDE (also previously impossible) and use from the RT version of access. It might help you out Good Luck Phill

Boot MAgic rocks, it come with Partition MAgic :) Phill

Menu - format - Conditional Formatting (A2k onwards)away you go Phill :)

Hi Jim Cheers for getting back. The DB is currently using the almost exactly the code you suggested but my main problem is one of resource conservation. The Form has three sub-forms all displaying standard time slots and used for static bookings for the selected date on the main form. I have...

Hi I've been developing a app that requires text boxes to be placed of the form according to time and place of booking, I remember reading that it waas not possible to create a control array within Access. Does any one have any experience with anything similar. If it isn't does anyone have a...

Thanks Ed Phill

how many twips in cm? cheers phill

Hi DB People I'm a bit lost . I have two tree view controld one populated with students and one classes in order to make our coleges enrollment system simpler I want to be able to drag a student node from one treeview into a class node of a treeview. The student node contains the StudentID as...

Hi Toptech The simplist way would be to put a limit on the count of records in a tbl you could use dcount and if the returned amt is greater than x display a warning message. I do this with demo versions of my product limiting the amount of clients that are able to be stored to 50. Hope t...

Hi there i'm writing a function to split an address block (the sort of thing you might find in an e-mail) into seperate address lines. Rather than re-desiging the wheel I wondered if anyone has got such a thing. Cheers Phill

Hi Frink I would really appreicate getting a look at your coed as well if you've got the time could you mail it to chilledproduce@yahoo.com Cheers Phill

I've been doing something a bit similar but have founf that I have to fill the VAriable pass word with the .value property not the .text eg. If Me.txtPass.Value <> GetPass(Me.cboStaff) Then STatements End if Might Help ? cheers Phill

I got the same problem a couple of weeks ago. its an A2K bug, I got the soloution from MSKnowledge base. You hae to create a new database then import all the objects you created from you original over to your new DB. You'll have to re-register your references and Active X controls. Hope it...

Hi Guys This is probley quite simple but I can the only solution I can come up with uses loops all over the place. I have two tables One listing all available values and another that contains a sub-set of these values. I'm creating a form which will work much like the query wizard in Access...

Hi Ya, I'm having a nightmare with some reports that need to be LAndscape. I set the relavant settings in page setup but they are not saved the next time I open Access? Any Ideas Cheers Guys