Recent content by nhorton79

  1. N

    locked ldb file

    I’ve had this happen to me before where the ldb file wouldn’t delete. All I’ve ever had to do was reopen the database and then close again. Sent from my iPhone using Tapatalk
  2. N

    Mobile Calls via VOIP

    Any joy with these pekajo? Sent from my iPhone using Tapatalk
  3. N

    Mobile Calls via VOIP

    Haven’t done so before but if your field was ContactPhone you could try: Application.FollowHyperlink "tel: “ & [ContactPhone] Give it a try and should open in your default VOIP program. Sent from my iPhone using Tapatalk
  4. N

    Function issue

    Away from computer at the moment so can’t test this but try escaping the string to include the date supplied i.e. Holidays = DCount("*", "tblHolidays", "([HolidayDate] <= " & EndDate & ") AND ([HolidayDate] >= " & StartDate & ")") If this doesn’t work you might also need to add hashes (#)...
  5. N

    Issues appending records with dates into SQL Server

    I also found this on SO which talks about using parameters: https://stackoverflow.com/questions/35470311/ms-access-date-format-for-sql-insert-using-vba A comment by Dai further down talks about this in further detail... Sent from my iPhone using Tapatalk
  6. N

    Issues appending records with dates into SQL Server

    I don’t really know a lot about SQL Server but I’ve had hassles in Access using dates when I’ve forgotten to add hashes. I.e. ...#” & myDateField & “#... Sent from my iPhone using Tapatalk
  7. N

    Custom Project Number with Fiscal Year

    I could do, but I like for it to show the last date of the financial year for simple understanding if I ever go back through functions. I should probably just dim endmonth and have it set to month(#31/03/2019#) or have it dlookup the enddate from my settings table so that it’s not hard coded...
  8. N

    Custom Project Number with Fiscal Year

    In my database I use: Public Function FinancialYear(dDate As Date) As Integer Dim EndDate As Date: EndDate = #3/31/2019# Dim EndMonth As Integer: EndMonth = Month(EndDate) If Month(dDate) <= EndMonth Then FinancialYear = Year(dDate) Else FinancialYear = Year(dDate) + 1 End If...
  9. N

    Working with GDrive

    Thanks for that link Gizmo! I’ve always hated using scripting for JS in VBA. This looks soo much nicer and easier. Sent from my iPhone using Tapatalk
  10. N

    Working with GDrive

    Yes. But it’s easy to distribute and register these in your database setup. To be fair my apps only have about 30 front-end users but the setup should be the same regardless (although they’re all on W10 which is nice that I don’t have to faff about with multiple OS). If that’s not your thing...
  11. N

    Working with GDrive

    There is a ton of links down the sidebar for different technologies.
  12. N

    Working with GDrive

    Try: https://www.example-code.com/vbscript/
  13. N

    Working with GDrive

    Did you have a look at the pages with examples I gave you links to? On the Chilkat page there are heaps of VBScript examples (which are very similar VBA, the main exception being that you'll find most VBS variables aren't declared and are treated as Variants). The other thing with Chilkat is...
  14. N

    Working with GDrive

    There are free libraries for working oAuth and oAuth2 though like Vba web https://github.com/VBA-tools/VBA-Web But the good thing with Chilkat is they have predefined code samples. Although you could adapt their code to work with VBA web Sent from my iPhone using Tapatalk
  15. N

    permissions denied error with CreateTextFile()

    Kind of makes sense rally. Like sonic8 said, you don’t want to use c:\ as a dumping ground. Sent from my iPhone using Tapatalk
Top Bottom