Search results for query: *

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

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

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

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?

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

Hi there, I am wonder is there any easier way to re arrange the position of all object in a form based on the size of the screen.

Hi there, Is anyone here know how to create a mirror textbox? For example. I have a small textbox for user to enter comments or notes. I also wanted to create another cmdbutton that allow user to open a popup form with a big text box that allow user to edit their notes and every changes that...

Hi there the problem. I am try to add a new data to the "actions" table with the following code. However I kept on getting error message when some of the ID field is null. I hope someone here can help me to solve the problem. The error i got is Run time error '3421' Data Type conversion error...

Hi, I am trying to create a cmd button to remove the selected record from a lisbox. However the following code i use is only allow me to delete one record. Can someone here know hoe to fix it ? Sub RemoveFromList(RemoveList As Access.ListBox) Dim varlistItem As Variant For Each varlistItem...

Hi there, I have created a multicolumn list box to allow user to select multi record and save them to the Project_script table. When the user click the cmdAllocateScript button the system will also pickup the record that already exist in the Project_script and only save the record that have not...

HI there, Is anyone here have any example or have any idea to open an excel worksheet from Access using a Command button. I have a table to store the hyper for the excel work sheet. Thank in advance,

Hi, I wanted 2 multiple column listboxes and when I double click a record on on listbox and it will automatically add the selected record to the other listbox. Is anyone here have any idea or example on how to achieve this?? Thank in advance.

Hi I have created a listbox to display the details form a table and I have also created several textboxes to display the details of the data that currently selected. However I have having trouble in choosing the right event to place my code to update the details in the textboxes when I select...

I have created a search button using the Docmd.OpenReport code get the report I want. however if i wanted to search for a new report with different conditions and I forget to close the previous report, the docmd.openreport function will only bring the old report to the front and will not allow...

Hi, I am trying to pass the values from a user form(datasheetview) to fill up the related textbox in the search form where people can get the user details and generate a customize report. For example when user double click on a particular row of data on the user datasheet view form, the...