Recent content by jackryan

when multiple user use the splitted mdb, it becomes a little slow, is that ok?

thank you for your explanation, i set my Record Lock Property into Edited Records and it seems that this is really what i want.

sir, thank you for your reply, i tried your suggestion, but im curious when 2 user simultaneously use the same form, only one person can edit the data. is it because of record locking?

hello, im making a simple msaccess database and i want it to be used by about 5 users simultaneously. im using access 2007 but the file format is in 2003. any help please? thanks edit... i'm not using vb for front-end

You can press "Print Screen" key on your keyboard to give a screen shot of your screen then open your Paint application and Click Paste. Save-As- .Jpg Format, then you can attach your picture here. hope that helps

yes you can use our if-then statement If AmountOwing<=0 then AmountOwing=0

any more help please?

Can you try changing the settings on your users computer using your Admin account?

Yup I think opening each report design view and re-setting the default printer will do the job.

Hello, Wayback 2 years ago I think I encountered the same problem, what I've done then was set the default printer properties into A4, on another machine, I found out that the user is playing with the printer settings changing the default A4 into 8.5 x 11, Hopefully this might help you.

I'm sorry if I hasn't been able to reply, I'm at the jobsite yesterday and I'm not able to check your suggestion. I need to reference my Max(SumOfNormal), I'm only curios because why is it that I am able to get my formula to work inside the Report, and not inside Query. I only copy the same...

Hello, Thank you for your interest in helping me on my problem, My Food/Other Allowance calculation is like this there are certain employee that have Allowance, and others have not, now if the employee have no Allowance then [Food]=[Food]/[Days]/8*[SumOfNormal] else [Food]=[Food] then...

I already tried creating an Expression field inside the query and let the query handles the formula, I broke my If-Then-Else statement into 3 parts but I get an error Circular reference by FoodQ

any help please?

hello, i am facing problem with my unbound field Food1 calculation, i can get my Food1 to calculate, but when I created another unbound field Sum_Food1 to SUm/TOtal my Food1, and i run my report, its been asking me for the Parameter Value of Sum_Food1 Food1= IIf([Text78] Between...