Question: How to get the value from ComboBox to strSQL in VBA? I am trying to get value from ComboBox to strSQL, but I just have

How to get the value from ComboBox to strSQL in VBA?

I am trying to get value from ComboBox to strSQL, but I just have no idea how to do this.

My value of ComboBox is Mid(combobox, 6, 3)

I tried

strSQL = "Select * from schedule where FltNumber = Mid(combobox, 6, 3)" or

strSQL = "Select * from schedule where FltNumber = '" & Mid(combobox, 6, 3) & '""

and other many ways did not work.

Please help

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

I need help with Visual Basic code. I have attached file that i have done so far. I am only getting one error when i am trying add new employee. You can download my Zip folder to Run the whole...

Q:

I have been given the assignment to: Steganography is a technique of encoding a text message into a picture. Create a Steganographer class. Write a method for this class called "encode" that accepts...

Q:

Can someone help me figure out why the technicianID doesn't like it when it comes out null. Please. The program is in Visual Basics 2019 using .NET Framework. Project 3A SQL Server Sample Solution...

Q:

This assignment is about simulating a bingo game. Create a 2D array that will be your bingo card. The bingo card will ONLY be 5x5. Make sure your random numbers are truly random between program runs....

Q:

This assignment is about simulating a bingo game. Create a 2D array that will be your bingo card. The bingo card will ONLY be 5x5. Make sure your random numbers are truly random between program runs....

Q:

I just need help in how to get the gross pay and the rest of the calculations so far my code works great, but I'm stuck on how to calculate the gross pay. Here is my code:...

Q:

Program 6 Functions (100 points) Overview: For this assignment, re-write program 5 so that it uses functions to display the menu, get values from the user, and perform the various arithmetic...

Q:

can you rewrite this code without using break,continue,return inside and outside the loop. Arbitary value / sentenial value cannot be used to control loop. For filling the card with unique numbers,...

Q:

I need help with my assignment. I got the consumer code done but I need help with the producer code where it starts at void Producer. I know I'm not getting that right. If anyone can help figure that...

Q:

WRITE CODE WHERE IT SAYS TO WRITE CODE: producer.c #include #include #include #include #include #include #include #include #include // Size of shared memory block // Pass this to ftruncate and mmap...

Q:

What is globalization? (b) Why may companies want to engage in the global market and conduct business internationally? Use any business cases / examples that you are familiar with or curious about

Q:

(a) Show that C[a, b] is a real vector space. (b) Let W (k) be the set of all functions in C[a, b] with ((a) = k. For what values of k will W (k) be a sub-space of C[a, b]? (c) Let t1, t2, ( ( ( ( tn...

Q:

dalam kondisi penerbitan obligasi apakah diskonto atas utang obligasi timbul? dalam kondisi penerbitan obligasi apakah premi atas utang obligasi timbul

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

(Appendices) Identify the accounting items for which adjustments are made to the purchase price of goods acquired for resale when determining the cost of purchases. Assume that the firm uses the...

Q:

(Appendices) ERRORS IN ENDING INVENTORY. From time to time, business newspapers report that the management of a company has misstated its profits by knowingly establishing an incorrect amount for its...

Q:

(Appendices) DISCOUNT POLICY AND GROSS MARGIN. Compton Electronics sells Motorola cellular phones. During 19x8, Compton sold 1,000 units for $300 per unit. Each unit costs Compton $180. At present,...