Search results

Thanks for the suggestion. How do I use the UNC path name when using the link table manager?

Hey all, Im having some link table issues that Im hoping you folks can help me with. I have a client who has users in different locations. I have database A that houses some tables that are linked into database B which are located on drive X:\ The issue is since there are different locations...

Hey all, I need to run two functions during an After update event on a form. The two functions will operate individually but how to I write it to run one function after the other?

Id like to see your code as well as reference so I have a toolbox of different code snippets to use for future projects.

Id like to see it. I was thinking about creating a template but the naming convention of the file has to include a date and time stamp since the report will go out hourly. I figured I can create a new file every hour with the the date format in the event I need to refer to previous file for...

Ill have to check this out and get back.

I apologize for the confusion. Basically what I need to do is allow the end user to be able to filter through the data in each column in the excel attachment. Once I figure out how to create the attachment to include in the email, I think I there is code to autofilter. I checked the link you...

I currently have a function that generates an email outlook with a table from a query in my db. I need to add an excel attachment of the same query results with filtering of the column headings. Can I use the export to excel functionality that is in Access and if so how do I add the filtering...

Im working on an hourly report that shows summarized sales data. In my example Im capturing the sales at site A,B and C every hour. I also need to show the total sales of the entire group. In the report I need to show the total for each site and a separate total for all sites for the previous...

First off I apologize if this is in the wrong section. Im running this in a module so I though this was a fitting place to post the question. I have automated emails in a module that creates a table in an Outlook email. One of my columns can have a large amount of text and the column in the...

I have a function that puts the first 2 characters of a string into a textbox. What Im attempting to do is add a "1" to those first two characters when an after update event occurs. How would incorporate the "1" into the left(string,2) code to make it work? Any help would be greatly appreciated.

I entered the code and this is the result in the immediate window "myIntarray(0) = -1" I also have a debug print already in my code which displays "The String value was not found in the table, returning -1" which upon looking I set values to -1 if it is not found in the reference table of the...

Unfortunately my DB contains proprietary and confidential information. Is there another way for you to assist with the troubleshooting? In general, Im having an issue with null values in a combo box returning a -1 value and the nz function and the other provided solutions are still returning a...

There is no particular reason for using function over sub. I guess its just habit. Thanks for the solution! It worked but I need to add breaks because it was merging the two together.

The function intEffortAsInt is a Dlookup that looks up the possible answers and the designated value.

Thanks for the info. So where in my code will I place your suggestion?

Ive tried using the NZ function as follows and it still shows as -1 Dim myIntarray(8) As Integer Dim myString As String myString = vbNullString myString = Nz(Forms!frm_example!Combo0.Value, 2) myIntarray(0) = intEffortAsInt(myString)

See Below. The only table that populates is table 2 at the bottom. The code for table 1 seems to be completely ignored. Public Function Report() Dim olApp As Outlook.Application Dim olMail As MailItem Dim mailbody As String Dim rs As DAO.Recordset '********************* created header of table...

Good Evening everyone! Im trying to create an html formatted table in Outlook that displays the results of a designated query. Ive been successful in creating the table for one of my queries but when attempting to create an additional table based on another query, Im only getting first to be...

Hey there! First post looking for some assistance. Here's my situation. I have a form where users answer a series of questions through combo and check boxes that grade their experience. When they have made all of their selections and submit, I need to provide a result based on their answers...