Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 30
Search took 0.02 seconds.
Search: Posts Made By: mhorner
Forum: Visual Basic 05-28-2019, 06:02 AM
Replies: 13
Views: 697
Posted By mhorner
Re: Powershell Commands through VBA

I actually didn't figure out how to pass powershell commands through VBA. I am happy to share my powershell script (+ the required PS commands to call the script successfully):

First, an instance...
Forum: Visual Basic 05-24-2019, 03:51 AM
Replies: 13
Views: 697
Posted By mhorner
Thumbs up Re: Powershell Commands through VBA

Good morning DBGuy, thanks for your help. I did get this working, but abandoned the powershell script and tackled both the front and back end backup routines directly through VBA. I ended up using...
Forum: Visual Basic 05-21-2019, 08:55 AM
Replies: 13
Views: 697
Posted By mhorner
Re: Powershell Commands through VBA

I'm not sure this would be possible because I cannot call a script because scripts are blocked by company policy until I change the execution policy in powershell upon calling each instance of...
Forum: Visual Basic 05-20-2019, 11:46 AM
Replies: 13
Views: 697
Posted By mhorner
Powershell Commands through VBA

Hi everybody,

I created and manage an access database at work, and recently we've upgraded to Windows 10 / Office 365. I have 1 hurdle I am struggling to resolve and was hoping for guidance if...
Forum: Reports 04-02-2019, 11:26 AM
Replies: 5
Views: 264
Posted By mhorner
Forum: Reports 03-18-2019, 08:33 AM
Replies: 5
Views: 264
Posted By mhorner
Re: Applying Filter to Report & All Bound Children on Report

Yes sir, see attached. Forgive that many features have been removed to maintain confidentiality.

I've highlighted the Employee dropdown selector and report buttons in yellow. All you need to do is...
Forum: Reports 03-18-2019, 04:40 AM
Replies: 5
Views: 264
Posted By mhorner
Applying Filter to Report & All Bound Children on Report

Hi everybody,

I have a report I've created which pulls in query data from two separate queries:

The report is called: rptMonthlyReport
It is bound to the source: qryMonthlyReport

This...
Forum: General 02-12-2019, 04:42 AM
Replies: 3
Views: 147
Posted By mhorner
Split DB Performance Over Network

Hi everybody,

I've created fairly complex database at work here in the US to manage and track a large amount of projects, reports, and data. Initially this was only used at our corporate office,...
Forum: Modules & VBA 12-22-2018, 08:16 AM
Replies: 10
Views: 733
Posted By mhorner
Re: On Double Click Event in Subform

The subform source object was a query, and I had it displayed in datasheet view (not form view), so there were no additional controls being used on the subform to use an event to trigger on (like a...
Forum: Modules & VBA 12-18-2018, 01:32 PM
Replies: 10
Views: 733
Posted By mhorner
Re: On Double Click Event in Subform

Thank you much! I ended up resolving this, but not easily. I did not use the double click event. As you said, it was not specific enough to identify what exact record was selected in the subform. I...
Forum: Modules & VBA 12-12-2018, 12:34 PM
Replies: 10
Views: 733
Posted By mhorner
Re: On Double Click Event in Subform

Sorry, if I could retract reporting the post -- I would.

I honestly did take offense as I was asking for guidance in how to set up a subroutine on the double click event of a subform and provided...
Forum: Modules & VBA 12-12-2018, 11:16 AM
Replies: 10
Views: 733
Posted By mhorner
Re: On Double Click Event in Subform

Thank you! Unfortunately, this is exactly where I'm looking for guidance - in how to do exactly this. I tried referencing the field name, ID, as seen below:

Private Sub ID_DblClick(Cancel As...
Forum: Modules & VBA 12-12-2018, 10:45 AM
Replies: 10
Views: 733
Posted By mhorner
On Double Click Event in Subform

Hi everybody,

I have a form for users to enter project data into a table. On this form, I also have a subform displaying a list of the users projects.

When a user selects a project record from...
Forum: General 10-26-2018, 10:51 AM
Replies: 4
Views: 195
Posted By mhorner
Re: DoCmd.OpenForm, WhereCondition using Alphanumerics

Ok so thank you very much, this works now. Turns out I had the text box control set to rich text and the field in the table set to plain text, so it was turning out as <div>VALUE I AM TYPING</div>....
Forum: General 10-26-2018, 10:40 AM
Replies: 4
Views: 195
Posted By mhorner
Re: DoCmd.OpenForm, WhereCondition using Alphanumerics

Thank you for the advice! I really appreciate it. Unfortunately, this didn't entirely work. But I believe we are on the right path.

I tried what you suggested and the value I type into txtProject...
Forum: General 10-26-2018, 09:43 AM
Replies: 4
Views: 195
Posted By mhorner
DoCmd.OpenForm, WhereCondition using Alphanumerics

I have a database I've been designing to track projects. I'm having trouble setting up a DoCmd to open a form to specific records where field values contain alphanumerics. I'll try to keep this...
Forum: Tables 06-19-2018, 04:32 AM
Replies: 2
Views: 228
Posted By mhorner
Lookup Column Example

Hello everybody, I was wondering if anybody has or knows of an example database which uses a lookup column...
Forum: Forms 06-13-2018, 11:40 AM
Replies: 11
Views: 348
Posted By mhorner
Re: Updating 2 Tables From 1 (unbound) Form Field

Thanks for the help!


I've got this working well using your advice. I consolidated the tables into 1 which simplified literally everything. This simplified the need for relationships and now...
Forum: Forms 06-13-2018, 03:47 AM
Replies: 11
Views: 348
Posted By mhorner
Re: Updating 2 Tables From 1 (unbound) Form Field

Thanks for the advice!


I thought about it overnight and based on some of your comments, I'm going to combine the 2 directive tables. The original purpose was so that a user must select a...
Forum: Forms 06-12-2018, 12:39 PM
Replies: 11
Views: 348
Posted By mhorner
Re: Updating 2 Tables From 1 (unbound) Form Field

Hi guys, thanks for the quick replies. Here's the zip file. Its a work in progress, so forgive me if its still sloppy.


I'll read through everybody's responses and post up a reply. Thank you guys...
Forum: Gaming 06-12-2018, 12:21 PM
Replies: 17
Views: 12,055
Posted By mhorner
Re: Battlefield or COD?

battlefield, all the way. Way better, feels like more of a simulator than an arcade.
Forum: Sports, Health & Fitness 06-12-2018, 12:20 PM
Replies: 23
Views: 12,906
Posted By mhorner
Re: E-cigarettes aka Personal Vaporizers

Good for you! I've heard a mixup of both good and bad things. Mostly good though.


I can certainly say its substantially easier on your lungs to vape, but who knows the long term effects quite...
Forum: Sports, Health & Fitness 06-12-2018, 12:18 PM
Replies: 20
Views: 7,431
Posted By mhorner
Re: Tips for loosing weight..

Start a garden! Gardens both get you outside, give you basic exercise to keep you moving, and gives you healthy food at the end of the day.


It something to be proud of, fun, and actually...
Forum: Gaming 06-12-2018, 12:15 PM
Replies: 30
Views: 7,263
Posted By mhorner
Re: Elder Scrolls Online

Pretty cool MMO, poor online play though I thought. Everybody basically zergs around in a mob of 100 people.
Forum: General 06-12-2018, 12:11 PM
Replies: 7
Views: 9,790
Posted By mhorner
Re: ghost text or placeholder for textbox

You could also use VBA to do this so you can bind it to a control or event. I've used the code below to set the value of a text box, then when a user clicks inside the text box, it erased the default...
Showing results 1 to 25 of 30

 
Forum Jump



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