Search results for query: *

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...

Hi there i have create an Access Db and an Access Front end where all the forms and reports are located. The from and report in the front end have link table from the access db. I have set up a security in (login adn password) on the from end. However I dun know how to set security on the...

We would like to know if there is a way of identifying duplication of records in an Access Table Below is the code that we have use to import record into an Access Table Private Sub Command28_Enter() On Error GoTo Command28_Enter_Err Dim strpath As String strpath = Text29...

PHV suggestion is working well But is not exactly what I need. I am current using the auto center function to allign my screen. I will try CautionMP's code later.

The reason i put the code in form_load is becasue I wantedo set the the correct location for all the objects when the form is loaded and it will not change until the user close the form. I also wanted maximize the form everytime loaded. However the code I am using is unable to give me the exact...

I have tried it but it still not working