Invoicing in Microsoft Access

Invoicing
By Richard Rost

2 years ago

Custom Event Class examples Upload Images Link
Gary James
3 months ago

I've revisited this topic because on the advice of Alex Hedley, I've uploaded my simple little custom event class sample project and Riches modified Order and Invoicing project to a GitHub Repository.

Along with the two Access projects I've created a Readme file that describes the changes made to Rich's project.

Here is the GitHub Repository address:
https://github.com/NfaToys/Global-Messaging-Events-Class.git

Alex Hedley
3 months ago

Have you tried using VCS / GitHub to export all the objects so it's easier to see what's going on and if you ever make changes you can compare.

Gary James
3 months ago

The files in the Event class repo are binary Access projects, so version control wouldn't be able to show anything meaningful. However, my SizeAndLocation class repo are text files, and I've already made a minor change to the source code that shows up in the web based GitHub repo.

I'm slowly getting familiar with GitHub. In the past I've used Microsoft SourceSafe for version control and source code archiving.

Alex Hedley
3 months ago

Did you watch the above video(s)?
So you use the the Access AddIn to export your accdb to files, commit them to GitHub, then upload the accdb file as a Release.

Gary James
3 months ago

No, I have the GitHub Desktop app installed on my Laptop. I add files to my local repo and the Desktop app syncs the files with the web based repo. To add revisions to the repo I have to use the web browser to access this functionality. This isn't present in the Desktop app. I wasn't aware there was a GitHub add-in for Access. Would this offer any advantages over the Desktop app? And if so, where would I find it?

Gary James
3 months ago

I just noticed that you provided a link above. Sorry about that. Let me check it out and I'll get back to you.

Gary James
3 months ago

Alex, I watched your video and I followed the installation instructions. However, after the add-in was installed I opened up one of my projects and none of the VCS functionality was enabled. Can you think of any reason why this isn't working?

Gary James
3 months ago

Alex Hedley
3 months ago

Should be in the Database Tools tab

https://github.com/joyfullservice/msaccess-vcs-addin/blob/master/img/gui-demo.gif

Alex Hedley
3 months ago

I'll have to add some GitHub Desktop videos to my git course.

Depending on what revisions you mean you should be able to add changes to your files in the GitHub app and sync again, you should need to go to the web for that.

Gary James
3 months ago

Ok, here's what I found.

I uninstalled the add-in, removed the non functional SourceSafe VCS ribbon, and started over reinstalling the GitHub Add-In.   The install went Ok, and the SourceSafe VCS ribbon didn't get installed the second time.

When I open the Add-In manager I now see the GitHub VCS menu selections.   Using the default subdirectory option, when I select "Export All Source" it creates a directory with a "ProjectName.SRC" name and extension and places a ton of files in that subdirectory.   Am I right in assuming that once I do this, I should then make my project directory a GitHub Repository and sync it to the web?

One more thing.  I my have found a bug in the GitHub VCS Add-In.   If I export my project, and immediately try to export it again, I get a VBA runtime error.   See the attached images.

Thanks again for your help with this.

Gary James
3 months ago

Here's one additional image.

Gary James
3 months ago

Alex Hedley
3 months ago

You can use GitHub Issues on their Repo to raise a bug.

Alex Hedley
3 months ago

Yes, that src folder is what you want to upload to GitHub.

Alex Hedley
3 months ago

Then make a change to one of your objects (table/form/report/etc) then run the export again and you can see the changes made.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Invoicing Comments

Subscribe to Invoicing
Get notifications when this page is updated