Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 304
Search took 0.04 seconds.
Search: Posts Made By: jleach
Forum: The Watercooler 11-20-2018, 06:23 AM
Replies: 4
Views: 925
Posted By jleach
Re: Looking to hire an Access dev

Feel free to reach out. Even with the best intentions/skills/personalities, it's still hard to find a good all around fit, so ideally a few candidates...

Thanks
Forum: The Watercooler 11-20-2018, 06:07 AM
Replies: 4
Views: 925
Posted By jleach
Re: Looking to hire an Access dev

Mostly because I'm not sure who is interested and not, so this way it's not a bother to them if I ask: they can reach out if they are. And, there's likely twice as many that could do it than those...
Forum: General 11-20-2018, 03:55 AM
Replies: 19
Views: 752
Posted By jleach
Re: DB properties in new DB?

Table would work also. I'm used to text files working with other systems and storing things in git, so that's what came to mind first, but either or. A local table is self-contained so probably...
Forum: General 11-20-2018, 03:03 AM
Replies: 19
Views: 752
Posted By jleach
Re: DB properties in new DB?

I'm not sure of any easy way offhand (easy as in clicking a checkbox during the import process like you would for Import/Export specs, I mean).

What I'd probably do in this situation is keep a...
Forum: The Watercooler 11-20-2018, 02:50 AM
Replies: 4
Views: 925
Posted By jleach
Looking to hire an Access dev

Hi all - I'm looking to hire an Access/VBA developer on a contract basis to help out with some projects. Anyone around here particularly good at this stuff and looking for some paid work?

Should...
Forum: Other Software 10-14-2018, 06:47 PM
Replies: 14
Views: 5,288
Posted By jleach
Forum: Other Software 10-14-2018, 09:20 AM
Replies: 14
Views: 5,288
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,920
Views: 570,677
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: 142
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: 533
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: 115
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: 105
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: 383
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: 105
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: 224
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: 1,052
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: 605
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: 333
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: 9,560
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,545
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: 224
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,545
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: 224
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: 264
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: 254
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
Showing results 1 to 25 of 304

 
Forum Jump



All times are GMT -8. The time now is 05:23 AM.


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

Featured Forum post


Sponsored Links


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