Search results for query: *

Hi all, Does anybody knows how to stop On Current Event? I have a loop under On Current event which will keep looping until time >= 9.00 a.m. When current time reach or exceed 9.00 am I want to stop the looping under the Form's On Current event.I've tried to put the coding in the On Timer event...

Hi All.... I have a system which record test sessions. I need to automatically CLOSE the test session if the date for that particular test session is equal to today's date and the time is 9.00 am and above. So...I put the code in the On Timer Event for the Sign On Screen so that when the user...

Hi all... I have a program that requires to open the recordset of a query where the query has a few criteria. This is the coding: dim rstQryEmployee as DAO.Recordset set rstQryEmployee=CurrentDb.OpenRecordset_ ("QryEmployee", dbOpenDynaset) The above codes works fine...

I need to add certain data from Table A into table B if and only if the data in table A does not exist yet in table B. The problem is, when i use the DO UNTIL Loop, The 1st data in table B that doesn't match the 1st data in table A is consider as UNMATCH data by the system although if that data...

Hi, I need to copy data from one table into another table and manage to do this if the destination table is blanks.When the destination table is not blank anymore(contains the first time copied data from the main table), then I want to add new data in the main table into the destination table...

On opening one of my forms I have a combo box in one of it's subforms that occasionally will not dispaly the value for the linked criteria it is opened with. It will flash for a split second then disappear. It is also quite whimsical , sometimes displaying sometimes not. The query for this...

Hi........I have this code under my FIND button. It works fine. Then just now I refresh the data in my link tables. After that this code does not work as it suppose to..... This is the code: Private Sub btnFind_Click() On Error Resume Next Dim ssql As String Dim scriteria As String scriteria =...

Hello.... I have a form that is bound to a query that are build from another query. When i open up my form.....an SQL statement based on that query will run....and the form will be displaying only the required data......... My problem is that.....some PC can go through this process (the opening...

Hello.... I have a continuous form that contains 2 comboboxes. User will select the job number and subjob Id from this combobox then when they click FIND button, The list of jobs and subjobs will be filtered to match the one specified in the comboboxes. The find function works fine....what i...

Hi.... Anybody knows how to lock the DELETE button function and the BACKSPACE button function on the keyboard? I need to disable these two key stroke so that the user can only do the deletion by clicking the Delete button on the form.....I have to force the user to use the delete button on the...

Hi..... I have a form that is bound to a table...let say table A. Table A contains only the current budget data. The previous budget data are moved into a history table. What I need is for the form to display all the current budget information plus the one field that contains the previous...

Hi, I would like to add a control in the form that allow users to carry over the existing record into a new record. I really appreciate if anyone can answer this question. Thank a bunch.

Hi, I'm new in Access. hope can help me. I've created one table contains: ID Description DivENG DivSRD DivSBD DivIPD ----------------------------------------------------------- 1 description 1 _/ 2 description 2 _/ _/ 3 description 3...

Hi... i'm using Len function to count the number of characters that the user has entered in several textboxes: totalChar=len(text(1).text) + len(text(2).text)+len(text(3).text) me.txtShowTotal=totalChar The problem that i encountered is when the user key in the 1st letter the counting did'nt...

Hi.... How to run a non visual basic executable file from a visual basic executable file? For example, i need to open another application from my visual basic .exe file.....

Hi... Can i change the data type of a field using a query expression? If can then how to do it? I have a field with a text datatype (in access table) to be change to numeric datatype so that it can link to another field in another table (not an access table)where the datatype is numeric.

HI.... i have developed Access form that is bound to a query. The query has a Mid([]) and Left([]) expression that i use to rearranged a string of numbers position. The query runs OK from my PC (windows 98 and office 2000) and some other PC. But there are many PCs that gives error when i run...

HI..... I have a data grid to display all the data in the Access database where the user can edit these data. One of the fields in the Access database is in the Yes/No format, meaning it contains a checkbox. My problem is...when the data from the database are displayed in the data grid the...