Search results

I am looking for a method to combine the data for a particular field from each record into a separate field. Example: Result: Seattle, WA 98104, Chicago, IL 60605, Los Angeles, CA 90010. How can this be achieved?

Hi, I am looking to make a custom messages for this code, If it imports successfully then output "Import Successful" else "Error in Source File". New to coding, so any pre-written script to help would be appreciated. Private Sub cmdImportExcel_Click() 'the path to the excel workbook Dim...

Simple and works! Thank you

Please help me to remove the form default icon. I don't want anything in replace of it. A simple solution rather one that requires modules of code. The links under this thread did not help. Thanks in advance.

Neither of the threads below provide the solution to my query.

Hi, I really need a simple sample database which demonstrates how to select a an excel file from a chosen location and transfer the data to the specified table. Can anyone point one out to me please?\ Many thanks

I have created a summary query which counts each grade, I want to average percentage the count of each grade using the total. How can this be achieved in the query? :banghead: Thanks in advance

Hi All, Unfortunately, I can't share the database for confidentiality reasons but here is what I want to achieve: - Every Subject has a set of students - some subjects share the same student list - rather than listing the students under each subject separately, I wish to have a format where I...

I have some graphs on a form, I found it easier to manipulate the graphs on a form than on a report. I want ALL the graphs on the form to be inserted into the body of the mail. Any pre-written VBA written to achieve this would be greatly appreciated.

Can someone please help me place the customised 3022 message into this code as it is still defaulting to the original msg Dim rst As DAO.Recordset Dim varItm As Variant Set rst = CurrentDb.OpenRecordset("tbl_assignSessions", dbOpenDynaset) For Each varItm In List41.ItemsSelected With...

Sorry, I should have been clearer. I am trying to add a text to the hyperlink as shown in bold below, but it just displays the code and does not convert it to an actual hyperlink. How do I modify the code to allow HTML formatting? Public Sub Command6_Click() Dim vTo, vCC, vSubj, vBody, vRpt...

Thanks, but how do I modify the original post in Post#1 to make HTML compatible hyperlinks?

How do I add the hyperlink text to disguise the file path?

the hyperlink works perfectly thank you!

As an alternative, Can I add a hyperlink in the body of the email to a location on the server? If, so how do I do this in this code?

Hi, I have a fully working script for attaching a report to an e-mail. I want to extend the script to attach another report. not sure how I can add a second sql script and attach the second report to the e-mail... Public Sub Command6_Click() Dim vTo, vCC, vSubj, vBody, vRpt, vForm, vHoy Dim...

Can I limit an Access report group to 10 records per group when printed? A simple code snippet that I can use and adapt perhaps.

OK, still getting the error... Test Data: Enter Day: Sunday Period: 11

Its not adding due to the value not existing in the staff table? but when I add it manually, it adds, but not through the VBA

One to Many