Search results

From 2009 onward I have only bought solid state disks for my computers. Fast forward to today and I bought my first mechanical hard disk in 12 years. Why? Because as much as I love them, it's for detachable backup and the value proposition for SSD's isn't there for this use case. This disk...

Using Power Apps hosted by Dataverse and used within a Teams environment, it appears to me that this is the solution Microsoft intends for organizations to develop internal business apps quickly going forward. In that sense, it occupies the same space as Access, but it goes further in that they...

Hey all, My team has a lot of functions that are done on spreadsheets and I'm eager to consolidate and simplify our processes with a new database. However, I want everyone to have access to certain things at any time via mobile devices. That may include various lists like a roster or financial...

Any NAS users? I have a Synology Diskstation that's been going strong for 11 years. There is a 1 TB WD Black and a 2 TB WD Green in there. I use it as a media server from the 1 TB drive, which backs up to the 2 TB drive weekly. The 2 TB drive also takes the weekly backup from my PC. I'm...

I'm very active on another forum that is undergoing a vBulletin to XenForo transition. We were given examples of what the forum would look like once it comes back online. They are all stark white pages with no contrasting breaks between posts. Everyone is dreading it. I like what this forum has...

Hey all, I have quality data that is calculated in the aggregate and can be queried over a specified time period. For example, quality was 97.50% for the period of March 1 to March 31 using a simple formula of ([Pieces]-[Defects])/[Pieces]. I do not store the results of those calculations. If I...

Hi all, I have a report that I must show in Print Preview as Report View does not display my subreports accurately. Unfortunately, Print Preview means my on-form command buttons disappear, so I have reluctantly enabled the right-click menu to print and send as attachment. Two problems. One, I...

Say you needed to add a foreign key (see attached) to a table that has existing records and relationships. What is the easiest way?

This is probably something simple, but: Table Data: Sum of Samples for PR 5.5.12 = 630 Query Output: Where is the extra 156 coming from? Here: Whenever there is more than one subrecord, the number of "Samples" is counted again, in this case, twice. 630+156=786 How should I adjust my...

I can't post this database at this time but I can provide a screen shot of the current situation. I'd like some input on this conundrum. You have a parent main form and a child subform, each with its own table. The structure is inspections of products. Samples of each product can not exceed a...

What would it have on it? Talking about at the database control and development levels, not doing simple things like adding users or adjusting privileges. I'll start. It would be nice to have an Developer's form with controls to: Kick out all users within a specified time Set flag to lock the...

When using the dark theme, here is how the above post looks: Is that because @jdraw specifically switched his text color to black there? Maybe the "none" or "remove formatting" option would be better in this case as it should then follow theme rules.

This would help deter advertisers and spammers. They've been on the rise.

My database will accommodate up to a 125% screen scaling setting. In the event that a user uses the 150% setting, I need to detect that and load a special, compact version of the form. There are some hints here that could be possible...

Hey all, I am doing a validation check based on null fields and setting the border color if true. The following works well: Function ValidateInspection() Dim ctrl As Control For Each ctrl In Forms.frmInspection.Controls Select Case ctrl.Tag Case...

Sub HideAllMenus() Dim ctrl As Control For Each ctrl In Screen.ActiveForm.Controls If ctrl.Tag = "MenuAdmin" Or "MenuReports" Then If Not ctrl.Visible = False Then ctrl.Visible = False End If End If Next End Sub This works great when...

Hey All, I've searched for answers on this but keep coming up with various ways of adding WHERE statements. I do not want to add a WHERE. I am trying to pull only the record(s) I need to work with. A WHERE seems to pull the recordset and filter on the local machine. It's like asking the...

After some testing yesterday I decided to change the way my DE form loads: https://www.access-programmers.co.uk/forums/threads/open-form-to-new-record-but-with-a-specific-value-in-text-box.309738/post-1671935 This means using DoCmd.OpenForm "frmInspection", acNormal, , , acFormAdd, acDialog...

I'm looking at some code from pbaldy here: http://www.baldyweb.com/Requery.htm I have a record list and a popup data entry form. On the click event of the Close button on popup form, I have a requery, which acts on the underlying form (the record list in this case) to add the new record to the...

I'm the developer of an Access application that I will also use myself in my line of work. Sometimes I hear ideas thrown around by management regarding a web interface, which is a whole different ballgame and would require a complete rewrite and another year+ of development time. Most of it...