Search results

Feel free to tell us about one of your favorite recipe's and post them here. I just tried a new recipe today that really blew my wife and I away. I will share it here. Crock Pot Chicken Thighs with Artichokes and Sun-Dried Tomatoes We paired it with mashed potatoes and a bottle of Robert...

I'm not used to using the IN clause in SQL expressions so was wondering why I'm getting this 3075 error when trying to run an Update query on my table Media. The idea was to simply select media items from a list box (ListBox) and then run the query to update the Name and Date that the media will...

I'm trying to do a simple textbox validation to test if the description field is filled out in a very simple test form. This works when using simple code logic, but if using my close and save button, the form closes before there is a chance of correcting the problem on the form. So then I put in...

This is just an attempt to get Daniel Pinault's data driven menu working using the same html file shown in his part 2 video where he demonstrates it working. I put the html file in a folder called html and used a function to set the Edgebrowser0 ControlSource to the current path. This works, but...

Most of you probably already know about this gem, but the uBlock Origin extension for your browser will get rid of all those annoying YouTube adds while watching your favorite videos. You might have to update it regularly to keep up with the on going war to block or disallow add blockers, but...

I have a text file full of data that appears like the following example data. I'm looking for a way to transform that data into proper tabular data in Excel so that I can apply the resulting data as the source for mail merge labels. The end goal is to create proper hard drive labels. Title =...

Not sure what is going on with Access today. I think it started happening this morning, but I just may not have noticed until earlier this morning but all of my forms are missing the very left portion where the ruler measurments are. This includes the upper left hand corner where the form...

Please tell me there is a way around this nonsense. I have tried to rename extensions of the exe files themselves but their av scanner is looking at the actual file header and determining the actual type of file it is. I know I can use another file upload service, I'm trying to avoid that...

This is kind of a puzzle in that, I know that this must be possible because I seen another talented developer create a form like this. In fact, this is my attempt at duplicating one of his modern looking forms. If you look at the screen shot you can probably surmise that this form is actually...

I recently watched a video that shows a guy designing forms, and by default, his forms had rounded corners! (see the 1:26 mark in the video). This was very confusing to me as this didn't seem possible without some windows API code to create the effect. Well as it turns out, those rounded corners...

JP has nailed down how a leftist thinks and drew it all out in a nice mind map just to clarify things. Enjoy.

The report I have runs perfectly fine on any system that has MS Access installed on it, but comes up with a Enter Parameter Value pointing to the Date identifier when running on a machine that only has the runtime installed. I trouble shot this down to a text box in the footer that contains the...

I have no idea why it is creating this error on some rows of data. Can anyone figure this out?

This was sparked by the following presentation given by Mark Rendle: First up is IBM Cobol's Hello World code: //COBUCLG JOB CLASS-A, MSGCLASSZA, //HELOWRLD EXEC COBUCLG,PARM.COB='MAP,LIST,LET' //COB.SYSIN DD * 001 IDENTIFICATION DIVISION. 002 PROGRAM-ID. 'HELLO'. 003 ENVIRONMENT DIVISION. 004...

This is a hard thing to duckduckgo for. What is the official designation or name for numbers, variables and functions that are suffixed with special characters. I know what they do and how they work, just have no idea what they are called in VBA parlance.

Just checking if there is a way to output debug info in various basic colors in the Immediate Window. If so, any examples on how to do it?

Should be getting a demo of this next week, this looks real promising for those clients that must have their Access App accessible from anywhere. Of course there are service fee's involved but it looks reasonable to me. It's on a per seat basis, and depending on how you want to use it it could...

I'm sure this has been brought up many times in various different places but after doing a search, I didn't find a nice one stop shop thread on it explaining the reasoning behind the views (maybe I'm blind). It would be nice to create one single place on the forum where all of our combined...

I have various projects that require custom sorting on either alpha numeric lists of items or just custom groupings. This of course uses a helper column with a list of numbers that can force any sort order I want. Maintaining those lists has been a pain so I finally broke down and made a form...

I like sampling different wines and usually gravitate towards the Cabernnet Sauvignon and some Merlot's. One that I found recently is Dreaming Tree 2019. Not bad at all.