Search results

I get a "file not found" which makes sense since the Shell command would be looking for "msg". I'm running Win 7 so I cannot comment on Win 10 but we are running same Access 2007 so I still find it a bit weird that yours are working. Strange hey

Even without referring to cmd.exe - I mean did you put the above code in a module and it opens a Windows Msgbox just like that? If so what Win version are you running?

Ahh - I found the answer: start "" cmd /c "echo Hello world!&echo(&pause" So I implemented it like this: Does the trick Cheers!

Nope - also only open the cmd window and nothing else :(

@Tera - Thanks. I'm not at the office for a few hours. Will test later

Thanks but I very specifically want to open, run code and quit Access without any User input etc. So I don't want to keep Access open. If I create Windows message boxes it automatically opens one after the other as you close them. Which means I can que them and the User will see them at a later...

Thanks I'll try the batch method was just hoping for a more direct way as I'm looping through records and queuing Windows messages boxes for each record matching the criteria. So I want to limit the time it takes. PS: I specifically don't want to use msgbox inside Access as I will open the...

Hi all, I want to run the following command from VBA: If I type "msg * test" into the cmd window, I get a nice Windows message box. I tried to Shell it like this: Shell "cmd.exe msg * test" but it does not work. It only brings up the cmd windows but does not execute the msg command. Any...

Ahh great - Just not sure if I'll be able to convert it to VBA...

Thanks - gonna try that!

I like to try and think out the box with free stuff and making them do what I want. I can easily loop through a list of mobile numbers to do some of this but I would still like to find a solution for the <Send> button. Maybe someone here has web coding knowledge and can build a "wait until fully...

I agree - there is an API but at a price. The code/URL string in my OP is however from WhatsApp's official website. I'm using it at the moment and it works fine but you have to manually click on <Sent> which I would like to automate to make the above option even more powerful I normally stay...

Haha - don't jump to conclusions - I'm sending notices to a close-group of members

Hi all, I came across this info regarding sending WhatsApp messages via the web (PC). https://faq.whatsapp.com/en/android/26000030/?lang=lt I can use FollowHyperLink to action a new message but I still have to click on the <Send> button in WhatsApp. It is not a problem for Single messages...

Hi all, I need some advice. I need the table data from a Pervasive PSQL database to be exposed to the Internet in some or other way in order to use the data in a Website's frontend.. I can create a ODBC DSN connection from within Access to link to the tables and then have code on a timer event...

Thanks I also saw that link but was not of much help. I eventually found another which, in short gave the advice to create a batch file on the fly and execute that. Inside the batch file you will echo the commands and special characters to the com port eg: echo texthere >\\.\com3 Thanks

Hi All, The code below is giving me a "ActiveX component can't create object 429" error. The MSComm32.ocx file did register sucessfully via Cmd Any help would be appreciated. Running Access 2007 but also tried it on a Access 2013 machine I had to browse to the ocx file as Microsoft Comm...

Hi Cronk & Galaxiom A lot of thought has gone into the process since my initial post and subsequent own reply. @Galaxiom – Thanks I actually did end up using a “compsite” key made up my the CurrentUser and PCName to make sure Users data are kept separate in the event of more than one User...

Ahh - I think I've got it. The main problem is that if anyone of the multiple Users have AutoNum in any of the 2 tables already existing in the main online tables it will not append the data. One route I can follow is to set a "range" for each User by setting the AutoNum using Allen Browne's...

Hi all, This is what I have: tblOrders tbl and tblItems tbl with one-to-many relationship (ID Auto) Items tbl also has a ItemsID (Auto) I have a few frontend Users sharing the backend tables to update data. The problem is that sometimes their internal server goes offline due to hardware...