Search results

Hello Newman, Can you please help me on my query expression? I have this expression working [(WT=THK*WIDTH)/1000*LEN/1000*7.85*QTY] I have two TYPES to evaluate in order to get the weight (7.85 or 8) TYPE: "CS"=7.85 TYPE: "SS"=8 I don't know how to write the IIF statement. Many thanks for...

Hello Newman, Can you please help me on my query expression? I have this expression working [(WT=THK*WIDTH)/1000*LEN/1000*7.85*QTY] I have two TYPES to evaluate in order to get the weight (7.85 or 8) TYPE: "CS"=7.85 TYPE: "SS"=8 I don't know how to write the IIF statement. Many thanks for...

Can someone please tell me how can I change the record source of my report before opening my report. Currently am doing manually change the record source by going to design view and change manually. Any help would be appreciated, thanks, cagay

Is anybody out there kind enough to post a good head start sample db for managing employees with photo included in form and in report. Would appreciate any help and thanks, cagay

Hi!, I would do that by "IMPORT", open your MDB file, while your database window is open, select "FORMS" Object, don't select any form items in it. Point your mouse anywhere in the blank space and then "RIGHT" click your mouse, then select "IMPORT", follow onscreen instruction. Hope this will...

Create your combo box by the combo wizard and drop it into your form header, then just follow the onscreen instruction..(be sure to select the option "Find a record".. Hope this will help you,

Hello Pat, I just want to make some clarification, "Me.SomeField", if I will replace this to one of my table field, how about the other fields. Also I think this code is useful on "required" field.. I just want a code to put behind my "SAVE" button to either save the record/data or no and close...

Well, thank you all guys.. Been trying the code of MJ McAbney, it also tiggers when I click my "AddRecord" button..maybe because it is "beforeupdate" event..I guess I don't need a button, just make my form as data entry = yes..

BeforeUpdate Event Pat, My Access level is very beginner, infact this is my very first DB to make. Can you guide me, what is the code to be use in the "BeforeUpdate" of my form!.. Thanks, cagay

Thank you mousemat, I will try to adopt your approach..

Form - Before_Update Hi SJ McAbney, Can you show me the right code, I don't now much yet in code.. Thanks for your time.. cagay

Is anyone there who can show me a db sample of unbound data entry form. I want to control the builtin auto save of Access, because sometimes I don't want to save the data of my form.. Thanks, cagay