Search results for query: *

I am calling an action query, that moves records from one table to another, from a buttons OnClick event. The query works fine but Access being Access throws up the standard error message. I know that there is a way the the messages can be turned off while the query runs but I have forgotten...

I am calling an action query, that moves records from one table to another, from a buttons OnClick event. The query works fine but Access being Access throws up the standard error message. I know that there is a way the the messages can be turned off while the query runs but I have forgotten...

Please excuse me if I go in-depth on this but I want to give you all the facts so to save time later (no pun intended). Adding Up A Range Of Time Values - Im In A Mess Is there a function/query that will add up a range of cells on a sub form that contain time values in MM:SS format, for...

Please excuse me if I go in-depth on this but I want to give you all the facts so to save time later (no pun intended). Adding Up A Range Of Time Values - Im In A Mess Is there a function/query that will add up a range of cells on a sub form that contain time values in MM:SS format, for...

Please excuse me if I go in-depth on this but I want to give you all the facts so to save time later (no pun intended). Is there a function/query that will add up a range of cells on a sub form that contain time values in MM:SS format, for example: 00:30 + 00:30 = 01:00 (1 minute) and then...

Hi, I would like to explore the use of some of, what I presume to be, the ActiveX controls that can be found under the "more controls" button in Access 2k's Form Design. My problem is, I just would not know where to start. There seems to be no documentation anywhere. I have searched...

How reliable or accurate is the MS Access 2000 “Table Analyzer” wizard at splitting tables with duplicate data ? I have table in a inherited db that has hundreds of dup’ records but as the table as a whole has over 17000 records with 12 data fields per record, I am very loathe to start messing...

I am having problems refering to a field or control on a subform. What I am trying to do is this: I have a main form called [FrmItems] and 2 subforms [SubFrm1] & [SubFrm2]. Both sub forms are displayed as datasheets and on [SubFrm1] is a field or control called [ItemID]. I also have a button on...

I am having problems refering to a field or control on a subform. What I am trying to do is this: I have a main form called [FrmItems] and 2 subforms [SubFrm1] & [SubFrm2]. Both sub forms are displayed as datasheets and on [SubFrm1] is a field or control called [ItemID]. I also have a button on...

I am having problems refering to a field or control on a subform. What I am trying to do is this: I have a main form called [FrmItems] and 2 subforms [SubFrm1] & [SubFrm2]. Both sub forms are displayed as datasheets and on [SubFrm1] is a field or control called [ItemID]. I also have a button on...

Is there a function/query that will add up a range of cells that contain time values, for example: 00:30 + 00:30 = 01:00 and then display the results in a txt field on a from. I have a subform called frmtimes and a txt field called txttime. The subform displays records based on a table and the...

Is there a function/query that will add up a range of cells that contain time values, for example: 00:30 + 00:30 = 01:00 and then display the results in a txt field on a from. I have a subform called frmtimes and a txt field called txttime. The subform displays records based on a table and the...

Is there a function/query that will add up a range of cells that contain time values, for example: 00:30 + 00:30 = 01:00 and then display the results in a txt field on a from. I have a subform called frmtimes and a txt field called txttime. The subform displays records based on a table and the...

I have a form [frmMain] that displays a subform [subfrmData] which in turn displays a set of records based on a query. I have been trying to work out a way of Access selecting which ever record I decide to highlite using the record selectors and then Running ONE of a further set of two other...

HELP - I have been trying to cure this problem for a week or so now andits driving me mad. Forgive me for going into detail but I want to makesure I state all the correct information.I have asked in the relivant news groups but so far my post was either not asnwered or the ***TWO*** answers I...

HELP - I have been trying to cure this problem for a week or so now andits driving me mad. Forgive me for going into detail but I want to makesure I state all the correct information.I have asked in the relivant news groups but so far my post was either not asnwered or the ***TWO*** answers I...

This subroutine below was written for use in continuous forms where you want to sort and then re-sort the columns by clicking on their headings (as in Windows Explorer)and came free from the Aldex software site. I am trying to adapt it for my own use and failing terribly. I am trying to this...

HELP - I have been trying to cure this problem for a week or so now and its driving me mad. Forgive me for going into detail but I want to make sure I state all the correct information. I have asked in the relivant news groups but so far my post was either not asnwered or the ***TWO*** answers I...

HELP - I have been trying to cure this problem for a week or so now and its driving me mad. Forgive me for going into detail but I want to make sure I state all the correct information. I have asked in the relivant news groups but so far my post was either not asnwered or the ***TWO*** answers I...