Recent content by eka24

Doc Man, you are right it is not licensed. As to Api calls that you talk about, am quite new and therefore have no idea. I guess the license might be the problem as you suggested. Thanks I will work on that.

Thanks all for your contribution. I am considering all your points. I must add that for accdb is fine. It's only when I convert to accde that I am unable to open in another machine.

I have been using docmd.movesize on all my forms it works fine for me. example docmd.move (,,5000,10000)

Please in this case what do I do the references

OK I will check

Please when I create accde and opens it on another computer, it gives error message "upgrade your microsoft access database to the current one, then open the database". However, when I create the accde on that other machine it works. what am i doing wrong as both machines are using access 2013.

thank very much all of you. Richmond's helped me

OK I will try and get back

Please I have a Table "tblSubmission" with Field "ClNo" I found the code on this platform which works fine when make manual entry into the textfield "ClNo" which prevent duplicate in the table "tblsubmission". My Problem: ClNo is a concateated field which derives from three other textboxes...

I believe you my question wasn't clear to you. I have already linked my access to excel which updates when data is changed in access. However queries in my database with NZ Do not appear as part of the queries in the excel. I did some search which point to the usage of Nz as excel doesn't...

Please the objective is the have the query appear in Excel. As it is it doesn't show but other queries without NZ shows.

Please I want to be clear should I replace all NZ with VAL.

Please the quer below works fine but I cant get in excel because of the NZ. Cann anyone help me modify it so I can link it to excel' Payment: (IIf([IncomeExpense]="Expense",(Nz([PaymentAmount]))+(Nz([BankAmount]))+(Nz([Payable]))+(Nz([PaAmount])),0)) thanks in advance

I have been able to achieve what i wanted upon some search with; UPDATE Table1 SET Table1.Field1 = Switch([Field1] Like "Grade1","Grade2",[Field1] Like "Grade2"," Grade3"); I need help on how to achieve same using VBA Thanks in advance

I am replacing the old values with the new ones. Example replace Grade1 with Grade11, Grade2 with Grade12