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

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

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

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

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

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

As my report opens, this code runs: Private Sub Report_Open(Cancel As Integer) sdate = InputBox("Please Enter Shift Report Start Date", "Report Start Date") edate = InputBox("Please Enter Shift Report End Date", "Report End Date") If IsDate(sdate) = True And IsDate(edate) Then Me.Filter...

Afternoon all I'm trying to open a report based on a selection in a Combo drop down on a form. The report lists shifts booked by operatives to various contracts and I want to limit the results to the contract selected. I get the error message: Run Time Error '3075' Syntax error in Query...

My database has a table listing employee details which links to a table of documents. Another table lists document versions which links to a table of document version owners. Since most of the people in the employees table are also in the document owners table any alterations to their details...

Can anyone please tell me how to insert a thumbnail of a jpg into a Word table? The original jpgs are all about 1.5Mb each and I need to create a document to display 20 of them to email to a client. An Excel file will do if this would be easier. Regards Tyler