Search results

I need some help in setting up a subdatasheet based on table. I have a Products table which contains all of my inventory items and also has a subdatasheet which references the Inventory Transactions table. My Inventory Transactions table reflects items that have been disbursed on a certain...

Hello All, I could really use some help/direction in how to proceed with designing a table for an inventory database I want to setup. I am not understanding how to setup a "category" table properly. I want the category table to contain a category id # (autonumber) and a list of categories...

Hi Trevor, I just wanted to take a moment to tell you again how thankful I am for all the help you provided me. I finally figured out on my own what was stopping MS-Task Scheduler from running my macros. Thanks to your code and MS-Task Scheduler, my Access macro automatically outputs a pdf...

Hi Trevor, Thanks so much for the suggestion. The database macros/functions are all working as they should. The ONLY problem I have now is that I can't get it to run via Task Scheduler when I try to place a switch to activate the macro. If I don't place a switch after the argument in Task...

Hello Trevor, I just wanted to drop a line to let you know that I finally got the macro to work with the modules. I kept searching the internet for answers and someone was nice enough to tell me that I needed to change the Sub routine to a Function and then call that module, which in turn...

Trevor, I wanted to add too, that I figured out why I couldn't get the code to run past the "Dim 01App As Outlook.Application" line.....I had to set the reference for Outlook in the database, so things are running again now. I still have been unable to understand how to get the vba code to run...

Hi Trevor, Thank you for responding so quickly. Here is is the code I have in my database so far: First module named RptExtras: Function GetBoiler(ByVal sFile As String) As String '**** Created by someone else Dim fso As Object Dim ts As Object Set fso =...

Trevor, Please help again. What I am trying to do now is not working....what am I overlooking? Okay, so the code you modified for me is working and NOW what I'm trying to do is: 1. Export and output to pdf the daily ms-access report using "ExportWithFormatting" which is saved to my desktop...

Trevor, Disregard my post.....I figured out how to fix it. I had to make it ".Attachments.Add" Again, thank you so very much for helping me, I appreciate it immensely. I will let you know how everything turns out as I'm still working on this.

Hi Trevor, Thank you so very much for responding to my request and for modifying your code for my use. I apologize for the delay in responding, things have been soooo busy. I am attempting to use the code as instructed, however, I can't get it to work. I took the first block of code you gave...

Trevor, First, let me begin by saying "thank you, thank you, thank you" for providing workable code which I was able to implement for my situation. You do not know how long I have been scouring the internet searching for a solution. I do have a few additional questions for you regarding this...