Search results

CJ_London, I think I'm making progress, but not quite there. I have renamed the combobox cboSundays and the code now runs to give the sundays date, however it only returns 5 dates, and they are every other sunday date. Any ideas? Thanks

Thanks CL_London, I have done exactly as you instructed in your post. However I get a runtime error "424" object required. The code debugger shows; cboSundays.RowSource = "" as requiring something. As I'm useless with code, can you suggest what I'm missing many thanks for your patience!

jdraw, thanks for your reply. I'm sure this is along the lines of what I'm after. However, I'm not sure where to put this code, do I need to change the text box to a combo and the enter the code under the build event tab? you may have guessed I'm not that competent with VB!

I think I need to clarify what I'm trying to achieve. On the form a Sunday in entered in to a text box. This date is then used in 7 employee sign in sheets for the week, with each sheet adding a 1 to the date to give a date for each day. I may need to print out a number of weeks sign in sheets...

I don't suppose there a way of listing the next 10 sundays, in a table or query, from DATE() so one could be selected from a combo box?

Every Sunday would be entered, I have tried creating a table, to base a combo box on, with dates for consecutive sundays, but this seems a long way round to enter every sunday date. I wouldn't know where to start the create some kind of code that would do it for me.

I don't know if this is possible, but here goes. I have a text box on a form that requires a date to be entered. I'm using Access 2013, so it provides a calendar to select the date required. I need the date to always be a Sunday, is there any way of getting the calendar to show only Sundays or...

Your a genius! many thanks

Evening all, hoping someone can help with this one, I have a combo box in a form which gets values from a query, the order of the records is already sorted in the query based upon another field. Is it possible to order the records in the combo box? I have read it should be done in row source...

thanks your reply, i'm not sure where to put it in my query, below is the SQL, any guidance would be much appreciated SELECT [car no] & "-" & [axle position] AS joined, [09ts data].[axle serial], [09ts data].Date, [09ts data].KM, [09ts data].[turn description], [09ts data].[ave post wd] FROM...

I'm hoping someone has an answer to the problem I've been given. In the range column there are multiple entries for the same record, but somehow I need to show the last entry by date for each. eg 12001-1 has 3 records but I only need to show the one with the latest date. 12006-4 has 4 records...

I have a number of reports that have up to 36 text boxes on each, each text box uses the DLookUp function to find specific records. When I run a macro, using the Open Report function and have the view set to print, the report prints out before all the text boxes have been filled with the...

:)Thanks for all replies. I have got round it by creating a new front page and running the code from there, then opening the form that uses the linked table.

I have code that copies an .xls file from a USB to a folder on my PC: Private Sub data_backup_Click() On Error Resume Next Kill "C:\test\LATHE_DATA.xls" On Error GoTo 0 MsgBox "Ensure USB is inserted" FileCopy "\\Client\A$\GeneralUSB_sda1\LATHE_DATA.xls", "C:\test\LATHE_DATA.xls" MsgBox "Backup...

thanks for your reply, how do I get a union query to sort car_no in descending, as this could well solve my problem, thanks

I have 8 queries 110, 120, 130, 140, 140s, 130s, 120s and 110s which I have combined these using a union query, however the union query returns results based on the first column of the queries. I need the query to return the results in the order above. the first column of each query is called...

thanks for your reply. as a novice to access I didn't realise the impact of spaces when naming objects and yes it is beginning to haunt me. As for ordering my union query I'm afraid I do not understand what you are suggesting. Does it make any difference if I change the column format from...

Hi, I have just discovered union queries and have been able to combine 3 queries, SELECT * FROM [110 last turn] UNION SELECT * FROM [120s last turn] UNION SELECT * FROM [110s last turn] but the union query appears to set the order based on the numerical value in the first column of the query...

If I cannot change the column header height, can I hide it, I can then add labels to the form to give the appearance of column headers?

Thanks for the advice. I'm not familiar with a continuous form, what might that be?