Search results

I had considered that at one point, but I couldn't figure out how to make the credentials stay with Access, rather than the user.

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...

The contents need to be accessed through the database. Currently, the database automatically opens the files in their native application, and I'd like to retain this functionality, as this product is being developed for the lowest common denominator (i.e., automate as much as possible)...

Anything and everything - .MSG files (the inquiries are initiated by incoming emails), .PDFs, .DOCs., .XLS are the most prominent, but I've even seen some .wav files come through. I'm currently converting the files into binary streams, then saving the streams into .DAT files. If I could figure...

If I were able to store the files within the tables of the database (as attachments in access, or as varbinary(max) records in SQL Server) the users would only be able to view the attachments associated with the inquiry they were viewing. The users won't have direct access to the tables due to...

I guess I'm not being clear - allow me to use an example: The database provides Paul access to Inquiry #123. George has access to Inquiry #456. Each needs access to the attachments associated with their own inquiry, but not the other. The attachments are stored in the following locations...

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...

That's really funny - my first response was precisely how to rename the table, but I reread your original post and thought you wanted to save it as a separate file, so I deleted everything and rewrote that! Anyway, here's how to rename a table, assuming you've created a second table that has...

If you're using a Save As File Dialog, you can specify the file name as the InitialFileName in the file dialog prior to displaying it. Dim fdlg As FileDialog Dim FileName As String Set fdlg = Application.FileDialog(msoFileDialogSaveAs) ' Set the value in the unbound textbox...

What do you mean by "my code won't open"? Can you open the database? If so, what happens after you type Alt+F11? If that gets you nowhere, try holding the shift key when opening the database, then doing the Alt+F11 trick...

In the Do...Loop portion of your code, try this: Do Until rsemail.EOF MyMail.BCC = MyMail.BCC & rsemail!Email & ";" 'And on to the next one... rsemail.MoveNext Loop This way, each address is added with a semi-colon at the end. When the code is looped, the next address is simply appended...

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...

Also, try adding "me" in front of the control name

At first glance, it appears as though that code should work. I'd check to make sure that the back style is Normal, and not Transparent. Also, (and this is probably a small oversight) make sure that you have your colors correct - in both cases above, if or else, you are changing the color to...

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...

If you add the days, then the months, and then the years (rather than the other way around) it does work: ? DateAdd("d", 27, #2/2/10#) 3/1/10 ? DateAdd("m", 10, #3/1/10#) 1/1/11 ? DateAdd("y", 2, #1/1/11#) 1/1/13 It's not the most reliable method for determining the difference, given that...

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...

WORKAROUND - Runtime Error 52 when using Dir Function I've developed the following workaround which simply ignores any errors raised when deleting the file. I changed PROC_EXIT: Set msgNew = Nothing Set rsInq = Nothing Set rs = Nothing Set db = Nothing If Dir(strPath &...

I purposefully left out the major part of the function due to preprietary (and ultimately irrelevant) information. The End Select statement was left in by accident, as I had a couple of application-specific error handling procedures in place. Here is the code: Public Sub MySub(msgNew as...

Mihail, For some reason when I initially replied, this part didn't show up in your reply. Either way, the error still occurs.