Recent content by pekajo

Thank you all for your help

Hi, Can anyone tell how to export a time field to spreadsheet as hh:mm only. My short date also includes the date 00/01/1900 08:45:00 Thanks Peter

Thank you so much it worked like a charm. Peter

Hi, Does anyone have a script to email an attachment that does not use Outlook as I use Thunderbird. Bot Perplexity and Gptchat cannot manage it. Thanks Peter

Hi, Can anyone give me advice or example of producing a ghantt chart in ms access Thanks for any help Peter

Hi, Has anyone been able to Integrating online payment system to Ms access? Regards Peter

Hi, Has anyone managed to integrate and online payment site with MS Access or will I have to just download. The data base is local. Thanks for any help Peter

Hi, Is Ms Access able to connect to an online payment platform that will integrate with MS access, which is not online, and if so can you give me some leads on how it works Thanks Peter

Hi, Hope this is not to complicated. I have a [startdate] and a [finishdate] fields and want to show all the people who will be working on a [selecteddate] (variable). [startdate] = #01/03/2024# [finishdate] #/01/05/2024# For everyone who will be at work between these dates and will be at...

Hi, Many years ago I used Skype to make calls from MS Access to mobile phones etc. Can anyone tell me if this still works or if they have another provider that will do the work. If you do can you send the code so I can use it. Thanks for any help. Peter

Hi, Does anyone know if it is possible to create an outlook type calendar to run on access? Thanks for any help. Peter

Hi, I am using the build in contact form using the php version but am having a issue that I think the browsers may not run php on the hosting site. That is, it works on my browser (Braver) but not on Edge both are on the same PC. If this is true is there a way around this issue. Thanks Peter

Hi, Hope you can help on 2 questions. 1. What are the pros and cons of migrating my ms access tables to sql and moving to an sql server. and using ms access as a front end. (forms, queries and reports) 2. Advice on the easiest way of doing the conversion. Thanks for any help. Peter

Hi, Can someone help in a DSum function. The following works aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt") But when I want to add another AND statement it does not aa = DSum("[IncTotal]", "Income", "[mmyy] = '" & vmth & "' AND [IncCA] = & vt" & " AND [Incyy]...

Cheers