Search results

I came across this pdf today and thought I would share it. There may be a newer version if you go to the COS official website. The group has been working diligently to get the states to agree to call a convention to propose some much needed amendments. The left is working more successfully to...

This is the simplest example I could make. It is states as the main form and cities as the subform. The sample includes a mainform with a subform and a button to open the subform as a popup so you can see how to handle populating the FK for each new record in the popup form. Access does this...

I was trying to find a post I made yesterday and couldn't remember its title or the name of the op so I thought I should just be able to scroll down the new posts list looking at each item that had been updated since Sunday morning. But, the post I was looking for wasn't there. I ended up...

I cannot get back to the old Outlook on my new Win 11 computer. I'm ready to ditch Outlook entirely. The new, but not improved Outlook is missing too many features. There has to be something better. I really dislike web apps so would prefer something that installs locally. Any suggestions?

I ended up with New Outlook when I installed Office and it doesn't support the rules that the Old outlook supported so my spam is back out of control. How do I get Old Outlook to install. MS as completely messed up the install of Office and doesn't give me any options except 32/64 bit

Apparently, Excel has changed the way that it imports .csv files when you use the Data tab to import the file. It INSISTS on importing it as a table. I don't want it to be a table. I can't find any way to take data that is a table and make it not a table. The obvious copy and paste to a new...

On my new computer I installed O365. It has been years since I had to run this install. In their world Access doesn't exist. It was very sad to see. All the other components were installed on the Start Menu but not Access. Access was relegated to the "more" section.

I'm a little late to this game. I've been struggling with Win 11 when supporting a client for over a year. I recently got a new computer (thanks for your help in deciding what to get). I am so tired of change for the sake of change I don't know how many times I can say it. They messed up the...

There is a method of generating x records using what is frequently called a "tally table". This table has rows with values from 1 to x with x being the maximum number of items you will need to generate. This particular example is from a receiving/shipping application I built for a client. The...

PragerU has a lot of very informative videos. Marissa Streit is without a doubt the best interviewer I have ever listened to. She is totally on top of the topic and asks great questions including asking for definitions. This is the second interview by her that I posted today. The other is in...

This should not be a political topic. It is important for everyone to understand what happened during the COVID outbreak so it doesn't happen to us again. This video is a few months old but I just saw it today. I have heard Dr. Atlas speak on the topic before but this video is pretty...

Is there an addin that manages rules in a useful way? I'm trying to find a rule that is getting rid of email I want. Thee is no search or sort that I can find. Usually, they allow email I don't want to pass through:poop:

This sample shows several options for data selection as well as several options for data output. Printing a report is simple. Printing a report for a specific client is a little more complicated, Printing a report for every client record in a file requires a VBA Loop, Printing a report for a...

I came across a bunch of old .mdb's. I really don't know if they contain anything useful but I'd like to convert them. I have a laptop with A2010 so that should be able to read at least back to A97. I know how to do the conversion with code but why reinvent the wheel? Does anyone have a db...

This sample just can't be imported and used, it requires customization. There is a table behind the scenes which documents the reports and also identifies each report's arguments and whether they are required or optional. I've used this concept in at least a dozen applications and given that...

One of my clients has decided to switch to 64-bit. I'm still using 32-bit. There is no problem with the app except for my lack of ability to create an .accde that runs under 64-bit Office so I need to do something. I no longer have a spare computer to keep the two versions of Office separate...

I have an application that populates bookmarks in a Word document. The app works fine on my PC but not on the client's. I'm using the O365 subscription slightly behind the bleeding edge. Client has a 2019 boxed version. Both are 32 bit The error is 5941 -Requested member of collection does...

I want to change the color of the border of a button if the form the button opens has data to show. Using the theme name of the color doesn't work. Am I going to have to figure out what the numeric value is and hard code that????? That makes the themes pretty useless. If DCount("*"...

The agents who conducted the raid on Mar-a-Lago were authorized to use deadly force. How was that supposed to work? Start a showdown between the FBI and the Secret Service? Who thought that was necessary and why would a judge ever sign off on the concept? Defund the FBI.

I just read an article that explained where this phrase came from. Apparently the term was coined by the American author O. Henry in his 1904 novel "Cabbages and Kings". The novel is set in a fictional central American country (likely Honduras) led by a ruling class that exerts absolute power...