Search results

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

All is revealed in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=150648 I have one form onto which data is entered and another form which displays the data (with other stuff). If the data entered on the first form is not saved prior to the opening of the second form...

Cheers MStef I put a save record comand (DoCmd.RunCommand acCmdSaveRecord) in the On Open Event and it works when there is a newly entered record to save but crashes when there is not. Is this because the record has already been saved? Can I code the open form event to check if there is an...

Is this because the record has already been saved? I have the same problem. I put a save record comand (DoCmd.RunCommand acCmdSaveRecord) in the On Open Event and it works when there is a newly entered record to save but crashes when there is not. HTH Tyler

Good Afternoon I think this belongs in the Query Forum. My database displays a form on which I enter details and create a new record. There is a button which when clicked runs a query and opens another form which displays the information entered on the first form. The system works but in...

I now have report dates back in my header! Thanks for that Kempes Regards Tyler