Recent content by stallyon

thanks for this. all i needed was a component cable. bought one this weekend, connected it up to my plasma tv and set my wii to run on HD mode. jobs a good un :D cheers and that

shouldnt it read: CustomerID = iCustID rather than iCustID = CustomerID

I've heard of ACT but never had the fortune to use it. When you set your tables up did create a relationship diagram, and if so, did you join the tables together with cascade update or cascade delete set? for future checks, add fields to your tables which has a Now() default value. this will...

change the LastName_LostFocus() to an AfterUpdate() event

but to answer your original question. add all the fields as if you were creating a bound form. then select all the fields on the form, with all fields selected type any letter into the control source for the fields and press return. all fields which change control source to that you typed in...

left() mid() right() and instr() should do the trick

How do i enable the HDTV setting on my Wii? My TV is HDTV ready but the HDTV option on my Wii is disabled...do i need a cable or something?

rather than click the field and do a search, click the filter by form icon, select the field to search and type IS NOT NULL, then click the Apply Filter icon

do you have any code that saves the record or refreshes the recordsource?

decompile it, check all references point to valid files, compact and repair then retry

I think wrappnig the openargs in brackets should work: Forms!(Me.OpenArgs)!toField = writeValue

in the Input Mask of the text box type in 99/99/99;;_ or 99-99-99;;_

One problem i can see with this is query runtime. The DMax() Function would run for every record. This aint so bad if you have an index on the fields you use in your DMax statement but if you dont you could get into some serious lag. Best option would be to write a piece of VBA code stepping...

you can check who has logged on using the in built CurrentUser() function.

if the unique product reference (UPR) is indeed unique then you can link the source and destination table together via the UPR (select the UPR on the source table and drag onto the UPR on the destination table), double click on the line that links the 2 fields and select option 2 to show all...