Search results for query: *

How about if you walked all the controls in a loop building a concatinated string which would include each succeeding control's value. Just before you add a control's data to the concatination, test for its existence in the concatinated string with the instr() function. As soon as instr()...

Hi Why not just check if file exists after shelled program ran? See below. Regards Kevin An Allen Brown routine to check: Function FileExists(ByVal strFile As String, Optional bFindFolders As Boolean) As Boolean 'Purpose: Return True if the file exists, even if it is hidden...

I think the OP is working with and looking for output in Month/Day/Year format so tweak code as: Public Function getDateFromStr(strDate As Variant) As Date Dim yr As Integer Dim mnth As Integer Dim dy As Integer Dim DateDate As Date If Not IsNull(strDate) Then yr =...

Your original problem/request. If you want Gregorian months between and two dates try the below. It just stuffs the Month names into an array. It then concatenates all the names and hands that back as a string. You could also stuff them in a table or, or, or. Regards Kevin Sub Test()...

Another set of functions but this is said to run in VB6 or VBA. http://www.dafaweek.com/HebCal/HebCalVb6.html

This points to a set of PHP functions for all sorts of Jewish calendar Routines with full source code. While you are not programming in PHP, the logic would be parallel to these. http://www.ziporah-greve.net/prog/jewish-php.html#leapyear

Edit

Hi GPM I would be surprised if the Server and the workstations were configured remotely the same. User permissions would certainly be different between a workstation and a server. Most places I am familiar with would not even put non server type application (ie MSAccess.exe) on a server. You...

Try writing a separate query to each involved table to make sure the connection is working and the data is there and you have rights to it. Then write queries to each join separately to ensure that matches exist and data is returned. You say that you have run the query from a number of PCs and...

Hi, Try the below: Regards Kevin With Literals: DoCmd.TransferDatabase acImport,"dbase IV", "C:\MyDBFs\", acTable, DBFFileName.DBF","MyAccessTableName" With Variables: SourcePath="C:\MyDBFs" DBFName = "MydbaseFile.DBF" AccessTableName = "tblToPutIn" DoCmd.TransferDatabase...