Search results

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

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

Hi, hope someone can assist please! I am struggling to do a Desc sort this query on the first field, Sec SELECT TOP 30 Mid([DocNumber],InStrRev([DocNumber],Chr(47))+1) AS Sec, Left([DocNumber],4) AS Try, QB_Invoice.DocNumber, (Right([DocNumber],5)) AS TheDocNumber, QB_Invoice.TimeModified FROM...

Hi, hope someone can assist. Going in circles with this one. I would like in an EOF loop, for the first record to trigger one string and the remaining records in the loop to trigger another. Do While Not rs.EOF '1st record - do this '2nd and subsequent records - do that rs.MoveNext Loop...

Hi, I am struggling to find an example of code that will open an URL and login to the site automatically. I am trying to login to this site: id.caspio_com One example shows error at oLogin.value = Username with the error "Object variable or With block variable not set" - run-time error '91'...

Hi, I hope someone can shed a light on this - seems so simple yet the answer alludes me. This works in a form query: SELECT Contact_People.* FROM Contact_People WHERE (((Contact_People.Category)="Accounts")); However, I want to have the record source exclude "Accounts" from the field Category...

Hi, I hope someone can assist. I have a table with the following fields: Contact_ID, Company_ID and EmailAddress. The situation is that the same email address can be associated with 1 or more companies. Therefore the Contact_ID and Company_ID will differ from the same email address. For...

Hi, I am struggling to resolve this, and may not be resolvable because of firewall security? I trigger this FTP code to upload a PDF file which has just been generated to my website. If I deactivate my virus protection software, works fine. If not, is blocked. Any suggestions whether there is...

Hi, I wonder if anyone can assist me please. The below code works well in my Access Database at work, but somehow not in the same database from home. I modified the code to allow 64bit systems (computer at work), whereas one at home is 32 bit. The file to upload's directory is changed from my...

Hi all, I have created a query for totals by year, and another for totals by month (and able to select the month in question) Is it possible to create a query which combines both, i.e., yearly totals, and including the months? (potentially being able to select the month in question) See image...

Hi, I suspect this is not possible, but! I have a pivot query that works correctly. This issue is that I would like to somehow insert into a column heading, or even row heading, the data range that I am quering so that when copied and pasted, the user is reminded of the date range the data...

Hi, hope someone can help! The below code unzips a non-password protected file perfectly. However not for a password protected file. I have struggled to find a solution using the famous search engine. Can anyone help, or at least aid with an alternative vba? Thanks Function Unzip1(ZippedFile...

I am trying to determine the first time a company [Company_ID] placed an order [Order_Date]. I have tried different ways and they are clumsy and do not give the correct result. It somehow seems that there should be an easy way to do this but I cannot figure this out (not being an expert...

Hi, wonder if someone can advise? I have the following query which allows me to create a graph. It results in the following results: Test, Interval and Count. However if the count value is nothing, then no Interval is generated and then no data is generated and the graph generates an error...

Hi, hope someone may be able to advise! I am trying to join two queries into a pivot table This pivot on one query works: TRANSFORM Count(SampleTestedFor.TestedFor) AS TestedFor SELECT IIf([SampleTestedFor].[Packed]=8,'','LCMS') AS TestGroup FROM ((Samples_List INNER JOIN SampleTestedFor ON...

Hi all, Is it possible to have a link in my returned email message that when clicked, will open my Access database and open a specific form with the linked record ID? Thanks

Hi, I wonder if this is possible and if someone can advise? My database generates pdf reports to a folder that syncs through OneDrive to a SharePoint folder. On SharePoint, the pdf is electronically signed and moved to a second folder, where it is synced back to a second folder on OneDrive...

Hi, I hope someone can assist I want to include a "catch-all" in the recordsource for a combo box. This works for an Access based table: SELECT DISTINCT rBST.Received_Date FROM rBST UNION Select "All" From rBST ORDER BY rBST.Received_Date DESC; However, when creating the table in SQL, I am...

Hi, hope someone can help! I trigger a vbs script (update.vbs) when a form closes, which is meant to trigger a batch file (update.bat). The reason for doing it this way is to keep the process hidden. I have included text messages in both when testing to ensure that each works. When I trigger...