Search results

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

Have a read through : Early vs Late Binding

i would highly suspect this so yes....install Access 9.0 Object Library on the Vista machine and try running again

create a macro called autoexec which automatically runs when the database is opened, then in the macro add a command to open a 'user' form. in the user form on the load event, compare currentuser() against your table and perform any actions that your user table requests

have a group query with no grouped field, then for each field that you want to check have the following iif expression: Sum(iif([Field name to check goes here] Is Null,1,0)) if the field is blank (null) it will return a 1 if it isnt blank it will return a 0, then we add up all the 1s :D

I had realised that Bat17 but wanted to give the idea of how it may be done and let him work the rest out for himself rather than do it all and for jomiur not to learn anything