Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 413
Search took 0.04 seconds.
Search: Posts Made By: GBalcom
Forum: Modules & VBA 08-01-2019, 08:08 AM
Replies: 11
Views: 9,502
Posted By GBalcom
Re: Create a Google Calendar event with VBA

I don't have an account on Utteraccess.com. I'll create one, but not sure it will let me download anything without a few posts under my belt there.
Forum: Modules & VBA 07-31-2019, 05:42 AM
Replies: 3
Views: 168
Posted By GBalcom
Re: Add event to Google Calendar with VBA

Did you guys get this code to work?
Forum: Modules & VBA 07-31-2019, 05:08 AM
Replies: 11
Views: 9,502
Posted By GBalcom
Re: Create a Google Calendar event with VBA

One last bump....

Looking into this again.

I did find this other thread, but it appeared to die, and not have a good end result.
...
Forum: General 07-16-2019, 10:28 AM
Replies: 8
Views: 165
Posted By GBalcom
Re: OutputTo Macro not running

Hmm...The code I have was to send an email automatically. I'd like to have it open for the user to edit before sending. The real trick is I don't use Outlook, but rather EMClient.

It must be...
Forum: General 07-16-2019, 10:23 AM
Replies: 8
Views: 165
Posted By GBalcom
Re: OutputTo Macro not running

Thanks arnelgp, I forgot about that. Another trick you helped me remember is if you just change the file extension from .accdb to .accdr it will also simulate the runtime.

Using this trick did...
Forum: General 07-16-2019, 09:53 AM
Replies: 8
Views: 165
Posted By GBalcom
Re: OutputTo Macro not running

It's actually the emaildatabaseobject macro I'm using. Is that one available? I can write it in VBA, it just seemed easier for this one to do it in a macro....guess not.
Forum: General 07-16-2019, 09:08 AM
Replies: 8
Views: 165
Posted By GBalcom
OutputTo Macro not running

Hello,
Made a quick app this morning which uses a macro to email a report. Runs fine on my computer (Win10/access 2013). When I deploy to Station A or B (Win7/Access 2013 runtime) it gives me...
Forum: Reports 07-12-2019, 05:01 PM
Replies: 3
Views: 125
Posted By GBalcom
Forum: Reports 07-12-2019, 07:32 AM
Replies: 3
Views: 125
Posted By GBalcom
Field values not showing for every record

I have a report that is based on a query. query shows all records for the field first name. I used the wizard to create the report, and not it is not showing the field value for every record. It...
Forum: Modules & VBA 06-25-2019, 03:55 AM
Replies: 10
Views: 292
Posted By GBalcom
Re: VBA as a language, how "deep" can we go?

Woah! Thanks Minty, I had no idea. I'll have to get my hands on that.
Forum: Modules & VBA 06-25-2019, 03:34 AM
Replies: 10
Views: 292
Posted By GBalcom
VBA as a language, how "deep" can we go?

"Professional" Developers always seem to throw dirt on VBA and say it's not going to be around, etc. After learning what its capable of, I simply don't see the need to move elsewhere. It's too easy...
Forum: Modules & VBA 06-13-2019, 11:04 AM
Replies: 10
Views: 189
Posted By GBalcom
Re: Programming Logic for stopping events from occuring

Thanks guys,
Marks comment got me thinking. It was procedural, but I was missing an important step.

This is a snippet of my previous code:


Public Function RunProgram() As Boolean
...
Forum: Modules & VBA 06-13-2019, 06:25 AM
Replies: 10
Views: 189
Posted By GBalcom
Re: Programming Logic for stopping events from occuring

Thank you Jdraw!
I wasn't aware of the issue with unhandled exceptions and global variables. One question -- what exactly is an unhandled exception? Every single function or sub in my...
Forum: Modules & VBA 06-13-2019, 05:39 AM
Replies: 10
Views: 189
Posted By GBalcom
Programming Logic for stopping events from occuring

For the sake of brevity, I'll be as abstract as I can. If you need more details, I'll be happy to go deeper.

I have developed a medium sized application where I have a flow of 3 main events....
Forum: Modules & VBA 05-22-2019, 08:50 AM
Replies: 7
Views: 187
Posted By GBalcom
Re: Find Record Count during transaction

Thanks for the quick responses guys.

As far as the transaction. I was trying to use it because I don't want the records created by this test to persist in the database. So, It doesn't look...
Forum: Modules & VBA 05-22-2019, 05:27 AM
Replies: 7
Views: 187
Posted By GBalcom
Find Record Count during transaction

Long story short, I'm using a DAO Transaction during my unit testing.

Apparently, Dcount doesn't pickup the newly inserted records in the middle of a transaction. If I comment out the...
Forum: Theory and practice of database design 04-19-2019, 05:17 AM
Replies: 9
Views: 400
Posted By GBalcom
Re: Best Practice Advice: How to find out when a record is updated in read only BE

Jdraw,
All product docs are directed towards the user interface. No user group, small niche product. I know the developer, but, I don't think he'll oblige.

I don't want to give him any bad...
Forum: Theory and practice of database design 04-18-2019, 12:43 PM
Replies: 9
Views: 400
Posted By GBalcom
Re: Best Practice Advice: How to find out when a record is updated in read only BE

Hi Mark,
It does have a sequential key. There is no last updated field. It is a 3rd party out of the box application, so we only have Read access to the DB via ODBC. No way to add it,...
Forum: Theory and practice of database design 04-18-2019, 11:50 AM
Replies: 9
Views: 400
Posted By GBalcom
Re: Best Practice Advice: How to find out when a record is updated in read only BE

Thanks Pat,
Believe it or not, this is an off the shelf ERP, so we don't really have any control over the underlying db. It's a shame, as it makes it harder. Somedays I think it'd be easier to...
Forum: Theory and practice of database design 04-18-2019, 07:46 AM
Replies: 9
Views: 400
Posted By GBalcom
Best Practice Advice: How to find out when a record is updated in read only BE

I'm creating an application that will look into our ERP back end (Borland, through read-only ODBC), and find new or changed records in a specific table, then take actions, such as adding them to our...
Forum: Modules & VBA 04-16-2019, 12:16 PM
Replies: 5
Views: 195
Posted By GBalcom
Recordcount performance testing

For years now I've avoided using the native Dcount function like the plague because I've been told it has terrible performance.

Today, I'm starting to plan a new application (rewrite of an...
Forum: Modules & VBA 04-11-2019, 08:10 AM
Replies: 3
Views: 96
Posted By GBalcom
Don't ask user for Query Parameters

I have a form with a subform (qry) on it. I want the form to load, then the user fills out some cbo boxes in the header, which then pass that information to the subform (fills out the parameters of...
Forum: Modules & VBA 04-08-2019, 08:58 AM
Replies: 3
Views: 200
Posted By GBalcom
Unit Testing

Does anyone do unit testing on their VBA projects within Access? I use RubberDuck, which has a framework for it, but I'm having a hard time understanding what and how I would actually test, and...
Forum: Modules & VBA 03-01-2019, 06:16 AM
Replies: 3
Views: 99
Posted By GBalcom
Find File Create Date

I'll try to make this short. We have a CNC Machine (Windows-based) on our shop floor that we send files to from the office. These files are used once, to run the program, then we need to delete...
Forum: General 02-12-2019, 04:37 PM
Replies: 4
Views: 149
Posted By GBalcom
Re: Auto Run Application- Is Access the right platform?

Excellent, that's what I was hoping to hear. Thank you, Gentlemen!
Showing results 1 to 25 of 413

 
Forum Jump



All times are GMT -8. The time now is 12:04 PM.


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