Search results

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

Thank you for this alternative, much appreciated!

Wow, brilliant, thank you! I would not have solved this ever! Much appreciated. Harris

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

Excellent, worked like a charm. Syntax is obviously everything! Thank you very much for your help. Much appreciated

The .bat file is in my CurrentProject.Path I have accidentally found this to work! shell "cmd /c ""H:\My Documents\AccessDatabases\UpdateDB.bat""", vbNormalFocus However can you advise on how to change the path using CurrentProject.Path? I have tried various ways and simply cannot get the .bat...

Used these: Call shell(Environ$("COMSPEC") & " /p H:\My Documents\AccessDatabases\UpdateDB.bat", vbNormalFocus) Dim RetVal RetVal = shell("H:\My Documents\AccessDatabases\UpdateDB.bat", 0) Neither worked

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

Worked perfectly, thank you.

I think I have worked it out! Thanks, let me check the results

Thank you. I am not sure how one would do this (I am not an programming expert!)

I hope someone can help. I have a table with among other the following fields: Customer_ID and Customer. I have a second table with among other these associated fields: Customer_ID and Ordered_Date. So this second table may have the following entries: Customer_ID and Ordered_Date 112...

Thanks for your input. Unfortunately partly works. The year is the problem, i.e., last year is at the end ElisaLCMS_Union ElisaLCMS_Union Week Week 20212 02 20213 03 20214 04 20215 05 20216 06 20217 07 20218 08 20219 09 202110 10 202111 11 202112 12 202113 13 202114...

This does work! Fantastic! Thank you.

Thanks but that does not work: Week 202110 202111 202112 202113 202114 20212 20213 20214 20215 20216 20217 20218 20219

Can anyone help please? I have a group by query and trying to have the result sorted by year-week. Tried Val(Right(Format$([Order_received],'yyyy/ww'),Len(Format$([Order_received],'yyyy/ww'))-5)) If my query tests for the date range from Nov 2020 till May 2021, if I sort by week only, then last...

Thanks for all the input, much appreciated. I will test by changing debug.print to something like A=2 and testing, but suspect that theDBguy's advice is probably most appropriate. I appreciate that one can have this work using very complex methods but I do not want to go there! I was...

Thanks for the link. My question is not based on the logic, but how does one construct a dynamic IF-Then statement with a variable number of AND variables, and that will execute correctly when constructed.

Thanks for your quick responses. I hope that this is clearer. I have an IF statement that checks to see whether a field value in a record is NOT = 'A' and NOT = "B" and NOT = "C", and if true, will update another field. At present the values "A", "B" and "C" are coded into the IF statement. I...

Hi, I wonder if anyone can help please. I have the following statement: If rsAct("InvoiceLine_ItemRef_FullName") <> "Discount" _ And rsAct("InvoiceLine_ItemRef_FullName") <> "URGENT" _ And rsAct("InvoiceLine_ItemRef_FullName") <> "Courier" Then...