Search results for query: *

Hi all, Using Win11 Pro on a Dell box. I had set up weekly backups to a WD 2TB Passport external drive. This system has worked well for the better part of a year. But suddenly a couple of months ago, the backup hung up at 97% complete while creating the system image of the C: drive. I've kept...

Hi, I'm using Win11 Pro on a new Dell laptop. I periodically get notified to update Windows Explorer. The notice says to right click the taskbar and select Properties, then select Update on the popup window. In the past, this used to work as described. But lately, maybe the last 2 or 3 times...

I'm running Win11 Pro. I've set up several reminders using task scheduler to display a message at set times. I've set the scheduler to run the messages even if I'm not at the PC. However, my laptop is almost always on and I'm logged in. The PC will sleep if no activity after a half hour or so...

Hi, I'm using Access 2010 on both a Win 7 Pro box and a Win 11 Pro box. My database prints address labels on Avery type 5167/8167 (1/2" x 1&3/4"). There are 3 lines for the address and all 3 lines can grow or shrink. The first line prints the name; the second line prints the street address, and...

Hi folks, I'm coming from a Win7 Pro laptop and just purchased a new PC Laptop with Win 11 Pro. (As an aside, I have grown to hate the 11 interface.) Having said that, I am the only user account on the PC which was created during the initial setup where I became the Administrator. Because I...

Hi, I'm using MSAccess 2010 on a Win7 Pro box My DB keeps track of books that I've read, whether from library, ebook, ones I've purchased or others have given me. I have one main form with no subforms on it. There are checkboxes for friends & relatives to whom I loan books or receive books...

Hi, I'm using Access 2010(32-bit) on a Win 7 Pro box. Been using this a number of years and never had this problem before; or any problem I couldn't resolve in Access or Excel. I went to the immediate window and typed =currentdb.version. At first when I typed the period, the context menu...

Hi, I wanted to learn Powershell and discovered some Youtube vid tutorials. I'm using Win7 Pro 64-bit which has Powershell 2.0 installed. One of the vids instructed how to install the Windows Management Framework (WMF) 5.1, which would upgrade Powershell to 5.1, on a Win7 box. I downloaded...

Hi, I'm using Win 7 Pro 64-bit. At one point I added Excel to open .txt files in Windows Explorer. Now that option shows up first in the context menu so every time I double click on a text file, Excel attempts to open it. I want to remove Excel and go back to Notepad as the first option in the...

Hi, I'm using Access 14 on a Win7 Pro box. I have a DB (BooksRead) in the accdb format. I wanted to add a startup form to the DB. I've done this before. In fact I have another DB (WorkingDB) that utilizes the AutoExec macro to open with a form. When I try running the BooksRead DB I get an...

Hi all, And a Happy New Year to the multitudes here. I'm using Access 2010. I created a DB that I want to distribute to family & friends for their use. Because no one has full blown Access, I want to distribute the DB with runtime. But I first wanted to test out how the DB responds under...

Hi, I'll start off by saying I'm not a fan of the embedded macros in the Switchboard. I prefer to get into the code and tweak it to my specs. I'm using 32-bit Access 2010 on a Win7 Pro box. After converting the Switchboard macros to VBA code, and opening the Switchboard, the first msg I get...

Folks, I tried using an optional argument in a subroutine. When I try calling the subroutine from another subroutine and attempt to enter the second (optional) argument, the line of code turns red. When I try compiling I get a syntax error. I'm attaching a Word .docx file showing the...

Folks, This by no means is a very critical problem. It's more annoying than anything else as it doesn't impact the user, just the developer (me!). LOL Using Access 2010 on Win7 Pro box. On my form I have a BeforeUpdate event. Whenever I try switching from the active form to design mode, the...

Hi, I have a procedure in Access that imports data from an Excel file after coded manipulation of that data. This is done in the background; that is, the Excel app doesn't appear on the taskbar. When the code errors out and I have to stop the execution, the Excel app is still showing as a...

Hi, I have a procedure in Access that imports data from an Excel file after coded manipulation of that data. This is done in the background; that is, the Excel app doesn't appear on the taskbar. When the code errors out and I have to stop the execution, the Excel app is still showing as a...

Hi, I just discovered, accidentally, that when running an update query in VBA code with SetWarnings turned off, any record with an error doesn't get updated. When I tested the update query by itself, the error message indicated there was a validation violation. But when checking every field...

Folks, I have an Insert Into query that fills a table. When I run the query as a simple Select query I get one more record than when the Insert query runs. I've checked the filtering criteria, and the missing record in the Insert query meets the criteria which is proved when running the query...

Hi Folks, I was attempting to cleanup code and make it more efficient. So I ran the Performance Analyzer on one of the forms which contains significant amount of code. The suggestion was to declare the class module as Option Explicit. When trying to compile, I was directed to elements which...

Hi, I'm trying to polish my MSAccess VBA code by introducing error logging. I discovered a way to log the errors to an external file. The example showed how to pass the error message to a Sub which logs the info to a file. Obviously I can also pass the error number as well if I choose. The...