Recent content by Tyler08

Hi all Can anyone recommend some software that will combine a series of jpgs into a video output? My little boy found some videos on YouTube of animated Lego figures but I had to ban it due to the expletives on the over dubs! So I told him that we would make our own. Any suggestions? Regards...

oc Man Thanks you very much for your most informative and verbose reply. The dependency issue is now more clear in my mind. The monetary figures in the database were taken from the original tender submission and so as such represent income rather than cost. So prior to your reply I had added a...

Thanks for the reply dk. That should work great for totalling the costs, I'll use it in a report. My problem though (which I didn't explain too well (as usual!)) is that up until now I have populated the tables using a form. I enter the shift date in a text box, select the site the person...

Morning all My database was quite simple, recording number of shifts worked on various contracts. The cost of each shift is taken from a staff type table. My problem is now that the bean counters want a different rate for each staff type depending on what contract the staff member is booking...

Thanks for your help gentlemen. I did the text box ShiftDate.text first then the other 3 combo boxes only offered .value so that's what I used. I'll change the ShiftDate.text to ShiftDate.value and mark my learning curve slightly higher! Thanks again Regards Tyler

Afternoon all. My database keeps records of shifts worked. The form which is used to input the data has drop down boxes to select Contract, Site, Name, etc. The user enters this data from the time sheets. Each shift record can be the same for each day of the week. I'm trying to code a way of...

Cheers twoplustwo That’s close but not quite there! Using that example, if I select United Kingdom in the first combo then the second combo gets loaded with a list of UK Cities. What I want is to be able to select UK in the first Combo, have a default city displayed in the second combo as a...

Morning all My database records shifts worked by each individual on each site of each contract and the percentage of the shift booked. I click the new record button, enter the date of the shift, select the Site from a combo box and the Contract name is displayed in a text box. Then I select...

Hey Brian Don't let my thickness put you off!! Thanks for the clarification. Regards Tyler

Brian Sorta CountA? Please explain Tyler

Don't panic! I found it: =SUBTOTAL(3,A2:A283) (It wasn't CountA() at all!!!) Regards Tyler

I once had a spreadsheet which used CountA() at the bottom of a column. The spreadsheet also had an autofilter on it. The CountA() formula had an extra bit in it so the correct total number was displayed when the filter was used. Can anyone please remind me what the formula was? Regards Tyler

Cheers MStef Tyler

Code moved to the top of the click event of the button which opens the second form. Database functioning properly now. Thanks for everyone's input. Tyler

Code moved to the top of the click event of the button which opens the second form. Database functioning properly now. Thanks for everyone's input. Tyler