Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.15 seconds.
Search: Posts Made By: speakers_86
Forum: Modules & VBA 01-10-2017, 01:50 PM
Replies: 4
Views: 376
Posted By speakers_86
Re: Access data in Acrobat Form

I see two options. One is to find a way to convert the pdf to a jpg, create a report in Access, and use the picture property to reference the jpg. Then just align the controls so they 'fill in' the...
Forum: Sample Databases 12-10-2016, 07:14 PM
Replies: 1
Views: 5,174
Posted By speakers_86
Installer

This is a stand alone utility that will

-relink the shared front end to the back end
-copy the shared front end to the local hard drive
-create a shortcut to the local front end on the desktop...
Forum: Windows 11-28-2016, 04:57 PM
Replies: 10
Views: 4,070
Posted By speakers_86
Re: Anyone using Microsoft Edge?

Windows 10 is okay, 7 might still be better. The most recent version of Explorer isn't terrible, but I'm still a Chrome fanboy. Firefox was only ever good because it was better than the old...
Forum: General 11-28-2016, 04:12 AM
Replies: 8
Views: 1,066
Posted By speakers_86
Re: Locked Down Database

You might like the startup form I posted in the samples. It gives you a GUI for database properties you can get too easily.
Forum: General 11-28-2016, 04:03 AM
Replies: 15
Views: 3,797
Posted By speakers_86
Re: Detect broken backend connection at startup

When I do this, I also try to write to a text file on the shared drive to test for read/write access before even connecting to the backend. If that routine fails, I give the user the option to...
Forum: General 11-23-2016, 09:21 PM
Replies: 4
Views: 1,411
Posted By speakers_86
Re: Auto resize the datasheet form

There is a value you set the width to which tells Access to automatically size it based on the data. I believe the value is -1 or -2. I don't remember.
Forum: Forms 08-14-2016, 12:04 AM
Replies: 4
Views: 505
Posted By speakers_86
Re: How to reference control on Main form from query

Try this: forms!fStartForm.[fAll Valid Workorders Owing Money].form.WorkOrderID The fAll Valid... form exists as a child of the parent form, not as an object in the forms collection.
Forum: Forms 08-12-2016, 06:41 PM
Replies: 9
Views: 1,610
Posted By speakers_86
Re: Spit Form Datasheet Font Size Not Changing

I've got a sample here that duplicates the split form while only using a subform. I'll be posting an update soon to fix a couple things.
Forum: Modules & VBA 08-03-2016, 04:55 PM
Replies: 8
Views: 623
Posted By speakers_86
Re: Reuse code?

I mostly have two modules, one called 's' and one called 'g'. The s is for specific, and only contains code that is just for that database. The g is for generic, and can be safely used in all of my...
Forum: Visual Basic 07-26-2016, 07:18 AM
Replies: 7
Views: 2,679
Posted By speakers_86
Re: References for VBA Project across Office versions

Late binding is always a good idea. Early binding may not work across different computers. It's unfortunate, but that's the way it is.
Forum: General 07-11-2016, 09:12 AM
Replies: 5
Views: 477
Posted By speakers_86
Re: Users in DB?

I've seen a sample that is able to read the backend's record locking file and tell who is using it. Would it help if I linked to it? I'm not sure if this is okay to do though...
Forum: Forms 07-07-2016, 07:59 AM
Replies: 9
Views: 422
Posted By speakers_86
Re: Dispaly Calendar

I don't recommend activex controls unless this project is just for you. Other computers that control might not be available or in the same place.
Forum: Modules & VBA 07-04-2016, 10:12 AM
Replies: 26
Views: 2,577
Posted By speakers_86
Re: Getting file sharing lock count exceeded error

I think I missed something, I thought you all determined this was being caused by the records being released asynchronously. Is that not the verdict anymore? I was just about to go and add a timer...
Forum: Modules & VBA 07-04-2016, 06:32 AM
Replies: 26
Views: 2,577
Posted By speakers_86
Re: Getting file sharing lock count exceeded error

Thanks for this. I have this issue too, but never got around to troubleshooting it.
Forum: Reports 07-04-2016, 06:05 AM
Replies: 7
Views: 506
Posted By speakers_86
Re: Aligning the tick boxes in a report

Once you do that you will probably want to use align left or align top to get them aligned perfect.
Forum: General 06-25-2016, 09:15 AM
Replies: 8
Views: 897
Posted By speakers_86
Re: Pre-FE db delivery Checklist

Perhaps this (http://www.access-programmers.co.uk/forums/showthread.php?t=283288) will help you. It brings all of the properties front and center and gives you a hotkey to get back to it.
Forum: Modules & VBA 06-03-2016, 08:08 AM
Replies: 19
Views: 1,629
Posted By speakers_86
Re: 2010 db won't run on 64 bit installation

Don't use call. Just do:

Scroll Me, Count

Me is the form, you are passing the form itself to the scroll sub routine. Count is the argument provided in the mousewheel event.

Also, if you...
Forum: The Watercooler 06-01-2016, 11:55 AM
Replies: 63
Views: 3,416
Posted By speakers_86
Re: Question related to speed of light.

That's what is great about theoretical physics. Nothing is really set in stone! There is a theory called the variable speed of light (VSL) that says the speed of light varies over great periods of...
Forum: General 05-30-2016, 11:45 AM
Replies: 6
Views: 457
Posted By speakers_86
Re: Embedded Bitmap Images

Don't embedded images cause the database to grow over time though? I thought there was some quirk to access caused the database to inflate for no good reason.
Forum: General 05-30-2016, 08:06 AM
Replies: 6
Views: 457
Posted By speakers_86
Re: Embedded Bitmap Images

Even for the bitmap images? I feel like since they are baked into the program it shouldn't matter if I embed them. I'm talking about the Picture property for command buttons. They have those tiny...
Forum: The Watercooler 05-30-2016, 08:02 AM
Replies: 63
Views: 3,416
Posted By speakers_86
Re: Question related to speed of light.

This is how I understand it.
Forum: General 05-29-2016, 11:09 AM
Replies: 6
Views: 457
Posted By speakers_86
Embedded Bitmap Images

Is it okay to use the built in bitmap images? Will it cause the size of the database to increase? Or should I go through the effort of making a linked image?
Forum: Forms 05-28-2016, 12:15 PM
Replies: 4
Views: 1,769
Posted By speakers_86
Re: Use command button to open selected record on a form without filtering?

This is something that we do from time to time, which means it justifies a routine in a module I think. Here is some reusable code: Public Sub MoveTo(frmToMove As Form, strNameOfIdField As String,...
Forum: Modules & VBA 05-28-2016, 08:14 AM
Replies: 41
Views: 1,913
Posted By speakers_86
Re: Lost Modules - Possible corrupt DLL

Regarding the powershell thing, you're looking at the wrong post in that thread.
Forum: Modules & VBA 05-28-2016, 08:12 AM
Replies: 41
Views: 1,913
Posted By speakers_86
Re: Lost Modules - Possible corrupt DLL

Did you look at the references? Make sure none of them are missing.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:45 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