Recent content by blu_macey

Hello sir Cj, Glad to know that there are colors in my imagination, heheh I will do my best to develop more in sub forms and controls after I'm done with the queries. I need to know more, heheh Cheers! Chino

Hello experts, Just a question, upon searching the net found an article WorkFlow in Ms Access 2007. My question is, is it really possible to make a work flow in access? And if so, can it be done in Ms Access 2010. Read the article, but can't find any tutorial. Thank you in advance. Your's...

I've been looking for this, thank you for sharing. Keep it up. Trying to understand your Calculator. Cheers! Chino

Yes burrina, I made a copy before splitting, by trial and error, I found out that your right whenever I change the location of the Back End or Front End or Vice Versa the front End won't open, and that's what I'm pretty curious off, cause the front end won't open in a design mode there is...

Hello burina, I'm home, first thing I did was to open the Front End in my lap top,unfortunately it also produce same result. Only the home screen of the Ms Access pop's up. The Front End (form,queries,reports) are missing. I can't open the front end in design mode since after clicking the file...

Thank you Burrina, I will try your suggestion later at home, because the original file is in my laptop, and I'm currently at the office, I only use flash drive to copy the DB. I hope it works. Badly need to make it works. I'll keep you posted. Thanks for your time. Cheers! Chino

I right click the file and here's what I get,can't see where can I enable or disable the file. For your advise. Many Thanks!

Hello burrina, Thank's for the quick response. Please help, how can I enable it? Sorry not familiar with... When opening I click on the enable button (Yellow status bar) is it what you mean? Cheers!

Hello Experts, Once again need your expert advise, I split my data base and place the front end and back end at one folder. In my lap top its functioning properly, but when I copy the folder via flash drive to my Office computer, the front end won't open (.. please see image below), but the...

Hello JHB, here is the screen caps. RunMenuComand came from the print button wizard. I just copied it to other forms. Cheers! Chino

I have a macro that goes like this, OpenReport ReportName = Voucher_rpt View = Print Window Mode = Dialog RunMenuCommand Command SelectRecord RunMenuCommand Command PrintPreview RunMenuCommand Command PrintSelection And then when I hit the button a dialouge box appear with...

Hello Dave and Jiri, Sorry I haven't posted the error message for the 1st example, my bad, Anyway when running the code it says, "Compile error: Block if without End If" That is why I look for a way around. Thank you for sharing your ideas, I'm learning a lot :) Cheers! Chino

Got the answer to my question here... http://bytes.com/topic/access/answers/845378-nested-if-elseif-syntax final Code as edited.. Private Sub Form_Load() txtUser.Value = strUser txtRole.Value = strRole txtFocus.SetFocus 'Set Enabled state of command button based on User...

Hello everyone, Here I am again seeking for your expert's advice. In my database there are three roles namely 1. Accountant 2. Bookkeeper 3. Cashier I have a Main Page Menu form with three buttons, specifically for the above mentioned roles. My code goes like this: Private Sub...

I hope the experts would see these post, for I'm also having this error on my database.