Search results

Hey everyone, Just wanted to post this here - I just finished a Access project that was deeply intertwined with Outlook (generating outgoing email and scraping incoming messages, custom forms) and Excel VBA (primarily for reporting). If anyone has any specific questions regarding either...

I've come across some sort of weird bug. I have a combo box that contains a list of values, but users can add their own if they choose. If the value they type in isn't on the list, the Not In List event fires. Once the procedure is done, the form inexplicably closes. Oddly enough, it only...

[SOLVED] Save Changes Warning no longer popping up Periodoically, the "Save Changes?" warning that pops when closing a query whose design has changed stops popping up, and the changes are automatically saved. I've tried going into the immediate window to change SetWarnings to True, but that...

I'm developing in Access 2007 and created a runtime version. When the user clicks the X to close the runtime application, the main form's Load event fires. Any clues as to why this might be? Some of the code is based on other forms that do close, so of course errors start flying. Note, this...

I'm putting together an access database (2007) that tracks client inquiries (or as everyone else calls them, trouble tickets) and I want to be able to attach files to the inquiry record. My first attempt was to use a linked table with an attachment field, but given the quantity of inquiries we...

I'm deploying an Access 2007 front end application as a runtime application (.ACCDR), and I'm using a few non-standard reference libraries in the VBA. When I package the database into the .ACCDR file, do the reference libraries get bundled, or do I need to add references to them on the user's...

A manager created an issued database (based on a template) and asked me to write some code that would create new records based on incoming emails. The code is run on the Outlook side, fired by the Item_Added event of the Inbox Collection. Everything was working fine until the manager, on a...

Find the difference between two dates is simple if you're simply looking for the number of days between them. However, if you're looking to express the difference in a bit more user-friendly way, you can use the following code to calculate the difference in years, months, and days. The code...

I'm trying to delete a file in a network location. Sometimes the file is there, sometimes it's not, so I'm using the following code: strPath = "\\network drive\My Folder\" strFilename = "MyFile.doc" If Not Dir(strPath & strFilename) = "" Then Kill strPath & strFilename Occasionally, I get a...

I'm trying to store files on a linked SQL Server table, much the way I would using the Attachment data type in Access. (I couldn't use the Attachment data type, though, due to size restrictions - we're storing about a gig a week.) Almost everyone says to store the attachments on a file system...

OK, this one's a doozy... First, I'm developing both the Front End and Back End in Access 2007, and I intend to distribute the application using the Access Run Time. The powers that be will not let me use SQL Server. The database is required to house attachments. Initially, I had created...

I have a list box that displays the contents of a back-end table that is has a new record added roughly 45 times per hour. I'd like the listbox to refresh automatically when a new record is added and, ultimately, notify the user that the new record is there. Are there any non-form events I can...

Hey folks, I'm building a help-desk application that converts incoming emails to trouble tickets, scarping various details about the inquiry from the body and subject of the message. Some of the emails come directly from clients, making identifying the client fairly simple - I simply compare...

I could use some advice... I'm developing an Access application that's integrated with Outlook. It's a custom CRM solution that automates trouble tickets based on incoming emails. As such, both Outlook and Access will be running perpetually. This is a multi-user product - about 40 users...

I've been an Access Developer for close to 15 years now, and the VBA jobs seem to be dwindling, but I see a lot of VB.Net jobs - almost 10 for every VBA job I find. Since I have a lot of VBA experience in both Access and Excel, I figured I'd take on VB.Net. I'd like to get certified, but it...

I'm trying to use a file dialog to allow users to select the spreadsheet they want to import, but when I use the following code, I only get the folder path - the file name is left off. Private Function GetFileName() as String Dim dlg As FileDialog Set dlg =...

I'm working on a form where I have a couple combo boxes. In the past, I'd create/link a Lookup table - in this case, I have about 30 values from which the user can choose, but I also want to allow users to enter a custom value if the one they want isn't on the list. But I'm now toying with...

I took over an old Access project and have been going through the code. I have no formal development training - my skills come from a lot of experience. Can someone explain the benefits of using "stDocName" in the following code? My question is, why wouldn't you just use: I'm sure...

Hey everyone, Just got my first Access developer contract after a decade of a non-IT career. I love the new interface and all the cool things that come with Access 2010 - but I need a quick primer on SharePoint. It's not required for this job, but from what little I know about the product, I...

I got a real noodle scratcher here... I've got a form that parses a data string into individual records, and inserts them into a table. Currently, the string is pasted into a text box, and the user must click a button to begin the parse/insert process. My client recently informed me that the...