Search results

Thanks, I tried the crosstab query but for data only allows Count, Sum, Average, etc. I am not an expert coder, so know nothing about the group concatenation function. TheDBGuy, is this a possible solution and can you please guide me to where on your site I can find this?

Hope someone can help! I have a query that produces results for DateReportDue, SampleID and TestedFor. I would like to produce either a query or report where I have the row name as TestedFor, the column name as DateReportDue and list the SampleIDs that are contained in both. In other words...

Thanks arnelgp! Also an excellent solution! In summary: two solutions offered - in post #18 AND post #20

@CJ London Thanks for suggesting the approach found at A multi select form using unbound check boxes It is excellent, and a novel approach. Not one I would have thought of! And a special thank you for the example database which demonstrated its use, and coding. This will work perfectly for...

1. The recordsource doesn't need to be a query, it only needs to be based on orders. Orders only contains Company_ID and not the company name, hence the join between Companies and Orders tables 2. Order id probably doesn't need to be shown on the form. Are users using that externally of the...

Thanks for all your input. Some interesting approaches to consider. I think my initial example was very simplified, so I am attaching an image of how the form looks, with some details modified to 'hide' details.

@The Doc Man Thank you, this is a novel solution I did not think of. However it becomes 'cumbersome' if the user is scrolling through say 50 records that they will be making a selection from.

Thanks for asking. I was struggling to express myself clearly! If for example I have a list of records (primary keys shown) listed in a continuous form: 1111 sal@co.com 1112 fred@co.com 1113 ann@co.com 1114 gef@co.com etc I would like my user, via a checkbox, to select 1112 and 1114...

I have a database with data stored in a backend. I have a Form with a recordsource linking two tables, e.g., SELECT Companies.CompanyName, Orders.* FROM Companies INNER JOIN Orders ON Companies.Company_ID = Orders.Company_ID; I would like a user to be able to select specific records (tickbox)...

Hi Colin, Thanks for your contribution! I did comment out .Configuration.Load-1 with no effect on the result. Interestingly, I uploaded my database to a computer in the USA a few minutes ago, and the test email failed. In other words, code not influenced by my fiber/internet provider. I am...

@pbaldy Thank you for the link. This is the site I originally looked at when developing my code. I tried to code now again, and unfortunately fails to work. @Minty Thanks for the link too. I use CDO Email Tester to check whether my parameters work, and they were successfully working till...

Hi The Doc Man, Much appreciated, thank you! Lots of information to assess and to check. I do not think it is these three for I have assessed, checked, and thoroughly discounted these as possibilities: 1. Incorrect SMTP server / port 2. Incorrect login/password 3. FROM address not valid...

Hi all, Wonder if anyone can give input why I am getting an error, or what may have changed. I have been using the code below in Microsoft Access DB for years to connect to smtp.office365.com and send emails. Out of the blue, around 4 weeks ago, I started receiving an error: "transport failed...

Hi @arnelgp Is it possible to return the intermediate value, i.e., #text# #strings# #VBA Function# as individual values rather than in one go? Thanks! Harris

@MajP - Thanks, I am aware of the VBA Split() function but could work out how to extract 'all from the string. @arnelgp - You are a star! This is perfect, thank you! I found something similar doing a Google search, but the function only drew the first instance from the string. Much...

Hi, I hope someone can assist - I have searched Google and cannot find a function that could do this for me. I would like to find a function that can extract all text between two 'delimiters' in a string. In other words: String = "Easily extract #text# between two #strings# with this #VBA...

Thanks very much for the potential solutions! And particularly for the code, much appreciated. I would not have considered these possibilities at all.

Thanks, the '#' column is not necessary to capture Using .HTMLBody is also an interesting idea! You are correct, lots of trial and error! At the moment, more like error

Thanks for your potential help! I have forwarded the example to your email address. Thank you Harris

Hi all, I hope that someone can help this novice programmer with vba to import the following table. The data arrives in an email table, and we copy and paste into a text box. The code needs to extract the data and import into an Access table. I appreciate that the table will have 5 fields which...