Search results

I will give it a try. Thanks!

Hello guys, The newbie needs your help once again, I do have a Update query wherein i have a criteria involving a "SumOfQty" . However, it prompts me with "Operation must be an updatable query" error. I tried to change it with the field "Qty" from the table and it works fine but i need the...

thanks for the reply. my problem is the table and the data are already existing. it's too complicated to me to reformat everything :(

a component can be made in different machines, however a program code/number should always be unique. Hope i make sense :)

Hi guys, Need help! I am just making a simple form on entering components with program numbers on different machines. In adding a new record, how can it prompt me if the new machine number i am entering on either machine1, machine2 or machine 3 is NOT a DUPLICATE program number(compared to...

It worked. Thank you so much! I really appreciate it :D Have a great day. . . . .

It worked. Thank you so much! I really appreciate it :D Have a great day. . . . .

I will try it later :)

Hi Guys, What do i need to add from below codes in order to prompt "Record not found" in case of no match on the database? I feel its an IF then Else statement but dont know how to apply :(...

I created a form wherein i can do a keyword search by JobTraveler number using a textbox and add a button to run the report. I did use parameter criteria: Like "*" & [Forms]![F_SearchForm]![txtJobTrav] & "*" it works fine as a form but after i added it in the main form(as Navigation) the...

Hi everyone, Im glad to be part of this community. Im a beginner in access and hope to learn more from here. :)