Search results for query: *

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...

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...

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...

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...

I'm working with a VBA macro in Excel that refreshes data by using the following command: Selection.QueryTable.Refresh BackgroundQuery:=False Before Excel can access the Oracle data, the following prompt is displayed: Logon to Oracle User Name: Password: Server: The User Name and Server...

I'm working on automating an Excel report. Each time this Excel report is opened, Excel displays the following message box: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= The workbook you opened contains automatic links to information in another workbook. Do you want to...

How can VBA be used to detect a circular reference error in Excel? I'm using VBA to completely automate a report that's been partially automated by someone else. The partial automation sometimes produces an Excel "circular reference error." My VBA code needs to check for circular...

I'm trying to use an access query within an excel macro to get a certain value. The query results are being stored in a recordset. Is there a way to assign the query result (it's always only 1 field of 1 record) to an excel variable? Any help will be appreciated.