Search results

The below DCount statement gives me the number of duplicates records from the "Query_Find_Duplicates_For_Gift_Totals" query. How can I get the names of the duplicate records from the below DCount statement? DCount(" Gift_Totals.[Survey_Taker_Last_Name]", "Query_Find_Duplicates_For_Gift_Totals")

How can I eliminate the Microsoft Outlook email safety message when sending an email using "SendObject" ? Attached is the image of the message.

Is it possible to retrieve the count of duplicate records (produced from the query below) ? I want to see if there are any duplicate records, if so, then show them on a form. If no duplicate records, then display a report with the single record. In (SELECT [First_Name] FROM [Location_Totals] As...

What does the below error mean and do I fix it ? Runtime Error 2147467259 (80004005) It fails on ==> Set M = O.CreateItem(olMailItem) ' Remember to add REFERENCE to Microsoft Outlook Object Library Dim Msg As String ' Msg = "Dear " & Firstname & ",<P> & _ ' "Your statement balance as...

I have a macro that's giving me a 3211 error. How can I find out which form, table, or query in the macro is open ?

What is needed to move to the next textbox automatically without tabbing ? Current settings are as follows for all textboxes. Tab Index is 12 Tab Index is 13 Tab Index is 14 Tab Index is 15 Tab Index is 16 Tab Index is 17 Tab Index is 18 Tab Index is 19 Tab Index is 20 Tab Stop Yes Auto Tab...

Is there any way to change the .PDF file name from the number "1" to a name that I will give with the DoCmd.SendObject method (Access) acFormatPDF parameter ? Right now the attached file is named '1.PDF'.

Is there a way for MS Access to create a report that shows the flow on how Forms, Reports, Tables, Macros, and Queries are associated ?

Can someone tell why my e-mails are arriving anywhere from eight (8) hours to an entire day later to recipients when using the DoCmd.SendObject method (MS Access) ? The e-mail providers are Comcast and gmail (i.e. Comcast.net and Gmail.com).

Can someone tell me why I'm getting the below error message. "Data type mismatch in criteria expression" I'm trying to pass a variable (via VBA) from a form to another form that retrieves a associated records to the form called. The form criteria is to match a variable that has the value of...

I have a MS Access database that has a form that collects data (i e. survey). I want to make this form available for use on the internet. The form creates an entry in a table, then the entry is appended to a summary table. How will MS Access work when this form is activated (on the internet) at...

I'm having trouble with the proper placement of the quotes for a Do.Cmd.RunSQL VBA statement. The SQL code works. Would someone add the DoCmd.RunSQL statement and quotes in the proper place for the below code ? Eventually, "Evans" will become a variable rather being hardcoded. Thanks ! ! ...

I need to export data from a table in a database to another database table (same table name) using VBA ? Examples are welcomed. Thanks ! ! !

Is it possible to create a REPORT from a FORM ? If so, please tell me how. Thanks ! ! !

Is it possible to change the text color (when printing) based on the value of another field ? I want to check if a checkbox is selected on a form, if so I want the entire line (print record) to print in red. It looks like "Conditional Formatting" will not do this.

Anybody see what is wrong with the content in my 'Testit' query criteria ? I'm trying to pass dates from a form (i.e. Date_Selected) to my query (i.e. By_Selected_Date_Query) ? The syntax used is below. Also, I've attached the database. Between [Form]![Date_Selection]![StartDate] And...

How can I retrieve the results of the below SQL statement in VBA ? Dim strSQL As String strSQL = "SELECT [Sales Tax Table].[Category_Name] FROM [Sales Tax Table] WHERE [Company Name] = '" & Me.Name_Choose & "'"

Is it possible to share tables with two (2) different databases ? To clarify . . . I have a database that collects data into tables (via form) that are needed to produce reports by a different database.

Is it possible to change the color (to red) of text in a textbox after it's update. I don't see how to do this in the 'New Formatting Rule' in 'Conditional Formatting' of the 'Format' section.

How can I retrieve the results of the below SQL code ? Also, How can I replace the hard coded 'Target' value with the variable named 'Account' ? Dim strSQL As String Dim rs As DAO.Recordset Account = [List7].[Column](0) strSQL = "SELECT Bill_Name, Last_Paid, NextPaymentDate FROM...