Search results

can anyone explain why a calculation in an Access query gives a different result to the same calculation in Excel. For example 1/70 = 0.0143 in Excel (this is the correct answer) but when I do the same in an Access query I get the result of 1.42857142857143E-02 How do I write the calculation...

Thanks Unc for taking to time to share your experience (and frustrations). I am very interested in downloading the free db so would appreciate if you can message me with how to go about this. Thanks again Caroline ;)

something to try at a later date perhaps (no pun intended ;))

I did try this but didnt work when editing a date

thanks I may give this a go at some point when I find the time.

I think the only way to go here is to use the after update event to do the requery and then (although not ideal) just get the user to tab out of the control when they use the date picker. I will go with this for now and then perhaps I will come back to it another day when I am not up against...

this works to a degree. What I mean is it works for the date picker and if entering a date from an emtpy text box but if you try and edit a date that is in the text box it requeries before you finish editing. for example if you have 17/02/2020 and try and change it to 10/02/2020 by deleting the...

Sounds like this could work but how do I test for a full date first? I did try doing a length measure but it always seems to be 10 even when I have only typed a single character (i have tested this with a message box to check the length)

Apologises for the lack of response, just been hectic with work. I haven't read through all the responses yet so I will do next in the hope to find a solution but just to answer the question about whether the control is bound or not, its not. It is an unbound control merely used to filter the...

I have searched the web for a solution for this but I havent been able to resolve my issue despite others having similar issues. I have a form with a text box using the built in date picker. I want the user to be able to manually type in a date or choose one from the date picker. Once they...

just doing the 1 activate didnt work hence having to do one then another. Thanks about the Dim it was a typo

Yes thank you. Here is my complete code if it helps anyone else. Private Sub cmdPortFolioOutput_Click() On Error GoTo Errorhandler DoCmd.SetWarnings False Dim outputFileName As String strOutputFileName = [Application].[CurrentProject].[Path] & "\DE_Data\Portfolio\OUT\PortFolioTemplate_" &...

Thanks for all your help, I do appreciate it. I did already try searching on Google for help before coming on here which is what I always try to do but I am not too clever but do actually try before pestering the experts. You will see that I already use the docmd.setwarnings = False statement...

Thanks but I get an error saying Compile error: Method or data member not found which points to this line. Application.DisplayAlerts = False

The code below opens the file that I create (containing the 3 sheets all selected) and it does actually work and only the first sheet is selected (the other two arent) which is perfect BUT when I close the excel file it doesnt save it in that state. So I need to find a way of saving the changes...

Thanks, yes I still need help. Just to confirm that the file I attached earlier, if I open it all 3 tabs are selected even though cell C5 is the active cell. But if I click on the Data Ribbon then none of the buttons are active. The only way I can activate them is if I click on one of the sheet...

Do you think there is an issue with the original code selecting the 3 tabs. I have no idea why it does this but I am using MS Office Pro 2019. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Portfolio_MainLive", strOutputFileName, True DoCmd.TransferSpreadsheet acExport...

Nope, all 3 tabs are still selected.

Here is an example of the Excel file containing the 3 tabs which are all selected after using this code below. (the data in the tabs is just made up and would usually have lots of columns and hundreds of lines of data but I just need to protect the data) Dim xl As Object Set xl =...

Thanks for this. I still have an issue with the other tabs that are selected. I believe you code is actually working and activating cell A1 in the first tab but because the other two tabs are still selected I still have the issue of not being able to use any of the buttons on the Data ribbon...