Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 96
Search took 0.02 seconds.
Search: Posts Made By: DeanFran
Forum: General 08-20-2019, 03:39 AM
Replies: 14
Views: 241
Posted By DeanFran
Re: Struggling with an Inventory Tacking DB

Mark,


Yes, we do have to maintain information on all batches manufactured, but that is beyond the scope of this project. As I mentioned before, I built an Access application that manages QA and...
Forum: General 08-19-2019, 04:39 AM
Replies: 14
Views: 241
Posted By DeanFran
Re: Struggling with an Inventory Tacking DB

Pat,


Yes, with a few exceptions, we are on demand. We have a few part numbers that aren't that we manufacture a batch of, and essentially manage the shipping and inventory for our customer....
Forum: General 08-16-2019, 10:10 AM
Replies: 14
Views: 241
Posted By DeanFran
Re: Struggling with an Inventory Tacking DB

Plog,
Thank you for taking the time to do that. There are a bunch of redundant tables/relationships in there as I was trying different things. I apologize. I should have cleaned it up first, and...
Forum: General 08-16-2019, 08:09 AM
Replies: 14
Views: 241
Posted By DeanFran
Re: Struggling with an Inventory Tacking DB

How about the whole thing?

This is the latest iteration. I think Im getting close, but...
Forum: General 08-16-2019, 07:37 AM
Replies: 14
Views: 241
Posted By DeanFran
Struggling with an Inventory Tacking DB

Short description, the thing will hinge on two things, Batches (that we manufacture) and Purchase Orders (that we receive from customers).
The fields that really matter are these
Batch Table
...
Forum: General 03-18-2019, 05:14 AM
Replies: 10
Views: 262
Posted By DeanFran
Re: Password Protecting Backend of Split Database

Thank you for pointing me to the folder permissions facet of all this. I finally got a chance to take a look. My sandbox application was stored on a shared volume attached to a Netgear rounter, using...
Forum: General 03-15-2019, 09:17 AM
Replies: 10
Views: 262
Posted By DeanFran
Re: Password Protecting Backend of Split Database

Its just my helper (a cooperative co-worker) and myself. No one else.
Forum: General 03-15-2019, 09:09 AM
Replies: 10
Views: 262
Posted By DeanFran
Re: Password Protecting Backend of Split Database

Yes, both the front end and back end are set to shared in Client Settings.
Forum: General 03-15-2019, 07:26 AM
Replies: 10
Views: 262
Posted By DeanFran
Re: Password Protecting Backend of Split Database

I'm sorry, that was poorly worded. Should say re-link table TO front end.
Forum: General 03-15-2019, 06:11 AM
Replies: 10
Views: 262
Posted By DeanFran
Password Protecting Backend of Split Database

I'm trying to learn about this, so I created a single table, single form test app. I followed the directions found in numerous places online.

1. Split database.
2. Delete the linked table in...
Forum: Macros 09-11-2018, 05:04 AM
Replies: 3
Views: 372
Posted By DeanFran
Re: Audit Trail With Table Level Data Macro Question

Thank you for pointing this thread out to me. What did it for me, was your link to the Microsoft Help article. Finding the application log pointed me to my extremely simple error. Lots of good info...
Forum: Macros 09-11-2018, 04:04 AM
Replies: 3
Views: 372
Posted By DeanFran
Audit Trail With Table Level Data Macro Question

I'm trying to get a grasp of the concept as explained by Scott Gem here.

https://scottgem.wordpress.com/2012/10/18/audit-trail-using-data-macros-2/
I think I've done it properly, but it's not...
Forum: Reports 08-01-2018, 07:42 AM
Replies: 3
Views: 198
Posted By DeanFran
Re: Sum in a Report Based on Query

Thank you Ranman for replying, but I'm afraid you've lost me.
Forum: Reports 08-01-2018, 06:35 AM
Replies: 3
Views: 198
Posted By DeanFran
Sum in a Report Based on Query

I'm trying to build a report that lists a set of events. The events have a start and stop date/time value. I perform the math to calculate the duration of the event. I am trying to sum the column of...
Forum: Macros 05-29-2018, 11:32 AM
Replies: 4
Views: 595
Posted By DeanFran
Re: Printing Macro Steps

Thanks for your replies. I spent a few hours messing about with the V-Tools addin, but wasn't able to figure out how to print a macro. In the end, I just converted the macro to vba. As you all say,...
Forum: Access FAQs 05-25-2018, 08:26 AM
Replies: 5
Views: 17,840
Posted By DeanFran
Re: How I Use Access User-Level Security by Jack MacDonald

This link to the pdf in the above post is no longer functional.
Forum: Macros 05-25-2018, 08:05 AM
Replies: 4
Views: 595
Posted By DeanFran
Printing Macro Steps

I'm using Access 2010. Is there a way to generate a paper copy of the action steps in a macro? I've lloked all around, but cant seem to find a way to do this. I know I can take screenshots, but...
Forum: Queries 05-17-2018, 07:00 AM
Replies: 2
Views: 239
Posted By DeanFran
Re: Zero versus Null Confusion Maybe?

Homer Simpson Duh! *Pounding my head on desk*. Thank you.
Forum: Queries 05-17-2018, 05:45 AM
Replies: 2
Views: 239
Posted By DeanFran
Zero versus Null Confusion Maybe?

Iíve built a simple inventory tracking tool for our manufacturing department. Our products are manufactured in discrete batches, and the number of shippers produced is entered. Then shippers are sent...
Forum: Modules & VBA 04-27-2018, 09:11 AM
Replies: 4
Views: 389
Posted By DeanFran
Re: DLookup For Duplicate Entries and MessageBox Response Question

The code I found online was setup as Cancel = True. It was applied to a similar but different need, so that may be where that came from. Thanks for the link, and I will give the DCount option a try.
Forum: Modules & VBA 04-27-2018, 06:07 AM
Replies: 4
Views: 389
Posted By DeanFran
Re: DLookup For Duplicate Entries and MessageBox Response Question

Yes it does. Thank you. I need to study VBA more. My method of changing things in stuff I found online until I break it or it works, while often illuminating, leaves me in situations like this more...
Forum: Modules & VBA 04-27-2018, 05:50 AM
Replies: 4
Views: 389
Posted By DeanFran
DLookup For Duplicate Entries and MessageBox Response Question

Dim FoundNotFound As Variant, Response As Variant
FoundNotFound = DLookup("LotNumber", "BatchT", "LotNumber='" & Me.LotNumber & "'")
If Not IsNull(FoundNotFound) Then
Response =...
Forum: General 03-30-2018, 09:39 AM
Replies: 9
Views: 602
Posted By DeanFran
Re: Dealing With User Mistakes-Particularly Accidental Records

I often have the auto number displayed for my own use on forms and reports, and I confess I'm guilty of not always going back and hiding all of them. I have recently started the rule of never having...
Forum: General 03-30-2018, 09:01 AM
Replies: 9
Views: 602
Posted By DeanFran
Re: Dealing With User Mistakes-Particularly Accidental Records

I did not know this, nor did the person who was insisting that gaps in the auto number sequence would be a red flag should an auditor stumble across it.

Your proposed solution would work in our...
Forum: General 03-30-2018, 06:02 AM
Replies: 9
Views: 602
Posted By DeanFran
Dealing With User Mistakes-Particularly Accidental Records

I've built a few small applications that are used by different small groups of people in my small organization. So far, its been sufficient for a user to tell me they made a mistake, and I go into...
Showing results 1 to 25 of 96

 
Forum Jump



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