Recent content by kkgusta

Please ignore this threat, problem fixed Typo

Hi If I have 2 tables Table one has: -ProjectID -BuildID -ScriptID -Script details Table two has: -ResultID -ProjectID -BuildID -ScriptID -Result Query (QryReport) used to generate report select T1.ProjectID , T1.BuildID , T1.ScriptID , T2.ResultID , T2.Result...

Yup got it work. thank for for all your reply

Hi If I have 2 tables Table one has: -ProjectID -BuildID -ScriptID -Script details Table two has: -ProjectID -BuildID -ScriptID -Result ProjectID,BuildID and ScriptID are the primary keys for these table. If I want to find out the scripts that not exists in table two what kind of where...

Hi there, I have created a UDF to calculate some date for my spreadsheet. Now I am trying add more features to my UDF which is every time when I user the function in the cell the selected cell format will be updated to date and the font colour will change to RED. I have been trying to look for...

Thank rjoubert. How about tutorial for customising chart report with vba ??

Hi there, I am trying to learn to create a chart report in Access. However I have no idea where to start and supply data to the data source of the chart. Is anyone here know or have any material that can help me to understand more in creating chart report?

Hi there, Is anyone here know the easiest way to create a save changes before closing an unbound from. Like when you are in an edit or add new mode and you choose to close the form and a message box will pop up and prompt user to save the change before it close the form. Currently I am trying...

Thank Remou

I have choosen to hide my database tables window from the startup option. However if you press the shift key when the database is first loaded the tables window will still open. Is anyone here know how to disable the shift key or hide the tables window completely from user?

Thank The Aceman1, It work again after I re link the table.

Hi yummy7, i have a problem by using the password in fof my dabatase. After i set the password in the access database, i am having difficulty in accessing the database using the set rs = currentdb.openrecordset(SQL) The error message "in valid password" is popping up every time the frontend...

Hi there Thank for your reply, I have tried both solution form Yummy7 and randy700. Both solution are working. Cheers

Yup it is working now. thank alot Zion 7

I have create a simple Access db and froms. Whenever user encounter an runtime error in the from Access will ask user to debug and the vb editor with the related vba code will be display. Is anyone know how to disable or setup some security like password login on the vb editor that limit the...