Search results

  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
  16. N

    Working with GDrive

    I believe Google Drive uses oAuth2 to get an access token using your client id and secret. Honestly, I’ve been using the Chilkat library which has a heap of useful connections for vbscript which are fully adaptable for VBA. www.example-code.com/vbscript/ It is a paid library $295 USD, but...
  17. N

    permissions denied error with CreateTextFile()

    Probably something to do with permissions. I’m an Administrator on my computer and yet it still won’t let me. I imagine it’s something to do with the actual request coming from Access. Sent from my iPhone using Tapatalk
  18. N

    permissions denied error with CreateTextFile()

    Try creating the text file in another directory. I.e. desktop . Sometimes I have trouble creating files in the root “c:\” on some computers due to weird permissions settings. Sent from my iPhone using Tapatalk
  19. N

    Send Outlook appointments

    There’ll certainly be some modification required, just to make sure that fields line up with the correct fields in the database. Saves as an appointment if there is null or “” in the textbox txtAttendees, otherwise it sends the meeting request. Handles richtext body as well by using the...
  20. N

    Send Outlook appointments

    I might be a little late to the party, but this is what I use... It handles them as either appointments or meeting requests. Dim objOutlook As Object Dim sAPPPath As String Dim objMyMsgItem As Object Dim objMyApptItem As Object If IsAppRunning("Outlook.Application") = True Then 'Outlook...
Top Bottom