Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mal2ty

    Actuate textual Query Editor Syntax Question

    Is LDTEXT REMARK one column or two?
  2. mal2ty

    Actuate Error

    When the message box comes up that asks you if you want to debug, click yes. When the next message box tells you there is no user source, click OK. Click on Debug - Call Stack. The method that created the error should be highlighted. Double click on the highlighted error, and you the code...
  3. mal2ty

    Maximizing a Form

    Check Out thread222-576697
  4. mal2ty

    FindRecord or GoToRecord syntax

    I was able to get this to work with the following code: DoCmd.GoToRecord acDataForm, "Registration", acGoTo, numin The actual code I used is: lngRecordNum = Forms.Item("Recruitment").CurrentRecord Forms.Item("Recruitment").Requery DoCmd.GoToRecord acDataForm...
  5. mal2ty

    Combining results from 2 queries?

    Sorry for the lack of clearity. Here are two queries that are closer to what I'm truly looking for: This query counts all the courses in the catalog: SELECT COUNT(*) FROM CATALOG; This query counts the distinct number of courses each student has taken, and groups it by student id: SELECT...
  6. mal2ty

    Combining results from 2 queries?

    I need a query that will display the students who have enrolled in all the courses. I am working with the following tables: STUDENTS(SID,FNAME,LNAME) CATALOG(CNO,CTITLE) COURSES(TERM,LINENO,CNO) ENROLLS(SID,TERM,LINENO) I can display the number of courses each student has enrolled in by using...
  7. mal2ty

    Combining two queries

    I found one answer to my own question. Is this the best way to do it? SELECT * FROM (SELECT CUSTOMERS.CNAME, COUNT(DISTINCT ORDERS.ONO) FROM CUSTOMERS, ORDERS WHERE CUSTOMERS.CNO = ORDERS.CNO GROUP BY CUSTOMERS.CNAME ORDER BY COUNT(DISTINCT ORDERS.ONO) DESC) WHERE...
  8. mal2ty

    Combining two queries

    I'm trying to get the names of customers who have placed the 5 highest orders. I'm able to run one query to find the highest order, and another query to find the number of orders placed by each customer. Is there a way to combine these two queries to obtain the desired results? Here are the...
  9. mal2ty

    #N/A values

    Using the proposed formula resulted in only #N/A and FALSE values. This is how I tested it: =IF(VLOOKUP(B10,'ExcelFile.xls!$A:$D,4,FALSE)="#N/A",0) However, I was able to get the following formula to provide the desired results...
  10. mal2ty

    Code that removes other code from project (Excel)

    Here it is... This code will remove a module from a VBA project: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Function KillMacros() Dim intCount As Integer Dim intComponentNum As Integer intCount = 1 intComponentNum = ThisWorkbook.VBProject.VBComponents.Count Do While...
  11. mal2ty

    Code that removes other code from project (Excel)

    This functionality would be quite useful to me also. I tried implementing the code, but I received the following error: Run-time error '424': Object required I am still playing with the code to try and figure out how to fix the error, but if there are any more suggestions, please post...
  12. mal2ty

    #N/A values

    Here's something that seems to work. It's pretty crude coding, but at least it seems to get the job done. Dim intRow As Integer Dim intCol As Integer Dim sngGetValue As Single Dim strCellAddress As String Selection.Offset(intRow, intCol + 7).Value = "=CELL(" &...
  13. mal2ty

    #N/A values

    Goska: I tried your proposed solution, but ended up with the same error. Here is the code I was using: Dim sngGetValue As Single sngGetValue = Selection.Offset(intRow + 5, CStr(intCol + 64)).Value If (IsNA(sngGetValue)) Then sngGetValue = 0 End If Any other ideas?
  14. mal2ty

    #N/A values

    Is there a reference that needs to be added to use the IsNA function? When I tried to use it, I received the following error: Compile error: Sub or Function not defined
  15. mal2ty

    How to send email from a vba script

    Ooops. I meant sending the Excel file as a shortcut. (It's been a long day)
  16. mal2ty

    How to send email from a vba script

    How about sending the Excel file as an attachment, is there a way for this to be done?
  17. mal2ty

    #N/A values

    Amazingly enough, I believe that I've found a solution to my own problem. For those interested, the code I'm now using is as follows: Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlValues, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=False Cells.Replace...
  18. mal2ty

    #N/A values

    I'm working with VBA to replace #N/A values with 0s in an Excel spreadsheet. The #N/A values in my spreadsheet are the result of the VLOOKUP function. The problem I'm encountering is that I receive an error every time I try to check for a #N/A value. Currently, I'm trying to detect these...
  19. mal2ty

    Bypass warning when deleting a tab in Excel

    That's exactly what I was looking for. Thanks!
  20. mal2ty

    Bypass warning when deleting a tab in Excel

    I'm using VBA to delete a worksheet in Excel. Each time I delete a worksheet, Excel produces a message box with the following warning: The selected sheet(s) will be permanently deleted. To delete the selected sheets, click OK. To cancel the deletion, click Cancel. Is there a way to...

Part and Inventory Search

Back
Top