Search results for query: *

I am trying to build this passthrough query with a Onclick event SELECT format(Workorders.[Internal Work Order Number],"000000") as Workorder, format([Workorders.DateOpened],"dd/mmm/yyyy") as [Date Opened], format([Workorders.DateClosed],"dd/mmm/yyyy") as [Date Closed] from Workorders UNION...

I have created this function Function Shopex_ind(myForm) On Error GoTo Err_Shopex_ind Dim Shopex Shopex = "" If myForm![Shop1] = -1 Then Shopex = 1 myForm![Shop1Label].BackColor = 65280 myForm![Shop 01]...

I am running a query with Like "*" in the criteria and the query returns everything except the records with a null value in that field. Am I missing something? I thought that Like "*" should return everything.

I have created a report with a subreport that shows part numbers and the vehicles that they fit on. The main report shows the part number and vehicle it can be used on as well as other usefull info. The subreport shows any other vehicles that the part can be used on. My problem is that I want...

I have a query SELECT tblPrepTime.Course, tblPrepTime.Instructor, tblPrepTime.Type_Of_Prep, tblPrepTime.Date, tblPrepTime.Time, tblCourseInfo.Course_Name, tblCourseInfo.[Start Date], tblCourseInfo.[End Date] FROM tblPrepTime INNER JOIN tblCourseInfo ON tblPrepTime.Course =...

I have a report with one subreport. The subreport is based off of a query. I have code that will change the query but can't seem to get the subreport to refresh with differernt data. The subreport is in a header and I am using the onformat event of the header to fire the code to change the...

I am trying to get the ? character to print. In my code I am using Chr(192) and I get the ? character as a result. What am I doing wrong?

I have this code Sub DisplayArray(InArray() As String) Dim i As Integer, j As Integer For i = LBound(InArray, 1) To UBound(InArray, 1) For j = LBound(InArray, 2) To UBound(InArray, 2) Debug.Print InArray(i, j), Next j Debug.Print Next i End Sub which very nicely prints...

I have created a multidimensional array and want to either output it to a report or form. I have found code to display one dimensional code in the immediate window but can't get it to work for multi dimensions. Sub DisplayArray(InArray() As String) Dim i As Integer For i = 1 To...

I have been trying to get this formula to work but I can't get it to maintain the number of holidays that is calculated when the year changes. Here is the code. PS. I tracked down most of the coding thanks to Tek-Tips. //Main formula WhileReadingRecords; Local DateVar Start :=...

I am trying to open an access 95 database in xp pro but I get the error "The parameter is incorrect". Any ideas would be appreciated.

I have been able to check http:// hyperlinks on my website, using this function, which I found on Tek-Tips. Private Function File(byVal pathname) Dim objFSO Set objFSO = Server.CreateObject("Scripting.FileSystemObject") File = objFSO.FileExists(pathname) Set objFSO = Nothing...

I am using Crystal 9 Advanced and an Oracle 8.1.7.4 database with ODBC connection, CR Oracle ODBC Driver 4.10. I am trying to get this formula to work Local NumberVar x; //Declare x to be a Number variable Local NumberVar y; //Declare y to be a Number variable x:={ASSETLCF.UNITCOST}...

Is there a way to let a user know that their report is in the que? I am using Crystal Reports 9 Advanced RAS

We are currently using the RAS from Crystal Reports 9 Advanced. The application is using ASP. There is a limit of 5 concurrent users with the RAS. If we move to Crystal reports XI Developer can we get by the concurrent limit? Do we have to go to Server XI? From reading the documentation on...

I am trying to get a count of column F where it has a date of 31-Dec-2005 and where column E is blank. I thought this formula would do the trick =COUNTIF(Tasks!F:F,AND(Tasks!E2:E147=DATEVALUE("31-dec-2005"),ISBLANK(Tasks!F2:F147))) The only result I get is 0, there are 39 occurances, I...

I am having difficulty getting my Access Query to sort numbers properly. Here is a sample. 1170 120 1215 1370 1370 1463 172 1734 1764 1972 How do I fix this? I have tried moving this column to the first position, with sort ascending on, to no avail.

I have Crystal Reports 9 Advanced. It ships with RAS and Crystal Enterprise Standard. The RAS has a queing ability that the CE lacks, after 5 concurrent connections you get a web error. Is there any way to combine the two so that the scheduling capability of CE can be used in conjunction with...

I have Crystal Reports 9 Advanced. It ships with RAS and Crystal Enterprise Standard. The RAS has a queing ability that the CE lacks, after 5 concurrent connections you get a web error. Is there any way to combine the two so that the scheduling capability of CE can be used in conjunction with...

I need to transfer information such as first name and last name between applications. I thought using a cookie would be the best way. I can create and read the cookie in the first application but cannot read the cookie in the second application. From researching the problem it appears to be a...