Search results

Hey folks, long time no see. The company has me working primarily in C# these days, but today I'm fighting Access again. The situation is that we have an application that takes a WinZip self-extracting archive, executes the archive in silent mode, and provides an export location. This has...

Okay, so I'm exporting the results of a query to a fillable PDF and saving them to a different folder. Null sweat, right? The problem I'm running into is this: My first two files generate just fine, but the third one kicks back a Type Mismatch error. I've determined which line it is (the PO...

Okay, I'm stumped. Is there any way to display more than 255 characters in a combo box? This is for Access 2016, for what it's worth. The reason is that in an application I inherited, there is a method for users to update the 'Comments' field on multiple records at once. During this update...

Okay, in a nutshell, I have this form that generates its underlying SQL when it is opened and assigns the recordset as part of a procedure called by Form_Open. One of the things I do is check to see if the recordset is empty, and if so, I notify the user. However, the users have requested that...

Okay, on one form in an app I'm building, I'm getting notifications that records are showing #DELETED# in all fields after a data change. I've narrowed down the cause to the form being based on a SQL Server view, and the specific data change immediately causing the record to be filtered out by...

Okay, this is a weird one. I have a procedure that is somewhat long. In a nutshell, it takes 2 required and 7 optional parameters, validates an excel file and worksheet name, does a number of different things based on whether or not the file or sheet already exists and what the calling code...

Um...interesting problem. I didn't know invisible ink was an option on this forum. ;)

Here's something someone might find useful. I don't know about Access 2013, but in Access 2016, Microsoft, in its infinite wisdom, decided to limit the color themes available in Access. Unlike the rest of the Office suite, there is no longer a color theme available that turns the Access...

Okay, this one is driving me bananas. I have a driver procedure that is supposed to call a number of sub-procedures, then close the spreadsheet I was importing from and quit Excel. Here is the code. Please excuse the mess, it's still under development, so this isn't my final code by any means...

Hey, anyone else having issues getting to Chip Pearson's site? I'm getting nothing but 404 errors from it all of a sudden.

This is getting aggravating. I have an app that has recently started randomly returning the following error from SQL Server when executing a procedure from Access: The procedure in question is called by a pass-through query that is literally just EXEC and a series of parameters. EXEC...

I'm trying to modify the Ribbon for an app. My employer has a VERY strict 'no installing anything' policy. That means that it's turning out to be INCREDIBLY difficult to find idMso names for tabs and groups, as the single, solitary thing everyone who ever answers custom Ribbon questions...

Here's an aggravating situation in Access 2007: I'm trying to set up a check box on an unbound form (basically a search screen) to, when updated, check to see if a specific text box has data entered, and if it doesn't, cancel the update and revert the change. Here is the initial code: Private...

Okay, I'm trying to help a co-worker resolve an error he's encountering, and failing miserably. The idea here that the user enters a month/date value into a text field and hits a button, and the system imports a text file that matches the entered value into a specific table. Here is the code...

...I will create a recordset loop until EOF and actually remember to include MoveNext. :banghead:

Okay, this one is driving both my users and myself nuts. I'm designing a bunch of applications for my current employer, and as a new hire, I got one of their Win7 machines rather than a Win8 one. The only other difference of note is that the Win7 machines have Office 2007 installed, while...

Okay, I'm trying to use the calendar sub form I found HERE http://www.access-programmers.co.uk/forums/showthread.php?t=218962 in post #4. My problem is that I've not worked with custom events before, and can't figure out how to catch when DateChanged triggers, and how to access the new date it...

One of the most commonly asked questions I’ve seen on this and other MS Access sites has got to be ‘How do I show a progress bar?’ While Access has a built-in meter bar, upon which I will elaborate momentarily, I’ve also ended up having to create a couple other options that I’ll share. EDIT...

We've seen a number of requests lately about automatically distributing database front end files after a new version is released. This is a modified version of code taken elsewhere on the web; I did not write the vast majority of it, only making a couple updates (mainly to keep the code from...

Here's the situation: I have set up a raw data table named "dbo_tblRawData". It has 26 fields (way more than the number of columns I'll ever have to import into this tool), all of which are 100-character text fields. I am trying to use DoCmd.Transferspreadsheet to transfer a spreadsheet into...