Search results for query: *

Hi Gang, I forgot to mention I am using the DoCmd.SetWarnings True and false. The thing I am looking for I think is something like db.execute "Queryname" But there is some other stuff that goes before it that stops the warning messages. Thanks again, Kenny

Hi Keith, Thanks for your reply but I forgot to mention that I already had the SetWarnings on and off lines in my code. The thing I am looking for I think is something like db.execute "Queryname" But there is some other stuff that goes before it that stops the warning messages...

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

Hi Jimmy, Many thanks for the reply and taking the time to help with the above code. I am sorry that I have not replied until now but I have only just had a chance to try it due to work commitments. I am sorry to say that the dreaded "kenny" factor has kicked in (what ever I try I...

Hi Robert, Many thanks for taking the time to reply, I appreciate it. Your comments contain some good advice that I will make sure to follow. Thanks again, Kenny

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

Hi Lightning, Thanks for your reply, this is a most frustrating problem and I appreciate your help. I tried your suggestions but I still get the same error message from the same line of code, EG: Run-time error '450': Wrong number of arguments or invalid property assignment" and the...

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

Hi Doug, Many thanks for your reply, I am grateful for all the help you guys give in here but looking at your code gave me a right headache (heh heh), very complicated stuff. I think the problem is I did not explaine my needs very well. I may well be wrong but I think your code adds up time...

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

Hi Michel, I will give your suggestions a try but i am not sure if my VB-A knowledge is up to it. Thanks for the suggestion. Kenny