Search results

sorry. the database is that large now there is no way the limits would allow it. even when zipped.

i would like to have an xmas countdown. i currently have it displaying just the amount of days. i would prefer it if it had days hours:minutes:seconds. i have already have it on a form that has the timer set at 1000 so refresh is not a problem. heres the function i have to display the days...

ok ok. the reason they have been duplicated is for a diary system. i have frmDiary and frmDiarySub1. sub1 holds 5 columns which each relate to one set of details in tblMultiSchedule. i had this built for me and cant for the life of me figure out how he gets data into the txt boxes on the...

i have 2 tables that hold similar data. in one table tblMultiSchedule i have a few blank columns. i want to update each column(ActualCost*) with the correct data which is stored in tblOrdersItems. the corresponding fields in each tbl are tblMultiSchedule.OrderItemID1...

one more thing to get the cogs ticking. the record set seems to exit sub Exit_Proc: rs.Close Set rs = Nothing Exit Sub i have some more vba that i want to continue after this. how do i take out the exit sub without getting an error. thank you

thank you. it works.

thank you for the reply. infact it is a copy of a record set that you have done for me in the past. you helped me out with this about a year ago. the reason i dont do the sql like that is that i am not to good with them laid out that way. i prefer to put them in one long line. i will give it a...

i have tried to do this record set all on my own but i am struggling. i get an error that causes me to have to shut down access through task manager. luckily i have learnt to save it before i test it(experience) 'open record set' Dim rs As DAO.Recordset On Error GoTo Err_Proc 'Check To See If...

thanks for that but I think ill leave it as hours. hopefully that last post isn't wasted and just got your brain working for the day. thanks again

thank you for that. is there a way to display eg. 68 hours and 45 minutes. if its too complicated im happy with 68.75 hours. we only have treatments in 15 minute increments anyway so it wouldn't be a long decimal. I think I can cope with 1/4

how do I format the text box to that. I already have short time in them. do I have to change them all to elapsedhours = mytime*24 ive tried what I have just said and it doesn't work as though I expected. I knew it wouldn't be that easy but....

I have a report that shows the daily activities. it shows how long it takes to do each task. however some tasks are 8 hours andsome are 10 hours. when all these times are added together it will give the time on a clock. not a total of hours spent. ie. treatment1 : 8 hours treatment2: 10...

I am trying to create a button for me and other users to export reports to excel. using the ribbon the results are correct. using DoCmd.RunCommand AccmdExportExcel seem to give different results. as I say using the export to excel gives the correct export but using the vba gives incorrect...

the query is behind a lst box on a form so it wont be referencing anyother form anyway. but i will look at the link for other queries i have done and duplicated with a different form name. thank you

namliam: thanks for that. im not really trying to get the stock that is lower than 999 but to get all of the stock. would the correct one be NZ?

it sounds to me that the word doc is dragging info from a query. if it is dragging it from a tbl then the field will have to be in the table with all the other info. i think you need to clarify if the vehicle is in the same data source as the other field that word has. look at your tbles...

i have just tried to amend my query. the idea is that the initial results are to show all items that are instock. ie have a value >0. if i click a check box i want to display all items that are available regardless of stock. so my criteria expression is as follows...

thank you. perfect as usual

I have vba that runs at 08:30 am. I would now like to run vba on the 1st of each month. how do I do this. for the time I use If TimeValue(Me.txtClock) = TimeValue("08:30 AM") Then.......... thank you

thanks for your help. i have managed to do it now. i have tried something similar to this but i wasnt successful. i think you saying that it can be done spared me on to complete it thanks. the images below show how i did it.