Search results

I've been learnig about dates and Access and was surprised to learn that there's no native function determine the number of weekdays between 2 dates as there is in Excel. I googled around and found a couple of functions that do that job, and have been noodling around with using one of the...

I have a split database with about 15 users, each with their own front end. The back end is housed on a NAS on our company LAN. There is also a Datto backup device that backs up the NAS regularly throughout the day. The front end has a login form that pulls from a user table. The login form...

I have a split database, and each user has their own FE. A couple of folks in the office would like to pull data from it. Both setups call for pulling from a query I made for them that reside in the BE. I setup their Excel workbook connections for them, and everything works until someone is...

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 ProductID Quantity Manufactured Ready Status Date of Manufacture Purchase Request Table...

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...

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...

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?

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.

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...

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'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...

I'm no graphic designer, and I'm barely a passable Access database designer, but one thing I'm always disappointed in are the look of my reports. I would very much like to hear ideas on how to make reports more professional looking.

I created a combo box on a form bound to a table field, and I created my own list. I realized later that I left a member off the list. After much fiddling around, I finally was able to fix the Row Source after I changed the Inherit Value List property to "No". Creating a new combo box carried...

I have an Access application that requires a date input in this format, YYMMDD with the day being the last day of the month. This date becomes part of a bar code as an expiry date code, that gets printed on a label. I have guidance text right above the textbox that explains how to input the...

Can anyone take a look at this and provide some insight? This started happening about two weeks ago, and I can’t seem to find the root cause. Here is the scenario I have a set of causalities that can be attributed to an event. The event is documented as an Investigation Report{IR}. (Table...

I almost always create a login form, and have always just used the password input mask, and let users create whatever password they like, but I have often wondered how to create an improved password requirement, i.e. at least 4 lettesr, and 4 numbers or some such, but have never been able to...

A couple years ago I took over maintaining a preventive maintenance DB. There is one aspect I haven't been able to fix. To say I'm not the most qualified VBA person would be an understatement, though I know enough to believe its the answer to this question. One of the functions of the DB is to...

This has been a small annoyance since I started working with Access a few years ago. I've dug around properties, and tried all sorts of different things, but have never been able to figure out the cause. I'm sure its probably something obvious I missing, but I would dearly love to know what...

I've built my first attempt at this idea. I have a 4 level cascade set up and its working as intended, but one issue I have is some 3rd level options don't require a set of 4th level options, and some do. My table structure is tblFirstLevel FirstLevelID FirstLevelName tblSecondLevel...

Access 2010 Split DB with the BE on a shared drive Runtime file created by copying and renaming accdb file after splitting. All FEs are accdr. Each user has their own copy of the FE Each FE works. BE Client Settings Default Open Mode 'Shared' Default Record Locking 'No Locks' Client Settings...