Search results

Yes it will! I already have the figures up till May in a spreadsheet - I can manually enter the May sales to date and then at least I'm up and running for the rest of this year and ready to go properly next year... I'm stupid for not having a salesdate field really. Thanks for your help on this...

Ok well I've added a date field now that populates on insert. Bit late I know..

First I ought to explain that I'm really bad at this - so you're very welcome to call me an idiot...and I think I might have misled you. I don't need to store the MaySales value in a table - it was just something I tried in the process of trying to make it work. The business concerned is an...

Hi there! The MaySales field is in the subform and it's control source is a table.

Please help - I'm pulling my hair out! When I get a sale I want to check which month it is and add the amount to a field. I have a field for MaySales, JuneSales etc so I'll use similar code for each month, changing the month each time. I'm currently doing this on the 'on exit' event of the...

Thanks John. :)

Hi John - thank you for your help. I am using Access 2000. I did do a search in Google for this and found that the warning cannot be disabled. http://support.microsoft.com/?scid=kb;en-us;291912 There is a workaround but it isn't appropriate for me. I didn't think to check whether the 2003...

Hi again, Thanks but playaudio.zip didn't work for me. For some reason I cannot put a wmp control in my form (Access locks up when I try) and I think this example requires that there is such a control. It wouldn't work anyway.. What is really confusing is that if I hard code the path to the...

Thanks John, I'll have a go with this in the morning. Many thanks. Ali

This isn't working for me - why? This would be great if I could get it to work but I can't! I am a novice though... I have a text box called Hyperlink which has a hyperlink to the wav file. I have a continuous form with a different hyperlink in each record and a cmd button which I have...

Hi - this'll take a while, forgive me! The purpose of the database is to store video clip information along with timecode in and out points. The 'timecode in' fields consist of four fields; Hours, Minutes, Seconds and Frames. The 'timecodeout' fields are another four - Hours, Minutes, seconds...

Sorry I should be more specific. TomJ's solution was perfect for getting the sum of all TD values into a field in the Main form header [SumTD]. I now want to process the [SumTD] value and put the result in another field [CompileTime]. I need to do this with the After Update event of a tick...

Thanks Rich, you've obviously spotted my limited talent! I tried Dsum before posting but unfortunately I am in Access 2K.

Except that....... I'd like to apply NZ(Sum([TD])) to the after update event of a tick box. I'm getting the error 'Sub or Function not defined'. I have: dim newval as String newval = NZ(Sum([TD])) - Which is where the error occurs ..and thereafter I'm procesing the value of newval to...

That worked a treat! Many thanks :)

Hi - can anyone help with this one? It should be simple.......! I have a mainform/ subform routine where I am trying to add the values of a control in all the subform's records and enter it in a field in the main form. 'subform name = Compilation_Form. 'memory = the field in the main form I...

Wayne - you are a diamond!! It works! Thank you thank you thank you. I've written pages and pages of code trying to do this and I never would have got there! Cheers! Ali :)

Hi, I've been trying to make what I thought would be a simple timecode calculator for calculating the duration of video/audio clips. Timecode format is HH:MM:SS:FF, where ff is 'frames'. I'm using 25 frames/second timecode, so 24 is the max value before 'FF' resets at 00 and 'SS' gains 1...

Thanks DC!

Should be simple... I have a combo box in a subform whose row source is a query. The query is based on tblEngineers. The combo box's control source is based on a different table. I simply want to be able to type a new name in the combo box and have it appear in the list so that when it I go to...