Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 299
Search took 0.25 seconds.
Search: Posts Made By: jleach
Forum: Other Software 10-14-2018, 06:47 PM
Replies: 14
Views: 4,614
Posted By jleach
Forum: Other Software 10-14-2018, 09:20 AM
Replies: 14
Views: 4,614
Posted By jleach
Re: The best remote database backend for an Access front end?

I wasn't involved in the initial thread here, but use SQL Database (aka, Azure SQL Server hosting) with Access FEs often. Have done it with AWS as well, and some other lesser-known hosts. No major...
Forum: The Watercooler 10-13-2018, 07:18 AM
Replies: 2,907
Views: 568,010
Posted By jleach
Re: What's your best/worst joke?

That was a good one.
Forum: Reports 10-12-2018, 09:32 AM
Replies: 4
Views: 100
Posted By jleach
Re: Excel graphs in access

I'm not sure of how to display Excel graphs "live" in Access. Access charting is sub-par, although recent version(s?) do have some improvements.

I think the generally accepted technique is to...
Forum: General 09-22-2018, 02:20 PM
Replies: 5
Views: 232
Posted By jleach
Re: Bing, Google & Here map API's

I suspect jdraw's link will cover it, but as an FYI, there is a Google API that takes a street address and turns it into lat/lng coords (and vice-versa). Geocoding/reverse-geocoding is the term, I...
Forum: Queries 09-19-2018, 03:54 AM
Replies: 4
Views: 100
Posted By jleach
Re: datediff function

Hi - can you show us the query/expressions you were trying to use? Can't quite figure out with the info you gave.

Cheers,
Forum: Modules & VBA 09-19-2018, 02:42 AM
Replies: 4
Views: 82
Posted By jleach
Re: Run-time Error '13': Type mismatch

No prob. Now that you're fixed, a few additional thoughts.

I usually prefer to use parentheses to make it a bit more readable, and line breaks perhaps. Not strictly required, but reading it...
Forum: Reports 09-19-2018, 02:38 AM
Replies: 15
Views: 323
Posted By jleach
Re: Conditional Formatting the Field based on the Value of Another Field

I've generally found Conditional Formatting to be slow, especially based on heavily calculated fields (usually some flicker/delay in rendering the format, especially noticeable when scrolling).
...
Forum: Modules & VBA 09-19-2018, 02:33 AM
Replies: 4
Views: 82
Posted By jleach
Re: Run-time Error '13': Type mismatch

Break out each OR into a full expression:

If Unit_Type = "ASDF" OR Unit_Type = "QWERT" OR Unit_Type = "ZXCV" Then

Tedious, but required. hth
Forum: Modules & VBA 09-19-2018, 02:32 AM
Replies: 6
Views: 186
Posted By jleach
Re: Post Journal entry to Quickbooks using Quickbooks SDK and Ms Access vba

I took a look for VB6 SDK support/examples for Intuit and was not able to find anything helpful (or even confirmation that it's supported).

Regarding walking through the .NET COM approach, it's a...
Forum: SQL Server 09-17-2018, 02:47 AM
Replies: 18
Views: 726
Posted By jleach
Re: Determine if SQL Server is online

For me, ADO is preferred for things like this (checking if the server is reachable, initially validating users), typically on startup because once you make a DAO connection, a lot of those DAO...
Forum: General 09-15-2018, 12:43 AM
Replies: 13
Views: 589
Posted By jleach
Re: Programming with VBA and Macro

It should not present any specific problems. There's no reason macros and code can't intermix within an Access project.
Forum: Modules & VBA 09-14-2018, 06:15 AM
Replies: 6
Views: 242
Posted By jleach
Re: Office 2016 Access VBA sending XML

>> 32bit <<

That was going to be my guess. Usually a broken Active X would mean that either a) the library was removed from the system (not likely in the case of the MSXML parser), or when you...
Forum: Access World News 09-13-2018, 03:50 AM
Replies: 22
Views: 906
Posted By jleach
Re: Seeking a favour: Please help me populate my new forum!

Hi Jon - if possible via settings somewhere, would you consider making it so users need not be signed in to view attachments? For example, I'm looking at this thread:...
Forum: General 09-12-2018, 06:42 AM
Replies: 9
Views: 1,446
Posted By jleach
Re: Retrive a Base64 text to picture

Well, first let's see if we can decode the Base64 string. Start out getting the actual Base64 portion of the original data string (I'm guessing everything after the last "/", but we'll have to...
Forum: Modules & VBA 09-12-2018, 06:33 AM
Replies: 6
Views: 186
Posted By jleach
Re: Post Journal entry to Quickbooks using Quickbooks SDK and Ms Access vba

I took a quick look at the SDK and it seems it's only supported for .NET, Java and PHP.

If you want, you can write a .NET app and compile a COM library from it that you can consume within VBA, but...
Forum: General 09-11-2018, 08:55 AM
Replies: 9
Views: 1,446
Posted By jleach
Re: Retrive a Base64 text to picture

Base64 is a text-based representation of binary data. You can use VBA to encode/decode it. Below is a link to a function that claims to do so (I haven't tested this one in particular, but there's...
Forum: Modules & VBA 09-11-2018, 07:35 AM
Replies: 6
Views: 186
Posted By jleach
Re: Post Journal entry to Quickbooks using Quickbooks SDK and Ms Access vba

As far as I know, QDBC is the only way to do this. It's not particularly difficult: register the driver and run the code, really. Hardest part of that is having the correct license for the driver....
Forum: Modules & VBA 09-11-2018, 04:57 AM
Replies: 5
Views: 223
Posted By jleach
Re: Need HELP With Filtering Calendar

I love this calendar - have used it in numerous applications. Peter does some great work. Sounds like Colin has you squared away, but didn't want to pass up an opportunity to commend Peter on his...
Forum: Modules & VBA 09-04-2018, 10:08 AM
Replies: 6
Views: 165
Posted By jleach
Re: VBA parsing JSON file

This might help also: it's bare-bones minimum: https://dymeng.com/parsing-json-with-vba/

hth
Forum: General 08-24-2018, 05:03 AM
Replies: 19
Views: 901
Posted By jleach
Re: Which naming convetions you are using?

Yea, this has been a pet peeve for years.

As a quick workaround, you can use the fully qualified enum name instead of just member:

Public Enum SomeStuff
StuffThis = 0
StuffThat = 1
End...
Forum: General 08-22-2018, 06:24 AM
Replies: 17
Views: 1,261
Posted By jleach
Re: Rename Database and Corruption Error Goes Away?

>> However this would be an insurmountable task <<

Can't be much worse than constant corruption and data loss issues, can it?

If nothing else, split all the databases first: this is usually a...
Forum: Forms 08-22-2018, 05:38 AM
Replies: 5
Views: 179
Posted By jleach
Re: Disable close button for current database

As a side note, there's also the standard windows Close button at the top right of the Access window itself, which (AFIAK) can't be altered with the Ribbon.

There is some Windows API code that can...
Forum: General 08-22-2018, 05:31 AM
Replies: 17
Views: 1,261
Posted By jleach
Re: Rename Database and Corruption Error Goes Away?

I strongly agree with ridders... this is one of the first things we learn about corruption prevention: the db gets split, everyone gets their own copy of the fontend to use (this is usually step 2,...
Forum: General 08-22-2018, 05:27 AM
Replies: 19
Views: 901
Posted By jleach
Re: Which naming convetions you are using?

Also: while underscores are low on my list as a matter of personal preference, they're generally harmless except: do be careful of anything that starts with an underscore, as this has special...
Showing results 1 to 25 of 299

 
Forum Jump



All times are GMT -8. The time now is 01:59 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World