Search results

Try this, in the OnCurrent event procedure of the main form: [SubFormNameGoesHere].Requery

Hmmm... can you try (if you haven't already) putting quotes around each section of text that will become rows in the listbox? Example of what I'm thinking of... "one";"two";"milk;cake;beer;cookies" In that example, I would expect that only the first two semi-colons would be treated as...

Have you tried putting quotes around the description part, to see if you can get the semi-colons in there?

So you are trying to run the code with the Shell function from an Access database that is run via Citrix, and it is calling a batch file that is supposed to open another database on the users' PCs?

You can temporarily change the "/c" to "/k" to force the command window to remain open. Maybe there is some additional information that can help lead to a solution.

Just to verify, when you log into one of the Citrix servers and open up 'My Computer', do you see a V: drive mapping?

If I understand your problem, your users are running Access via a Citrix session, and you want to have a batch file on the users' C: drive be executed. If so, you may be in luck, if your users' C: drives are mounted as a known drive letter from within the Citrix sesson - V: is commonly used for...

Does Citrix map a drive, such as V:, for the user's C: drive? Can you put the batch file on a network share, and then use a UNC path (or known pre-existing drive mapping)?

Try this: Dim RetVal RetVal = Shell("cmd.exe /c c:\winedb\email.bat", 1)