Search results

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 the ReadyShare application that comes with these routers. For some reason I don't understand...

Its just my helper (a cooperative co-worker) and myself. No one else.

Yes, both the front end and back end are set to shared in Client Settings.

I'm sorry, that was poorly worded. Should say re-link table TO front end.

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 the front end 3. Open back end in exclusive mode. 4. Encrypt back end. 5. Re-link table in front end...

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 in that thread. Bookmarked for later more in depth reading.

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 working. If anyone could take a minute and have a look at the attached test db, and point me to what...

Thank you Ranman for replying, but I'm afraid you've lost me.

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 durations, and am having trouble understanding what to do. See attached. What am I not grasping?

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, its best, and it has the added bonus of the fact that I can study the vba code to learn about how...

This link to the pdf in the above post is no longer functional.

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 wondered if I'm missing something.

Homer Simpson Duh! *Pounding my head on desk*. Thank you.

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 out as customers require. I used two tables, the Batch table BatchT, and a Shipped Quantity...

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.

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 often than I'd like.

Dim FoundNotFound As Variant, Response As Variant FoundNotFound = DLookup("LotNumber", "BatchT", "LotNumber='" & Me.LotNumber & "'") If Not IsNull(FoundNotFound) Then Response = MsgBox("Lot number already in use. Check Batch List for next available number", vbOKOnly) If...

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 visible to users from the start.

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 case, I think, and be pretty easy to implement. Thank you for the information.

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 the whatever table(s) are affected, and delete the record(s). My latest project is larger, and will...