Search results

True, its been running since 2013, 2 times a week they need to save hundreds of records (about 188,000++ to date) so pretty much its almost there and I also told them that after about 10-11 years they need to replace the app but of course due to budget constraints they didn't care that much up...

Hi Doc, Yup one of my local client that distributes nutritional assistance, it was a split DB and after 8 yrs it is now struggling :)

Hi Doc, Agreed!, but for this kind of small app I will not bother to setup a split DB with an open source SQL (if budget is an issue) but truly the 2GB cap is history when using a split DB and SQL. :) We all have experienced clients who are always concern with their budgets rather than the...

Hey Pat, Nice to see a fellow COBOL programmer on this thread, I started as COBOL/CICS Programmer way back on Mid/Mainframes lolz. Anyways, @arnelgp got the drift of what I am tackling and it works as I envisioned! Thanks for your insights and as always "we" as programmers can always find a...

Hi Morgana, I am in the middle of developing a sales & stocks monitoring system for my brother, a simple concept at first and then became complicated as it progress, btw kudos to this thread for members who are always ready to shell out their knowledge. anyways, based on my experience the way...

ok here's a present scenario I am right now, I didn't bother yet to try the code pardon @arnelgp, like you said everything works well when I use the standalone forms with tab control, but when I plugged it on a navigation with (horiz & vert left config) it gives me the dreaded error. I have...

simply wow! exactly what I wanted! Thanks a lot @arnelgp!

Thanks Arnel, it works logically on a single nav, but below is the screenshot of my form (Horiz & Vert Left Nav) the problem I am facing is I want the "Add New Product" and "Edit Product" either be disabled or hidden including the "subforms" so the user can only navigate/click the "View...

Hi Pat, I got your point on this, but what I am trying to accomplish is what my professor in PROG/SAD class always taught us "never give/show an option to an unauthorized user in your program/application..." for there will be more questions/explanations involved plus it is not a good practice...

Hi Arnelgp, I tried your approach but doesn't seem to get the job done, it will work initially when the logged user is not allowed to view the "subform" under the navigation tab, but when an allowed user is the active one, I need to click that navigation tab to show the "subform", what I need...

Hi, I am now having the same problem, on my Navigation Form when a user clicked a button it automatically shows the "subform" associated with "Navigation Target Name", now I wanted to disable this "subform" based on User Roles, others tab are ok to play with are there any solutions to this one...

Hi Guys, I am having difficulty trying to figure out how to deign a field using a single combo box, below is the structure: Field: Ethnic Background Possible Selection(s): - African/American - Native American - Hispanic - Caucasian - Pacific Islander + Chamorro + Palauan + Yapese...

@David, I do visited your Wiki for quite a while even before starting this project, yes it does work perfectly on a WIRED LAN, but then on the other hand (WAN, Off-Site, Remote replication) it's not, I know it's my design or maybe its not the way to solve this problem I am facing. Well I was...

Wow, great insights! Thanks guys. I've been working on replication for 2 days, but the BE seems to bloat every now and then, I can't seem to find a sample update module or macro (if you will) to try it out, I am begging everyone to pls. show me a thread or a sample to get me started. Thanks...

@pkstormy & HiTechCoach, Thanks for your insights, I wanted to do remote connection but the problem is their budget, as I've said they are non-profit org. and a budget for remote access is off the table for now. I do appreciate it much if can give me insight on the other possibility of...

Hi Guys, I need all the help, again a non-profit org. asked me to create a DB that can house information to all its clients. But the catch is that some staff needs to go on-field service and needs the DB for editing and/or adding new records. I never tried replication & synchronization so it's...

Hi Guys, Nice to be back again, as always I am in need of help :( I have 2 tables namely: JobVacancies & JobCandidates both of which has common memo field type, AvailablePosition for JobVacancy & PreviousPosition for JobCandidates. Now I want to create a query to search the available...

Hi guys, Sorry been out for a while, anyways I managed to deploy the HRMS it's been stable so far. I'm sorry for not posting the screenshots but I will try to squeeze some time to post it to get someone off the hook when get stucked. As far as I am concern, for beginners I agree to Bob in...

Hi Guys, I have this problem that really took meoff the hook for quite sometime now, I almost surrender on this task, so please bear with me and your HELP is really appreciated. Here it goes.... I have a table which consists of DB Users (User Name, Password, User Level), also a table for...